Whoops! Something went wrong.

Click here to refresh the page

Correlation and Regression Activity - Interest Rates and the Dow

Correlation and Regression Activity - Interest Rates and the Dow
Correlation and Regression Activity - Interest Rates and the Dow
Correlation and Regression Activity - Interest Rates and the Dow
Correlation and Regression Activity - Interest Rates and the Dow
Correlation and Regression Activity - Interest Rates and the Dow
Correlation and Regression Activity - Interest Rates and the Dow
Correlation and Regression Activity - Interest Rates and the Dow
Product Rating
File Type

Unknown Format

Be sure that you have an application to open this file type before downloading and/or purchasing.

91 KB|5 pages
Product Description
This is an activity in Microsoft Excel that analyzes interest rates set by the Federal Reserve and price of the Dow Jones Industrial Average from 2000 to 2009. This activity is intended for high school and college level statistics classes (also applies to economics classes). Students will use REAL DATA (included) to (1) create a scatter plot, (2) find the correlation coefficient using data analysis toolpak (or StatsPlusLE for Mac), (3) Test the significance of the correlation using P-values, (4) Find the Regression equation, and (5) Explain the significance of the data and analysis.

Solution and Grading Rubric are included, along with links to helpful YouTube videos.

This activity can take anywhere from 1-2 hours (or 2 days of high school class). The file is Excel based and completely editable! Enjoy!
Total Pages
5 pages
Answer Key
Included
Teaching Duration
2 days
Report Copyright Infringement
  • Comments & Ratings
  • Product Q & A
Loading...
$2.00
Digital Download
Add one to cart

Advertisement

Advertisement

$2.00
Digital Download
Add one to cart
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up