Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Statistics and Probability Expert

find out a 3-month and weighted moving average as well as also compare the forecast using MAD.

The manager of the Carpet City outlet wants to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will purchase their carpet from one of Carpet's City's many competitors. The manager has collected the subsequent demand data for the past 8 months:

Month

 Demand for Soft Shag Carpet(1,000 yd.)

1

8

2

12

3

7

4

9

5

15

6

11

7

10

8

12

A. find out a 3-month moving average forecast for months 4 through 9(use excel)

B. find out a weighted 3-month moving average forecast for months 4 through 9. Assign weights of .55, .33, and .12 to the months is sequence, starting with the most recent month.

C. Equate the two forecasts by using MAD. Which forecast appears to be more accurate?

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M923417

Have any Question? 


Related Questions in Statistics and Probability

A box of 30 diodes is known to contain five defective ones

A box of 30 diodes is known to contain five defective ones. If two diodes are selected at random without replacement, what is the probability that at least one of these diodes is defective?

A blackjack hand consists of 2 cards drawn from a 52-card

A blackjack hand consists of 2 cards drawn from a 52-card deck. The order in which the cards are drawn does not matter. (a) How many different blackjack hands are there? (b) In blackjack, the suit of the card is irreleva ...

Prove that the sequence of sample means of iid random

Prove that the sequence of sample means of IID random variables converges in the MS sense. What conditions are required on the IID random variables for this convergence to occur?

Write a matlab program to generate a realization of the

Write a MATLAB program to generate a realization of the random process from given exercise (using the frequency domain method). Use a periodogram to estimate the PSD of the process using the realization of the process yo ...

Letnbspnbspbe a wide sense stationary gaussian random

Let   be a wide sense stationary Gaussian random process and form a new process according to  is a constant and is a random variable uniformly distributed over   and independent of  (a) Is Y(t) wide sense stationary? (b) ...

1 a stock broker knows that the end-of-year balance x

1. A stock broker knows that the end-of-year balance X (percent of the January 1 balance) in the client,s account has a distribution with mean μ percent and standard deviation σ = 10. The broker collected a sample of 49 ...

The unit impulse response of a discrete linear filter

The unit impulse response of a discrete linear filter is   The autocorrelation function for the input random sequence is Determine the cross-correlation function between the input and output random sequence.

Supposenbspnbspis a circular gaussian random variable whose

Suppose   is a circular Gaussian random variable whose PDF is described by Equation, (a) Find the PDF of the magnitude,   for the special case when  (b) Find the PDF of the magnitude  for the general case when  (c) For t ...

A market researcher wants to study the television viewing

A market researcher wants to study the television viewing habits of a particular small city. A sample of 40 adult residents is asked to record their television viewing in one week. The results are: Viewing time: = 15.3 h ...

How did egypts physical location along the nile river

How did Egypt's physical location along the Nile River affect the culture's political system,religion, and art? Explore at least three examples.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate