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
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
Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter13: Probability And Calculus
Section13.3: Special Probability Density Functions
Problem 16E
Related questions
Question
Please answer the questions in excel and show the correct equations.
Thank you
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,