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

  Control charts this problem will be referred to in the study

Binomial Distribution: Control Charts this problem will be referred to in the study of control charts. In the binomial probability distribution, let the number of trials be n = 3, and let the probability of success be p = 0.0228.

  Determining standard deviation in average revenue

Suppose that sales of lemon­ade and sales of brownies are independent, determine standard deviation in his revenue.

  Estimating the mean-median and mode values

What is the arithmetic mean selling price?

  Conditional probability based on uniform distribution

Assume that the smiling time of eight-week old babies, in seconds, follows a uniform distribution between 0 and 23 seconds, inclusive. This means that any smiling time from 0 to and including 23 seconds is equally likely.

  Mean and standard deviation

Mean and standard deviation are 584.6 and 34.28

  Calculating expected number of interruptions per day

Calculate expected number of interruptions per day. Calculate standard deviation.

  Explaining statistics is science of conducting studies

Statistics is science of conducting studies to: Solve a system of equations.

  Probability that gas tank-s capacity is above the range

Determine the probability that gas tank's capacity is above 15.25 gallons?

  Estimating the standard error of the mean

When using the distribution of sample means to estimate the population mean, what is the benefit of using larger sample sizes?

  Computing average daily rainfall in week

Compute average daily rainfall in the week and for weekends. Get the average of weekdays' rainfalls and average of weekend's rainfalls.

  Construct a histogram and a frequency polygon

Using the data file below, construct a histogram and a frequency polygon. Describe the shape of this distribution.

  Freedom for the two-sample t procedures

It has been claimed that women live longer than men; however, men tend to be older than their wives. Ages of sixteen husbands and wives from England were obtained. These data should be analyzed with a

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