1 / 18

Localized Trendlines

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.

nusa
Download Presentation

Localized Trendlines

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Localized Trendlines LSP 120 Week 6 Joanna Deszcz

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

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

  4. Let’s Interpret This Graph But what about this downward trend?

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

  6. Let’s Interpret This Graph Is the Localized Trendline more accurate than the overall trendline?

  7. An Example • Percentcollegewomen.xls

  8. Adding a Localized Trendline • Step 1 • Create and xy scatter plot of the data • Is a localized trendline needed? • Yes if… • Low R2 value • Trendline doesn’t fit the data points • Trend changes direction

  9. 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

  10. Adding a Localized Trendline • Step 3 • Add cells as a new series • Category (X values) in First column

  11. Adding the New Trendline • Step 4 • Right-click on any of the new data points • Choose Add Trendline from menu

  12. Trendline Dialog Box • Select Linear Trendline • Select • Display Equation • Display R-squared value

  13. The New Trendline

  14. Animation in PowerPoint • Once the chart is complete… • You can animate it with PowerPoint to emphasize your points • Here’s how….

  15. 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

  16. 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”

  17. 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

  18. Design your Slides • Click on the Design tab to add custom or preformatted colors and designs to your slides

More Related