Instructions

Assignments must be completed on MindTap AND a completed workbook with your full completed solutions must be submitted via Sakai. You must submit both in order to receive any credit.

Hardcopies or copies emailed will not be graded.

There is no option for late submissions in MindTap. Failure to submit your submit your assignment on MindTap before the due date will result in zero credit.

Submit your worked data in one single MS Excel Workbook. Start your solution set by using the assignment shell provided on Sakai. Use appropriately labeled worksheets for each problem/section of a problem.

Pay very close attention to the final presentation of your work and make sure it is print-ready. Prepare all spreadsheets so that they are clear, attractive and easy for the untrained eye to follow and understand. While accurate content and precise execution of the techniques is critical, formatting, typographical and grammatical acuteness is also very important. General sloppiness and inconsistent formatting will lower your grade.

Note: Ignore MindTap warning about text-based answers. All open ended questions will be graded as well. In fact, your grade will depend equally on the accuracy of your analytical techniques and your interpretation of the results.

Assignment files should be named as follows:

• Asg#_FirstInitialLastname
• e.g. Assignment 1 for Michael Phelps would be named Asg1_MPhelps.xlsx

Question 1. 50 points

The data are for monthly retail sales of beer, wine, and liquor at U.S. liquor stores.

Question 2. 50 points

The data are on a motel chain’s revenue and advertising.

A.Use these data and multiple regression to make predictions of the motel chain’s revenues during the next four quarters.
In addition to advertising, also try using advertising, lagged by one quarter, as an explanatory variable.
Assume that advertising during each of the future four quarters is $50,000.

Let X1 represent the quarter.

Let X2 represent the advertising.

Let X3 represent the lag1(Advertising).

Let X4 represent the quarter1.

Let X5 represent the quarter2.

Let X6 represent the quarter3.

B.Use simple exponential smoothing to make predictions for the motel chain’s revenues during the next four quarters.

C.Use Holt’s method to make forecasts for the motel chain’s revenues during the next four quarters.

D.Use Winters’ method to determine predictions for the motel chain’s revenues during the next four quarters.

E.Which of these forecasting methods would you expect to be the most accurate for these data?

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.