MA 203DL Excel Project 9
Prediction Intervals (Multiple Regression) Questions are taken from "Elementary Statistics using Excel, 6th Edition", Mario Triola, practice problems from sections 10-3 and 10-4 For problems 1 - 4 find A) the explained variation B) the unexplained variation C) The indicated prediction interval In each case, there is sufficient evidence to support a claim of linear correlation, so it is reasonable to use the regression equation when making predictions. 1)
\fAltitude and Temperature Listed below are altitudes (thousands of feet) and outside air temperatures ("F) recorded by the author during Delta Flight 1053 from New Orleans to Atlanta. For the prediction interval, use a 95% confidence level with the altitude of 6327 ft (or 6.327 thousand feet). Altitude (thousands of feet) 3 10 14 22 28 31 33 Temperature ("F) 57 37 24 -5 -30 -41 -54Town Courts Listed below are amounts of court income and salaries paid to the town jus- tices (based on data from the Poughkeepsie Journal). All amounts are in thousands of dollars, and all of the towns are in Dutchess County, New York. For the prediction interval, use a 99% confidence level with a court income of $800,000. Court Income 65 404 1567 1131 272 252 111 154 32 Justice Salary 30 44 92 56 46 61 25 26 18Crickets and Temperature The table below lists numbers of cricket chirps in 1 minute and the temperature in "F. For the prediction interval, use 1000 chirps in 1 minute and use a 90% confidence level. Chirps in 1 min 882 1188 1104 864 1200 1032 960 900 Temperature ("F) 69.7 93.3 84.3 76.3 88.6 82.6 71.6 79.6Weighing Seals with a Camera The table below lists overhead widths (cm) of seals measured from photographs and the weights (kg) of the seals (based on "Mass Estimation of Weddell Seals Using Techniques of Photogrammetry," by R. Garrott of Montana State Univer- sity). For the prediction interval, use a 99% confidence level with an overhead width of 9.0 cm. Overhead Width 7.2 7.4 9.8 9.4 8.8 8.4 Weight 116 154 245 202 200 191\fTown Courts Listed below are amounts of court income and salaries paid to the town jus- tices (based on data from the Poughkeepsie Journal). All amounts are in thousands of dollars, and all of the towns are in Dutchess County, New York. For the prediction interval, use a 99% confidence level with a court income of $800,000. Court Income 65 404 1567 1131 272 252 111 154 32 Justice Salary 30 44 92 56 46 61 25 26 18Altitude and Temperature Listed below are altitudes (thousands of feet) and outside air temperatures ("F) recorded by the author during Delta Flight 1053 from New Orleans to Atlanta. For the prediction interval, use a 95% confidence level with the altitude of 6327 ft (or 6.327 thousand feet). Altitude (thousands of feet) 3 10 14 22 28 31 33 Temperature ("F) 57 37 24 -5 -30 -41 -54Weighing Seals with a Camera The table below lists overhead widths (cm) of seals measured from photographs and the weights (kg) of the seals (based on "Mass Estimation of Weddell Seals Using Techniques of Photogrammetry," by R. Garrott of Montana State Univer- sity). For the prediction interval, use a 99% confidence level with an overhead width of 9.0 cm. Overhead Width 7.2 7.4 9.8 9.4 8.8 8.4 Weight 116 154 245 202 200 191Crickets and Temperature The table below lists numbers of cricket chirps in 1 minute and the temperature in "F. For the prediction interval, use 1000 chirps in 1 minute and use a 90% confidence level. Chirps in 1 min 882 1188 1104 864 1200 1032 960 900 Temperature ("F) 69.7 93.3 84.3 76.3 88.6 82.6 71.6 79.6
