Spreadsheet Evaluation
By
Jeffrey R. Frye
This write up covers the initial stamp problem with the data and questions asked in assignment 12 problem 12. I used an Excel spreadsheet to conduct my exploration, in conjunction with a TI-83 plus graphing calculator. The initial data given was input into the Excel spreadsheet as shown below. Several different possibilities were considered to find the line of best fit of the scatter plot that resulted from the year and cost data for stamps. The curves that I considered were linear, exponential, and cubic. Based upon this investigation, I determined that the power of 3, or cubic graph, gave the best fit to the data. It also had the highest value. The higher the value, the better the fit is for the data. The different graphs are shown below. The data is also shown.
Year |
Price |
|
|
1919 |
2 |
1932 |
3 |
1958 |
4 |
1963 |
5 |
1968 |
6 |
1971 |
8 |
1974 |
10 |
1975 |
13 |
1978 |
15 |
1981 |
20 |
1985 |
22 |
1988 |
25 |
1991 |
29 |
1994 |
32 |
1997 |
33 |
1999 |
34 |
2002 |
37 |
To answer the questions posed in this assignment, I looked at two different data sets. One set was the data given above, and the other was using what seemed to be asked for in the question. The question asked for predictions based upon using the data for price of stamps from 1933 to 1996. Using this data, the cubic equation was still the better predictor, having a value of .9877. The prediction for the cost of the stamp to be $.64 is the year 2013. The prediction for the cost to be $1.00 is the year 2030. Finally, the next increase of $.03 was predicted to occur in 1996, making the cost of a stamp $.35. This result is ahead of what has occurred. The cubic regression equation that is obtained is.
When the data shown in the above pictures is included in the analysis, a slightly different result occurs. The $.64 price stamp is predicted to happen in year 2020. The $1.00 stamp is predicted to occur in the year 2042. The next $.03 increase was predicted to occur in the year 2003. Once again, it appears that the immediate predictions are ahead of the actual result. The equation and value are shown on the graph.
Explore this with Excel spreadsheet.
Return to main page