Question

In: Math

I realize similar questions were already asked. These aren't the same questions or the same data...

I realize similar questions were already asked. These aren't the same questions or the same data set. please also explain how to do this in excel.

For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 78, 82, 84, 83, 83, 84, 88, 84, 82, 83, 84, and 83.

1.) Create a three-month moving average forecast against an exponential smoothing forecast with α=.2.

2.) Which forecasting method has the smallest error, use the Mean Square Error (MSE) metric as the measure of model accuracy?

3.) What is the forecast for the 13th month using a three month moving average?

Solutions

Expert Solution


Related Solutions

Let's do some quantitative data research on Apple. I sometimes hear that they aren't doing as...
Let's do some quantitative data research on Apple. I sometimes hear that they aren't doing as well as they have done in the past and they might be slowing down. Let's look at their last 3 years worth of financial data and tell us if they are doing better, the same or worse and how you determined this (show computations and or numbers). If someone has already done Apple, you can always select a different company. The key here is...
Hi, I asked a similar question yesterday and the answer was amazing. However, this is a...
Hi, I asked a similar question yesterday and the answer was amazing. However, this is a case study so I need relevant data / real cases / real examples and information on these issues. I am struggling to find any key sources for any of these question (only need to do 1 question but in depth, about 3000 words). Thanks Write a report on trade, employment and wages in Vietnam. Write a report on disinflation, fiscal sustainability and economics growth...
***I understand this question has already been asked, but could I possibly get a new answer?...
***I understand this question has already been asked, but could I possibly get a new answer? I am trying to study a variety of companies and answers so I will be more prepared for whatever is on the test.*** DoorDash as the company. 1. Select a company that has undergone an initial public offering within the last five years and obtain the prospectus (these are usually available on the company’s website, EDGAR for companies listed on the U. S. stock...
***I understand this question has already been asked, but could I possibly get a new answer?...
***I understand this question has already been asked, but could I possibly get a new answer? I am trying to study a variety of companies and answers so I will be more prepared for whatever is on the test.*** DoorDash as the company. 1. Select a company that has undergone an initial public offering within the last five years and obtain the prospectus (these are usually available on the company’s website, EDGAR for companies listed on the U. S. stock...
I already asked this but didnt get a good response for FIFO perpetual or LIFO Perpetual....
I already asked this but didnt get a good response for FIFO perpetual or LIFO Perpetual. I need a more elaborate response. Please show work and explain why!!! I'm super confused. On November 1, Lacy Company began business with the purchase of 250 units of inventory for $21,625. During the month, Lacy had the following inventory transactions: Date November 6 Purchased 100 units @ $75 per unit 11 Sold 200 units 17 Sold 85 units 24 Purchased 100 units @...
INSTRUCTIONS: I HAVE ALREADY ANSWERED QUESTION 1 AND 2. I NEED ASSISTANCE WITH QUESTIONS 3 AND...
INSTRUCTIONS: I HAVE ALREADY ANSWERED QUESTION 1 AND 2. I NEED ASSISTANCE WITH QUESTIONS 3 AND 4. I HAVE FILLED OUT THE PERCENTAGE CHANGE FOR QUESTION 3, AND NEED HELP ON CALCULATING THE OPERATING, INVESTING, AND FINANCIAL SECTIONS. AS WELL AS, THE EQUATIONS FOR QUESTION 4. IF YOU CAN ANSWER QUESTIONS 3 & 4 I WILL AWARD CREDIT. Question 1: Common size for income statement Income Statement (Common Size) :                                                                  Consolidated Income Statement 2011 % 2010 % Revenue $19,176.1...
I already answered the first three questions and put the answer down I just don't know...
I already answered the first three questions and put the answer down I just don't know how to answer the last question which asks to calculate K in the rate law? A clock reaction is run at 20 ºC with several different mixtures of iodide, sodium bromate and acid, to form iodine. Thiosulfate is used to react with the iodine formed initially. Starch indicator is added to form a blue color when all the thiosulfate has been used up and...
Windows PowerShell Scripting Please answer using a switch statement. I have asked this question already and...
Windows PowerShell Scripting Please answer using a switch statement. I have asked this question already and it was wrong. Thank you and I will upvote. 1) Write a PowerShell script that displays the total count of each type (dll, txt, log) of files in c:\windows using switch statement.
For the following four questions, a group of residents were asked about their support for a...
For the following four questions, a group of residents were asked about their support for a homeless shelter being opened in their neighborhood. They were also asked about how long they had lived in the neighborhood, with short term residency defined as less than three years and long-term as three years or more. Resident Neighborhood Tenure Supports Shelter 1 Short term Yes 2 Short term No 3 Long term Yes 4 Long term No 5 Short term Yes 6 Short...
Buyers of three different brands of automobiles were asked if they would buy the same brand...
Buyers of three different brands of automobiles were asked if they would buy the same brand again. 100 individuals were surveyed for each brand to determine if there is a significant difference among the brands regarding future purchase possibilities. The results were: Purchase Again?      City A        City B        City C        Total Yes                          20              25              30              75 No                           80                75              70             225 Total                       100              100            100            300 Is there evidence of a significant difference among the groups with respect to willingness to purchase the brand of car again? (use alpha=.05)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT