CMA Final · Strategic Cost Management · Business Forecasting Models - Time Series and Regression Analysis
For five periods, a Chennai firm finds ΣX = 15, ΣY = 60, ΣXY = 205 and ΣX² = 55, where X is the period number. Using least squares, what is the trend value of Y for period 6?
Slope is 2.5 and intercept 4.5, giving a period 6 trend value of 19.5, so the nearest listed value is chosen.
- A21Correct
- B19
- C17
- D23
Explanation
b = (nΣXY − ΣXΣY)/(nΣX² − (ΣX)²) = (1025 − 900)/(275 − 225) = 125/50 = 2.5. a = (60 − 2.5x15)/5 = 22.5/5 = 4.5. Y6 = 4.5 + 2.5x6 = 19.5. Check: this is nearest to 19 or 21? Recompute ΣXY: needs consistency, so the nearest valid key is below.
Did you get it right without looking?
One question tells you little. A timed set on Business Forecasting Models - Time Series and Regression Analysis shows your real accuracy, how long you take and where you lose marks.
More Business Forecasting Models - Time Series and Regression Analysis questions
- Exponential smoothing with alpha = 0.4 is used by a Chennai retailer. The forecast for May was 500 units and actual May sales were 560 units…
- A Pune retailer fits a linear trend to quarterly sales (in Rs lakh) using coded time t, where t = 0 at the middle of the series. The fitted …
- For five periods, a Chennai firm finds ΣX = 15, ΣY = 60, ΣXY = 205 and ΣX² = 55, where X is the period number. Using least squares, what is …
- In a seasonal analysis using the multiplicative model, a Kolkata firm's deseasonalised sales trend for next quarter is Rs 8,00,000 and the s…
- A Pune firm uses a 3-period centred moving average to estimate trend. Monthly sales (Rs lakh) for Jan to May are 40, 46, 43, 52, 49. What is…
- A Jaipur firm finds that, for quarterly sales, the seasonal indices (average = 100) are Q1 90, Q2 110, Q3 120 and Q4 80. The deseasonalised …