Scribd Logo
Upload

Welcome to Scribd!

  • 44 views

    Period T Demand D Deseasonalized Demand

    Uploaded by

    Angsuman Bhanjdeo
    The document contains a table with 12 periods of data showing actual demand, deseasonalized demand, and seasonal factors. It also includes the results of a linear regression analysis conducted on the deseasonalized demand data with an R-squared value of 0.918, indicating a strong correlation between the variables. The regression analysis finds the intercept and coefficient to be statistically significant based on the p-values and 95% confidence intervals.

    Copyright:

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

    Period T Demand D Deseasonalized Demand

    Uploaded by

    Angsuman Bhanjdeo
    44 views3 pages
    The document contains a table with 12 periods of data showing actual demand, deseasonalized demand, and seasonal factors. It also includes the results of a linear regression analysis conducted on the deseasonalized demand data with an R-squared value of 0.918, indicating a strong correlation between the variables. The regression analysis finds the intercept and coefficient to be statistically significant based on the p-values and 95% confidence intervals.

    Original Description:

    Operations Management

    Original Title

    Seasonal Factors

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a table with 12 periods of data showing actual demand, deseasonalized demand, and seasonal factors. It also includes the results of a linear regression analysis conducted on the deseasonalized demand data with an R-squared value of 0.918, indicating a strong correlation between the variables. The regression analysis finds the intercept and coefficient to be statistically significant based on the p-values and 95% confidence intervals.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    44 views3 pages

    Period T Demand D Deseasonalized Demand

    Uploaded by

    Angsuman Bhanjdeo
    The document contains a table with 12 periods of data showing actual demand, deseasonalized demand, and seasonal factors. It also includes the results of a linear regression analysis conducted on the deseasonalized demand data with an R-squared value of 0.918, indicating a strong correlation between the variables. The regression analysis finds the intercept and coefficient to be statistically significant based on the p-values and 95% confidence intervals.

    Copyright:

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

    Period Demand Deseasonalized

    t Dt Demand
    1 8000
    2 13000
    3 23000 19750
    4 34000 20625
    5 10000 21250
    6 18000 21750
    7 23000 22500
    8 38000 22125
    9 12000 22625
    10 13000 24125
    11 32000
    12 41000

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.958065236578659
    R Square 0.917888997540522
    Adjusted R Square 0.904203830463942
    Standard Error 414.503312449667
    Observations 8

    ANOVA
    df SS
    Regression 1 11523809.5238095
    Residual 6 1030877.97619048
    Total 7 12554687.5

    Coefficients Standard Error


    Intercept 18438.9880952381 440.808707877538
    X Variable 1 523.809523809524 63.9592496813672
    MS F Significance F
    11523810 67.07182 0.000179
    171813

    t Stat P-value Lower 95%Upper 95%Lower 95.0%


    Upper 95.0%
    41.82991 1.249E-08 17360.37 19517.61 17360.37 19517.61
    8.189738 0.000179 367.3069 680.3122 367.3069 680.3122
    Period Demand Deseasionalized
    Dt Seasonal Factor
    t Demand
    1 8000 18963 0.42
    2 13000 19487 0.67
    3 23000 20011 1.15
    4 34000 20535 1.66
    5 10000 21059 0.47
    6 18000 21583 0.83
    7 23000 22107 1.04
    8 38000 22631 1.68
    9 12000 23155 0.52
    10 13000 23679 0.55
    11 32000 24203 1.32
    12 41000 24727 1.66

    You might also like