1. The document shows demand data and moving averages over a 15 month period to estimate trends using the moving average method. It includes demand values, 3 month moving averages, 4 month moving averages, and 3 and 4 month weighted moving averages.
2. Regression analysis is used to estimate a linear trend line that best fits the demand data, shown as Estimated Value over Time.
3. The moving averages smooth random fluctuations in the demand to identify underlying patterns or trends over time.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as XLSX, PDF, TXT or read online from Scribd
1. The document shows demand data and moving averages over a 15 month period to estimate trends using the moving average method. It includes demand values, 3 month moving averages, 4 month moving averages, and 3 and 4 month weighted moving averages.
2. Regression analysis is used to estimate a linear trend line that best fits the demand data, shown as Estimated Value over Time.
3. The moving averages smooth random fluctuations in the demand to identify underlying patterns or trends over time.
1. The document shows demand data and moving averages over a 15 month period to estimate trends using the moving average method. It includes demand values, 3 month moving averages, 4 month moving averages, and 3 and 4 month weighted moving averages.
2. Regression analysis is used to estimate a linear trend line that best fits the demand data, shown as Estimated Value over Time.
3. The moving averages smooth random fluctuations in the demand to identify underlying patterns or trends over time.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as XLSX, PDF, TXT or read online from Scribd
1. The document shows demand data and moving averages over a 15 month period to estimate trends using the moving average method. It includes demand values, 3 month moving averages, 4 month moving averages, and 3 and 4 month weighted moving averages.
2. Regression analysis is used to estimate a linear trend line that best fits the demand data, shown as Estimated Value over Time.
3. The moving averages smooth random fluctuations in the demand to identify underlying patterns or trends over time.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as XLSX, PDF, TXT or read online from Scribd
28 74 4 33 87 11 21 69 4 40 69 9 38 81 7 46 97 10 If an employee scored 83 in the aptitude test and prior experience of 7, what performance evaluation would be expected ? Yc 4.871 + 0.211X1 + 1.689X2 Yc 34.207 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations
SS MS F Significance F 235.4815798 117.7408 2.129748 0.265658 165.8517536 55.28392 401.3333333 Standard Error t Stat P-value Lower 95% 25.89727572 0.188088 0.862811 -77.5457 0.396316025 0.532929 0.631034 -1.05005 1.457638946 1.159073 0.330304 -2.94935
SUMMARY OUTPUT Regression Statistics Multiple R 0.946476235 R Square 0.895817263 Adjusted R Square 0.882794421 Standard Error 15.29879179 Observations 10 ANOVA df Regression Residual Total
Intercept Time (t)
1 8 9 Coefficients 278.6666667 13.96969697
SS MS F Significance F 16100.07576 16100.08 68.78815 3.37E-05 1872.424242 234.053 17972.5 Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0% 10.45106442 26.66395 4.21E-09 254.5665 302.7669 254.5665 1.684341541 8.293862 3.37E-05 10.0856 17.8538 10.0856
RESIDUAL OUTPUT Observation Predicted Sales (In $ 1000) Residuals Standard Residuals
50 Regression Statistics Multiple R 0.980326323 R Square 0.961039699 Adjusted R Square 0.949908185 Standard Error 1.910940432 Observations 10
Time (In Weeks)
ANOVA df Regression Residual Total
SS 2 7 9
630.5381466 25.56185335 656.1
Coefficients Standard Error Intercept 47.16494227 Advertising Expenditure 1.599040336 on TV and Radio (X1) Advertising Expenditure 1.148747938 on Store Displays in malls (X2)
