how to make a frequency graph in excel for a mac

The frequency formula will be copied into all of the cells.Ĭlick and drag to highlight the data in the frequency distribution column. Click the mouse at the end of the formula in the formula bar and press 'Command' and 'Enter' on the keyboard. Click and drag to highlight all of the values in for the frequency, in this example they would be in column 'B.' Press 'Enter.'Ĭlick and drag to select all the cells in the frequency distribution column, starting with the cell where you entered the formula and ending with the last cell that has a bin array value to the left. In this example it would be the cells in column 'A.' Type a comma which will highlight 'bin_array' in the formula bar. For example, if you are using a percentage scale, you would want to end at '100.' When you're done, press 'Enter.'Įnter a column heading for the next column over and label it as 'Frequency Distribution.' In the first blank cell under the heading, type the formula '=Frequency(' and then you will see in the formula bar the labels 'data_array' and 'bin_array.' Click 'data_array' and then click and drag on the spreadsheet to select all of the data cells. Click and drag downward to copy the formula until the last number shows the maximum limit for your frequency distribution. Hold your mouse pointer over the lower, right corner of the cell so that it turns into a black cross. After you type in the formula, but before you press 'Enter' the cell will be highlighted with a bold outline.

In the next cell below that, enter the formula: '=B2+10' where 'B2' is the cell where you entered zero and '10' is the number of units you want to show for each section of your frequency distribution. The Frequency function refers to this limit as the 'Bin Array.' In the first cell under the column heading, type the number zero.

For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. Type a new column heading in a blank column to indicate the frequency limits that you want.

How to make a frequency graph in excel for a mac