Excel Exercises

Question 1

Plot the distribution of the grades in a course. The data follow.

Grade	# of students
A	11
B	27
C	33
D	16
F	6

Question 2

A financial manager in a firm wants to know how profit margins have done for the past 16 quarters. The data follow.

Quarter	Profit Margin
1	5.05
2	4.10
3	5.15
4	5.20
5	6.75
6	5.30
7	5.35
8	5.40
9	5.95
10	5.50
11	5.15
12	5.60
13	5.65
14	6.70
15	5.75
16	5.80

a. Develop a line graph.

b. Smooth the data using a Moving Average (create a separate column using formulas).

Hint: A period's moving average value is the mean of the values for that period, the period before, and the period after.

c. In the above line graph (see a), plot the moving average of the profit margin.

You can also download the excel version of this page.