Question

In: Statistics and Probability

With the following 10 months of sales data, Determine which of the following models below is...

With the following 10 months of sales data, Determine which of the following models below is the most adequate for your set of data. Use MAD for your decision.

DATA:

Ring Sales:

Month

01 28

02 30

03 16

04 10

05 32

06 20

07 12

08 7

09 10

10 15

1. Moving Average n=2

2. Moving Average n=4

3. Weighted Moving Average (50%, 30%, 20%)

4. Weighted Moving Average (60%, 40%)

5. Exponential Smoothing (α = 35%)

6. Exponential Smoothing (α = 2/(n+1))

Explain your results and analysis.

Solutions

Expert Solution

HHERE best is n=4 because MAD is least for that


Related Solutions

given the expiremental data below, determine the equation that models the data. first plot the data...
given the expiremental data below, determine the equation that models the data. first plot the data on both a log-log graph and a semi-log graph. next, use these plots to determine the type of equation that best fits the data. finally determine the equation. x-values= 10,20,50,120,180,200 y values=4600,3200,1130,98,98,12,6
determine whether the following models are linear in the parameters, or the variables, or both. which...
determine whether the following models are linear in the parameters, or the variables, or both. which of these models are linear regression models? .(a) Yi = b1+ b (1/xi) +ui , (b) Yi = bi + b2InXi + Ui. (c) InYi= Inb1 + b2InXi + ui (d) InYi =b1 + b2(1/Xi) + ui (e) InYi = bi + b2Xi + ui
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $18,000 $ 95,000 February $15,000 $130,000 March $24,000 $ 70,000 April $26,000 $120,000 May $19,000 $ 90,000 June $14,000 $100,000 On average, 45% of the sales on account are collected in the month of sale, 30% are collected in the month following sale, 15% are collected in the second month following sale, and the remaining 10% is collected three...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $110,000 February $18,000 $125,000 March $26,000 $119,000 April $24,000 $140,000 May $14,000 $ 88,000 June $18,000 $137,000 On average, 25% of the sales on account are collected in the month of sale, 30% are collected in the month following sale, 35% are collected in the second month following sale, and the remaining 10% is collected three months after...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $15,000 $ 70,000 February $18,000 $ 80,000 March $14,000 $160,000 April $26,000 $120,000 May $18,000 $170,000 June $24,000 $105,000 On average, 35% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 10% are collected in the second month following sale, and the remaining 15% is collected three months...
After analysing several months of sales data, the owner of an appliance store produced the following...
After analysing several months of sales data, the owner of an appliance store produced the following joint probability distribution of the number of refrigerators (x) and stoves (y) sold daily. Refrigerators (x) Stoves (y) 0 1 2 0 0.08 0.14 0.12 1 0.09 0.17 0.13 2 0.05 0.18 0.04 a Find the marginal probability distribution of the number of refrigerators sold daily. b Find the marginal probability distribution of the number of stoves sold daily. c Compute the mean and...
After analyzing several months of sales data, the owner of an appliance store produced the following...
After analyzing several months of sales data, the owner of an appliance store produced the following joint probability distribution of the number of refrigerators and stoves sold hourly    0    1 2 Stoves 0    0.08 0.14    0.12    0.34 1    0.09 0.17 0.13    0.39 2    0.05    0.18    0.04 0.27 REF 0.22    0.49    0.29    1 b. What are the laws for a discrete probability density function? c. If a customer...
Question 1 : Which of the following is a feature of models? A. Models are as...
Question 1 : Which of the following is a feature of models? A. Models are as complex as the phenomenon being studied. B. Models are the same as hypotheses. C. Models are more complicated than real life phenomena. D. Models help in making predictions for the future. Question 2 : Which of the following is a feature of a perfectly competitive market? A. There is only one seller of a commodity. B. The government rations commodities. C. The product of...
A sample of 5 months of sales data provided the following information: Month 1 2 3...
A sample of 5 months of sales data provided the following information: Month 1 2 3 4 5 Units Sold 96 110 85 96 93 Develop a point estimate of the population mean number of units sold per month (to 1 decimal). Develop a point estimate of the population standard deviation (to 2 decimals).
A simple random sample of 5 months of sales data provided the following information: Month: 1...
A simple random sample of 5 months of sales data provided the following information: Month: 1 2 3 4 5 Units Sold: 94 85 85 94 92 (a) Develop a point estimate of the population mean number of units sold per month. x = (b) Develop a point estimate of the population standard deviation. If required, round your answer to two decimal places. s =
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT