Americans spend nearly $7 billion on Halloween costumes and decorations. Sample data showing the amount, in dollars, 16 adults spent on a Halloween costume are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet a. What is the point estimate of the population mean amount adults spend on a Halloween costume (to 2 decimals)? $ b. What is the sample standard deviation (to 2 decimals)? $ c. Provide a 95% confidence interval estimate of the population standard deviation for the amount adults spend on a Halloween costume (to 2 decimals)? so≤ $

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
Question
Excel
5
D2
123458UH23
6
7
9
File
10
11
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
21
template - Saved
A
Dollars
Spent
10
71
21
64
35
35
34
45
54
17
11
95
42
33
66
29
Home
=
Insert
B
Arial
X ✓ fx
Part a
Mean
Draw
Part b
Standard Deviation
✓ 10
Page Layout
Part c
Degrees of Freedom
Data +
с
Lower Limit Critical Chi-square
Upper Limit Critical Chi-square
Calculation Mode: Automatic Workbook Statistics
V
The 95% confidence interval
C.I.Lower Limit
C.I.Upper Limit
B
Formulas
V
D
Search (Option + Q)
Data
Review
E
View
Formula
ab
Help
F
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Number
>
G
←0
.00
.00
→.0
H
▬▬▬▬
1
V
J
K
Ev
L
Editing
AP
M
Give Feedback to Microsoft
Comments
N
T
O
100% +
Transcribed Image Text:Excel 5 D2 123458UH23 6 7 9 File 10 11 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 21 template - Saved A Dollars Spent 10 71 21 64 35 35 34 45 54 17 11 95 42 33 66 29 Home = Insert B Arial X ✓ fx Part a Mean Draw Part b Standard Deviation ✓ 10 Page Layout Part c Degrees of Freedom Data + с Lower Limit Critical Chi-square Upper Limit Critical Chi-square Calculation Mode: Automatic Workbook Statistics V The 95% confidence interval C.I.Lower Limit C.I.Upper Limit B Formulas V D Search (Option + Q) Data Review E View Formula ab Help F #N/A #N/A #N/A #N/A #N/A #N/A #N/A Number > G ←0 .00 .00 →.0 H ▬▬▬▬ 1 V J K Ev L Editing AP M Give Feedback to Microsoft Comments N T O 100% +
Americans spend nearly $7 billion on Halloween costumes and decorations. Sample data showing the amount, in dollars, 16 adults spent on a Halloween costume are contained in the
Excel Online file below. Construct a spreadsheet to answer the following questions.
X
Open spreadsheet
a. What is the point estimate of the population mean amount adults spend on a Halloween costume (to 2 decimals)?
$
b. What is the sample standard deviation (to 2 decimals)?
$
c. Provide a 95% confidence interval estimate of the population standard deviation for the amount adults spend on a Halloween costume (to 2 decimals)?
$
<o<$
Check My Work
Reset Problem
Transcribed Image Text:Americans spend nearly $7 billion on Halloween costumes and decorations. Sample data showing the amount, in dollars, 16 adults spent on a Halloween costume are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. What is the point estimate of the population mean amount adults spend on a Halloween costume (to 2 decimals)? $ b. What is the sample standard deviation (to 2 decimals)? $ c. Provide a 95% confidence interval estimate of the population standard deviation for the amount adults spend on a Halloween costume (to 2 decimals)? $ <o<$ Check My Work Reset Problem
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

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