- 1). Launch Excel from the Microsoft Office folder, which is located in the Applications folder in the Finder. Select “Excel Workbook” from the Project Gallery and click “OK.”
- 2). Create three column titles in the first row, by typing “Data” in cell A1, “Range” in A2 and “Distribution” in A3. Click and drag the lines between columns to adjust the column size as needed. Drag the cursor over these three cells and press “Command-B” to make the font bold.
- 3). Enter your collected data in the first column beginning with cell A2. For example type “19,” “22,” “44,” “45,” “52,” “62” and “72” in cells A2 to A8.
- 4). Enter the ranges you want to see in the second column. For example, to see ranges in groups of 10, type “20,” “30,” “40,” “50,” “60,” “70” and “80” in cells B2 to B8.
- 5). Click cell “C2” to highlight it. Locate the Function Button in the Toolbar at the top of the screen and click the arrow beside it. Click “More Functions” from the drop-down menu.
- 6). Click “Statistical” in the Function Category menu. Click “Frequency” in the Function Name menu. The required format for the function and a description appear at the bottom of the window.
- 7). Read this information at the bottom of the window. Note that two values are required in the Frequency function, a data array and a bins array, separated by a comma and both within one set of brackets. Click “OK.” The Frequency dialog box opens with the cursor already in the Data Array text field.
- 8). Type “A2:A8” in the Data Array field. Press “Tab,” then type “B2:B8” in the Bins Array field. Click “OK.” A number appears in cell C2, showing the number of times a data value appears that is equal to or less than the value in cell B2. In this example, the number one appears, representing the number of items in the data column below 20.
- 9). Click cell A2 and change the number from 22 to 20. Notice that the value in Cell C2 changes from one to two.
- 10
Double-click cell “C2” to reveal the function. Drag the cursor over the entire function and press “Ctrl-X” to cut it. Press “Enter.” - 11
Click on cell “C2” again, then drag the mouse down to cell “C8.” Press any letter on the keyboard. This is only to make the cursor appear in cell C2. Press “Delete” to delete that letter, then press “Ctrl-V” to paste the function back in the cell again. Hold down the “Shift” and “Command” keys and press “Enter.” This key combination will fill the cells with an analysis for the range entered in the cell beside them. - 12
Create a graph for the distribution analysis by highlighting Cells C2 through C8. Click the “View” menu, select “Toolbars” and click “Chart.” Click the “Chart” menu, then click “Line Chart.” A line chart of the distribution appears.
- Advertisement -
- Advertisement -