Docstoc

Localized Trendlines

Document Sample
Localized Trendlines Powered By Docstoc
					   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




                 But what about
                 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
    Adding a Localized Trendline
   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
Adding a Localized Trendline
   Step 2
    ◦ Remove the original
      trendline
    ◦ Select and copy the
      data that represents
      the newest trend
    ◦ Click on the chart to
      activate it
    ◦ Choose Paste Special
      from the Paste menu
Adding a Localized Trendline
   Step 3
    ◦ Add cells as a new
      series
    ◦ Category (X values) in
      First column
Adding the New Trendline
   Step 4
    ◦ Right-click on any of
      the new data points
    ◦ Choose Add Trendline
      from menu
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
  emphasize your points
 Here’s how….
    PowerPoint
 Open a blank presentation
 Add a new slide
    ◦ Home – Slides – New Slide
 Copy your chart from Excel and paste it
  on the slide
 You may delete the title slide if you wish
  Add Animation
 Click on the chart to activate it
 Click on the Animation Tab
 Choose Custom Animation
   › Click Add Effect
   › 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
    Design your Slides
   Click on the Design tab to add custom or
    preformatted colors and designs to your
    slides

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:3/14/2013
language:Unknown
pages:18