QUESTION 29 The amount of money out of income spent on housing is an important component of the cost of living. The total costs of housing for homeowners might include mortgage payments, property taxes, and utility costs (water, heat, electricity, internet, etc.). An economist selected a sample of 10 homeowners in New England and then calculated these total housing costs for the same homeowners as a percent of monthly income, five years ago and now. The information is reported below. Is it reasonable to conclude that the average percentage of income spent on housing is less now the same as the average five years ago? At the .05 level of significance, test whether the average percentage of income spent on housing is the same as it was five years ago. The data for the 10 homeowners is given below: Homeowner 1 Five Years Ago Now 17 2 20 3 29 4 5 6 7 8 9 222324222 29 36 41 45 29 29 22233222 15 27 39 44 26 28 10 26 26 t-test: Two Sample Assuming Equal Variances t-test Paired Two Sample for Means Regression t-test: Two-Sample Assuming Unequal Variances O O O O QUESTION 30 The Super Bowl, the championship game of the National Football League of the United States, is an important annual social event for Americans, with tens of millions of viewers. The ads that air during the game are expensive: a 30-second ad during the 2013 Super Bowl cost about $4M. Polls often ask whether respondents are more interested in the game or the commercials. Using the 40 responses from one such poll, we produced a frequency table below. Based on the table below, what is the percentage of respondents who are either interested in commercials or games? Response Counts Percentage Commercials 8 20.0 Game 18 45.0 Won't Watch 12 30.0 No Answer/Don't Know 2 5.0 Total 40 100.0 30% 95% 65% 20% QUESTION 12 If 2012 is the base year, then the inflation rate for 2012 equals CPI in 2012 CPI in 2013 x 100. CPI in 2012 CPI in 2013 CPI in 2012 x 100. CPI in 2013 CPI in 2012 CPI in 2013 x 100. CPI in 2013 CPI in 2013-CPI in 2012 CPI in 2012 x 100. The sales manager of a large auto parts distributor wants to estimate as early as April the total annual sales of the region. On the basis of regional sales, the total sales for the comp x any can also be estimated. If, based on past experience, it is found that the April estimates of sales are reasonably accurate, then in future years the April forecast could be used to revise production schedules and maintain correct inventory at the retail outlets. You will be using a Data Analysis tool. If you want to explain or predict the annual sales based on the number of retail outlets, which variable would you select for y? Number of Automobiles Number of Retail Annual Sales Registered (milions) Outlets ($milions) 9.27 1539 39.702 5.86 1021 7.196 8.81 1246 14.055 3.81 550 2.511 6.31 1396 13.625 11.62 1790 48.919 8.96 987 29.6 6.28 701 7.114 7.77 649 19.116 5.92 1227 9.994 The problem does not give enough information to determine which variable is y Annual Sales Number of Automobiles Registered Number of Retail Outlets QUESTION 34 MPG (miles per gallon) on the highway for large pickups ranges from 14 to 21 MPG. Typically the more horsepower and the larger the engine size, the lower the MPG. A sample of eight pickups was selected: Pickup Horsepower MPG Avalanche....285.......15 Pickup Ram... Silverado....300... 16 Blackwood....300.. .17 Sierra.... .325.... 14 Horsepower MPG .215.......19 F-150......202.......21 GMC1500...150.. Tundra.....190.... .23 19 You ran a regression, and got the results below. Using a level of significance of .05, what can you conclude, and why? Regression Statistics Multiple R R Square 0.93787084 0.87960172 Adjusted R Square 0.85953534 Standard Error Observations 1.15081758 8 Intercept Horsepower Coefficients 29.0308785 -0.0448638 Standard Error 1.715063703 t Stat 16.926997 P-value 2.7176E-06 0.006776216 -6.6207702 0.0005719 Horsepower has a statistically significant effect on MPG, because .00057196 is less than .05. Horsepower does not have a statistically significant effect on MPG, because -0.0448638 is more than .05. Horsepower has a statistically significant effect on MPG, because -0.0448638 is less than .05. Horsepower does not have a statistically significant effect on MPG, because .00057196 is more than .05. QUESTION 34 MPG (miles per gallon) on the size, the lower the MPG As Pickup Avalanche...285. 311ado...aco.. Black....300.. si.......225.