1 / 8

Analyzing Data Using Excel

Analyzing Data Using Excel. 1. Graphing Trendlines 2. Determining the validity of a graph and data. 1. Graphing trend lines. Using the data provided, construct a spreadsheet Create a graph, using the chart wizard. Select the chart and move to “chart”, then “select trendlines”.

alexis
Download Presentation

Analyzing Data Using Excel

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. Analyzing Data Using Excel 1. Graphing Trendlines 2. Determining the validity of a graph and data

  2. 1. Graphing trend lines • Using the data provided, construct a spreadsheet • Create a graph, using the chart wizard. • Select the chart and move to “chart”, then “select trendlines”

  3. 1. Graphing trend lines • Select the graph from the “type” menu tab that illustrates what your graph looks like • Select the options tab and select both: • “Display equation on chart” • “Display R squared value on chart” • Click OK • Click and move the equation and r squared value so you can read

  4. 1. Graphing trend lines • What does R square (R2) mean? • The closer the value to 1, generally the more valid the trend of data • If R square is below .5, then generally, the graph does not show a valid trend • If R square is low, try to repeat the process and select a different graph from the menu

  5. 2. Determining the validity of a graph and data: Things to consider *Look at your graph. • Does it make sense? • What did you originally think your graph would look like? • Did you make a data entry error? • How much data was collected?

  6. 2. Determining the validity of a graph and data: Things to consider • What variables may have affected the data? • The more variables, generally the less accurate the data. • Look at your graph and consider the variables that may have affected the data

  7. 2. Determining the validity of a graph and data: Things to consider • Was the data collection method accurate? • How was the data collected?

  8. 2. Determining the validity of a graph and data: Things to consider • The more data, the more accurate the analysis of the data • For example, 5 points of data will create a less accurate trend than 500 data points on a graph

More Related