**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.