ONLY ANSWER THE INCORRECT ANSWERS AND MAKE THE FORMAT READABLE.

7.

A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Click on the datafile logo to reference the data. DATAF Years of Annual Sales Salesperson Experience ($10005) 1 1 80 2 3 97 3 4 92 4 4 102 5 6 103 6 8 11 1 7 10 119 8 10 123 9 11 117 10 13 136 a. Choose the correct scatter diagram for these data with years of experience as the independent variable. A. 140 Annual Sales ($1000s) +120 -100 +80 +60 +40 +20 Years of Experience 3 4 8 10 12 14 B. 140 Annual Sales ($1000s) +120 -100 +80 . +60 +40 +20 Years of Experience 4 8 10 12 14140Annual Sales 310005. 120 ' . l i?\" .- i O 60 40 20 Years of Experience \"WNW-\"$.-.Q...1P...1P...1f'.. v0 b. Develop an estimated regression equation that can be used to predict annual sales given the years of experience. Compute b1 and ()0 (to the nearest whole number). b1 0 b0 0 Complete the estimated regression equation below. 1}: 0+ 6:13 C. Use the estimated regression equation to predict annual sales for a salesperson with 9 years of experience (to the nearest whole number). $ 0 \fDavid's Landscaping has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Data for 14 households may be found in the file Landscape. Click on the datafile logo to reference the data. DATAr If required, enter negative values as negative numbers. a. Select a scatter diagram with home value as the independent variable. A' Landscape Expenditures {$1000i I 20 . I ' I . I 15 g I I I I 10 Home Value l$1000i 2 0 4 0 6 0 8 O b. What does the scatter plot developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates a 9 linear relationship between the two variables. c. Use the least squares method to develop the estimated regression equation (to 5 decimals). g} = 0:1: + 0 d. For every additional $1000 in home value, estimate how much additional will be spent on landscaping (to 2 decimals). $ 0 e. Use the equation estimated in part (c) to predict the landscaping expenditures for a home valued at $575,000 (to the nearest whole number). $ 0 \fTo help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall score for ten 13-inch models (Consumer Reports website). Click on the datafile logo to reference the data. DATA file Price Overall Brand & Model ($) Score Samsung Ultrabook NP900X3C-A01US 1250 83 Apple MacBook Air MC965LL/A 1300 83 Apple MacBook Air MD231LL/A 1200 82 HP ENVY 13-2050nr Spectre XT 950 79 Sony VAIO SVS13112FXB 800 77 Acer Aspire $5-391-9880 Ultrabook 1200 74 Apple MacBook Pro MD101LL/A 1200 74 Apple MacBook Pro MD313LL/A 1000 73 Dell Inspiron I13Z-6591SLV 700 67 Samsung NP53503C-A01US 600 63a. Select the correct scatter diagram with price as the independent variable. A. 85 80 75 70 65 60 55 Overall Score 600 800 1000 Price i5: 1200 1400 b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates a 9 linear relationship between the two variables. c. Use the least squares method to develop the estimated regression equation (to 4 decimals). = 0 + 0 (C . Provide an interpretation of the slope of the estimated regression equation (to the nearest whole number). The slope means that spending an additional $100 in price will w the overall score by approximately 0 points. e. Another laptop that Consumer Reports tested is the Acer Aspire 539516646 Ultrabook; the price for this laptop was $700. Predict the overall score for this laptop using the estimated regression equation developed in part (c) (to 1 decimal). 0 EB) \fA large city hospital conducted a study to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was selected and the following data were collected. Excel file: data 1413.xlsx Distance to Work Number of Days (miles) Absent 1 00 MON-hm 10 12 14 14 18 N-JSNU'IUJOINIOOLH If required, enter negative values as negative numbers. a. Select the correct scatter diagram for these data. A. 104 Number of Days Absent 8+ 6+ 4 2+ 4 6 8 10 12 14 16 18 20 Distance to Work (miles) B. 104 Number of Days Absent 8+ 6 4 2 N . 4 6 8 10 12 14 16 18 20 Distance to Work (miles)C. 101 Number of Days Absent 8+ 6+ 4+ 2+ 6 8 10 12 14 16 18 20 Distance to Work (miles) Graph A Does a linear relationship appear reasonable? Yes, a negative one b. Develop the least squares estimated regression equation that relates the distance to work to the number of days absent (to 4 decimals). y = + c. Predict the number of days absent for an employee that lives 5 miles from the hospital (to nearest whole number). daysD K A B C E F G H Distance to Work Number of Days (miles) Absent W N A W A 6 8 NA NUWAN OOVOO 60 00 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29The Dow Jones Industrial Average (DJIA) and the Standard & Poor's 500 (S&P 500) indexes are used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P 500 is a better measure of stock market performance because it is broader based. The closing price for the DJIA and the S&P 500 for 15 weeks, beginning with January 6, 2012, follow (Barron's website). Click on the datafile logo to reference the data. DATA file Date DJIA S&P January 6 12,360 1,278 January 13 12,422 1,289 January 20 12,720 1,315 January 27 12,660 1,316 February 3 12,862 1,345 February 10 12,801 1,343 February 17 12,950 1,362 February 24 12,983 1,366 March 2 12,978 1,370 March 9 12,922 1,371 March 16 13,233 1,404 March 23 13,081 1,397 March 30 13,212 1,408 April 5 13,060 1,398 April 13 12,850 1,370\fb. Develop the estimated regression equation (to 3 decimals). Enter negative values as negative numbers. ,1): -669.0: 9+ 0.157 @DJIA c. Test for a significant relationship. Use a = 0.05. The p-value is less than or equal to v K'o 0:. Conclusion: significant relationship v w d. Did the estimated regression equation provide a good fit? w e. Suppose that the closing price for the DJIA is 13,500. Predict the closing price for the S&P 500 (to nearest whole number). 1451 0 f. Should we be concerned that the DJIA value of 13,500 used to predict the S&P 500 value in part (e) is beyond the range of the data used to develop the estimated regression equation? No vw