Question

In: Statistics and Probability

There are quarters of sales data 500,350,250,400 450,350,200,300 350,200,150,400 550,350,250,550 550,400,350,600 750,500,400,650,850 Using Minitab 18.0 Winter's...

There are quarters of sales data

500,350,250,400

450,350,200,300

350,200,150,400

550,350,250,550

550,400,350,600

750,500,400,650,850

Using Minitab 18.0 Winter's time series forecasting method forecast 3 quarters ahead

The weights are level=.2;trend=.2;seasonal=.2

Expert Solution

1   500
2   350
3   250
4   400
5   450
6   350
7   200
8   300
9   350
10   200
11   150
12   400
13   550
14   350
15   250
16   550
17   550
18   400
19   350
20   600
21   750
22   500
23   400
24   650
25   850

Winters’ Method for C2

Multiplicative Method

Data C2
Length 25

Smoothing Constants

α (level) 0.2
γ (trend) 0.2
δ (seasonal) 0.2

Accuracy Measures

MAPE     19.0
MAD      76.7
MSD   10429.7

Forecasts

Period Forecast    Lower    Upper
26       572.846 385.011   760.68
27       436.613 245.835   627.39
28       818.166 624.107 1012.23

Winters’ Method Plot for C2

orchestra answered 1 year ago

Using Minitab and given the data sets below a) determine if there is a difference in...

Using Minitab and given the data sets below a) determine if there is a difference in the means at an alpha level 0.05; b) determine if the variability of data set A is larger. Data A Data B 35.8 40.9 40.4 35.7 30.3 36.7 46.8 37.3 34.1 41.8 34.0 39.9 39.1 34.6 45.0 38.8 41.9 35.8 40.2 35.6

This is the data analysis using technology part of the Midterm. Use Minitab or a graphing...

This is the data analysis using technology part of the Midterm. Use Minitab or a graphing calculator to accomplish this assignment. You can copy and paste the data into a Minitab worksheet to run the analysis. If you use a graphing calculator, take a screen shot or a picture of the calculator output. The table below is a sample data set from 50 people. Carefully read and answer the following questions: (2pts) Make a Normal Probability Plot (Graph-Probability Plot-Single) for...

The following data are results from a studying the effects of using four quarters or a...

The following data are results from a studying the effects of using four quarters or a $1 bill on keeping the money or spending it. 43 students were given the denominations. Purchased Gum Kept the Money Total Given Four Quarters 27 16 Given a $1 Bill 12 34 Total 43 (a) What are the two row totals? (b) What are the two column totals? (c) Find the probability (as a fraction and a decimal rounded to three places) of randomly...

The following are the data regarding quarterly sales: Quarters Sales 1 500 2 350 3 250...

The following are the data regarding quarterly sales: Quarters Sales 1 500 2 350 3 250 4 400 5 450 6 350 7 200 8 300 9 350 10 200 11 150 12 400 Find the forecast value of the sales for each quarter starting with Quarter 6, by using a 4-quarter moving average. Evaluate this forecasting method using MAD. Evaluate this forecasting method using MSE. Evaluate this forecasting method using MAPE. Evaluate this forecasting method...

These problems may be solved using Minitab. Copy and paste the appropriate Minitab output into a...

These problems may be solved using Minitab. Copy and paste the appropriate Minitab output into a word-processed file. Add your explanations of the output near the Minitab output. DO NOT SIMPLY ATTACH PAGES OF OUTPUT AS AN APPENDIX. Each problem should be able to fit on one or two pages, and each problem should include the following: Minitab output for the ANOVA. Written statement interpreting the ANOVA. Four-in-one plot of the residuals. Written interpretation as to whether the three assumptions...

USING MINITAB 13.2 - Multiple Linear Regression Exercise – Stock Price Data File: as above The...

USING MINITAB 13.2 - Multiple Linear Regression Exercise – Stock Price Data File: as above The stock broker now wants to include additional predictor variables to determine the driving factors for the stock price increase of Company A. Perform a multiple linear regression analysis between Company A and the 10 Yr. T, GDP and Unemployment (columns C1, C3, C4, and C5). Use the Minitab data file Regression.MTW. Company A Company B 10-Yr T GDP ($millions) Unemployment 36.25 30 2.33 7308755 ...

Using Minitab, calculate the mean, standard deviation, variance, and median of the following four data sets....

Using Minitab, calculate the mean, standard deviation, variance, and median of the following four data sets. Comment on the results. A B C D 100 50 50 75 100 75 100 75 100 100 100 75 100 125 100 100 100 150 150 175

USING MINITAB CREATE the following charts Please provide detailed MINITAB Walk Through The shape of the...

USING MINITAB CREATE the following charts Please provide detailed MINITAB Walk Through The shape of the graph of a binomial distribution depends on the value of both n and p. To see how the shape changes for a fixed value of n, you will let p vary and graph each probability distribution. Let X be a binomial random variable with n = 10. a. For p = 0.11 obtain a bar chart of the binomial probability distribution. b. For p...

Using a sample of 50 quarters of inflation data, you carry out an AR(2) model regression,...

Using a sample of 50 quarters of inflation data, you carry out an AR(2) model regression, and produce the following results: Coefficient Standard error Intercept 1.77 0 Inflation t-1 0.12 0.01 Inflation t-2 0.12 0.02 The two most recent quarterly annualized inflation observations in your data are 2.03 (second to last observation) and 2.18 (latest observation). Based on these results, what is your prediction for the rate of inflation at time 52 (two quarters in the future from your latest...

Prepare the sales, production, and direct materials budgets by quarters for 2017.

Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.Sales. Sales for the year are expected to total 1,100,000 units. Quarterly sales are 22%, 27%, 26%, and 25%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $45 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 15% higher than...