Please do not copy from other source, thank you very much.

D. Spreadsheet Analysis "Measures of Central Tendency" (12 points)

Please set up an Excel spreadsheet using data from Table 3.1 (Textbook). Then compute the sample mean, standard deviation, variance, and coefficient of variation of each of the following microeconomic variables:

1. Net Profit.

2. Net Profit Margin.

3. Sales Revenue.

3.3 15.6 21.1 4.4 12.2 36.1 7.6 16.0 47.6 6.5 14.8 43.8 7.1 14.3 49.7 5.8 14.3 40.6 2.9 14.3 20.3 4.7 15.3 30.8 7.4 15.1 49.0 3.2 15.4 20.8 4.4 14.9 29.5 5.6 15.3 36.6 3.3 16.2 20.4 Mean 5.0 14.8 33.7 Sample variance 2.2 1.2 104.4 Sample standard deviation 1.5 1.1 10.2