software

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:

quot;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.quot;

Now I've enabled the quot;Data Analysisquot; 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: www.excelforum.com/member.php...oamp;userid=31295
View this thread: www.excelforum.com/showthread...hreadid=509684Hi!

gt;i'm assuming I need to add some function
gt;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 Toolsgt;Data 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

quot;confusedstudentquot;
lt;confusedstudent.22w6db_1139370601.7653@excelfor um-nospam.comgt; wrote in
message news:confusedstudent.22w6db_1139370601.7653@excelf orum-nospam.com...
gt;
gt; Hi,
gt;
gt; I'd like to start by thanking everyone in advance for helping students
gt; like me.
gt;
gt; I have a problem I'm working on for class and it goes something like
gt; this:
gt;
gt; quot;The salaries (in hundreds of dollars) of a sample of 40 government
gt; employees are as follows:
gt;
gt; 208 160 175 ...
gt; 265
gt; 173
gt; ..
gt;
gt; Construct both a frequency histogram (vanilla) and a relative frequency
gt; histogram (chocolate). Hint: use six bins.quot;
gt;
gt; Now I've enabled the quot;Data Analysisquot; feature, but i'm assuming I need
gt; to add some function to enable the frequency thing?
gt;
gt; I apologize for being so lost - I'm trying!
gt;
gt; Thanks people!
gt;
gt;
gt; --
gt; confusedstudent
gt; ------------------------------------------------------------------------
gt; confusedstudent's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31295
gt; View this thread: www.excelforum.com/showthread...hreadid=509684
gt;
quot;Biffquot; wrote:
gt; Don't know what is meant by a frequency histogram and a
gt; relative frequency histogram.

In the first case, the y-axis is the frequency represented by each
bin, as you might be used to. In the second case, the y-axis is
the percentage of the total in each bin-- the bin frequency divided
by the sum of the frequencies (total number of data).

Two distributions can have the same relative frequency
histogram, but different frequency histograms. For example,
consider a uniform distribution of 1000 data and 10000 data
over 10 bins. In the frequency histogram, the y-axis is 100
and 1000 respectively. In the relative frequency histogram,
the y-axis is 0.1 in both cases.