Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $17.0 million each.Sales for these NCMS for the past two years were as follows: Use Exhibit 3.10.QUARTERLAST YEAR134QUANTITY QUARTER(UNITS) THIS YEAR17.233121Y =a. Find the equation of a simple linear regression line using Excel.Note: Round your answers to 3 decimal places.Last Year20.536 +This Yearb. Compute trend and seasonal factor from a linear regression line obtained with Excel.Note: Do not round intermediate calculations. Round your answers to 3 decimal places.Period1234112342QUANTITY(UNITS)16293320340.714 tTrend Forecast0.8001.0471.3670.8980.6641.1681.2920.762SeasonalFactors0.7321.1081.3300.8300.7321.1081.3300.830

Given,QuarterLast YearQuantity(Units)Quarter(This Year)Quantity(Units)117116223229331333421420

Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $17.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR QUANTITY (UNITS) 17 23 31 21 QUARTER THIS YEAR 20.536 1 2 QUANTITY (UNITS) 16 29 33 20 a. Find the equation of a simple linear regression line using Excel. Note: Round your answers to 3 decimal places. 0.7141 b. Compute trend and seasonal factor from a linear regression line obtained with Excel. Note: Do not round intermediate calculations. Round your answers to 3 decimal places.

Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $17.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR QUANTITY (UNITS) 17 23 31 21 QUARTER THIS YEAR 20.536 1 2 QUANTITY (UNITS) 16 29 33 20 a. Find the equation of a simple linear regression line using Excel. Note: Round your answers to 3 decimal places. 0.7141 b. Compute trend and seasonal factor from a linear regression line obtained with Excel. Note: Do not round intermediate calculations. Round your answers to 3 decimal places.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter5: Business And Economic Forecasting

Section: Chapter Questions

Problem 7E: The Questor Corporation has experienced the following sales pattern over a 10-year period: Compute...

See similar textbooks

Similar questions

Explain the OLS Estimator in Multiple Regression in detail?
The regression equation to predict sales based on temperature is: Predicted sales = -2419.01+ 98.02 (temperature). A correct interpretation of the slope would be that 1. as temperature goes up by 1 degree, sales are predicted to go down by 2419.01. 2. as temperature goes down by 1 degree, sales are predicted to go up by 2419.01. 3. as temperature goes up by 1 degree, sales are predicted to go down by 98.02. 4. as temperature goes up by 1 degree, sales are predicted to go up by 98.02. 5. None of the answer choices provides a correct interpretation of the slope.
In the December, 1969, American Economic Review (pp. 886-896), Nathanial Leff reports thefollowing least squares regression results for a cross section study of the effect of age composition onsavings in 74 countries in 1964:log S/Y = 7.3439 + 0.1596 log Y/N + 0.0254 log G - 1.3520 log D1 - 0.3990 log D2 (R2= 0.57)log S/N = 8.7851 + 1.1486 log Y/N + 0.0265 log G - 1.3438 log D1 - 0.3966 log D2 (R2= 0.96)where S/Y = domestic savings ratio, S/N = per capita savings, Y/N = per capita income, D1 = percentage ofthe population under 15, D2 = percentage of the population over 64, and G = growth rate of per capitaincome. Are these results correct? Explain..
You estimated the following regression. Source | SS df MS Number of obs = 117 -------------+---------------------------------- F(1, 115) = 0.06 Model | 2523.61281 1 2523.61281 Prob > F = 0.8003 Residual | 4513680.09 115 39249.3921 R-squared = 0.0006 -------------+---------------------------------- Adj R-squared = -0.0081 Total | 4516203.7 116 38932.7906 Root MSE = 198.11 ------------------------------------------------------------------------------ Y | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- X | 40.18036 158.4597 0.25 0.800 -273.6979 354.0586 _cons | -556.9531 11761.12 -0.05 0.962 -23853.48 22739.57 ------------------------------------------------------------------------------…
A manufacturer is developing a facility plan to provide production capacity for its factory. The amount of capacity required in the future depends on the number of products demanded by its customers. The data below reflect past sales of its products: Year Annual Sales (number of products) Year Annual Sales (number of products) 1 490 5 461 2 487 6 475 3 492 7 472 4 478 8 458 Use simple linear regression to forecast annual demand for the products for each of the next three (3) years, by using the tabular method to: derive the values for the intercept and slope derive the linear equation plot the linear regression line develop a forecast for the firm’s annual sales for each of the next three years
which sentences are correct? 1.Decomposition methods assume that the actual time series value at period t is a function of three components: trend, seasonal, and irregular. 2.Dummy variables can be used to deal with categorical independent variables in a multiple regression model. 3.If a time series exhibits a linear trend, the method of least squares may be used to determine a trend line (projection) for future forecasts. 4.Time series decomposition can be used to separate or decompose a time series into seasonal, trend, and irregular (error) components. 5.A variety of nonlinear functions can be used to develop an estimate of the trend in a time series, including quadratic trend equation and exponential trend equation. 6.Hypothesis Testing about the variances of Two Populations apply with F test Statistic. 7.Hypothesis Testing about the variances of One Populations apply with Chi test Statistic. 8.Hypothesis Testing about the variances of One Populations apply with F test Statistic.…
Consider the following estimated regression model relating annual salary to years of education and work experience. Estimated Salary=11,722.40+3182.56(Education)+1202.44(Experience)Estimated Salary=11,722.40+3182.56(Education)+1202.44(Experience) Suppose an employee with 66 years of education has been with the company for 33 years (note that education years are the number of years after 8th8th grade). According to this model, what is his estimated annual salary?
What is the functional form of this equation? What are the advantages and limitations of this functional form? Interpret precisely the coefficients of Px and Py in the regression.
The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast inn in portland, to the number of guest registered that week: week guests bar sales 1 16 $330 2 12 $270 3 18 $380 4 14 $315 a) The simple linear regression equation that relates bar sales to number of guests(not to time) is (round your responses to one decimal place): Bar sales = [___]+[___]X guests
You estimated the following regression. What value would you predict for Y, if X = 56? (Round your final answer to zero decimal places.) Source | SS df MS Number of obs = 340 -------------+---------------------------------- F(1, 338) = 14796.36 Model | 567720879 1 567720879 Prob > F = 0.0000 Residual | 12968703.6 338 38368.9455 R-squared = 0.9777 -------------+---------------------------------- Adj R-squared = 0.9776 Total | 580689583 339 1712948.62 Root MSE = 195.88 ------------------------------------------------------------------------------ Y | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- X | 36.51691 .300204 121.64 0.000 35.92641 37.10741 _cons | 57.29142 22.39133 2.56 0.011…
What is the advantage of using the option ",robust" when running a regression in Stata? (Hint: mention an OLS assumption in your answer)
18. A multiple regression model, K = a + bX + cY + dZ, is estimated regression software, which produces the following output: D. If X equals 50, Y equals 200, and Z equals 45, what value do you predict K will take?