Objective 1 Create a histogram and a frequency table 2 Creat

Objective:

1. Create a histogram and a frequency table.

2. Create classes, and class widths

DATA:

FREQUENCY:

a. Select cells E2:E6

b. Type, but do not press enter: =FREQUENCY(A2:A41,D2:D6)

c. Press CTRL+SHIFT+ENTER and the array formula will be entered into each of the cells E2:E6 [If you have trouble with this shortcut then you will need to input this formula individually into each cell –do not drag for copy]. Check your frequency sum “n”.

HISTOGRAM:

a. Select cells E2:E6

Choose the Insert tab at the top.

Choose Column and the first Graph from the 2-D section (Clustered Column).

Go to Chart Layout section and choose Layout 8

iv. In the chart itself:

1. Click on Axis Title for X-axis. Change to name to Classes

2. Click on Axis Title for Y-axis. Change the name to Frequency

3. Click on Data or Chart Title. Change the name to Project One

4. Right-Click on the grid tick marks for the x-axis

a. Select Data Source

b. Click Edit in the category

c. Highlight cells C2:C6 from the spreadsheet

d. Click ok

5. Right Click anywhere within the columns and add Data Labels

i. Go to Print Preview.

i. Go to Page Set- up and choose Landscape then

ii. Go to Margins tab.

1. Right & Left Margins= 0.75; Top Margin = 0.6 and Bottom Margin = 0.5

iii. Go to Page tab and choose Fit

iv. Go to Header/Footer tab and choose Custom Header

1. In the Center Section type your name and then click ok.

i. Choose the Insert tab at the top.

ii. Choose Column and the first Graph from the 2-D section (Clustered Column).

iii. Go to Chart Layout section and choose Layout 8