Question

Calculate the mean and standard deviation of the following five numbers: 56.31, 56.74, 57.35, 56.10, 56.02 The figure shows a suggested setup for your spreadsheet where you enter the data in the yellow cells and enter formulas in cells C4:D8 and B9:B11 to carry out the appropriate calculations.

Use a spreadsheet to calculate the mean and standard deviation of the following five numbers 56.31, 56.74, 57.35, 56.10, 56.02 The figure shows a suggested setup for your spreadsheet where you enter the data in the yellow cells and enter formulas in cells C4:D8 and 11 to carry out the appropriate calculations Number 1 Computing Standard Deviation mean 56,50 D5 Enter your data here Number standard .587 deviation mean 111 Std dev There is additional feedback available! Incorrect. bottom divider bar. Click on the divider bar again to hide the additional feedback. Close Previous Give Up & View solution Try Again Next Ext

Answer 1

Mean Number r val =51.50 t 20 2.09 S tandewd deviation