Homework Help is Here – Start Your Trial Now!
Math
Statistics
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

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
Please answer the questions in excel and show the correct equations. Thank you
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
Transcribed Image Text: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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS