MGMT 5260 | Decision-Making Techniques for Managers Page 1 of 1 Module/Week 7 Homework Rubric MGMT 5260: Decision-Making Techniques for Managers Problem Items for grading Maximum points Waiting time...

excel file assignment


MGMT 5260 | Decision-Making Techniques for Managers Page 1 of 1 Module/Week 7 Homework Rubric MGMT 5260: Decision-Making Techniques for Managers Problem Items for grading Maximum points Waiting time Construct a scatter diagram. 2 Find the regression coefficients b0 and b1. 2 Interpret the meaning of the slope. 3 Predict the waiting time. 2 Is there a linear relationship? 2 Advertising State the multiple rogation equation. 3 Interpret the meanings of both slopes. 2 Predict the sales. 2 Highlight the coefficient of determination and explain its meaning. 2 Linear relationships between 1) Sales and Radio Ads? 2) Sales and Newspaper Ads? 4 Forecasting with Span 4 Forecast: Prices, Errors, Absolute Errors, Absolute Percentage Errors, MAE, and MAPE 7 Three Diagrams 1 Forecasting with Span 5 Forecast: Prices, Errors, Absolute Errors, Absolute Percentage Errors, MAE, and MAPE 7 Three Diagrams 1 Total points for this assignment 40 MGMT 5260 | Decision-Making Techniques for Managers Page 1 of 1 Module/Week 7 Homework: Regression Analysis and Forecasting MGMT 5260: Decision-Making Techniques for Managers Complete the following regression analysis and forecasting spreadsheet models. Fill out the provided Module/Week 7 Homework Template to solve each of the four questions. Problem 1: Simple Linear Regression See the problem description in the Waiting Time tab of the template file. Problem 2: Multiple Regression See problem description in the Advertising tab of the template file. Problem 3: Forecasting American Express closing prices are presented in the Template for Span of 4 tab. Create a moving averages forecasting model for a span of 4. Also complete the following: a. Calculate Forecasted prices, Errors, Absolute Errors, Absolute Percentage Errors, MAE, and MAPE. b. Create three graphs: i. Original observation ii. Forecasted and Original Observations iii. Forecast error Problem 4: Forecasting American Express closing prices are presented in the Template for Span of 5 tab. Create a moving averages forecasting model for a span of 5. Also complete the following: a. Calculate Forecasted prices, Errors, Absolute Errors, Absolute Percentage Errors, MAE, and MAPE. b. Create three graphs: i. Original observation ii. Forecasted and Original Observations iii. Forecast error Which moving average is better – with a span of 4 or 5? Provide your answer within the template.