The total number of thousands of tons of coal produced per year over a 10-year period for a certain region is provided in the accompanying dataset. Use double exponential smoothing to determine which pairs of values for alphaα and betaβ minimize MAD for this dataset. alphaαequals=0.10.1, betaβequals=0.80.8; alphaαequals=0.40.4, betaβequals=0.30.3; alphaαequals=11, betaβequals=0.60.6 Question content area bottom Part 1 First find the MAD for each pair of values, alphaα and betaβ. (Type integers or decimals rounded to two decimal places as needed.) alphaα betaβ MAD 0.10.1 0.80.8 enter your response here 0.40.4 0.30.3 enter your response here 11 0.60.6 enter your response here Part 2 Which pair of values for alphaα and betaβ minimize MAD for this dataset? alphaαequals=enter your response here and betaβequals=enter your response here (Type integers or decimals. Do not round.)

The total number of thousands of tons of coal produced per year over a 10-year period for a certain region is provided in the accompanying dataset. Use double exponential smoothing to determine which pairs of values for alphaα and betaβ minimize MAD for this dataset. alphaαequals=0.10.1, betaβequals=0.80.8; alphaαequals=0.40.4, betaβequals=0.30.3; alphaαequals=11, betaβequals=0.60.6 Question content area bottom Part 1 First find the MAD for each pair of values, alphaα and betaβ. (Type integers or decimals rounded to two decimal places as needed.) alphaα betaβ MAD 0.10.1 0.80.8 enter your response here 0.40.4 0.30.3 enter your response here 11 0.60.6 enter your response here Part 2 Which pair of values for alphaα and betaβ minimize MAD for this dataset? alphaαequals=enter your response here and betaβequals=enter your response here (Type integers or decimals. Do not round.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 39P

See similar textbooks

Question content area bottom

Part 1

First find the MAD for each pair of values,

alphaα

and

betaβ.

(Type integers or decimals rounded to two decimal places as needed.)

alphaα	betaβ	MAD
0.10.1	0.80.8	enter your response here
0.40.4	0.30.3	enter your response here
11	0.60.6	enter your response here

Part 2

Which pair of values for

alphaα

and

betaβ

minimize MAD for this dataset?

alphaαequals=enter your response here

and

betaβequals=enter your response here

(Type integers or decimals. Do not round.)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Trending now

This is a popular solution!

Step by step

Solved in 1 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.
Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
An antique collector believes that the price received for a particular item increases with its age and with the number of bidders. The file P13_14.xlsx contains data on these three variables for 32 recently auctioned comparable items. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Is the antique collector correct in believing that the price received for the item increases with its age and with the number of bidders? Interpret the standard error of estimate and the R-square value for these data.
The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?
The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?
The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?
The file P13_01.xlsx contains the monthly number of airline tickets sold by a travel agency. a. Does a linear trend appear to fit these data well? If so, estimate and interpret the linear trend model for this time series. Also, interpret the R2 and se values. b. Provide an indication of the typical forecast error generated by the estimated model in part a. c. Is there evidence of some seasonal pattern in these sales data? If so, characterize the seasonal pattern.
A trucking company wants to predict the yearly maintenance expense (Y) for a truck using the number of miles driven during the year (X1) and the age of the truck (X2, in years) at the beginning of the year. The company has gathered the data given in the file P13_13.xlsx. Note that each observation corresponds to a particular truck. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.
The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?
The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?