 Hi, this is Dr. Don. I have a problem out of Chapter 2, Section 1 in which you need to construct a frequency distribution and then a relative frequency histogram using the data you're given and five classes. So here is our problem and I'll work it step by step using Excel. First thing I want to do is click on the little icon there, the data table, open it to get the data. I want to click there to copy it to the clipboard, go to copy, then I'm going to go over here into my Excel and then paste that data there. I'm going to click done, we're done there. Alright, first thing we need to do is to get some information over there. I'm going to start writing it in. Okay, I've typed in some information we'll need. The number of bins we're given and that is five. We need to find the minimum value and I'll use equal m-i-n to call up that function and I need our range of data hit enter. So our min is 52. We need the max same range. We need to get the actual range. I was misspeaking there. So, whoops, equal max minus min equals 23. The width we take equal again, take our range, divide by the number of bins and that gives us 4.6. When we're doing histograms, we always have to round and we need to round up. So I'm going to go equal r-o-u-n-d and there's my roundup function. The number is there, comma and I want zero decimal places for this problem hit enter. So my width is five. Okay, now we need to start calculating our upper and lower limits. The lower limit is just equal to the minimum value. So I click there. The next lower limit is equal to that minimum value plus the width that there in D6. I want to hit function key F4 to lock it and that gives me 57 for the lower limit there. Now I can drag this down to get my lower limits for the remaining four bins. My upper limits in my stat lab, Larson, is to take this second bin lower limit and then minus one since we're dealing with zero decimal places here. That gives me 56 and now I can drag this all the way down and you notice I get a negative there and that's because I don't have anything that's a track from so I always drag it further down and that gives me my lower limits and upper limits 52, 56, 72, 76 and you can see that matches the classes over here. Okay, we're going to get our frequencies and to do that we're going to use the XL frequency function. It's a special function, an array function and we start out by selecting the five bins plus one in case there's some additional data you always select one additional and the way I remember that is I have to use one additional there in order to get the number of bins and then I just start typing equal f or eq to call up their frequency function click on that it wants to have the data array so I'm going to select my data hold down the control the put in a comma I'm sorry put in a comma and then my upper limits and I just need the five and then to enter it we've got to go control shift enter and there we get our frequencies 4 11 4 4 1 and the zero in that overage and you can see that matches the answers over here so we need to get our total I'm going to use the sum function and add those up and so we've got a total of 24 the relative frequency is just equal to the frequency divided by the total and I'm going to hit f4 to lock that and so that gives me a frequency of 0.1167 and I can drag that down to get my relative frequencies and so we're going to plot these I'm going to use the upper bin I'm going to highlight those hold down the control key and then hold down my frequencies and then I'm going to go to insert recommended charts there's a column chart I'll start with that and that gives me a column chart we've got to get rid of the gap so I'm going to click on one and it opens up a little menu we're going to get rid of the gap I'm going to go there and to the border and I want it to be black so I can see it close this and there is my histogram I'm not going to put a title there now we can compare with our alternatives and the best matches over here charlie you can see that our histogram looks like that so the final question has to be which class has the greatest relative frequency and which class has the least relative frequency well the one with the greatest relative frequency is this class there 57 to 61 I'm just going to highlight that and then the one with a minimum frequency is this class there and we'll highlight that and that's our answers 57 61 72 76 and that's the correct answer there so this takes a little bit of time but you can do it using excel and it goes faster if you don't have to explain it to someone so I hope this