 is is not the one that we're expected to have on outcomes just because knowing a little bit about how how many cylinders the car has and then six 84 and 8 104 here's another count if just picking this sell-up same formula taking this danger data range so then if we were to construct a histogram with this if you just select this data and create a histogram then it creates our buckets three to four four to five five to five five to six now we can adjust these buckets down here because really we would want them to just be one through eight possibly but sometimes when you create a histogram in Excel that can be a little bit tricky to try to get this this x-axis to be exactly what you want it meaning I would like this to just be you know one two three four to eight because it wants it needs to have a range so so so that could be a little bit tricky and so when you see this kind of data sometimes it might be easier to say the I would like a histogram but but but instead of of making the histogram I would just need a bar chart so it might be easier actually to make this table and then create your histogram from a bar chart based on this table instead of the data set so we can come down here and say this is another histogram basically created instead of from this data from this little table we put together which sometimes is easier to put together than others in this case because like if we had a range between one zero and one of a bunch of decimals and we don't know what it is then the rain it's gonna be a little bit more difficult we need the ranges we need the buckets but if you have something like this now I can say hey look I just need eight eight buckets right that are pretty well defined so I can create a table and then make our our histogram in this format so now I just got one two three four five six seven and eight and so and and this might be a little bit more clear format for us to put it in recognize just recognizing what the data looks like and making a slightly different kind of histogram or using a different tool we might trim this down even further and say hey look I don't really need the the ones that don't have anything in it because I only have a few factors so we might cut down the data set to something like this and then and then we might get a little fancy we got a little fancy with the with the the colors here so different formats for the histogram let's take a look at another one in this case we've got the name and the horsepower so in contrast with the horsepower notice that the horsepower might vary a lot more so so I can't so it's going to be more difficult to use the to use the second method we saw last time so the general idea we've got the name and then we've got the horsepower we might try to sort the horsepower from low to high or high to low and that will give us an idea of the horsepower but we would like to see it see other information related to it here's our standard calculations let's do it this time this way the average taking the average which is summing adding all of these up and then divided by one two three four the count right and then we're going to take the median take the one in the middle just like Rocky the boxers coach told them to hit the one in the middle that's the one we're going to do we're going to hit the one in the middle and that's the median function we've got the max that's the highest one the function to do that in excel is simply equals the max meaning take the highest number in this data set and the men is just simply going to be equals the men brackets data set take the lowest number in the data set so when we're looking at horsepower we've got the max 230 the men 46 the average 104 and the one in the middle 994 now just looking at these numbers note that that like if this maximum is an outlier it's like 230 it's you know there's it's not like it's out there all in and of itself but remember that the outliers on the high or the low end could have an impact on the average versus the median so if you see a big difference between the average and the median there's not a huge difference here but if you see a big difference then your thought process would be well maybe there's some outliers that are skewing the average that you need to kind of keep an eye on so if I look at a pictorial representation of a histogram we have something that's that's that's skewed to the right because we have the tail end on the right meaning the ones out here at 226 to 244 the high horse power there's only a few of them out here right so we've got kind of the middle that's somewhere around here right the 104 is the average so the middle point if ours to take a teeter totter you know and try to put it like at the middle so this thing balances you know left to right kind of thing on the histogram and there is our spread of the data so clearly this is going from the low the buckets 46 to 64 the 64 to 82 the 82 to 100 the 100 the 118 and so on and so forth now note it is possible for us to create a bar chart and recreate this data but it's not as easy as with the last data because I don't simply have just one through eight different buckets that are well-defined because now I have numbers you see these numbers I need a bucket I need something going from I can't list every number from 46 up to 244 that would the chart would be useless so so I have to have some kind of range on the buckets so that means if I was to try to make a a bar chart histogram I it would be a little bit more difficult because I would then have to make the ranges myself and then use a little bit more complicated it's still doable but you have to a little bit more complicated calculation to pick up the numbers that are between a certain range that's still a useful tool to do we'll do it in excel in future presentations because sometimes you might want a bar chart even when you're using the ranges because you might for example want to have two bar charts on top of each other and that might be easier to do then then with the histograms you might have a little bit more flexibility if you create your own table in other words and then create a bar chart with it then you do with the histogram tools so we'll take a look at those in future presentations