1. From your textbook, Statistics for Management and Economics, complete the following exercises:•"Multiple Regression": Exercises 17.39, and 17.42 17.39 Perform the Durbin-Watson test at the 5%...

1. From your textbook, Statistics for Management and Economics, complete the following exercises: •"Multiple Regression": Exercises 17.39, and 17.42 17.39 Perform the Durbin-Watson test at the 5% significance level to determine whether positive first-order Autocorrelation exists when d = 1.10, n = 25, and k = 3. 17.42 Test the following hypotheses with a = .05. Ho: There is no first-order autocorrelation. H1: There is positive first-order autocorrelation. 12= 50 k = 2 ,d = 1.38 "Time-Series Analysis and Forecasting": Exercises 20.19 and 20.35 20.19. Plot the following time series to determine which of the trend models appears to fit better. Period 1 2 3 4 5 Time Series 55 57 53 49 47 Period 6 7 8 9 10 Time Series 39 41 33 28 20 Week 5 Exercise 20.19 PeriodTime series 155 257 353 449 547 639 741 833 928 1020 20.35. The following trend line and seasonal indexes were computed from 4 weeks of daily observations. Forecast the 7 values for next week. Y' = 120 + 2.3r t = 1, 2... 28 Day Seasonal Index Sunday1.5 Monday.4 Tuesday.5 Wednesday.6 Thursday.7 Friday1.4 Saturday1.9 Submit your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box. Ongoing Data Exploration 2. Your final project entails systematic extraction of decision-aiding insights from a dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area. The goal of this project is to provide you with hands-on experience in conducting and interpreting different types of statistical analysis. The focus of your analysis will be on marketing strategies and analysis-related topics. At times, you will be expected to conduct additional research on topics that are not adequately covered in your text, for example, data due diligence. In the Week 4 assignment, you were asked to build a multiple regression model to explain the variability in the median school year, using a minimum of seven independent variables. Using the same model, thoroughly assess your model's diagnostics. Identify all relevant assessment dimensions, briefly outline their purpose and importance, and provide an assessment of your model in terms of the identified diagnostic measures. 3. From your textbook, Statistics for Management and Economics, complete the following exercises: "Decision Analysis": Exercises 22.2 and 22.11 Write your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box. 4. In the previous weeks, you used the sample dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area so as to conduct various analyses. This is similar to providing business analytics support on an ongoing basis and entails answering (by means of analysis) many different questions. Summarize your findings and draw conclusions. Create a final report document containing the following: •Executive summary: This section should be a 1-page summary of the most important findings presented in the context of the recommended course of action. •Data and methodology: In this section, describe the characteristics of the data and the specific methodologies used in the analysis. •Analytic details: This section should contain supporting evidence for the findings and conclusions presented in the executive summary section. Create your report in a 3- to 4-page Microsoft Word document.