Statistics 101

1. Use of Analysis ToolPak in MS Excel
    How to load
2. Get frequencies
   *) Data tab -> Data analysis -> Histogram
   *) Input range, select bin ranges (category ranges) -> OK
3. Constructing frequency polygon
   1st get midpoint in a row
   Then selecting frequencies draw 2 D line chart
   Then right on graph area -> Data option
   Select 'Edit' from horizontal axis label and highlight midpoint row
   OK on Select Data Source box