How would Interpret the following data using two sample t-testing if unequal variances? Each of these columns of data represent a different soda bottling line, with the values representing the amount of soda per bottle in ounces. The business question being asked for each of the three comparisons is "do the two bottling lines bottle the same volume of soda on average, bearing in mind that the sample difference that you may observe could just be coincidence." C7 C9 Mean 20.01679499870 19.98479325352 Variance 0.01032479977 0.00890427549 Observations 50.00000000000 50.00000000000 Hypothesized Mean Difference 0.00000000000 df 97.00000000000 t Stat 1.63184710438 P(T<=t) one-tail 0.05297709034 t Critical one-tail 1.66071461012 P(T<=t) two-tail 0.10595418068 t Critical two-tail 1.98472318601 Need help intrepreting Data using excel : Change number to 11 decimal places or correct intrepretation of data Two Tail P and t -(Excel) Two -Sample Assuming UnEqual Variances (Excel) Need difference between means Est. Error difference Degree of freedom Hypothesis Null Hypothesis Aternative Hypothesis P value 0.05 (alpha ) Is it significant ?
How would Interpret the following data using two sample t-testing if unequal variances? Each of these columns of data represent a different soda bottling line, with the values representing the amount of soda per bottle in ounces. The business question being asked for each of the three comparisons is "do the two bottling lines bottle the same volume of soda on average, bearing in mind that the sample difference that you may observe could just be coincidence."
C7 | C9 | |
Mean | 20.01679499870 | 19.98479325352 |
Variance | 0.01032479977 | 0.00890427549 |
Observations | 50.00000000000 | 50.00000000000 |
Hypothesized Mean Difference | 0.00000000000 | |
df | 97.00000000000 | |
t Stat | 1.63184710438 | |
P(T<=t) one-tail | 0.05297709034 | |
t Critical one-tail | 1.66071461012 | |
P(T<=t) two-tail | 0.10595418068 | |
t Critical two-tail | 1.98472318601 |
Need help intrepreting Data using excel :
Change number to 11 decimal places or correct intrepretation of data
Two Tail P and t -(Excel)
Two -Sample Assuming UnEqual Variances (Excel)
Need difference between means
Est. Error difference
Degree of freedom
Hypothesis
Null Hypothesis
Aternative Hypothesis
P value
0.05 (alpha )
Is it significant ?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps