A company wants to develop a simple linear regression model for one of its products. Use the following 12 periods of historical data to develop the regression equation and use it to forecast the next three periods. Click the icon to view the historical data for the previous 12 periods. The simple linear regression line is F₁ =+x. (Enter your responses rounded to two decimal places and include a minus sign if necessary.) Find the forecasts for periods 13-15 based on the simple linear regression and fill in the table below (enter your responses rounded to two decimal places). - X Period Forecast (F₁) (x) 13 14 15 O Period (x) 1 2 3 4 5 6 7 8 9 10 11 12 at (y) 211 184 199 187 156 150 162 165 146 130 119 129 D Next

A company wants to develop a simple linear regression model for one of its products. Use the following 12 periods of historical data to develop the regression equation and use it to forecast the next three periods. Click the icon to view the historical data for the previous 12 periods. The simple linear regression line is F₁ =+x. (Enter your responses rounded to two decimal places and include a minus sign if necessary.) Find the forecasts for periods 13-15 based on the simple linear regression and fill in the table below (enter your responses rounded to two decimal places). - X Period Forecast (F₁) (x) 13 14 15 O Period (x) 1 2 3 4 5 6 7 8 9 10 11 12 at (y) 211 184 199 187 156 150 162 165 146 130 119 129 D Next

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

Chapter4A: Problems In Applying The Linear Regression Model

Section: Chapter Questions

Problem 1E

See similar textbooks

Similar questions

Stores commonly offer a cheaper unit price for large quantity purchases. Quantity 1 2 5 10 20 Unit Price $100.00 $80.00 $70.00 $50.00 $40.00 a. Use regression to find a logarithmic equation to model the data. Round the numbers in your equation to 2 decimal places. y = a + bln(z) with You b b. Use your equation to find an appropriate unit price for a customer who purchases 15 items. c. Use your equation to find an appropriate unit price for a customer who purchases 25 items. $
The following data relate the sales figures of restaurant, to the number of customers registered that week: Week Customers Sales (SR) First 16 330 Second 12 270 Third 18 380 Fourth 14 300 a) Perform a linear regression that relates bar sales to guests (not to time). b) If the forecast is for 20 guests next week, what are the sales expected to be?
A scatter plot shows data for the cost of a vintage car from a dealership (y in dollars) in the year a years since 1990. The least squares regression line is given by y-25,000 + 500z. Interpret the y intercept of the least squares regression line. Select the correct answer below O The predicted cost of a vintage car from a dealership in the year is 820.000 O The predicted cost of a vintage car from a dealershpin the year 1090 is 85,000. O The predicted cost of a vintage car from a dealershp in the year 1990 is sse. The yintercept should not be interpreted.
The table lists fossil fuel production as a percentage of total energy production for selected years. A linear regression model for this data is (A) Draw a scatter plot of the data and a graph of the model on the same axes. y = - 0.33x+95.0 OA. OB. where x represents years after 1960 and y represents the corresponding percentage of oil imports. 100 100 Fossil Fuel Production Production (%) 96 Year 1960 07 -> 1970 1980 91 60 60 Years after 1060 88 Years after 1980 1990 84 OC. OD. 2000 83 100 , 100 0- 04 60 60 Years after 1960 Years after 1960 (B) Interpret the slope of the model. The rate of change of the percentage of oil imports with respect to time is -0.33% per year. (C) Use the model to predict fossil fuel production in 2010. In 2010 fossil fuel production as a percentage of total production will be about 78.5 %. (Round to one decimal place as needed.) (D) Use the model to estimate the year in which fossil fuel production will fall below 70% of total energy production. In the year…
As an auto insurance risk analyst, it is your job to research risk profiles for various types of drivers. One common area of concern for auto insurance companies is the risk involved when offering policies to younger, less experienced drivers. The U.S. Department of Transportation recently conducted a study in which it analyzed the relationship between 1) the number of fatal accidents per 1000 licenses, and 2) the percentage of licensed drivers under the age of 21 in a sample of 42 cities. Your first step in the analysis is to construct a scatterplot of the data. FIGURE. SCATTERPLOT FOR U.S. DEPARTMENT OF TRANSPORATION PROBLEM U.S. Department of Transportation The Relationship Between Fatal Accident Frequency and Driver Age 4.5 3.5 3 2.5 1.5 1 0.5 6. 10 12 14 16 18 Percentage of drivers under age 21 Upon visual inspection, you determine that the variables do have a linear relationship. After a linear pattern has been established visually, you now proceed with performing linear…
Use Excel's regression function to develop a multiple regression forecast for Pricilla Phashions Indicate the r² of the model, and whether all the coefficients for the regression are significant, then calculate the dress sales for Year-3. show steps on excel
How to run a linear regression analysis on excel based on the following data: Fatalities Ln Safety Belt Rate 1071 3.951243719 1138 4.058717385 996 4.257030144 991 4.374498368 1038 4.365643155 1004 4.348986781 1154 4.382026635 1148 4.404277244 1207 4.417635062 1110 4.410371108 969 4.455509411 848 4.49980967 862 4.515245478 895 4.477336814 865 4.494238625 853 4.577798989 820 4.561218298 850 4.535820108 1083 4.521788577 948 4.531523646 953 4.519612298 856 4.525044142
Sally Sells Sea Shells by the Sea Shore and collects all sales dataNow she is curious to find out what the elasticity of demand is for her shells Assume they are all the same type and quantity She scatter plots the data and finds there is a linear relationship that looks ripe for a regression estimation of the price response function for her shells The slope of her regression line is 61. Currently, her average daily price is 11.74 and she sells 95 quantity at that priceCalculate the point elasticity of demand for her sea shells
Please make a Data set and regression equation based on Student Debt and inflation with the following variables: Current student debt,interest rates, inflation rates ( will give thumbs up ) thank you so much.
What is a linear regression model? What is measured by the coefficients ofa linear regression model? What is the ordinary least squares estimator?
QUESTION 1 Suppose a researcher collects data on houses that have been sold in a particular neighbourhood over the past year, and obtains the regressions results in the table shown below. This table is used for Questions 1-6. Dependent variable: In(Price) Regressor (1) (2) (3) (4) (5) 0.00042 (0.000038) Size In(Size) 0.57 (2.03) 0.69 0.68 0.69 (0.055) (0.054) (0.087) In(Size)² 0.0078 (0.14) Bedrooms 0.0036 (0.037) Рol 0.082 0.071 0.071 0.071 0.071 (0.032) (0.034) (0.034) (0.036) (0.035) 0.037 0.027 0.026 0.027 0.027 (0.030) View (0.029) (0.028) (0.026) (0.029) Pool x View 0.0022 (0.10) 0.12 (0.035) Condition 0.13 0.12 0.12 (0.035) 0.12 (0.045) (0.035) (0.036) 6.63 (0.53) Intercept 10.97 6.60 7.02 6.60 (0.069) (0.39) (7.50) (0.40) Summary Statistics SER 0.102 0.098 0.099 0.099 0.099 R? 0.72 0.74 0.73 0.73 0.73 Variable definitions: Price = sale price ($); Size = house size (in square feet); Bedrooms = number of bedrooms; Pool = binary variable (1 if house has a swimming pool, 0…
Time left U:18:05 CLEAR MY CHOICE Finish a Question Consider the following model Y=B1+B2 X2 +e. Assume you change the scale of the y and X variables in such a way that Not yet Y*=aY and X2*=bX2. and you run the regression Y*=B1*+B2* X". What effect this scaling will have on answered the slope Marked out of 1.00 Select one: P Flag O a. B2=a+b (B2) question O b. B2*=a/b^2 (B2) O c. B2*-ab (B2) O d. B2*=a/b (B2) NEXT PAGE PREVIOUS PAGE