Level of Significance - Calculated 10. 11 12 13 14 15 16 17 18 19 Ho: v₁-20 20 Ha: v₁->0 Degrees of Freedom (df) t value Margin of Error Point Extimate of Difference Lower Limit Upper Limit Calculated Estimate of Variance Squared/([Car A Sample Size -1) (Car A Sample Standard Deviation Squared/Car A Sample Size)Squared +(1/(Car B Sample Size -1) (Car B Sample Standard Deviation Squared/Car A 0.00 Sample Size)Squared =TINV(probability-use alpha cell,deg freedom-use df cell) t value Standard Error #N/A =E6 2/((1/(C2-1)) (C4 2/C2r2+(1/(D2-1) (D4 2/ #N/A #N/A #N/A #N/A #N/A 22 23 24 21 Comparison of 2 cars gas mileage testing to see if Car A is better than Car B Level of Significance - Given Test Statistic - Calculate p-value calculated 0.050 =((C3-D3)-0)/SQRT((2.56)2/24+(1.81) 2/28) #N/A Use = TDIST(Test Statistic cell location, df cell location, enter the number of tails of 1) #N/A 25 Rule/Decision Statement: 26 27 CV tscore of alpha - calculated Use -T.INV(alph cell location, df cell location) #N/A 28 29 Rule/Decision Statement: 30 31 32 33 34 35 CAR A CAR B 2 Sample Size 24 28 3 Sample Mean (mpg) 29.8 27.3 4 Sample Standard Deviation (n 2.56 1.81 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ho: u₁-20 20 Ha: v₁-> 0 Estimate of Variance - Calculated Standard Error - Calculated Confidence Coefficient - Given Level of Significance - Calculated Degrees of Freedom (df) value Margin of Error Point Estimate of Difference Lower Limit Upper Limit 0.9 Car A Sample Standard Deviation Squared/Car A Sample Size plus Car B Sample Standard Deviation Squared/Car B Sample Size The Square Root of the Estimate of Variance Calculated Estimate of Variance Squared/1/Car A Sample Size -1) (Car A Sample Standard Deviation Squared/Car A Sample Size)Squared +(1/(Car B Sample Size-1)*(Car B Sample Standard Deviation Squared/Car A 0.00 Sample Size Squared =TINV probability-use alpha cell deg freedom-use df cell) t value Standard Error #N/A #N/A #N/A =E62/((1/(C2-1)) (C4 2/C2)2+(1/(D2-1)* (D4 2/D212) #N/A #N/A #N/A #N/A #N/A 21 Comparison of 2 cars gas mileage testing to see if Car A is better than Car B 22 23 24 25 Rule/Decision Statement: 26 Level of Significance - Given Test Statistic - Calculate p-value calculated 0.050 =((C3-D3)-0)/SQRT((2.56)2/24+(1.81)^2/28) Use TDIST(Test Statistic cell location, df cell location, enter the number of tails of 1) #N/A #N/A