Explore BrainMass

Explore BrainMass

    Casual Method of Linear Regression

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    Use Excel and the LINEST function to create it.

    b.Use the equation to generate your forecasts for months 16-19. NOTE: There is NO missing information.

    c.What can you say about the relationship between the variables?

    © BrainMass Inc. brainmass.com June 3, 2020, 9:30 pm ad1c9bdddf


    Solution Summary

    Casual Method-Linear Regression is given with the formula of Y=a+bX. The forecast sales are determined using this regression model.