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!