Grading Sheet
Part 1 | |||
Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on the worksheet. | |||
Possible points | Points earned | Comments | |
Five year inflation rate | 10 | ||
Projection of expenses in Worksheet 1 | 10 | ||
Part 1 total | 20 | 0 | |
Part 2 | |||
Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on the worksheet. | |||
Possible points | Points earned | Comments | |
Descriptive Statistics | 16 | ||
Interpret Descriptive Statistics | 14 | ||
Proportion calculations | 10 | ||
Interpretation of proportions | 10 | ||
Conversion of before well | 5 | ||
Conversion of after well | 5 | ||
Improvement level data set | 5 | ||
Descriptive Statistics for improvement levels | 10 | ||
Histogram | 5 | ||
Standard error of the mean | 5 | ||
Confidence interval | 10 | ||
Discussion of the placement of 0 | 10 | ||
Part 2 total | 105 | 0 | |
Total of Worksheet 2 | 125 | 0 | 0% |
Part 1 Inflation
Input your name here | |||
name | |||
You should just use information from Major Assignment 2, but if you want to retrieve fresh CPI data, here are the instrructions again. Step 1: Go to the Bureau of Labor Statistics website at the link below. Step 2: Check U.S. All items, 1982-84=100 Step 3: Click “Retrieve Data” Use the most recent CPI value and the CPI for the same month but five years earlier to estimate the price of your trip in five years and the five year inflation rate. | |||
Month | Year | CPI | |
Unadjusted CPI, all items for 5 years ago | number | number | number |
Unadjusted CPI, all items for last month | number | number | number |
What is the 5 year inflation rate, that is percent increase in your CPI values? | formula | ||
If something cost $1.00 five years ago, what would it cost now? | formula | ||
Total budget from Worksheet 1 | number | ||
5 year projected budget total | formula | CPI Data Link | |
Like Topic 4 DQ 1 |