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

Business - Lab Report ExampleAs it is seen, the most of customers are among 31 and 50 years (58 %). The equivalent 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 discharge sales. The minimum sale is 13.23 $, and the maximum sale is 287.59 $. Ten bins are defined and COUNTIF Excel buy the farm 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 sort outs and than define frequency for the established bins.As it is seen from the table for each sales region, the number of customers is great 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 t he region 13-40 $ is 1.7 times great 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 proprietorship 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. Discount s also attracted the