Highest performing model to forecast sales

Assignment Help Basic Statistics
Reference no: EM1316116

Forecast using Regression and Seasonal Index.

1. Using form of Regression method would give you the highest performing model to forecast Sales?  Why?

2. Graph the Actual and Forecast over Time Period to give visual evidence of the fit.       

3. Using your model, please forecast the sales for:

2008-April;

2008-July;

2009-Oct.;

And 2009-Dec.

Year

Month

Sales (MMs)

Time Period

2005

Jan

243

1

2005

Feb

238

2

2005

Mar

237

3

2005

Apr

185

4

2005

May

193

5

2005

Jun

151

6

2005

Jul

158

7

2005

Aug

167

8

2005

Sep

127

9

2005

Oct

149

10

2005

Nov

173

11

2005

Dec

229

12

2006

Jan

288

13

2006

Feb

265

14

2006

Mar

276

15

2006

Apr

224

16

2006

May

226

17

2006

Jun

184

18

2006

Jul

194

19

2006

Aug

200

20

2006

Sep

163

21

2006

Oct

173

22

2006

Nov

212

23

2006

Dec

277

24

2007

Jan

331

25

2007

Feb

306

26

2007

Mar

318

27

2007

Apr

260

28

2007

May

267

29

2007

Jun

219

30

2007

Jul

227

31

2007

Aug

237

32

2007

Sep

191

33

2007

Oct

215

34

2007

Nov

242

35

2007

Dec

306

36

 

Reference no: EM1316116

Questions Cloud

Describes common stock or preferred stock : Classification of preferred stock and common stock and check whether the characteristic listed below describes common stock (CS) or preferred stock (PS).
Using tree diagram-determining probability : Draw a tree diagram representing this experiment. Use this tree diagram to find the probabilities below.
Describe current degree of financial leverage : Describe Current degree of financial leverage and McFrugal's tax rate is 40% and The firm also has outstanding 1 million shares of common stock
Determining market structure of selected company : Examination of the company for which you are currently working (or a company with which you are familiar). Answer the following questions regarding this company.
Highest performing model to forecast sales : Utilizing form of Regression method which would give you highest performing model to forecast Sales. Utilizing your model forecast the sales
Multiple questions on accounting principles : Multiple questions on accounting principles and Joe's Appliances purchased inventory for $12,800 on credit. This transaction
Solve the quadratic equations : Solve the quadratic equations
Joint-marginal-conditional probability : Find the probability that an eligible voter selected at random will have the following characteristics.
Identifying the nash equilibrium for bertrand : Bertand: If the firms compete on the basis of (continuous) price, what is the Nash equilibrium if the game is played once? A finite number of times? Explain clearly.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Determining variance of the population

We are interested in testing to find out whether the variance of the population is vitally more than 0.003

  Questions based on binomial distribution

Questions based on binomial distribution, variance of the binomial distribution, discrete random variable and continuous random variables.

  Analysis of variance and its assumptions

Is there evidence of violations of the usual ANOVA assumptions of equal variances and normal populations? Set up and perform appropriate TESTS at the α = 0.05 level of significance.

  Determining sample as representative of population

In exercise identify (a) sample and (b) population. Also, find whether sample is likely to be representative of population.

  Distribution of the sample mean

What is the expected shape of the distribution of the sample mean?

  Determining odds student gets questions correct

Determine odds student gets more than 14 questions correct? Determine the odds student gets exactly 12 questions correct?

  Prediction interval for a new patient

The 95% prediction interval for a new patient with a 2-day cholesterol level of 220 is

  Probability distribution

Probability distribution described by the following density curve and The expected value of the sum of the weights of the two oranges, in pounds

  Sampling variability

A simple random sample of 1000 Americans found that 61% were satisfied with the service provided by the dealer from which they bought their car.

  One way analysis of variance-anova

Should Katie conduct a between-subject ANOVA or a within-subject ANOVA? Describe your answer.

  Partial anova table

Assume the data for the three groups are independent and the data are approximately Normal. The P-value is less than 0.01. The correct conclusion is that

  Solve the equations using linear algebra

Solve the equations using linear algebra

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd