11.1 Excel Activity 2b - Confidence Intervals for Variance and Standard Deviation (Freeform)

See attached data

The table showing the stock price changes for a sample of 12 companies on a day is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

11.1 Excel Activity 2b - Confidence Intervals for Variance and Standard Deviation (Freeform) Question 1 0110 The table showing the stock price changes for a sample of 12 companies on a day is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Submit a Open spreadsheet a. Compute the sample variance for the daily price change (to 4 decimals). H b. Compute the sample standard deviation for the price change (to 4 decimals). U c. Provide 95% condence interval estimates of the population variance (to 4 decimals). 5625:] d. Provide 95% condence interval estimates of the population standard deviation (to 4 decimals). 503:] Check My Work Reset Problem U U