Using Trend Lines In Numbers (#1202)


Hi, this is Gary with MacMost.com. On today’s episode let’s look at using trend
lines in Numbers for Mac. So let’s look at simple example. I’m using Numbers 3.6.2 and we’ll see how
trend lines can be very useful for seeing a trend in a lot of data. I’ve got this set of numbers here. It’s a table with everyday of the year and
the number of sales on the right. If I try to do a chart for this I’ll hit Chart
and I’ll just do a simple chart right here. I can see here everyday has a different bar
going all the way across. It’s hard to see if there is a trend. I get a feeling that sales were stronger at
the end of the year than at the beginning of the year. But, you know, there’s peaks and valleys everywhere. So is there a trend from the start of the
year to the end of the year. Are sales, indeed, going up. So you can figure that out using a trend line. What I’m going to do is I’ve got the Format
bar turned on here and I’m going to select, in the chart, this series. I’m going to click inside here so I’m selecting
the data inside not the chart itself. I’m going to go to Series and then there,
sure enough, is the option for Trendline. I’m going to turn on Trendline and I’m going
to use Linear because I’m looking to see if things are increasing. If there is a trend going on. So Linear will do it for me. It’s going to hopefully show me a line moving
upwards. I’ll select it and sure enough there it is. I can turn it off here and see that there
is a line going across that is definitely trending up. Now if I want to see it a little bit better
I can maybe select Series again, go to Style, change the Fill to a color fill, say a gray
that kind of puts the data in the background a little bit and makes the trend line itself
pop so I can see it. So I can see sales are gradually increasing
throughout the year even though with 366 data points it’s really hard to see that from the
individual bits of data. Now you have more options when it comes to
trend lines. So I’m going to select this Series again here
and I’ve got the trend line. I can name it here but I can also show the
Equation and the R Value. Now if you don’t know what these are then
it’s probably not something you need to worry about. The equation here is a simple linear equation
and it can very useful if you are using this in a math project or something to be able
to see the equation of that line and we’re going to see how that’s even more useful in
the next example. Here I’ve got a different set of data. I’ve got the data from a projectile being
shot from horizontal position 0 to 0 with a velocity of 100 vertically, a hundred up,
and 100 horizontally. So it’s continuing to move horizontally. I’m not taking any kind of thing like wind
or anything into account. Just 100 per second and being shot at a 45
degree angle. So 100 and 100 there. The vertical position starts at 0 and then
it will continue to move up. But vertical velocity here, you can see in
the formula, is being affected by gravity. That’s that negative 9.8 meters per second
there. So basically it’s physics. It’s being shot up but gravity is slowly slowing
it down as it’s going up. Eventually gravity now is pulling it down
and see that reflected here in the Vertical Position is rising, it gets to a peak point,
then it starts falling. I can easily show this visually by doing a
chart. I don’t want to show the vertical velocity. I want to just select column A and then Control
click column C and select these two columns. Then I do Chart and a line chart and I get
this chart here that really clearly shows the vertical position and the horizontal position
and you can see it as the arc of say a projectile through the air. So where do trend lines come in for this. Well, if I select the Series here, I’m going
to click inside and select this series I can go and set a Trendline. Now linear doesn’t make any sense because
this isn’t moving in a linear fashion. It’s going to say over time it’s going to
continue to move down because I’m ending here kind of underground. It doesn’t mean anything. What you want here is something that’s going
to be a Polynomial because a polynomial represents this type of data and, in fact, if I show
the equation I get a polynomial equation that perfectly represents the math underlying the
acceleration of velocity here. So you can actually use this formula to show
the position of the cannonball at any point, x and y. So it’s pretty useful here and it shows that
you can use these different trend liness for different things. There are reasons like this to use polynomial,
there’s reasons to linear, and there will be different mathematical reasons you may
have to use some of these other settings here. But it’s the basics of how you do it and how
you use trend lines in Numbers to show you different trends and to bring out more information,
like this formula here, from the data.

Dereck Turner

Leave a Reply

Your email address will not be published. Required fields are marked *