Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. general management
  3. month sales (2005) sales (2006) jan 5

Month Sales (2005) Sales (2006) Jan 5 21 Feb 8 20 Mar 10 29 Apr 18 32 May 26 44 Jun 35 58 Jul 28 46 Aug 20 32 Sep 14 27 Oct 8 13 Nov 6 11 Dec 26 52 a.Plot the data using Minitab. What kind of pattern do you observe? b.Develop a trend...

70.2K

Verified Solution

Question

General Management

Month

Sales (2005)

Sales (2006)

Jan

5

21

Feb

8

20

Mar

10

29

Apr

18

32

May

26

44

Jun

35

58

Jul

28

46

Aug

20

32

Sep

14

27

Oct

8

13

Nov

6

11

Dec

26

52

a.Plot the data using Minitab. What kind of pattern do youobserve?

b.Develop a trend line equation for this data (Use Minitab).

c.Decompose the above time series using a multiplicative model.Store the trend line, detrended data, seasonals, seasonallyadjusted data. Then, calculate CI (Hint: CI = Deseasonalized data /Trend), C as a centered 3-moving average of CI values, and finallyI (=CI/C).

d.Next, compute forecasts for the next 6 months using the trendline equation and the seasonal indices you have computed. (Hint:What should you assume for C and I components?)

Answer & Explanation Solved by verified expert
3.7 Ratings (494 Votes)
OriginaldataaThe nature of the plot suggests that there are effects of    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Calculus
1.2K views

Find the average rate of change on the given interval 1 s t t t...

Biology
1.2K views

You have just diagnosed a patient with rheumatoid arthritis in their hands, a chronic, inflammatory disorder...

Physics
1.2K views

Three different circuits are set up involving identical batteries and identical bulbs.Circuit 1 connects just...

Physics
1.2K views

12 If E and E denote the isothermal and adiabatic elasticities respectively of a diatomic...

Statistics
1.2K views

An article suggests that a Poisson process can be used to represent the occurrence of...

Calculus
1.2K views

Sketch the region enclosed by the given curves y sec x y 8 cos x...

Calculus
1.2K views

3 Dudley is dropped out of a plane and falls vertically toward the earth Dudley...

Algebra
1.2K views

Convert the following equation to ope intercept form 28x 4y 40

Accounting
1.2K views

Portsmouth Company makes upholstered furniture. Its only variable cost is direct materials. The demand for...

Accounting
1.2K views

After the success of the companys first two months, Santana Rey continues to operate Business...

Accounting
1.2K views

MaxFit Weight Loss Co. offers personal weight reduction consulting services to individuals. After all the...

Accounting
1.2K views

The following data were drawn from the records of Perez Corporation. Required a. Prepare a...