A 1 B C D E 2 Temperature Samples Size 67.4 Variance 10 =COUNT(A3:A12) 0.7 VAR.S(A3:A12) 3 4 67.8 5 68.2 Conf Coeff 69 69.3 Alpha CO 8 9 10 11 12 13 14 15 16 69.5 Chi-Sq Value Low Tail 67.0 Chi-Sq Value Upper Ta 68.1 68.6 Point Estimate 67.9 Lower Limit S^2 67.2 Upper Limit S^2 Lower Limit S Upper Limit S 0.95 Given 0.05 =1-C5 2.70 =CHISQ.INV(C6/2,C2-1) includes alpha/2 19.02 =CHISQ.INV.RT(C6/2,C2- includes alpha/2 0.70 =C3 0.33 =((C2-1)*C3)/C8 2.33 =((C2-1)*C3)/C7 0.58 =SQRT(C11) 1.53 =SQRT(C12) E G H Americans spend nearly $7 billion in Halloween costumes and decorations. Sample data is shown in the 2 spend column for 16 adult purchases. 1234567 Complete the following template and answer a and b to the right. Highlight the answer to c as described in the question. a. What is the estimate if the population mean amount spend on a Halloween costume? Answer a 7 8 b. What is the sample standard deviation? b 9 10 c. Provide a 95% confidence interval estimate of the population standard deviation for the spend on 11 Halloween costume by highlighting your answer in yellow. 12 13 Spend Samples Size #N/A 14 12 Variance #N/A 15 33 16 52 Conf Coeff Given 17 45 Alpha #N/A 18 69 Chi-Sq Value Low Tail #N/A 19 36 Chi-Sq Value Upper Tail #N/A 20 16 21 32 Point Estimate #N/A 22 22 Lower Limit S^2 #N/A 23 31 Upper Limit S^2 #N/A 24 13 25 63 Lower Limit S #N/A 26 64 Upper Limit S #N/A 27 44 28 98 29 20 26
A 1 B C D E 2 Temperature Samples Size 67.4 Variance 10 =COUNT(A3:A12) 0.7 VAR.S(A3:A12) 3 4 67.8 5 68.2 Conf Coeff 69 69.3 Alpha CO 8 9 10 11 12 13 14 15 16 69.5 Chi-Sq Value Low Tail 67.0 Chi-Sq Value Upper Ta 68.1 68.6 Point Estimate 67.9 Lower Limit S^2 67.2 Upper Limit S^2 Lower Limit S Upper Limit S 0.95 Given 0.05 =1-C5 2.70 =CHISQ.INV(C6/2,C2-1) includes alpha/2 19.02 =CHISQ.INV.RT(C6/2,C2- includes alpha/2 0.70 =C3 0.33 =((C2-1)*C3)/C8 2.33 =((C2-1)*C3)/C7 0.58 =SQRT(C11) 1.53 =SQRT(C12) E G H Americans spend nearly $7 billion in Halloween costumes and decorations. Sample data is shown in the 2 spend column for 16 adult purchases. 1234567 Complete the following template and answer a and b to the right. Highlight the answer to c as described in the question. a. What is the estimate if the population mean amount spend on a Halloween costume? Answer a 7 8 b. What is the sample standard deviation? b 9 10 c. Provide a 95% confidence interval estimate of the population standard deviation for the spend on 11 Halloween costume by highlighting your answer in yellow. 12 13 Spend Samples Size #N/A 14 12 Variance #N/A 15 33 16 52 Conf Coeff Given 17 45 Alpha #N/A 18 69 Chi-Sq Value Low Tail #N/A 19 36 Chi-Sq Value Upper Tail #N/A 20 16 21 32 Point Estimate #N/A 22 22 Lower Limit S^2 #N/A 23 31 Upper Limit S^2 #N/A 24 13 25 63 Lower Limit S #N/A 26 64 Upper Limit S #N/A 27 44 28 98 29 20 26
Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section11.4: Collecting Data
Problem 3E
Related questions
Question
Please answer the questions in excel the photo and show the excel equations used. Answer the questions with the yellow blanks. The other photo is an example.
Thankyou
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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt