Modify the Module 5 lecture companion spreadsheet (the Descriptive Statistics Calculator) in the following ways and submit the modified spreadsheet via this link.

Insert two columns to the right of the data column and delete the Standardized column.

In the first inserted column, now column B, provide the calculated Z score for 2,000 rows of data and in the second inserted column, now column C, provide the calculated t score for 2,000 rows of data display 4 decimal places and document with a cell comment when to use the Z score and when to use the t score. (10 points)

Program the calculations to result in a blank cell if the corresponding cell in column A is empty. (5 points)

Provide a margin of error and confidence interval calculation for the mean using t and a confidence interval for the standard deviation using X² use a cell comment to document when to use the margin of error and confidence interval and when not to. (10 points)