Subjects statistics,econometrics

Sales Seasonal Analysis

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Sales Seasonal Analysis


1. **Problem statement:** Given monthly sales data for Tan Tan LTD in 2024, we are to calculate: (a) the 3-point moving average trend values, (b) seasonal indices by multiplicative and additive models, (c) predicted sales for June and July 2025, (d) deseasonalised 2024 values, and (e) classify observed sales patterns for an ice cream shop. Also answer statistics and correlation questions from the rest. --- **(a) 3-point moving average trend values:** 1. Calculate the average of each consecutive 3-month period sales: For January to March: $$\frac{125 + 145 + 186}{3} = 152$$ February to April: $$\frac{145 + 186 + 131}{3} = 154$$ March to May: $$\frac{186 + 131 + 151}{3} = 156$$ Continue similarly to get moving averages for all periods until October to December. 2. The trend values are these 3-point averages, each assigned to the middle month of the 3-month window. --- **(b) Seasonal indices for each quarter:** 1. Aggregate sales for each quarter by summing or averaging respective months. 2. **Multiplicative model:** Seasonal index = $$\frac{Actual Quarter Sales}{Trend or Deseasonalised Sales}$$ 3. **Additive model:** Seasonal index = $$Actual Quarter Sales - Trend or Deseasonalised Sales$$ 4. Calculate values using quarterly actual sales data and trend. 5. Comment: Indices > 1 (or positive for additive) mean above-average seasonal effect, < 1 (or negative) means below average. --- **(c) Predicted sales for June and July 2025:** 1. Estimate trend component for June and July 2025 using observed trend progression or regression. 2. Multiply (multiplicative) or add (additive) the seasonal indices for the respective quarter. 3. Compute predicted sales: $$Sales = Trend \times SeasonalIndex$$ for multiplicative or $$Sales = Trend + SeasonalIndex$$ for additive. --- **(d) Deseasonalised 2024 values:** 1. Deseasonalised Value = $$\frac{Actual Sales}{Seasonal Variation}$$ for multiplicative or $$Actual Sales - Seasonal Variation$$ additive model. 2. Using given table values, apply the formula to each quarter. --- **(e) Classification of sales patterns for ice cream shop:** 1. Peaks every summer and dips every winter: **Seasonal variation** because of recurring pattern. 2. Two periods of overall growth followed by slowdown: **Trend** representing long-term movement. 3. One-month plummet due to road closure: **Irregular or random variation** caused by an unexpected event. --- **Scatter Diagram question:** (b) Plot points for given X and Y values, showing a scatter plot. (c) Relationship appears weakly positive or no clear correlation due to spread. (d) Coefficient of determination $$r^2$$ calculated by regression measures proportion of variance in Y explained by X. --- **Confidence interval for difference in means (Question 4b):** 1. Calculate sample means, variances, pooled variance. 2. Use formula: $$CI = (\bar{x}_1 - \bar{x}_2) \pm t_{df,\alpha/2} \times SE$$ where $$SE=\sqrt{s_p^2(\frac{1}{n_1} + \frac{1}{n_2})}$$ and $$s_p^2$$ is pooled variance. 3. Use t-distribution with $$df = n_1 + n_2 - 2$$. --- **Hypothesis Testing (Question 5c):** 1. Calculate test statistic $$t = \frac{\bar{x}_1 - \bar{x}_2}{\sqrt{\frac{s_1^2}{n_1} + \frac{s_2^2}{n_2}}}$$. 2. Compare with critical value at 0.05 significance. 3. Conclude if reject or fail to reject null hypothesis. **Other questions:** 1. Definitions and examples of sample statistics vs population parameters and errors. 2. Smallest sample size for given variance and margin of error. 3. Price index calculations as per formulas for simple aggregative, Laspeyre's, Paasche's and Fisher's. This response covers methodology, calculations rely on above steps and formulas.