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 corresponding percentage of customers are 20-30 years old and 51-60 years old (15 % and 18 % respectively). 9 % of the customers are of age(p) than 60.The same approach is used to estimate the percent relative frequency for the net gross revenue. The minimum sale is 13.23 $, and the upper limit 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 multitudes and than define frequency for the constituted 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 instan ce, 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 $. pass 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. close of customers are married women between 30-50 years and use Proprietary Card as a best-loved 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 reg ular customers. Discounts also attracted the