Concept explainers
a)
To determine: The graph from data of first six months of 2013 and to estimate the regression parameters -slope and intercept from that graph.
Introduction: Regression analysis is a
b)
To determine: The exact values of the intercept
Introduction: Regression analysis mainly accounts for a trend in data between dependent and explanatory variables. When applying regression analysis to forecasting problem, explanatory variable often corresponds to time and dependent variable to the series to be forecasted.
(c)
To determine: The forecasts obtained for July through December 2013 from the determined regression equation
Introduction: Forecasting is done based on previously observed data. Assuming first six months/periods of 2013 as baseline, forecasted values for rest periods of the year can be attained.
(d)
To explain: Reassessment on the forecasts made for July to December of 2013.
Introduction: The least square method assumes linear relationship between the variables.Linearity implies it can be illustrated as a straight row graphically. Linearity assumption may be violated in reality.
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
Production and Operations Analysis, Seventh Edition
- 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?arrow_forwardThe owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?arrow_forwardDo the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.arrow_forward
- The monthly sales for Yazici Batteries, Inc., were as follows: Jan Feb Mar Apr May Jun Jul Aug Sept Oct 21 23 17 14 11 16 16 18 Nov Dec 20 20 20 24 Month Sales This exercise contains only parts b and c b) The forecast for the next month (Jan) using the naive method=sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month= sales (round your response to one decimal place) Using exponential smoothing with a = 0.30 and a September forecast of 21.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…arrow_forwardThe San Diego Freeway 405 in Southern California showed the number of accidents during the past 6 months. Month Accidents Jan Feb Mar Apr May Jun 18 36 [Select] 28 48 39 55 Using the least squares regression method, the trend equation for forecast is Y = slope X + intercept What is the slope [Select] and the intercept [Select] What would be the forecasted July number of accidents [ Select] of this correlation, and coefficient of determination [ Select] and coefficient of correlationarrow_forwardThe following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 30 48 70 90 Part 2 Using the least-squares regression LOADING... method, the trend equation for forecasting is (round your responses to two decimal places): y = enter your response here + enter your response here x Y=?+?xarrow_forward
- H The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Number of Accidents 25 Feb 48 Mar Apr 64 100 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): ŷ=+xarrow_forwardThe monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 16 14 11 16 17 19 22 20 20 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month = sales (round your response to one decimal place). sales (round your response Using exponential smoothing with a = 0.30 and a September forecast of 18.00, the forecast for the next period (Jan) = to two decimal places). Using a method of trend projection, the forecast for the month (Jan) = sales (round your response to two decimal places). c) The method…arrow_forwardThe monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 21 20 15 14 13 15 17 18 20 21 20 23 This exercise contains only parts b and c. Part 2 b) The forecast for the next month (Jan) using the naive method = ____ sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach =____ sales (round your response to two decimal places).arrow_forward
- The following data are for calculator sales in units at an electronics store over the past nine weeks: Week 1 2 3 4 5 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE Sales Find the coefficient of determination (²). The coefficient of determination r² = 0. (Enter your response rounded to two decimal places.) 44459 46 51 58 Use trend projection with regression to forecast sales for weeks 10-13. What are the error measures (CFE, MSE, 6, MAD, and MAPE) for this forecasting procedure? How about r²? Obtain the trend projection with regression forecast for weeks 10-13. (Enter your responses rounded to two decimal places.) Forecast, Ft Period 10 11 12 13 Week 6 69809 7 Sales 54 63 53 61 MAD U MAPE %arrow_forwardThe following gives the number of accidents that occured on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of accidents 25 48 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): ^ y [___] +[___] xarrow_forwardPLEASE HELP ME WITH THIS EXERCISE SO THAT I CAN LEARN HOW TO SLOVEarrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,