Regression analysis. The owner of a small hardware store has noted a sales pattern for window locks that seems to parallel the number of break-ins reported each week in the newspaper. The data are: Sales: 46 18 20 22 27 34 14 37 30Break-ins: 9 3 3 5 4 7 2 6 4a. Plot the data to determine which type of equation, linear or nonlinear, is appropriate.b. Obtain a regression equation for the data.c. Estimate average sales when the number of break-ins is five.

Regression analysis. The owner of a small hardware store has noted a sales pattern for window locks that seems to parallel the number of break-ins reported each week in the newspaper. The data are: Sales: 46 18 20 22 27 34 14 37 30Break-ins: 9 3 3 5 4 7 2 6 4a. Plot the data to determine which type of equation, linear or nonlinear, is appropriate.b. Obtain a regression equation for the data.c. Estimate average sales when the number of break-ins is five.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
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?
Do 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.
A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?
The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
A study to determine the correlation between bankdeposits and consumer price indices in Birmingham, Alabama,revealed the following (which was based on n = 5 years of da ta):• LX = 15• Lx2 = 55• Lxy = 70• Ly = 20• L/ = 130a) What is the equation of the least-squares regression line?b) Find the coefficient of correlation. What does it imply to you?c) What is the standard error of the estimate?
Calculate a regression line for the data and indicate the forecast of sales for a store with advertising spending of R240,000? and R300,000? Store Advertising Sales 1 14 6 2 11 3 3 15 5 4 16 5 5 24 15 6 28 18 7 22 17 8 21 12 9 26 15 10 43 20 11 34 14 12 9 5
Answer the following questions 1. Calculate the slope for the regression line. (show all working) 2. Calculate the intercept for the regression line. (show all working) 3. Write the equation for the regression line 4. Forecast sales for a store if advertising spending is:-1. $240,000 2. $300,000
Sales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation. Year Sales 1 1,640 2 1,850 3 1,240 4 1,250 5 1,980 6 1,400 7 1,060 8 1,430 9 1,050 10 1,990 (Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your answer to 3 decimal places.) What is your forecast for next year's sales? (Do not round intermediate calculations and round your answer to 2 decimal places.)
Arnold Tofu owns and operates a chain of 12 vegetable protein “hamburger” restaurants in northern Chicago area. Sales figures and profits for the stores are in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Calculate a regression line for the data. What is your forecast of profit for a store with sales of $24 million? 30 million?
1.) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects only in the data. Qtr1 = 1 if Quarter 1, 0otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise, Qtr3 = 1 if Quarter 3, 0otherwise. Based only on the seasonal effects in the data, compute estimates of quarterly sales for year 6.a. Report the estimate of sales for Year 6 Quarter 1. (Enter a whole value.)b. Report the estimate of sales for Year 6 Quarter 4. (Enter a whole value.)2.) Let Period t = 1 refer to the observation in quarter 1 of year 1; Period t = 2refer to the observation in quarter 2 or year 1; … and Period t = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and Period (t), develop an estimated regression equation to account for seasonal effects and any linear trend in the time series. Based upon the seasonal effects in the data and linear trend, compute the estimates of quarterly sales for year 6.a. Report the estimate…
Arnold Tofu owns and operates a chain of 12 vegetable protein “hamburger” restaurants in northern Chicago area. Sales figures and profits for the stores are in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Calculate a regression line for the data. What is your forecast of profit for a store with sales of $24 million? 30 millions? Store Sales Profits 1 6 14 2 3 11 3 5 15 4 5 16 5 15 24 6 18 28 7 17 22 8 12 21 9 15 26 10 20 43 11 14 34 12 5 9