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
Grade Levels
Product Rating
Not yet rated
File Type
Excel Spreadsheet File
Be sure that you have an application to open this file type before downloading and/or purchasing.
0.09 MB   |   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
Answer Key
Included
Teaching Duration
2 Days

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$2.00
Digital Download
ADD ONE TO CART
User Rating: 4.0/4.0
 (6 Followers)
$2.00
Digital Download
ADD ONE TO CART
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