Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up - number data and frequencies
Hi-
I am trying to capture the frequencies of a data set of numbers. The numbers were recorded with one decimal point, and I am only trying to capture whole numbers. I have 11,300 records, and I would like to avoid manually rounding these numbers to the nearest whole number, but I need an accurate frequency count. How can I round up these numbers and count them specifically? (Rather than count the original data set that contains something similar to 13.1, 13.2, 13.2, 13.6, 13.8, etc.) Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple frequencies | Excel Discussion (Misc queries) | |||
graphing data of different frequencies | Charts and Charting in Excel | |||
Converting between different frequencies for time series data | Excel Discussion (Misc queries) | |||
how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |