This is a Statistics assignment from my business Statistics 2 class it is a bit to due and must have it done by the date.

This is an assignment from my Business Statistics 2 class there is no category for Statistics. Linear Trend and Autocorrelation Directions: Answer all of the following questions in a neat and an orderly fashion. Indicate which question is being answered by listing the question on the exam in its proper order. Show ALL calculations, as well as the computer analysis output. Credit will not be given for unsupported answers. All non-numerical answers MUST be typed. 1. Listed below is the selling price for a share of PepsiCO Inc. at the close of each year. Year Price Year Price 1990 12.9135 2000 49.5625 1991 16.8250 2001 48.6803 1992 20.6125 2002 42.2211 1993 20.3024 2003 46.6215 1994 18.3160 2004 52.2019 1995 27.7538 2005 59.8534 1996 29.0581 2006 62.0002 1997 36.0155 2007 77.5108 1998 40.6111 2008 54.7719 1999 35.0230 2009 60.8025 a. Plot the data. b. Use EXCEL’s Data Analysis add-in to determine the least squares trend equation. c. Discuss the regression equation and include both the coefficient of determination and the correlation coefficient in the discussion. Make sure to test the coefficient to determine if it is statistically significant at the .01 significance level. d. Calculate the points for the years 1992 and 2004. e. (i) Estimate the selling price in 2014. (ii) Does this seem like a reasonable estimate based on historical data? Why or why not? f. By how much has the stock price increased or decreased (per year) on average during the period? Show ALL of your work and show it in a neat and orderly fashion. 2. The production manager of Superior Sofa and Chair, a large furniture manufacturer located in Georgia, is studying the job performance ratings of a sample of 15 electrical repairmen employed by the company. An aptitude test is required by the human resource department to become an electrical repairman. The production manager was able to get the score for each repairman in the sample. In addition, he determined which of the repairmen were union members (code = 1) and which were not (code = 0). The sample information is reported below. Job Performance Aptitude Union Worker Score Test Score Membership Abbott 58 5 0 Anderson 53 4 0 Bender 34 10 0 Bush 97 10 0 Center 35 2 0 Coombs 83 7 0 Eckstine 67 6 1 Gloss 84 9 1 Herd 98 9 1 Householder 45 2 1 Iori 97 8 1 Lindstrom 90 6 1 Mason 96 7 1 Pierse 68 3 1 Rohde 82 6 1 a. Use EXCEL’s Data Analysis add-in to develop a multiple regression equation using the job performance score as the dependent variable and aptitude test score and union membership as independent variables. b. Discuss the regression equation and include the coefficient of determination in the discussion. Make sure to test the equation and each of its coefficients to determine if they are statistically significant at the .05 significance level. c. Plot the residuals in the order in which the data are presented. d. Check for homoscedasticity. e. Test for autocorrelation at the .05 significance level. Show ALL of your work and show it in a neat and orderly fashion.