# Localized Trendlines

Document Sample

```					   Localized Trendlines
LSP 120
Week 6
Joanna Deszcz
Let’s Interpret This Graph

What would a trendline look like?
Let’s Interpret This Graph

What would a trendline look like?
Let’s Interpret This Graph

this downward
trend?
Let’s Interpret This Graph

Maybe we should
do a trendline for
just this downward
segment.
Let’s Interpret This Graph

Is the Localized Trendline more accurate
than the overall trendline?
An Example
   Percentcollegewomen.xls
   Step 1
US Females enrolled in
◦ Create and xy                               Higher Education 1910-
scatter plot of the                                 2000
data                                   60
◦ Is a localized                         50
trendline needed?                      40

% enrolled
◦ Yes if…                                30
 Low R2 value                                    y = 0.1497x - 248.76
20
 Trendline doesn’t fit                               R² = 0.2885
the data points                      10
 Trend changes                        0
direction                             1900       1950          2000    2050
Year
   Step 2
◦ Remove the original
trendline
◦ Select and copy the
data that represents
◦ Click on the chart to
activate it
◦ Choose Paste Special
   Step 3
◦ Add cells as a new
series
◦ Category (X values) in
First column
   Step 4
◦ Right-click on any of
the new data points
Trendline Dialog Box
 Select Linear
Trendline
 Select
◦ Display Equation
◦ Display R-
squared value
The New Trendline
US Females enrolled in Higher Education
1910-2000         y = 0.59x - 1120.8
70                                          R² = 0.8764
60
50
% enrolled

40
30
20
10
0
1900      1920    1940     1960    1980      2000       2020
Year
Animation in PowerPoint
 Once the chart is complete…
 You can animate it with PowerPoint to
 Here’s how….
PowerPoint
 Open a blank presentation
◦ Home – Slides – New Slide
 Copy your chart from Excel and paste it
on the slide
 You may delete the title slide if you wish
 Click on the chart to activate it
 Click on the Animation Tab
 Choose Custom Animation
› Entrance
› Choose an effect
› Can modify speed and place of entrance as
well
› Click on drop down arrow next to “Content
1 Placeholder”
Continued…
 Choose Effect Options
 Choose Chart Animation tab
 Select Group Chart – By Series Option
◦ View slide show to see results
◦ Chart parts should come in in stages
 First chart
 Second, original data
 Third, trendline and localized data, predition, shapes