How do you create a freqency table in excel?

Answer 1

You need your actual values that you are getting your frequencies from first. Then you need a table of the category ranges that you want to get the frequencies within, such as having 10, 20, 30 etc., to see the amount of values within each range. Arrange these in a column. Then select the blank cells beside that column. With those blank cells still selected, in the first of them start the formula by typing =FREQUENCY( and then select the cells that you are trying to get frequencies for. Then press the comma key and then select the range with the categories. Then press the ) key. Then press Ctrl - Shift and Enter and the formula will fill out into the selected cells.

Answer 2

A table can mean different things. It may be just a block of data with headings for the columns and/or the rows. It can also be a table where you have values down the first column and across the first row. These can then be used in conjunction with a formula to create a set of data, like multiplying each value in the row by each value in the column. You can have what are called one-input or two-input tables. The formula can go into the cell that would be both at the start of the first row and the start of the first column. Then you would select the rectangular area starting from the formula cell and going down to the last value in the first column and across to the last value in the first row. Then you would use the menu item from the data menu or the equivalent on the ribbon, depending on your version of Excel, to create the table, by specifying what kind of table you want.