create a regression equation to make a forecast

Related BrainMass Solutions

• Statistics - Confidence Interval and Regression

  Would a fitted trend be helpful in making a prediction for 2004? (e) Fit a trend model of your choice to the 1992-2003 data. (f) Make a forecast for 2004, using either the fitted trend model or a judgment forecast.

• MAD, slope, intercept, regression equation, forecast

  333530 MAD, slope, intercept, regression equation, forecast Using data in chart 6-11 calculate a moving average forecast for months 4 through 12 using weights of 3, 5,9 What is the MAD for this forecast?

• What is the linear regression and 5-month moving average forecast for the sales data?

  Make sure you select "Show Equation on graph" if you want to see the equation on the graph. This is the regression equation. 4. Once you have the regression equation, you are all set.

• Regression & Time Series Analysis

  output to make a sales forecast for the time period below.

• Casual Method of Linear Regression

  185055 Casual Method-Linear Regression I used the formula Y =a+bX but 1.Regarding the causal method of linear regression: a.What is the appropriate linear regression model (equation) to forecast sales?

• Demand Forecasting and Forecasting Error

  Create a graph of sales ? Create 3-month moving average forecast and add it to the graph ? Create weighted moving average forecast (60% most recent, 30% two periods back , 10% 3 periods back) and add it to your graph ?

• Weighted Moving Average Using Multiple Regression

  Use Data Analysis from the attached excel file to create a multiple regression equation where the forecast for the next year is a function of the attendance in each of the previous 2 years.

• Forecasting techniques -regression moving average

  sure to include the equation for the linear regression calculation.

• Forecasting: weighted moving average

  Using simple linear regression analysis, calculate the regression equation for the preceding demand data. e. Using the regression equation in d, calculate the forecast for July. Thanks Hello Please see the excel file attached.

• Fundamentals of cost accounting

  Your response is in excel and shows you how to make a regression equation and then computes the forecast for you. Click on cells to see computation.