So right now all it's telling us is that we have 124 different observations.

The next step though is that we're going to go back to our pivot table fields,

and we're going to click and drag that percentage change column

into the rows area of the pivot table builder, right?

And when you do that take a look at what happens.

We've now populated our pivot table where each

row corresponds to a different percentage change.

And so when we look at for example, the percentage change of negative 1.67%,

what the count is telling us is that we have one observation in that range.

We have one observation for minus 0.67%,

we have one observation for minus 0.44%.

So keep in mind that we're only seeing the first two decimal places,

there are a lot more decimal places.

So that's why we're generally seeing only a single observation at each

level of the observation.

Well with the histogram we have the choice of how wide those bins are.

So what we're going to do is I'm going to hover over that first column,

the row label and I'm going to right-click.

And what we're going to go scroll down to is the group option.

All right, so let's click on that group option and pull up the menu.

And what the group option let's us do is choke the data together.

So rather than looking at specific values,

it's going to allow us to look at a range of values.

So I'm going to start that out.

So what's our starting value?

Let's put in, let's say the smallest observation we have is negative 1.67%.

I'll put in negative 0.0175.

So negative 1.75% and as a maximum we go all the way up to 2.2%.

I'll put in 0.0 to 5%, and then how big in increments we want it to move in.

Well, keep in mind that we're dealing with percentages.

So let's go in fairly granular intervals in this case.

So let's go 0.005, just so that you can get a sense for,

just so that we can see how Excel is going to

construct the pivot tables for us, right?

Okay, so we've got our starting value, our ending value and then the intervals.

And if these intervals don't work we can always come back in and change

the intervals to something that creates a more meaningful histogram for us.

All right it so this one it looks my intervals may have been a little

bit on the small side but let's work with that to see what we're dealing with first.

So you'll see now that I have ranges.

So from negative 1.7% to negative 1.65% I only have one observation.

If we jumped further down my column though from negative 0.45% to negative

0.4% I've got four observations.

So we've just grouped up the observations together based on specific values.

Now this is one way of looking at the data in this tabular format.

Not the easiest to digest the degree of dispersion that we have or

the frequency of observations.

Where we're going to click on next is the Pivot Chart option.