1 / 11

Step-by-Step Guide to Graphing and Regression Analysis in Excel

This guide provides a comprehensive walkthrough for graphing and performing regression analysis in Excel. Focused on the physical process, it details how to visualize relationships between two quantitative variables using scatterplots and trendlines. Learn to format your graphs, add axis labels, and interpret trendline equations and R² values for assessing the strength of relationships. Additionally, discover how to conduct regression analysis to test significant relationships between variables and obtain statistical reports.

kylee-watson
Télécharger la présentation

Step-by-Step Guide to Graphing and Regression Analysis in 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. DISCLAIMER This guide is meant to walk you through the physical process of graphing and regression in Excel…. not to describe when and why you might want to do these things or how to interpret them.

  2. Graphing relationships between 2 quantitative/numerical/continuous variables • Data should be in two columns, with paired observations (two things measured in same place/at same time/ on same object) in the same horizontal row. Select “Insert” tab Select “Scatterplot”

  3. Adding data From “design” tab Click “Add”

  4. Adding data Click in box, then highlight data you want on x axis. … and again for y axis

  5. Formatting • Add axis labels with appropriate units, get rid of gridlines…

  6. Formatting • Clicking on a part of the graph usually lets you edit that part…(e.g., font size of an axis label can be changed by clicking on that axis label)

  7. Trendlines • You can add a line that “best fits” your data…. helpful in summarizing how our y variable changes with x • Select more trendline options to get equation and R^2 displayed on graph.

  8. The equation of the trendline…. If you input a particular x value it predicts a y value. R2 – related to “r”, the correlation coefficient. Describes, in essence, how well the data are described by the line. R2 near 1 means the relationship between the variables is very strong, R2 near zero indicates weak/ no relationship.

  9. Regression analysis • Useful to testing for significant relationships between two quantitative variables. • Select “Data”, then “data analysis”, then “regression”. • If “data analysis is not an option, choose “add-ins”, then check “analysis” and “analysis tool pack – vba”. “

  10. Regression analysis • Click here, and highlight a column of your data for the x axis, what you think drives the relationship. • Click here, and highlight a second column of your data for the y axis. • Click here, and highlight an empty space on your worksheet where you want the stat. report to be placed.

  11. Regression analysis • Here is the reported p-value. • Here is the R2. Notice that when we graphed a linear trendline through this data, the equation was y = 0.3545x -1.90

More Related