Given the following information:Month 1 2 3 4 5Sales 25 20 40 35 30(a) Using the two-period weighted moving average with weights assigned to more recentin order 4 and 1,(I) the sales forecast for Month 6 is(ii) the forecasting error for Month 3 is(iii) the mean absolute deviation is(b) Using an exponential smoothing technique with alpha = 0.8(i) the sales forecast for Month 6 is(ii) The forecast error for Month 5 is(iii) The mean absolute deviation is

a) i) Monthly sales data:Month12345Sales2520403530Step 1 - Calculating Weighted Moving Average for…

Answered: Given the following information: Month…

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter4: Linear Functions

Section4.3: Fitting Linear Models To Data

Problem 23SE: The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the...

See similar textbooks

Similar questions

What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?
Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?
Find the mean hourly cost when the cell phone described above is used for 240 minutes.
In Table L-1, the total value of imports of Indonesian goods and services from China for the 2010-2019 period is reported on a quarterly basis. With this data you are asked to analyze it with the Trend model and Seasonal Index. Question: a. Calculate a moving average with the average period length of 4 or MA (4) [why four?] And put the results in a column. Beware of selecting the rows to place the average result. b. Calculate the moving average with the length of the average period is 2 from the data in column MA (4) and the result is given the symbol MA (2x4) and the result is placed in a column. Beware of selecting the rows to place the average result. c. Calculate the ratio to the Moving Average (Y / MA (2x4)) and place it in a new column! d. Calculate a seasonal index and interpret the results! e. Create a Deseasonalized data series and place it in a new column! f. Plot the Dessasonalized data series and read the long-term movement patterns of data! Remember that understanding of…
As part of the preliminary analysis of the data provided in Table D, the researcher produced the scatter plot below. Average taings, mo = e Scatter plot of Sales vs Earnings (IV) (V) (VI) A. (I), (II), and (VI) B. (II), (III), and (V) C. (III), (IV), and (V) D. (II), (IV) and (V) 40 . 50 Average Annual Sales 60 Which THREE of the following assumptions are inferable or discernible from the scatter plot? (1) Whether the sample of 20 MSMEs is representative of the population of MSMEs in the Western Cape province. Whether the assumption of a linear relationship between the independent variable and the dependent variable has been met or violated. Whether the assumption of normality of the independent variable and the dependent variable has been met or violated. The absence or presence of outliers in the data set. The direction of the relationship between the independent variable and the dependent variable. The significance of the relationship between the independent variable and the…
b) The following are the quarterly index numbers of whole sale prices: Year 1928 1929 1930 1931 1932 1933 1934 Values 125 112 136 142 118 120 122 Fit a linear trend to these data and find trend values(Y). Take the deviations of the observed values(Y) and verify that E(Y-Y^)=0.
The following is the data of the production of corona vaccine (Pfizer) for last few months. Using the moving average of 5 months determine the trend of production of corona vaccine. Month February March April Мay June July Production (units) 400 600 500 600 700 600 O a. 560 and 600 O b. 450 and 550 O C. 500 and 600 O d. 500 and 560
vt 14. Calculate trend values by the method of Least Square from the data given below and estimate the sales for 2007. Year 2000 2001 2002 2003 2004 Sales of GA. (Rs. lakhs) 70 74 80 86 90 上

Given the following information: Month 1 2 4 Demand 15 19 3 27 30 5 6 37 58 (a) Using the two-month weighted moving average with weights assigned to the oldest in order 0.3 and 0.7, (i) the forecast for Month 7 is (ii) the forecasting error for Month 5 is (iii) the mean absolute deviation is (b) Using an exponential smoothing technique with alpha=0.6, (i) the forecast for Month 7 is (ii) the forecasting error for Month 4 is (iii) the mean absolute deviation is Time left 1:04
Given the following information: Month 1 2 Sales 9 11 3 4 5 6 10 12 8 7 (a) Using the three-period weighted moving average with weights assigned to the most recent in order 4, 2 and 1, (i) the sales forecast for Month 7 is (ii) the forecasting error for Month 5 is (iii) the mean absolute deviation is (b) Using an exponential smoothing technique with alpha = 0.5 (1) the sales forecast for Month 7 is (ii) the forecasting error for Month 4 is D (iii) the mean absolute deviation is
When the moving average method is used to estimate the seasonal factors with quarterly sales data, a ______ period moving average is used.
The following table shows the monthly sales of a product for a 2-year period. Year Jan Feb. Mar. Apr. July Aug. Sept Oct. 73 Мay June Nov. Dec. 1 73 65 70 70 76 68 75 70 66 70 78 2 71 67 68 72 74 70 73 75 68 73 68 80 a) Forecast sales for year 2 (January thru December) using moving average with trend model (even though we already know actual sales). Use year 1 data as needed for 3-month and 5-month moving averages b) Compare the two forecasts. Which one do you prefer? c) Forecast monthly sales for year 3 by using the selected forecast.

SEE MORE QUESTIONS

Recommended textbooks for you

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

College Algebra

Algebra

ISBN:

9781305115545

Author:

James Stewart, Lothar Redlin, Saleem Watson

Publisher:

Cengage Learning

Algebra and Trigonometry (MindTap Course List)

Algebra

ISBN:

9781305071742

Author:

James Stewart, Lothar Redlin, Saleem Watson

Publisher:

Cengage Learning

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS