Question

In: Statistics and Probability

You are doing an internship with Macy’s and are tasked with forecasting sales so that you...

You are doing an internship with Macy’s and are tasked with forecasting sales so that you can make inventory orders. You have weekly sales data for men’s dress shirts in your store from each of the past six weeks. You decide to try both a 3-period moving average and exponential smoothing with λ = 0.7 to see which model is more accurate and then use that one to make forecasts. The sales data is shown below.

Week # of Shirts Sold
1 423
2 448
3 437
4 361
5 395
6 416

What is the calculated MSE for the exponential smoothing method? Round intermediate calculations and final answer to 4 decimals.

What is the calculated MSE using the 3-period moving average? Round intermediate calculations and final answer to 4 decimals.

Solutions

Expert Solution

Formula:

Formula Ref:


Related Solutions

You are doing an internship with Macy’s and are tasked with forecasting sales so that you...
You are doing an internship with Macy’s and are tasked with forecasting sales so that you can make inventory orders. You have weekly sales data for men’s dress shirts in your store from each of the past six weeks. You decide to try both a 3-period moving average and exponential smoothing with λ = 0.7 to see which model is more accurate and then use that one to make forecasts. The sales data is shown below. Week # of Shirts...
. You are doing an internship in strength and conditioning and working with athletes on acceleration...
. You are doing an internship in strength and conditioning and working with athletes on acceleration development from a 3-point stance. You read about a stick drill/acceleration ladder online that might be good to use with your athletes. According to the website, five-seven sticks (tape, cone, etc.) are placed in a ladder formation with the initial mark at a distance of 3 feet from the start line and the remaining “rungs” positioned with a progressive lengthening of 6 inches. The...
Suppose you are doing an internship at a local tax office. Your manager, asks you to...
Suppose you are doing an internship at a local tax office. Your manager, asks you to prepare a simple income statement using the following list of accounts to test your basic knowledge of financial reporting. Accounts Cash/Million Dollars/ Depreciation 25 General Management Expenses 22
Why do you want a sales internship? how would this be a fit for you AND...
Why do you want a sales internship? how would this be a fit for you AND you a fit for this?
You are tasked to design an application to keep track of sales for your company. Sales...
You are tasked to design an application to keep track of sales for your company. Sales should be tracked for two types of accounts: supplies and services. Complete the following:     Create a UML class diagram for the Account inheritance hierarchy. Your subclasses should be Supplies and Services.     All sales accounts will have an account ID (accountId).     You will need attributes to keep track of the number of hours (numberOfHours) and rate per hour of services provided (ratePerHour)....
1. Carlos is a business student doing an internship at Bruno and Venus, a firm specializing...
1. Carlos is a business student doing an internship at Bruno and Venus, a firm specializing in exports of sophisticated equipment to other countries. He finds that he is unable to create a representative chart depicting the processes such as procurement, shipping, and billing. This indicates that he lacks -----------skills. Data analysis Abstract reasoning Collaborative Experimental 2. The persons, places, things or events about which databases record information are referred to as: Keys Fields Tuples Entities 3. Before a business...
i am doing an internship in the physics department i was lucky enough to actually get...
i am doing an internship in the physics department i was lucky enough to actually get this internship as ive just finished my first year. the problem is i have a very professional professor he is so so smart so whenever he explains something to me i just don't understand it, i feel like we have so much mis understanding between me and him. The way he asks me to do things seems so vague to me but so obvious...
21) Sales Forecasting: You were asked at your new company to forecast sales for the coming...
21) Sales Forecasting: You were asked at your new company to forecast sales for the coming year. Utilizing the Compound Average Growth Rate, you have gone out and collected the data for the prior three years (noted below). Using this data, compute the a. compound growth rate for each of the years b. forecast next year’s sales by using the two-year average growth rate. Year Sales 2012 2,400,000 2013 2,750,000 2014 3,500,000 2015 ?
i'm doing this practice problem and i'm really struggling. if you be so kind to complete...
i'm doing this practice problem and i'm really struggling. if you be so kind to complete so it can help me comprehend. Please be sure to include a visual of the coordinate plane for questions 1 & 3. Thank you. 1)A pipe needs to run from a water main, tangent to a circular fish pond. On a coordinate plane, construct the circular fish pond at a given location and specify your center point and radius. 2)Write your circular fish pond...
Hi, Im doing my final project for quanatative analysis class. I was tasked to create a...
Hi, Im doing my final project for quanatative analysis class. I was tasked to create a regression analysis on Does the number of probowl player have bearing on becoming all pro. I ran the regression for the following data and got this output from Megastat but I'm not sure what it tells me. Regression Analysis r² 0.006 n   239 r   0.076 k   1 Std. Error   0.494 Dep. Var. All Pro ANOVA table Source SS   df   MS F p-value Regression 0.3397...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT