If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
histograms - frequency and relative frequency?
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 |
#2
|
|||
|
|||
histograms - frequency and relative frequency?
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 |
#3
|
|||
|
|||
histograms - frequency and relative frequency?
"Biff" wrote:
Don't know what is meant by a frequency histogram and a 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a Histogram for relative frequency distributions? | pipereed | General Discussion | 1 | February 28th, 2005 04:40 AM |
histograms with normal distributions | P.-S. ROSS | Worksheet Functions | 4 | September 16th, 2003 10:14 AM |