LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
simple frequencies tom g Excel Discussion (Misc queries) 5 September 4th 06 04:22 PM
graphing data of different frequencies Bob Charts and Charting in Excel 3 June 12th 06 08:17 PM
Converting between different frequencies for time series data hello Excel Discussion (Misc queries) 1 June 4th 06 05:23 PM
how to count the number of text frequencies and copy to other cell DG Excel Worksheet Functions 1 October 6th 05 07:11 PM
Rounding a number to a multiple quantity that adds to a fixed total number wjlo Excel Worksheet Functions 1 November 9th 04 04:43 PM


All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"