Please use only Minitab or Excel. Thank you
Please use only Minitab or Excel. Thank you
Please use only Minitab or Excel.
Please use only Minitab or Excel.
Thank you
Claim: Compound formula 1 will result better product.
Null and alternative hypothesis is
Vs
For doing this test first we have to check the two groups have population variances are equal or not.
Null and alternative hypothesis is
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.
Please use only Minitab or Excel. Thank you Please use only Minitab or Excel. Thank you...
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 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 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...
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 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 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 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 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. 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 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...