Report on the Sales

Statistical Analysis

Student’s Name

Institution’s Name

Date

Statistical Analysis Report

Sales person A, B, C, and D make sales for the company on daily basis for six days in a week during their free time. The weekly sales for the salesperson A, B, C, and D, are as shown in the table below. This paper focuses on evaluating the sales volume and consistency using the statistical analysis means.

Week A B C D

1 1774 2205 1330 1402

2 1808 1507 1295 1665

3 1890 2352 1502 1530

4 1932 1939 1104 1826

5 1855 2052 1189 1703

6 1726 1630 1441 1493

Table 1: Individual Sales

Week A B C D Daily average

1 1774 2205 1330 1402 1677.75

2 1808 1507 1295 1665 1568.75

3 1890 2352 1502 1530 1818.5

4 1932 1939 1104 1826 1700.25

5 1855 2052 1189 1703 1699.75

6 1726 1630 1441 1493 1572.5

Individual average sales 1830.833 1947.5 1310.167 1603.167 1672.917

Table 2: Average daily and individual sales

The statistical analysis for the above data is provided as shown below:

Column1   Column2   Column3   Column4  

Mean 1830.833 Mean 1947.5 Mean 1310.167 Mean 1603.167

Standard Error 31.12386 Standard Error 133.637 Standard Error 61.02645 Standard Error 63.61416

Median 1831.5 Median 1995.5 Median 1312.5 Median 1597.5

Mode #N/A Mode #N/A Mode #N/A Mode #N/A

Standard Deviation 76.23757 Standard Deviation 327.3425 Standard Deviation 149.4837 Standard Deviation 155.8222

Sample Variance 5812.167 Sample Variance 107153.1 Sample Variance 22345.37 Sample Variance 24280.57

Kurtosis -1.09385 Kurtosis -1.42753 Kurtosis -1.10545 Kurtosis -1.03376

Skewness-0.06158 Skewness-0.28295 Skewness-0.11125 Skewness0.19241

Range 206 Range 845 Range 398 Range 424

Minimum 1726 Minimum 1507 Minimum 1104 Minimum 1402

Maximum 1932 Maximum 2352 Maximum 1502 Maximum 1826

Sum 10985 Sum 11685 Sum 7861 Sum 9619

Count 6 Count 6 Count 6 Count 6

Table 3: Statistical Analysis of the Individual Sales

Statistical Analysis Discussion

Based on this evaluation, the mean for the salesperson A, B, C, and D is given as 1830.833, 1947.5, 1310.167, and 1603.167 respectively. Based on this data, A and B did fairly well in enhancing sales where B toped in the average sold goods per day followed by A. C sold the least number of goods per day followed by D. Salesperson C did very poorly compared to others. Based on the Table 2, that denotes the average daily sales, the day recording the highest volume of sales was the third day followed by day four, then day five, and then day one. The days with least volume of sales include day 2 and day 6. The average volume of sales per day was 1672.917.

The standard deviation measures how far each of the values in the analyzed column deviate from the mean. This implies that, standard deviation is one of the best statistical tools to use in this case to measure the data consistency. The standard deviation of the four salesperson; A, B, C, and D in this case is 76.24, 327.34, 149.48, and 155.82 respectively. This demonstrates that the values in each column deviate from the mean with the values provided above. This implies that the salesperson A was highly consistent compared to all others. The least consistent salesperson was the salesperson B with standard deviation of 327.34. This is more than double the standard deviation of the next largest deviation in the least. The deviations denoted by C and D are closely together compared to the other two salespersons; A and B. The most inconsistent salesperson has the highest means among all. The salesperson managed to make very high sales in some days and less in other days creating the perceived level of inconsistency in his or her sales. Salesperson A is the second best in terms of the average sales, and the best in terms of consistency. This implies that, the sales of salesperson A can highly be predicted and the company can highly rely on this salesperson in predicting the total volume of sales the salesperson can manage to handle on daily basis. Although salesperson B recorded the highest average sales volume, the person is highly inconsistent and thus, it is considerably hard for the company to predict what this salesperson can bring to the company at the end of the day. The high level of inconsistency makes this salesperson to be less reliable.

The consistency of data can also be demonstrated by the data range. The range for the four salespersons; A, B, C, and D are determined to be 206, 845, 398, and 424 respectively. Similar to the standard deviation, the A demonstrates the smallest range, while B demonstrates the largest range. Range is obtained by subtracting the highest volume of sale with the least volume of sales in a column. The large range means that the data is sparsely distributed while a small range implies that the data is closely distributed. Thus a small range should demonstrate a high level of consistency while a large range demonstrates a low level of consistency. In this regard, the column A demonstrates a high level of consistency while column B demonstrates a low level of consistency.