Hi everyone! Read through the material below, watch the videos, work on the Excel lecture and follow up with your instructor if you have questions.

 

Learning Outcomes.

  • Collect, organize and graph raw data.
  • Compute statistical parameters (covariance, correlation coefficient).
  • Compute a regression equation and use it to make predictions.

Topic. This lesson covers: Least Squares Method and Regression

lesson05excelDownload
Lesson05-regressionDownload

 Excel Lecture #5

Simple Linear Regression in Excel

 

Refer to your exit ticket example from Lecture #4. What is your regression equation? Use it to predict what your stock price might be 3 weeks from today. 3 weeks from today, refer back to your prediction. How accurate/inaccurate was your prediction? What variables might have effected the price? Here is an example.