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

please help asap i will upvote!!

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)?
$
≤0<$
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)? $ ≤0<$ Check My Work Reset Problem
B1
12345678
File
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
A
Dollars
Spent
14
72
21
61
35
Home
33
32
44
55
14
13
99
44
35
65
27
B
Insert
Arial
fx
с
Draw
D
Page Layout
10
E
B
Formulas
F
&
Data
G
Review
H
View Help
I
ab
J
C
Transcribed Image Text:B1 12345678 File 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 A Dollars Spent 14 72 21 61 35 Home 33 32 44 55 14 13 99 44 35 65 27 B Insert Arial fx с Draw D Page Layout 10 E B Formulas F & Data G Review H View Help I ab J C
Expert Solution
steps

Step by step

Solved in 7 steps with 5 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

part c is wrong. please fix that!!

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill