Frequency Distribution table and Histogram.

Step 1. Log on, click on Microsoft Excel.

Step 2. Enter data as follows:

⦁ In cell A1, type the title “Lab #1 – Frequency table and Histogram”

⦁ In cell A2, type your name

⦁ In cell A4, type the heading “Ages of Oscar Winning Actors”

⦁ Enter the following data in two columns:
Column A: cells A5 – A21
Column B: cells B5 – B21

Column A: 32  37  36  32  51  53  33  61  35  45  55  39  76  37  42  40  32
Column B: 60  38  56  48  48  40  43  62  43  42  44  41  56  39  46  31  47
Step 3. Constructing Frequency table and Histogram:
Enter the upper limits (2k > 34, so k = 6, i.e. the # of classes = 6,
class width = (max. – min.)/6 = (76 – 31)/6 = 7.5, rounding up, class width = 8.
Upper limits are: 37, 45, 53, 61, 69, and 77.
Type “Bin range” in cell D3 and enter the upper limits in cell D4 – D9.
Place cursor on an empty cell, say cell E4.
Select Data tab
Select Data Analysis (if your page doesn’t have this option, read the ‘instruction’ section of the Lab.
Click on Histogram and click OK
Go to input range and click on the red arrow icon to the right, highlight the data you entered in the two columns (A5 – A 21, B5 – B21) and click in the same icon.
Go to bin range (cells D4 – D9) and highlight the bin range column and enter the upper limits.
Click on output Range and type cell “E4”
Click on Chart output and click OK.
Modify the Bar Chart
To convert it to Histogram, follow these steps:
⦁ Right-click the center of one of the bars in the histogram and select “Format Data Series…”.
⦁ Choose “Series Options” from the menu at the left and pull the slider under “Gap Width” all the way to “No Gap”.
⦁ Choose “Fill” from the menu at the left and select “No Fill”.
⦁ Choose “Border Color” from the menu on the left and select “Solid line”.  Click “Close”.

Explain