Create a forecast using a three period simple moving average


Homework

Part I:

For the data listed below,

Month

Tired Sold

January

515

February

385

March

1413

April

1925

May

1146

June

894

July

826

August

635

September

2165

October

1535

November

707

December

639

i. Create a forecast using a three period simple moving average

ii. Create a forecast using a three month weighted moving average using weights 0.6, 0.3 and 0.1 assigning higher weight for the most recent period.

iii. Create an exponential smoothing forecast using a smoothing constant of 0.4.

iv. Calculate RMSE for each of the methods, compare values and identify the method yielding a forecast with better accuracy.

Part II:

For the data listed below,

Purchase

Income ($ '000)

Age

Gender

0

71.9

42

2

0

100.4

42

1

0

105.6

44

1

1

83.1

39

2

0

114.2

43

1

1

113.5

44

1

0

115.2

42

1

0

100.4

35

2

0

92.6

43

2

0

123.8

42

1

0

122.8

45

1

1

98.6

46

2

0

107.6

41

2

0

108.4

42

2

1

138.8

41

1

1

109.9

44

2

1

136.2

47

1

1

117.6

38

2

1

122.8

43

2

0

121.8

45

2

1

126.6

41

2

1

125.8

46

2

1

138.8

42

2

0

149.6

37

1

1

159.5

33

2

Code definitions: Purchase 0 - Not purchased and 1 - Purchased; Gender 1 - Male and 2 - Female

Fit a logistic regression model to predict purchase decision. Identify significant predictors and comment on classification accuracy.

Format your homework according to the following formatting requirements:

i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.

ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.

iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.

Solution Preview :

Prepared by a verified Expert
Supply Chain Management: Create a forecast using a three period simple moving average
Reference No:- TGS03142807

Now Priced at $50 (50% Discount)

Recommended (95%)

Rated (4.7/5)