Hi everyone! Read through the material below, watch the videos, work on the Excel lecture and follow up with me 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: Covariance and Coefficient of Correlation

  • Openstax Introductory Statistics:
  • Introductory Statistics by Sheldon Ross, 3rd edition: Sections 2.5, 3.7
  • Statistics with Microsoft Excel by Beverly J. Dretzke, 5th ed., COV(X,Y), CORREL(X,Y)

WeBWorK. Sets 12.2 and 12.3 due 9/20 at midnight

Excel Lecture 4Download
Powerpoint Lecture 4Download

Videos

Correlation and Correlation Coefficient in Excel