2 results
High school statistics research for Microsoft Excel
Correlation and Regression Activity - Interest Rates and the Dow
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)
Subjects:
Grades:
9th - 12th, Higher Education
Types:
Social Security/Private Fund Benefit Comparison Project
This project for an Economics, Accounting or Statistics class utilizes public information on the Internet (including the Social Security Administration website) to compare Social Security benefits with a comparably-funded private retirement account.
All of the instructions and tables are provided in the attached Excel-format spreadsheet, other than data that needs to be culled directly from the Social Security Administration website (and instructions on how to pull that data is provided).
Th
Grades:
11th - 12th, Higher Education
Types:
Showing 1-2 of 2 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands