Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Overview of the Trendline chart element.
Example Excel Spreadsheet
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
In Excel, trend lines are used
in the scatter plots, and
0:00
they show the general direction that
the points of a scatter plot are going.
0:04
Let's add a trend line to the Height and
0:09
Weight scatter plot we made
earlier in this course.
0:10
So, you've probably guessed correctly that
we're gonna go back to the Design section
0:14
of the ribbon and add a chart element.
0:20
And down here is Trendlines,
lets do Linear.
0:24
The slope of the trendline will signal the
strength of the correlation of the x and
0:27
y variables.
0:32
Let's make our trendline
a little bit thicker.
0:34
I'm gonna click on it, to select it,
then I'm gonna right click it and
0:38
scroll down to Format Trendline.
0:42
And I'm gonna go to the Line section and
increase the Width.
0:44
And to make it stand out a bit more,
I'm gonna make it black,
0:51
because the data points are blue.
0:55
So again, the slope with a trendline will
signal the strength of the correlation of
0:58
the variables.
1:03
If the trendline is sloping
down from left to right,
1:05
that means that is some degree
of negative correlation.
1:09
If it is sloping up from left to right,
1:12
that means there is some degree
of positive correlation.
1:15
So here,
based on this hypothetical data set,
1:19
if someone is 60 inches tall,
we'd expect their weight to be 120 pounds.
1:22
This is all hypothetical obviously, but
1:27
adding a trendline can help your audience
realized what data points are below or
1:31
above what we'd expect
them to be very quickly.
1:35
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up