Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Addata Class

    Uploaded by

    Sanjeev Kumar Suman Student, Jaipuria Lucknow
    This document contains a linear regression model for sales forecasting. It includes the parameter estimates for the variables in the model as well as the actual and forecasted monthly sales values and errors for 36 months. The model uses prior month's sales, advertising, and changes in advertising to predict future sales.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Addata Class

    Uploaded by

    Sanjeev Kumar Suman Student, Jaipuria Lucknow
    20 views1 page
    This document contains a linear regression model for sales forecasting. It includes the parameter estimates for the variables in the model as well as the actual and forecasted monthly sales values and errors for 36 months. The model uses prior month's sales, advertising, and changes in advertising to predict future sales.

    Original Description:

    DAE data

    Original Title

    Addata.class

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a linear regression model for sales forecasting. It includes the parameter estimates for the variables in the model as well as the actual and forecasted monthly sales values and errors for 36 months. The model uses prior month's sales, advertising, and changes in advertising to predict future sales.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    20 views1 page

    Addata Class

    Uploaded by

    Sanjeev Kumar Suman Student, Jaipuria Lucknow
    This document contains a linear regression model for sales forecasting. It includes the parameter estimates for the variables in the model as well as the actual and forecasted monthly sales values and errors for 36 months. The model uses prior month's sales, advertising, and changes in advertising to predict future sales.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 1

    A B C D E F G H I J K L M N O P Q R S T

    1 a 2.372373
    2 lambda 0.555179
    3 b 2.948116 delta A(t)
    4 c -0.426231 SSE Rsq stderr
    5 0 #VALUE! #DIV/0!

    6 Actual
    Month Sales Advertising Lagged Sales delta A(t) Forecast Sq Err error
    7 1 12 15
    8 2 20.5 16 12 Sales Forecast = a + lambda*lastsales + bLn (A(t)) + c*max (0,deltaA(t))
    9 3 21 18 20.5
    10 4 15.5 27 21
    11 5 15.3 21 15.5
    12 6 23.5 49 15.3
    13 7 24.5 21 23.5
    14 8 21.3 22 24.5
    15 9 23.5 28 21.3
    16 10 28 36 23.5
    17 11 24 40 28
    18 12 15.5 3 24
    19 13 17.3 21 15.5
    20 14 25.3 29 17.3
    21 15 25 62 25.3
    22 16 36.5 65 25
    23 17 36.5 46 36.5
    24 18 29.6 44 36.5
    25 19 30.5 33 29.6
    26 20 28 62 30.5
    27 21 26 22 28
    28 22 21.5 12 26
    29 23 19.7 24 21.5
    30 24 19 3 19.7
    31 25 16 5 19
    32 26 20.7 14 16
    33 27 26.5 36 20.7
    34 28 30.6 40 26.5
    35 29 32.3 49 30.6
    36 30 29.5 7 32.3
    37 31 28.3 52 29.5
    38 32 31.3 65 28.3
    39 33 32.2 17 31.3
    40 34 26.4 5 32.2
    41 35 23.4 17 26.4
    42 36 16.4 1 23.4

    You might also like