150 likes | 292 Views
This guide provides an in-depth understanding of regression equations, targeting MTH 240 Community College Statistics students. It covers essential topics such as linear equations, the slope, correlation, scatter plots, and finding the line of best fit using Excel. The content is designed to enhance students' analytical skills while engaging with real-world examples. Through practical applications, including video demonstrations, learners will master key concepts and improve their ability to analyze data effectively.
E N D
Regression Equations A guide for analyzing data MTH 240 – Community College Statistics Students
Table of Contents • Learning Objectives • Linear Equations Review • Equation of the Line • Different Forms of Linear Equations • Slope • Correlation • Scatter Plots • Regression Equations • Finding the Line of Best Fit • Excel Video Example • Example: The Unsupervised Student • Scatter Plot • Regression Equation • References Sarah DiCalogero - Regression Equations
Learning Objectives • Review Basic Linear Equations • Forms of Linear Equations • Slope • Correlation • Create Scatter Plots in Excel • Determine Regression Equations in Excel Sarah DiCalogero - Regression Equations
Review: Equation of the Line • Basic Linear Equation: Sarah DiCalogero - Regression Equations
Review: Different Forms of Linear Equations • Regression Line • “Line of Best Fit” • Different formulas convey same information: ^ ^ Sarah DiCalogero - Regression Equations
Review: Slope Positive Slope Negative Slope Hawkes and Marsh (2004) Hawkes and Marsh (2004) Sarah DiCalogero - Regression Equations
Review: Correlation • Relationship between two variables Strong Linear Correlation Hawkes and Marsh (2004) No Linear Correlation Hawkes and Marsh (2004) Weak Linear Correlation Hawkes and Marsh (2004) Sarah DiCalogero - Regression Equations
Scatter Plots • Graphs of Points • x – independent/explanatory variable • y – dependent/response variable • Example: Sarah DiCalogero - Regression Equations
Finding the "Line of Best Fit" Sarah DiCalogero - Regression Equations
Finding the "Line of Best Fit" • Regression Equation • Positive Slope • Y-intercept value < 0 • Correlation Y = 0.2299x – 1.7356 Sarah DiCalogero - Regression Equations
Finding the "Line of Best Fit": Excel Video Example Click on the image to link to the video YouTube (2009) Sarah DiCalogero - Regression Equations
Example: The Unsupervised Student Question: Does the number of hours a high school student spends unsupervised impact their overall grade average? Sarah DiCalogero - Regression Equations
Example: Scatter Plot Sarah DiCalogero - Regression Equations
Example: Regression Equation Sarah DiCalogero - Regression Equations
References • Hawkes, J., & Marsh, W. (2004). Discovering Statistics (2nd ed.). Charleston, SC: Hawkes Publishing Inc.. • YouTube. (2009). Plotting A Scatter Plot w/ Trendline in Excel. Retrieved from http://www.youtube.com/watch?v=nnM-7Q6gmUA Sarah DiCalogero - Regression Equations