Question

Please use only Minitab or Excel. Thank you

Please use only Minitab or Excel. Thank you

Two different tire compound formulas are tested for tire wear in thousandths of inches. Everything else that might vary is held at a pre-determined constant value to the best of the experimenters ability. The following are the samples randomly selected from the tires made by the different compound formulas (assume the outcomes are normally distributed). The values in the table are the wear in thousandths inches. The design engineer claims that Compound Formula 1 will result better product. Perform the adequate analysis and comment on the design engineers statement. Sample id Compound Formula 1 Compound Formula 2 72 74 75 76 75 75 78 72 74 74 78 82 82 81 80 72 78 74 73 13 14 15 16 17 18 19 20 21 78 76 75 72 73 73 81 23 24 25 26 27 28 29 30 78 75 72 76 74 79 76 76 75 81 76 82 72

Please use only Minitab or Excel.

Please use only Minitab or Excel.

Thank you

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Claim: Compound formula 1 will result better product.

Null and alternative hypothesis is

H0:\mu1\leq \mu2 Vs   Ha:\mu1> \mu2

For doing this test first we have to check the two groups have population variances are equal or not.

Null and alternative hypothesis is

H0:\sigma _{1}^{2}=\sigma _{2}^{2}

Ha:\sigma _{1}^{2}\neq \sigma _{2}^{2}

Test statistic is

F = largest sample variance / Smallest sample variances

F = 4.7310 / 4.3264 = 1.09

Degrees of freedom => n1 - 1 , n2 - 1 => 30 - 1 , 30 - 1 => 29 , 29

Critical value = 1.86 ( Using f table)

Critical value > test statistic so we fail to reject null hypothesis.

Conclusion: The population variances are equal.

So we have to use here pooled variance.

By using Excel we can solve this question easily.

Path is Click on Data ----------> Data Analysis ----------> t-Test: Two samples assuming equal variance ----->

Variable range 1 : Select compound formula 1 values

Variable range 2 : Select compound formula 2 values

Hypothesized differenced value: 0

Alpha: 0.05

Output Range: select an empty cell.

We get

t-Test: Two-Sample Assuming Equal Variances
Compound Formula 1 Compound Formula 2
Mean 74.46667 78.4
Variance 4.326437 4.731034
Observations 30 30
Pooled Variance 4.528736
Hypothesized Mean Difference 0
df 58
t Stat -7.15843
P(T<=t) one-tail 7.94E-10
t Critical one-tail 1.671553
P(T<=t) two-tail 1.59E-09
t Critical two-tail 2.001717

So p-value is near about 0

So p-value < 0.05 we reject null hypothesis.

Conclusion: Compound formula 1 will result better product.

Add a comment
Know the answer?
Add Answer to:
Please use only Minitab or Excel. Thank you Please use only Minitab or Excel. Thank you...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding...

    Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding each answer to the nearest whole number. Using the frequency distribution below (scores on a statistics exam taken by 80 students), determine:ion 1 of the preliminary test (scores on a statistics exam taken by 80 students), determine: 68 84 75 82 68 90 62 88 76 93 73 79 88 73 60 93 71 59 85 75 61 65 75 87 74 62 95...

  • Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding...

    Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding each answer to the nearest whole number. Using the frequency distribution below (scores on a statistics exam taken by 80 students), determine:ion 1 of the preliminary test (scores on a statistics exam taken by 80 students), determine: 68 84 75 82 68 90 62 88 76 93 73 79 88 73 60 93 71 59 85 75 61 65 75 87 74 62 95...

  • Please compute your z -don't use a package State your conclusion in plain English - not...

    Please compute your z -don't use a package State your conclusion in plain English - not just rejection 1 Students in the online class are suspicious that their schools 60 point loss may have caused their teacher to take out his frustration on the students by giving them a harder than usual exam. They manage to hack into his computer and get the following data: Scores for test Nov 2011 71 74 64 77 58 72 73 79 50 78...

  • Consider the below matrixA, which you can copy and paste directly into Matlab.

    Problem #1: Consider the below matrix A, which you can copy and paste directly into Matlab. The matrix contains 3 columns. The first column consists of Test #1 marks, the second column is Test # 2 marks, and the third column is final exam marks for a large linear algebra course. Each row represents a particular student.A = [36 45 75 81 59 73 77 73 73 65 72 78 65 55 83 73 57 78 84 31 60 83...

  • Use the accompanying data set on the pulse rates​ (in beats per​ minute) of males to...

    Use the accompanying data set on the pulse rates​ (in beats per​ minute) of males to complete parts​ (a) and​ (b) below. LOADING... Click the icon to view the pulse rates of males. a. Find the mean and standard​ deviation, and verify that the pulse rates have a distribution that is roughly normal. The mean of the pulse rates is 71.871.8 beats per minute. ​(Round to one decimal place as​ needed.) The standard deviation of the pulse rates is 12.212.2...

  • From excel please help me find the mean,median,standard deviation,range,maximum,and minimum.All range from 11.04-224.4 Birth Year -12...

    From excel please help me find the mean,median,standard deviation,range,maximum,and minimum.All range from 11.04-224.4 Birth Year -12 49 79 25-29 29 13-14 22 24-13 26 23 27 31 32 26 24 31 23 38 28 21 24 35 23 30 34 31 32 23 27 32 39 25 23. 34 ㄾ 30 24 25 27 24 27 29 24 33 29 23 25 74 78 끄 끄 76 76-73·74一75 77芬、76 80 77-74-72 78 76 78 75 77-74 끄 73、72 76 76...

  • PLEASE SHOW ME HOW TO DO THIS.... For the Excel Data Set please find and report...

    PLEASE SHOW ME HOW TO DO THIS.... For the Excel Data Set please find and report for Test 1 and Test 2 the Mean, SD, and the tolerance levels for both for which there would be any outliers (i.e., the value for which a score must be less than to be consider an outlier and the value for which a number must greater than to be considered an outlier. See picture Performance Data Group 1 1 1 1 Test 2...

  • 5. The response variable is the golf score after practicing a certain number of hours before...

    5. The response variable is the golf score after practicing a certain number of hours before playing a round (18 holes). 0 to less than 2 hours 85 81 82 79 80 84 83 81 2 hours to less than 4 hours 76 78 81 77 80 76 74 80 81 78 4 hours or more 77 73 76 73 75 78 76 72 72 a. Conduct the Hartley’s F-test. State your null and alternative hypotheses. Determine your critical region....

  • Please show all work step by step. thank you! Please read the direction in every problem....

    Please show all work step by step. thank you! Please read the direction in every problem. Show all your work here. (Round probabilities to 4 decimals.) 1. A student earned grades of 84, 78, 84, and 72 on her four regular tests. She earned a grade of 78 on the final exam and 86 on her class projects. Her combined homework grade was 87. The four regular tests count for 40% of the course grade, the final exam counts for...

  • *Please show excel function* What is the probability that a student will be over 60 inches...

    *Please show excel function* What is the probability that a student will be over 60 inches tall? (assume that the data are normally distributed with the population standard deviation =4.25) Height in inches Student 1 64 2 63 3 63 4 63 5 63 6 65 7 66 8 66 9 67 10 68 11 68 12 66 13 68 14 78 15 76 16 75 17 75 18 73 19 73 20 72 21 70 22 70 23 70...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT