Question

Using the Linear Regression Fit Line: y=0.409x+2.963, calculate a forecast for the 18th month. 2 Pts Actuals 12 0.4093x+2 9632 10 Calculate a Forecast for Month 18 18th Month Forecast a) b) Does this look like a good use of a regression approach & why? c) List any concerns you 2 might have if I asked you to forecast month 24 with the data for months 1 through 17 only? 0123456789 10 11 12 13 14 15 16 17 18
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Regression line y=0.409 x+2.963

When x=18

Then, y=0.409 *18 +2.963 =10.325           

So 18th month forecast =10.325

This will be a good approach for the forecasting provided that dependent variable pattern continues as in the past.

He main concerns are that the data after 18th will not be provided and thus the patterns in them is not precise which can lead to some forecast errors.

Add a comment
Know the answer?
Add Answer to:
Using the Linear Regression Fit Line: y=0.409x+2.963, calculate a forecast for the 18th month. 2 Pts...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • HELP ASAP Suppose you are wishing to fit a multiple linear regression model using one categorical...

    HELP ASAP Suppose you are wishing to fit a multiple linear regression model using one categorical variable that can take on 17 different values. For example, if you wished to use the months of the year in your model, the categorical variable "month" would have 12 different values: January, February, March, etc. In general, how many dummy variables would you need to incorporate into your model to completely capture the effect of all 17 conditions of a categorical variable on...

  • HW8_4 Fit the data in the table using linear regression. Plot the data points as well as the regr...

    Please write the codes in MATLAB. HW8_4 Fit the data in the table using linear regression. Plot the data points as well as the regression line. Determine the value of y whenx = 7.2 and print it to the screen using fprintf Then repeat the process, regressing in the opposite way (x vs y) to find the equation of the line needed to determine the value of x when y is 15 Optional brain food: Do you get the same...

  • excel spreadsheet information: Month Sales (in millions of boxes) 1 1306 2 1305 3 1311 4...

    excel spreadsheet information: Month Sales (in millions of boxes) 1 1306 2 1305 3 1311 4 1313 5 1324 6 1329 7 1346 8 1347 9 1378 10 1394 11 1441 12 1469 Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...

  • This is a table to show how to calculate a three-month moving average. Please use this...

    This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67...

  • Problem 2.2: Linear Regression. Suppose that I am trying to estimate Starbucks stock price with a...

    Problem 2.2: Linear Regression. Suppose that I am trying to estimate Starbucks stock price with a linear regression model. The Day and Volume are being used as my X1 and X2. a) Calculate the forecast for November 1 if Volume is 8000 b) Should I be using both Day and Volume as predictors of stock price? (Use Regression result output below) c) Does the data truly have a downward trend? How could I prove it from the Regression result output?...

  • WEEK 5 DUE DATE: 12/28/2018 Assignment: Regression Modeling Regression modeling is a foundational skill for those...

    WEEK 5 DUE DATE: 12/28/2018 Assignment: Regression Modeling Regression modeling is a foundational skill for those conducting secondary data analysis, much like you will encounter in the completion of the Doctor of Healthcare Administration (DHA) program. Additionally, regression modeling assists in finding connections among multiple variables and one dependent variable. Consider, for example, a healthcare administrator who may be asked to develop or interpret models of patient satisfaction based on other quantitative or dichotomous variables. For this Assignment, review the...

  • 2. Linear trend regression Aa Aa The U.S. Census Bureau collects data on the size and...

    2. Linear trend regression Aa Aa The U.S. Census Bureau collects data on the size and location of the houses that are constructed each year in the United States. The table and corresponding plot that follow show annual time series data on the mean square feet of floor space in new one-family houses in the Midwest. 2,400 2,300 Floor Space (Mean Square Feet) 2,200 2,100 2,000 1996 1998 2000 2002 2004 2006 2008 Year applicable to the time series because...

  • Part 1: Model Building 1. Submit both this word and excel file 2. Keep two decimal places for your answer Using the data Reynolds.xls. The variables are defined as: Sales (Y) =number of electronic lab...

    Part 1: Model Building 1. Submit both this word and excel file 2. Keep two decimal places for your answer Using the data Reynolds.xls. The variables are defined as: Sales (Y) =number of electronic laboratory scales sold Months (X) =the number of months the salesperson has been employed 1. Develop the scatter plot using Sales as y axis and Months as x axis, and can you see the curvature? 2. Using a simple linear regression model to develop an estimated...

  • Chapter 12 Project: Linear Regression and Correlation Student Learning Outcomes: • The student will calculate and...

    Chapter 12 Project: Linear Regression and Correlation Student Learning Outcomes: • The student will calculate and construct the line of best fit between two variables. • The student will evaluate the relationship between two variables to determine if that relationship is significant Data The table below gives total fuel efficiency (in miles per gallon) and mass (in kilograms) of 20 new model cars with automatic transmissions. We will use this data to determine the relationship, if any, between the fuel...

  • Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average...

    Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT