Use R programming or excel to answer the following. Visualize your answers.   Consider the following quarterly time series:   Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198 Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Compute the quarterly forecasts for next year based on the model developed in part b.

The personnel director of a large hospital is interested in determining the relationship (if any) between an employee’s age and the number of sick days the employee takes per year. The director randomly selects ten employees and records their age and the number of sick days which they took in the previous year.  Employee 1 2 3 4 5 6 7 8 9 10 Age 30 50 40 55 30 28 60 25 30 45 Sick Days 7 4 3 2 9 10 0 8 5 2 Copy Data The estimated regression line and the standard error are given.  Sick Days=14.310162−0.2369(Age)   se=1.682207se=1.682207  Find the 95% confidence interval for the average number of sick days an employee will take per year, given the employee is 26. Round your answer to two decimal places.

A. run a simple regression- dependent variable is Weeks, independent variable is Age.    B. run a multiple regression with dependent variable weeks and independent variable-age, married, head, manager and sales. C. Create the regular and standardized residual plots for both.  Please show the tables when entering values of the regression for both the outputs and the scatter plots.

K An institution reports many demographic statistics about countries of the world. Data were collected about the Fertility rate (births per woman) and the female Life Expectancy at birth (in years) for 200 countries of the world. The regression output and a scatterplot of the data are shown below. Complete parts a through d below. Response variable is: Life expectancy 219 total cases of which 19 are missing R squared 71.9% $= 4.303 Variable Intercept Fertility Coefficient 83.3753 -4.54984 OA. Yes, an outler occurs at approximately x (Round to one decimal place as needed.) ICCO Life Expectancy OB. Yes, an outlier occurs at approximately x= (Round to one decimal place as needed.) OC. No, there is no outlier. c) Interpret the value of R². Choose the correct answer below. 90- 80- 70- 60- 50+ 40- 2 Fersity This outier has an unusually high life expectancy given its fertility rate. b) is there an outlier? If so, identify it. Which data value is unusual? Select the correct choice below and,…