Hi!
i'm assuming I need to add some function
to enable the frequency thing?
The frequencies are calculated and are output in the histogram.
Assume your data is in the range A1:B5
Bins are in the range C1:C10
Goto ToolsData Analysis
Select Histogram
Fill in the user form
OK
Don't know what is meant by a frequency histogram and a relative frequency
histogram.
Biff
"confusedstudent"
confusedstudent.22w6db_1139370601.7653@excelfor um-nospam.com wrote in
message news:confusedstudent.22w6db_1139370601.7653@excelf orum-nospam.com...
Hi,
I'd like to start by thanking everyone in advance for helping students
like me.
I have a problem I'm working on for class and it goes something like
this:
"The salaries (in hundreds of dollars) of a sample of 40 government
employees are as follows:
208 160 175 ...
265
173
..
Construct both a frequency histogram (vanilla) and a relative frequency
histogram (chocolate). Hint: use six bins."
Now I've enabled the "Data Analysis" feature, but i'm assuming I need
to add some function to enable the frequency thing?
I apologize for being so lost - I'm trying!
Thanks people!
--
confusedstudent
------------------------------------------------------------------------
confusedstudent's Profile:
http://www.excelforum.com/member.php...o&userid=31295
View this thread: http://www.excelforum.com/showthread...hreadid=509684