11.1 Excel Activity 1b - Confidence Interval for Standard Deviation (Freeform)

See attached for data

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.

.l o ': CENGAGE I MINDTAP 0. Search this course o ' Question 1 1_ 0110 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 le below. Construct a spreadsheet to answer the following questions. xe a. What is the point estimate of the population mean amount adults spend on a Halloween costume (to 2 decimals)? $:l b. What is the sample standard deviation (to 2 decimals)? $:l c. Provide a 95% condence interval estimate of the population standard deviation for the amount adults spend on a Halloween costume {to 2 decimals)? $Esm Check My Work Reset Problem