1 / 105

Statistics Regression

Explore the concepts of correlation, regression, and line of best fit in statistics. Learn how to calculate regression, interpret correlation coefficients, and use Excel for data analysis. Get insights into fitting lines through data points and understanding the relationship between variables.

pitre
Download Presentation

Statistics Regression

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. Statistics Regression https://www.123rf.com/photo_6622261_statistics-and-analysis-of-data-as-background.html

  2. Correlation A relationship can be seen by graphing the independent and dependent variables in a scatter graph

  3. Correlation A linear relationship is very common

  4. Correlation When we calculated a correlation coefficient, we said it was a measure of the closeness to a linear relationship between the two variables

  5. Line of Best Fit That means, we could find the formula for a line that would be the best fit for the two variables

  6. Line of Best Fit We “fit” a line to the data

  7. Line of Best Fit Real-world data rarely lands exactly on a straight line

  8. Line of Best Fit But we fit the “best” line to the data

  9. Line of Best Fit When you graph two variables on an x-y plot, you can fit a line through the data called a “trendline”

  10. Line of Best Fit This trendline is a “line of best fit” to the data

  11. Line of Best Fit The “line of best fit” is created by minimizing the total distance of all the points to the line (deviations)

  12. Regression The line of best fit is called the “regression” line

  13. Regression Because it is a line, it has an equation: y = b + mx m = slope b = y-intercept

  14. Regression The slope “m” and the correlation coefficient “r” will both have the same sign

  15. Regression R2 tells how closely the regression line “fits” the data – “goodness of fit”

  16. Regression As you can imagine, the calculations for correlation and the regression line are scary scared-pic.jpg

  17. Regression Hooray for Excel!

  18. Regression Francis Galton

  19. Questions?

  20. Regression in Excel Edwin Hubble gathered and analyzed data from astronomical objects He used regression to show that the universe is expanding http://www.thefamouspeople.com/profiles/images/edwin-powell-hubble-1.jpg

  21. Regression in Excel Let’s take a look!

  22. Regression in Excel What do we do first?

  23. Regression in Excel What do we do first? GRAPH THE DATA!

  24. Regression in Excel

  25. Regression in Excel Does it look like a straight line would fit the data well?

  26. Regression in Excel Now we’re going to go to: Data Data Analysis Regression

  27. Regression in Excel They want “y” first (I HATE this…)

  28. Regression in Excel Let’s use “distance” for “x” and “velocity” for “y”

  29. Regression in Excel Eeek! What’s all this????

  30. Regression in Excel Here’s the RSQ. What is the %?

  31. Regression in Excel For the trend line, you need:

  32. Regression in Excel This (believe it or not) is the equation of the line of best fit!

  33. Regression in Excel Line of best fit: y = mx + b

  34. Regression in Excel Our equation is: Vel = 505.8409 xDist+ -48.3429

  35. Regression in Excel Highlight and copy:

  36. Regression in Excel Paste on the “Hubble” page

  37. Regression in Excel Add a new column heading: Trend

  38. We’re going to calculate our line:

  39. Copy it down…

  40. Oops! That doesn’t look right!

  41. The reference cells are changing for each row We need to make those constant

  42. Go back to the first entry Add a $ before the row numbers you want to keep constant

  43. Now, copy it down!

  44. Much better!

  45. Regression in Excel Create a new graph:

  46. Regression in Excel Make it purty! To make the trend line a line: change Marker Options to “none” change line color to “solid line”

  47. TAH-DAH!

  48. What Does It Say?

More Related