Homework Assignment Using XLSTAT In Excel – Get Instant Assignment Homework Help – assignmentsonline.org

Homework Assignment Using XLSTAT In Excel – Get Instant Assignment Homework Help – assignmentsonline.org

Statistics – Get Instant Assignment Homework Help – assignmentsonline.org

Mathematics – Get Instant Assignment Homework Help – assignmentsonline.org

1. A hotdog stand owner who sales hotdogs only on Saturdays has collected the following time series data on the number of hotdogs sold over the past 12 quarters.

Year                Quarter                      Demand           

1                      Winter                        29                    

1                      Spring                         65

1                      Summer                      56

1                      Fall                              45

2                      Winter                        23

2                      Spring                         57

2                      Summer                      48

2                      Fall                              32

3                      Winter                        14

3                      Spring                         55

3                      Summer                      52

3                      Fall                              25

A) Forecast next weekly rate using a 3 period moving average.

B) Forecast the next weekly rate using a 2 period moving averageWhich one of these (A or B)  is a better forecast and why? Please explain it in writing. 

C) Forecast the next weekly rate by using exponential smoothing with an alpha value of 0.3.

D) Forecast the next weekly rate by using a linear regression.

The Assignment has to be completed in Excel using the Add in XLSTAT. 

 

Assignments Online is most trusted online tutoring platform for students. We can help you with any assignment or any homework problem or any subject.

Place your order now

Assignment online is a team of top-class experts whose only goal is to give you the best assignment help service. Follow the link below to order now...

#write essay #research paper