PC Review


Reply
Thread Tools Rate Thread

Re: Frequency Function

 
 
dvt
Guest
Posts: n/a
 
      28th Jul 2003
Jason wrote:
> Hey, I have a question regarding Frequency. I have a list
> of data that I need to be counted and sorted into classes
> of 1-10, 11-20, 20-30. How do I go about doing that?
> I've ran the Frequency function, but it gave me way more
> results than their was actual data. Any help will be
> appreciated! Thanks.


You should be able to use the Histogram feature from the Analysis Toolpak.
Search for histogram in the help of Excel and you'll get the instructions
for finding and installing that add-in if you don't already have it
installed.

Dave
dvt at psu dot edu


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a SUM-function equivalent to the FREQUENCY-function? jmk@larvikbanken.no Microsoft Excel Worksheet Functions 5 18th May 2007 02:21 PM
histograms - frequency and relative frequency? confusedstudent Microsoft Excel Misc 2 8th Feb 2006 09:20 AM
Frequency within a frequency Vick Microsoft Excel Discussion 2 3rd Jul 2004 10:02 PM
frequency distribution and percentage frequency jeanne Microsoft Excel Charting 1 13th Jan 2004 08:43 PM
Error in using "Frequency" function in VBA code Gregg Ferguson Microsoft Excel Programming 1 10th Nov 2003 01:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:17 AM.