Please help with the question below.

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.

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)?

$ $

Dollars Spent		Part a			Formula
12		Mean			#N/A
71
24		Part b
63		Standard Deviation			#N/A
35
38		Part c
34		Degrees of Freedom			#N/A
46
51		Lower Limit Critical Chi-square			#N/A
19		Upper Limit Critical Chi-square			#N/A
12
99		The 95% confidence interval
48		C.I.Lower Limit			#N/A
35		C.I.Upper Limit			#N/A
64
28