This worksheet contains values required for MegaStat charts. Boxplot 12/5/2012 16:43.50 2 1559681 2 2093854 3 2093854 3 2359023 1 2359023 3 2359023 3 3039261 2 3039261 2 3565718 2 3039261 1 3039261 1 2093854 2 2093854 1 742364.5 3 742364.5 1 675744.9 3 675744.9 1 4457370 3 4457370 1 5875479 3 5875479 Dotplot 12/5/2012 16:44.17 1559681 1 1603596 1 1607733 1 1679013 1 1721920 1 1739859 1 1965955 1 2091918 1 2099663 1 2102240 1 2123721 1 2177617 1 2219444 1 2242803 1 2347251 1 2370794 1 2420171 1 2630458 1 2776354 1 2831385 1 2882756 1 3028033 1 3043003 1 3061770 1 3262109 1 3324246 1 3377371 1 3460280 1 3542406 1 3565718 1 Team X 1X1 League Opened Seating Capacity Salary 2012 Wins Attendance X2X2 X 3X3 X4X4 X 5X5 X6X6 BA ERA HR Errors SB X8X8 X 7X7 X 9X9 X 10 X 10 X 11X11 X 12 X 12 Arizona Diamondbacks Atlanta Braves Baltimore Orioles Boston Red Sox Chicago Cubs Chicago White Sox Cincinnati Reds Cleveland Indians Colorado Rockies Detroit Tigers Houston Astros Kansas City Royals Los Angeles Angels Los Angeles Dodgers Miami Marlins Milwaukee Brewers 0 0 1 1 0 1 0 1 0 1 0 1 1 0 0 0 1998 1996 1992 1912 1914 1991 2003 1994 1995 2000 2000 1973 1966 1962 2012 2001 48633 49586 45971 37495 41009 40615 42319 43429 50398 41255 40981 37903 45957 56000 36742 41900 74.3 83.3 81.4 173.2 88.2 96.9 82.2 78.4 78.1 132.3 60.7 60.9 154.5 95.1 118.1 97.7 81 94 93 69 61 85 97 68 64 88 55 72 89 86 69 83 2.18 2.42 2.1 3.04 2.88 1.97 2.35 1.6 2.63 3.03 1.61 1.74 3.06 3.32 2.22 2.83 0.259 0.247 0.247 0.26 0.24 0.255 0.251 0.251 0.274 0.268 0.236 0.265 0.274 0.252 0.244 0.259 3.93 3.42 3.9 4.7 4.51 4.02 3.34 4.78 5.22 3.75 4.56 4.3 4.02 3.34 4.09 4.22 165 149 214 165 137 211 172 136 166 163 146 131 187 116 137 202 90 86 106 101 105 70 89 96 122 99 118 113 98 98 103 99 Minnesota Twins New York Mets New York Yankees Oakland Athletics Philadelphia Phillies Pittsburgh Pirates San Diego Padres San Francisco Giants Seattle Mariners St. Louis Cardinals Tampa Bay Rays Texas Rangers Toronto Blue Jays Washington Nationals 1 0 1 1 0 0 0 0 1 0 1 1 1 0 2010 2009 2009 1966 2004 2001 2004 2000 1999 2006 1990 1994 1989 2008 39504 41922 50287 35067 43651 38362 42691 41915 47860 43975 34078 48194 49260 41487 94.1 93.4 198 55.4 174.5 63.4 55.2 117.6 82 110.3 64.2 120.5 75.5 81.3 66 95 74 94 81 79 76 94 75 88 90 93 73 98 2.78 2.24 3.54 1.68 3.57 2.09 2.12 3.38 1.72 3.26 1.56 3.46 2.1 2.37 0.26 0.249 0.265 0.238 0.255 0.243 0.247 0.269 0.234 0.271 0.24 0.273 0.245 0.261 4.77 4.09 3.85 3.48 3.83 3.86 4.01 3.68 3.76 3.71 3.19 3.99 4.64 3.33 131 139 245 195 158 170 121 103 149 159 175 200 198 194 107 101 74 111 101 112 121 115 72 107 114 85 101 94 93 101 58 97 94 109 87 110 100 59 105 132 134 104 149 158 135 79 93 122 116 73 155 118 104 91 134 91 123 105 Average Salary 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 $512,930 $578,930 $891,188 $1,084,408 $1,120,254 $1,188,679 $1,071,029 $1,176,967 $1,383,578 $1,441,406 $1,720,050 $1,988,034 $2,264,403 $2,383,235 $2,555,476 $2,486,609 $2,632,655 2006 2007 2008 2009 2010 2011 2012 $2,866,544 $2,944,556 $3,154,845 $3,240,206 $3,297,828 $3,305,393 $3,440,000 62. Refer to the Real Estate data, which reports information on homes sold in Goodyear, Arizona, last year. a. Let selling price be the dependent variable and size of the home the independent variable. Determine the regression equation. Estimate the selling price for a home with an area of 2,200 square feet. Determine the 95% confidence interval and the 95% prediction interval for the selling price of a home with 2,200 square feet. b. Let selling price be the dependent variable and distance from the center of the city the independent variable. Determine the regression equation. Estimate the selling price of a home 20 miles from the center of the city. Determine the 95% confidence interval and the 95% prediction interval for homes 20 miles from the center of the city. c. Can you conclude that the independent variables \"distance from the center of the city\" and \"selling price\" are negatively correlated and that the area of the home and the selling price are positively correlated? Use the .05 significance level. Report the pvalue of the test. Summarize your results in a brief report. 63. Refer to the Baseball 2012 data, which reports information on the 2012 Major League Baseball season. Let attendance be the dependent variable and total team salary, in millions of dollars, be the independent variable. Determine the regression equation and answer the following questions. a. Draw a scatter diagram. From the diagram, does there seem to be a direct relationship between the two variables? b. What is the expected attendance for a team with a salary of $80.0 million? c. If the owners pay an additional $30 million, how many more people could they expect to attend? d. At the .05 significance level, can we conclude that the slope of the regression line is positive? Conduct the appropriate test of hypothesis. e. What percentage of the variation in attendance is accounted for by salary? f. Determine the correlation between attendance and team batting average and between attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis for each set of variables. Price Bedrooms Size Pool Distance Twnship Garage Baths 263.1 4 2300 0 17 5 1 2 182.4 4 2100 1 19 4 0 2 242.1 3 2300 1 12 3 0 2 213.6 2 2200 1 16 2 0 2.5 139.9 2 2100 1 28 1 0 1.5 245.4 2 2100 0 12 1 1 2 327.2 6 2500 1 15 3 1 2 271.8 2 2100 1 9 2 1 2.5 221.1 3 2300 0 18 1 0 1.5 266.6 4 2400 1 13 4 1 2 292.4 4 2100 1 14 3 1 2 209 2 1700 1 8 4 1 1.5 270.8 6 2500 1 7 4 1 2 246.1 4 2100 1 18 3 1 2 194.4 2 2300 1 11 3 0 2 281.3 3 2100 1 16 2 1 2 172.7 4 2200 0 16 3 0 2 207.5 5 2300 0 21 4 0 2.5 198.9 3 2200 0 10 4 1 2 209.3 6 1900 0 15 4 1 2 252.3 4 2600 1 8 4 1 2 192.9 4 1900 0 14 2 1 2.5 209.3 5 2100 1 20 5 0 1.5 345.3 8 2600 1 9 4 1 2 326.3 6 2100 1 11 5 1 3 173.1 2 2200 0 21 5 1 1.5 187 2 1900 1 26 4 0 2 257.2 2 2100 1 9 4 1 2 233 3 2200 1 14 3 1 1.5 180.4 2 2000 1 11 5 0 2 234 2 1700 1 19 3 1 2 207.1 2 2000 1 11 5 1 2 247.7 5 2400 1 16 2 1 2 166.2 3 2000 0 16 2 1 2 177.1 2 1900 1 10 5 1 2 182.7 4 2000 0 14 4 0 2.5 216 4 2300 1 19 2 0 2 312.1 6 2600 1 7 5 1 2.5 199.8 3 2100 1 19 3 1 2 273.2 5 2200 1 16 2 1 3 206 3 2100 0 9 3 0 1.5 232.2 3 1900 0 16 1 1 1.5 198.3 4 2100 0 19 1 1 1.5 205.1 3 2000 0 20 4 0 2 175.6 4 2300 0 24 4 1 2 307.8 3 2400 0 21 2 1 3 269.2 5 2200 1 8 5 1 3 224.8 3 2200 1 17 1 1 2.5 171.6 3 2000 0 16 4 0 2 216.8 3 2200 1 15 1 1 2 192.6 6 2200 0 14 1 0 2 236.4 5 2200 1 20 3 1 2 172.4 3 2200 1 23 3 0 2 251.4 3 1900 1 12 2 1 2 246 6 2300 1 7 3 1 3 147.4 6 1700 0 12 1 0 2 176 4 2200 1 15 1 1 2 228.4 3 2300 1 17 5 1 1.5 166.5 3 1600 0 19 3 0 2.5 189.4 4 2200 1 24 1 1 2 312.1 7 2400 1 13 3 1 3 289.8 6 2000 1 21 3 1 3 269.9 5 2200 0 11 4 1 2.5 154.3 2 2000 1 13 2 0 2 222.1 2 2100 1 9 5 1 2 209.7 5 2200 0 13 2 1 2 190.9 3 2200 0 18 3 1 2 254.3 4 2500 0 15 3 1 2 207.5 3 2100 0 10 2 0 2 209.7 4 2200 0 19 2 1 2 294 2 2100 1 13 2 1 2.5 176.3 2 2000 0 17 3 0 2 294.3 7 2400 1 8 4 1 2 224 3 1900 0 6 1 1 2 125 2 1900 1 18 4 0 1.5 236.8 4 2600 0 17 5 1 2 164.1 4 2300 1 19 4 0 2 217.8 3 2500 1 12 3 0 2 192.2 2 2400 1 16 2 0 2.5 125.9 2 2400 1 28 1 0 1.5 220.9 2 2300 0 12 1 1 2 294.5 6 2700 1 15 3 1 2 244.6 2 2300 1 9 2 1 2.5 199 3 2500 0 18 1 0 1.5 240 4 2600 1 13 4 1 2 263.2 4 2300 1 14 3 1 2 188.1 2 1900 1 8 4 1 1.5 243.7 6 2700 1 7 4 1 2 221.5 4 2300 1 18 3 1 2 175 2 2500 1 11 3 0 2 253.2 3 2300 1 16 2 1 2 155.4 4 2400 0 16 3 0 2 186.7 5 2500 0 21 4 0 2.5 179 3 2400 0 10 4 1 2 188.3 6 2100 0 15 4 1 2 227.1 4 2900 1 8 4 1 2 173.6 4 2100 0 14 2 1 2.5 188.3 5 2300 1 20 5 0 1.5 310.8 8 2900 1 9 4 1 2 293.7 6 2400 1 11 5 1 3 179 3 2400 1 8 4 1 2 188.3 6 2100 0 14 2 1 2.5 227.1 4 2900 1 20 5 0 1.5 173.6 4 2100 1 9 4 1 2 188.3 5 2300 1 11 5 1 3