Business Report Lab Example | Topics and Well Written Essays - 750 words

Business - Lab Report Example As it is seen, the most of customers are between 31 and 50 years (58 %). The same percentage of customers are 20-30 years old and 51-60 years old (15 % and 18 % respectively). 9 % of the customers are older than 60. The same approach is used to estimate the percent frequency for the net sales. The minimum sale is 13.23 $, and the maximum sale is 287.59 $. Ten bins are defined and COUNTIF Excel function was used to determine the percent frequency distribution. The results are presented in the Table 4. 3. To get a cross tabulation of type of customer (regular or promotional) versus net sales it is necessary to separate net sales for these two groups and than define frequency for the established bins. As it is seen from the table for each sales region, the number of customers is greater for the group of promotional customers. The difference between two groups increases with the increase of net sales amount. For instance, the net sales for the region 13-40 $ is 1.7 times greater for the group of promotional customers; more than two times greater for the regions 40.01-68 $ and 68.01-96 $; and three times greater for the range 96.01-180 $. Net sales greater than 180 $ are only in the group of the promotional customers. The most of sales was made for the sum less than 124 $. Within this range, two times more sales were made in the group of the promotional customers. The following conclusions can be made based on the results of the statistical analysis. Most of customers are married women between 30-50 years and use Proprietary Card as a preferable payment method. More than a half of customers buy 1-2 items, and, typically the purchase amount is less than 124 $. As the promotional coupons were not sent to the regular clients, the promotion attracted more clients that are new. The amount of net sales for the group of the promotional customers is more than 2 times greater than for the group of the regular customers. Discounts also attracted the