Homework Help is Here – Start Your Trial Now!
Math
Statistics
10 1 Sandwich Measurements 12 Store 1 Store 2 Store 3 13 8.8 9.1 9.0 14 11.4 11.6 12.5 15 13.4 13.4 15.1 11.3 11.4 14.3 10.1 10.3 10.8 12.4 13.8 10.6 11.2 9.2 с F 1 Problem: Customers are complaining about sandwich length 2 You are the owner of three local sandwich shops. Recently you've received complaints from customers 3 that their "footlong" sub sandwiches were less than 12 inches long. As a measure of quality assurance, 4 data was collected on all footlong sub sandwiches made over the period of an hour at each store. 5 Determined which, if any, of your stores are making sub sandwiches that are significantly shorter than 12 6 inches. You will conduct three t-tests, one for each store. You want to be 95% confident in your results. 7 (Note. This case is inspired by reality. Search the internet for 'claims over footlong sub' for a historical 8 perspective and how a company used statistics to insure consistent quality.) 19 16 17 18 19 20 21 22 12.4 10.4 8.9 10.4 11.8 12.8 9.3 25 12.6 26 11.7 27 11.8 28 9.7 23 24 29 30 31 32 12.6 8.6 9.1 11.1 14.0 14.3 8.7 E 13.7 12.9 13.0 10.2 14.1 8.6 14.6 11.0 Sample Size Mean (length) Variance Standard Deviation Statistics Hypothesized Mean (M) Difference in Means (X-M) Standard Error T-Statistic Degrees of Freedom H Store 1 Store 2 Store 3 P-value P(T=t) two-tail* *Remember that the T.DIST.2T() function requires the t-statistic argument to be an absolute value, not a negative value, or an error will occur. Interpret the Results 1. What is the null hypothesis for these tests? 2. What is the alternative hypothesis for these tests? 3. Given the desired confidence level, what alpha should be used?

10 1 Sandwich Measurements 12 Store 1 Store 2 Store 3 13 8.8 9.1 9.0 14 11.4 11.6 12.5 15 13.4 13.4 15.1 11.3 11.4 14.3 10.1 10.3 10.8 12.4 13.8 10.6 11.2 9.2 с F 1 Problem: Customers are complaining about sandwich length 2 You are the owner of three local sandwich shops. Recently you've received complaints from customers 3 that their "footlong" sub sandwiches were less than 12 inches long. As a measure of quality assurance, 4 data was collected on all footlong sub sandwiches made over the period of an hour at each store. 5 Determined which, if any, of your stores are making sub sandwiches that are significantly shorter than 12 6 inches. You will conduct three t-tests, one for each store. You want to be 95% confident in your results. 7 (Note. This case is inspired by reality. Search the internet for 'claims over footlong sub' for a historical 8 perspective and how a company used statistics to insure consistent quality.) 19 16 17 18 19 20 21 22 12.4 10.4 8.9 10.4 11.8 12.8 9.3 25 12.6 26 11.7 27 11.8 28 9.7 23 24 29 30 31 32 12.6 8.6 9.1 11.1 14.0 14.3 8.7 E 13.7 12.9 13.0 10.2 14.1 8.6 14.6 11.0 Sample Size Mean (length) Variance Standard Deviation Statistics Hypothesized Mean (M) Difference in Means (X-M) Standard Error T-Statistic Degrees of Freedom H Store 1 Store 2 Store 3 P-value P(T=t) two-tail* *Remember that the T.DIST.2T() function requires the t-statistic argument to be an absolute value, not a negative value, or an error will occur. Interpret the Results 1. What is the null hypothesis for these tests? 2. What is the alternative hypothesis for these tests? 3. Given the desired confidence level, what alpha should be used?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 22PFA
See similar textbooks
icon
Related questions
Question

Hello. can someone let me know what formulas I would use for the tan part of the spreadsheet?

 Write formulas for each tan colored cell in the “statistics” table

 

D F Problem: Customers are complaining about sandwich length 2 You are the owner of three local sandwich shops. Recently you've received complaints from customers 3 that their "footlong" sub sandwiches were less than 12 inches long. As a measure of quality assurance, 4 data was collected on all footlong sub sandwiches made over the period of an hour at each store. 234567 11 Sandwich Measurements 12 Store 1 Store 2 9.1 13 8.8 14 11.4 11.6 13.4 15 13.4 16 11.3 11.4 17 10.1 10.3 18 12.4 12.4 10.6 9.2 19 20 21 22 A 5 Determined which, if any, of your stores are making sub sandwiches that are significantly shorter than 12 6 inches. You will conduct three t-tests, one for each store. You want to be 95% confident in your results. 7 (Note. This case is inspired by reality. Search the internet for 'claims over footlong sub' for a historical 8 perspective and how a company used statistics to insure consistent quality.) 9 10 23 24 29 30 31 32 10.4 8.9 10.4 11.8 12.8 9.3 25 26 27 11.8 28 9.7 12.6 11.7 B 12.6 8.6 Store 3 9.0 12.5 15.1 14.3 10.8 13.8 11.2 9.1 11.1 14.0 14.3 8.7 13.7 12.9 13.0 10.2 E 14.1 8.6 14.6 11.0 Sample Size Mean (length) Variance Standard Deviation Statistics Hypothesized Mean (M) Difference in Means (X-M) Standard Error T-Statistic Degrees of Freedom G Store 1 H Store 2 Store 3 P-value P(T=t) two-tail* *Remember that the T.DIST.2T() function requires the t-statistic argument to be an absolute value, not a negative value, or an error will occur. Interpret the Results 1. What is the null hypothesis for these tests? 2. What is the alternative hypothesis for these tests? 3. Given the desired confidence level, what alpha should be used?
Transcribed Image Text:D F Problem: Customers are complaining about sandwich length 2 You are the owner of three local sandwich shops. Recently you've received complaints from customers 3 that their "footlong" sub sandwiches were less than 12 inches long. As a measure of quality assurance, 4 data was collected on all footlong sub sandwiches made over the period of an hour at each store. 234567 11 Sandwich Measurements 12 Store 1 Store 2 9.1 13 8.8 14 11.4 11.6 13.4 15 13.4 16 11.3 11.4 17 10.1 10.3 18 12.4 12.4 10.6 9.2 19 20 21 22 A 5 Determined which, if any, of your stores are making sub sandwiches that are significantly shorter than 12 6 inches. You will conduct three t-tests, one for each store. You want to be 95% confident in your results. 7 (Note. This case is inspired by reality. Search the internet for 'claims over footlong sub' for a historical 8 perspective and how a company used statistics to insure consistent quality.) 9 10 23 24 29 30 31 32 10.4 8.9 10.4 11.8 12.8 9.3 25 26 27 11.8 28 9.7 12.6 11.7 B 12.6 8.6 Store 3 9.0 12.5 15.1 14.3 10.8 13.8 11.2 9.1 11.1 14.0 14.3 8.7 13.7 12.9 13.0 10.2 E 14.1 8.6 14.6 11.0 Sample Size Mean (length) Variance Standard Deviation Statistics Hypothesized Mean (M) Difference in Means (X-M) Standard Error T-Statistic Degrees of Freedom G Store 1 H Store 2 Store 3 P-value P(T=t) two-tail* *Remember that the T.DIST.2T() function requires the t-statistic argument to be an absolute value, not a negative value, or an error will occur. Interpret the Results 1. What is the null hypothesis for these tests? 2. What is the alternative hypothesis for these tests? 3. Given the desired confidence level, what alpha should be used?
Expert Solution
steps

Step by step

Solved in 3 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS