Advice 1: How to calculate the seasonal coefficient

The coefficient of seasonality is the value, counted in the trade. It allows you to determine seasonal variation in the rate of sales of a product. This allows you to arrange for its delivery on time and setvariant warehouse. Calculation and coefficient of seasonality will enable you to optimize the performance of a commercial enterprise.
How to calculate the seasonal coefficient
Instruction
1
Consider the period of calculation of the coefficient. For grocery store in General over the year monthly sales volume may remain essentially unchanged, but keeping a record of weeks, it will be understood that on Saturday and Sunday, these volumes are significantly higher than on weekdays. Accordingly, you will need to organize the delivery of perishable products to a greater extent specifically to the weekends. In stores that sell building materials, seasonality of sales is expressed in a significant increase in warm season, so the calculation can be done monthly, depending on the month of the calendar year.
2
Lead sales statistics for each type of goods. For accurate result you must have data at least for two or three years (in the case of a grocery store for a few weeks). This will allow you not to take into account in their calculations of random factors and increase their reliability. Break all products sold in your store in the category. Select the unit of measure. It is better not to use this as a money – always have to consider the factor of inflation of Rosstat, and it does not always coincide with the actual performance. Keep records of volumes, kilograms, boxes.
3
Use monthly sales data for the last three years. To determine the average monthly sales of products in a particular category, add their performance for the year and divide by the number of months in year 12. Divide sales by the average value to obtain the coefficient of seasonality for the month being analyzed. In exactly the same way to calculate the coefficients of the seasonality for each month over several years, add them up and divide by the number of years participating in your analysis. You will receive the average rate of seasonality. The accuracy of its determination will be higher, the greater the number of years analyzed.
Useful advice
Note that not all products can be forecast, and some periodically there is an excessive demand. Therefore, the values can be corrected taking into account these factors and expert opinions.

Advice 2: How to calculate the accuracy

To compare two samples drawn from the same underlying population, or two different States of one and the same set method is used student. It can be used to calculate the significance of differences, that is, to know the trustworthiness of the conducted measurements.
How to calculate the accuracy
Instruction
1
In order to choose the right formula of reliability, determine the value of groups of samples. If the number of measurements is greater than 30, such a group would be considered large. Thus, there are three options: both groups are small, the two large groups, one small group, the second – biggest.
2
In addition, you will need to know, dependent on whether the measurement of the first group with the second measurement. If each i-th variant of the first group opposed to the i-th embodiment of the second group, they are pairwise dependent. If the options within the group can be interchanged, such groups are called groups with pairwise-independent variants.
3
For comparison of groups with pairwise-independent options (at least one of them must be big), use the formula presented in the figure. Using the formula you can find the student's criterion, it determines a confidence probability of the differences between the two groups.
The formula for calculating the student's t-test for pairwise-independent groups
4
To determine the student's t-test for small size groups with pairwise-independent options, use another formula, it is represented in the second picture. The number of degrees of freedom is calculated in the same way as in the first case: fold the volume of the two samples and subtract the number 2.
The formula for calculating the student's t-test for small groups
5
To compare two small groups with pairwise-dependent results using two formulas of your choice. The number of degrees of freedom is calculated differently according to the formula k=2*(n-1).
The formula for calculating the pairwise student's t-test for dependent groups
6
Next, specify confidence probability according to the table t-student's t test. In this case, note that the sample was reliable, confidence probability must be at least 95%. That is, find the first column value of the number of degrees of freedom, and the first line is a calculated student's criterion and rate, more or less, the resulting probability of 95%.
7
For example, you received t=2,3; k=73. On the table to determine a confidence probability, it is more than 95%, therefore, the differences of the samples is accurate. Another example: t=1,4; k=70. According to the table below to the minimum value for 95% confidence, k=70, t must be equal to at least of 1.98. You have the same it is less - only 1.4, so the difference of the samples unreliable.
Is the advice useful?
Search