1 / 22

Types of Graphs

Learn how to make line graphs, bar graphs, and scatter plots in Microsoft Excel to compare, show trends, and analyze data easily. Follow step-by-step instructions and tips for creating visually appealing and informative graphs.

clairc
Download Presentation

Types of Graphs

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. Types of Graphs Creating a Graph With Microsoft Excel

  2. Line Graphs • Line graphs compare two variables (One is usually time) • Given one variable the other can easily be determined • Show trends in data and show how one variable is affected by the other as it increases or decreases • They enable the viewer to make predictions about the results of data not yet recorded

  3. Bar Graphs • Make comparisons between different groups (variables) very easy to see.

  4. Scatter plot graphs • Use horizontal and vertical axes to plot X-Y data points • Scatter plots show how much one variable is affected by another. The relationship between two variables is called their correlation . • Scatter plots usually consist of a large body of data. The closer the data points come when plotted to making a straight line, the higher the correlation between the two variables, or the stronger the relationship.

  5. Scatter plot graphs • A perfect positive correlation is given the value of 1 • A perfect negative correlation is given the value of –1

  6. Scatter plot Graphs If there is absolutely no correlation present then R2 = 0 The closer R2 is to 1 or -1, the stronger the correlation, or the stronger the relationship between the variables The closer R2 is to 0, the weaker the correlation

  7. Creating Graphs With Microsoft Excel

  8. Step 1 Launch Excel Open a new Excel workbook Click on the NewWorkbook button.

  9. Step 2 Enter the data to be graphed

  10. Step 3 Highlight data to be graphed

  11. Step 4 Select the Chart Wizard Click Here

  12. Step 5From the Chart Wizard box that opens select Chart type Click & Hold to view sample graph

  13. Step 6Click Next

  14. Step 7Add Title and Label Axes

  15. Step 8Click on As new sheet Click here to have your graph use the whole page

  16. Finished Graph

  17. Now make a Bar graph using the same data • Click on sheet 1 • Repeat steps 2-8 to complete a bar graph • Print your graph to science cart laser • Write your name on the graph and hand in to Mr. Girard

  18. Making a Scatter plot line graph • Plot the following data • Create a scatter-plot graph • Click on chart • Click on add trendline • Click on linear • Click options • Check Display equation on chart • Check R-squared value on chart • Print graph and hand in to Mr. Girard

  19. Regression Line The closer the R2 Value is to 1.0 the better the fit to the data

More Related