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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
Transcribed Image Text: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)
Transcribed Image Text: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
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
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman