To hide a column or row, right-click on the letter or number for the column or row (A, B, C, etc. The same technique works for rows put your cursor between the two numbers until you see the two-headed arrow, and then drag or double-click. When you get the two-headed arrow, drag to the right or left as desired.ĭouble-clicking on that same spot will “autofit” the column, making the column as wide as the largest piece of text/data in that column. You can change a column's width by putting your cursor between the letter for that column and the next. You can also access the headers and footers via the Insert ribbon. With the Page Setup dialog box open, you can click on the Header/Footer tab to change them. g., A, B, C, 1, 2, 3, etc.) not the sheet's headers and footers. Note that the Print Titles icon evokes the Page Setup dialog box, and that Print Titles here refers to the row and column headings (e. In the Page Setup group, you can set the margins, orientation, and print area. Just as the Home ribbon provides you with the options that used to be only accessible in the Format Cells dialog box, the Page Layout ribbon gives you access to features that used to be in the Page Setup dialog box (click on the Expand icon to access that traditional dialog box). You can also click on the Expand icon to open the traditional Format Cells dialog box that contains tabs for these various categories.
Column C then displays the frequency distribution of the data set.Ĭlick the "Insert" tab, select "Insert Column Chart" in the Charts group and then choose the first option in the 2-D Column or 3-D Column section to create a frequency chart to visually display the results.Copy the data, and then right-click the cell you would like to paste it into. Press the "F2" key and then press "Ctrl-Shift-Enter" to copy the formula as an array.
In the example, hold the "Shift" key and click cell C5 to select cells C1 through C5. Hold the "Shift" key and click the last cell in column C that corresponds to the last bin value in column B. In the example, type "=Frequency(A1:A50,B1:B5)" in cell C1. Replace "data_range" and "bin_range" with the actual range of data and bin values. Type "=Frequency(data_range,bin_range)" (without quotes here and throughout) in cell C1, but don't press "Enter" yet. In the example, you might enter "20," "40," "60," "80" and "100" in cells B1 through B5 to find the frequency distribution of scores in ranges of 20 points each. These values correspond to non-overlapping numerical ranges and should be listed in ascending order.
Enter the list of bin values in column B.