Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Data Visualization with Excel!
You have completed Data Visualization with Excel!
Preview
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