Ben (Yu Zhenghao)
Case study 1
February 3, 2012
Set A 1. The average age of customers is 43.08. 2. The average age of the married customers is 44.5. 3. The average age of single customers is 35.625. 4. Female:93% Male:7% 5. The average sales of single customers are 75.35 and average sales of married customers are 78.02. Married customers consumed much than single customers.
Set B 1.Method of Payment | Frequency distribution | Proprietary Card | 70 | MasterCard | 14 | Visa | 10 | Discover | 4 | American Express | 2 |
2. | Relative frequency distribution | Percent frequency distribution | Proprietary Card | 0.7 | 70% | MasterCard | 0.14 | 14% | Visa | 0.1 | 10% | Discover | 0.04 | 4% | American Express | 0.02 | 2% |
3.
The graph shows the proportion of five payments. It seems that proprietary card covers the most area.
The bar chart clearly shows the number of five means of payments. Besides, the frequency of the use of five methods of payment is also clearly notified.
4. Proprietary Card has the most use of customers.
Set C
1.
2 | 0 | 0 | 2 | 2 | 4 | 8 | 8 | 8 | 8 | 8 | | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 6 | 6 | 6 | 6 | 6 | 6 | 8 | 8 | 8 | 8 | 8 | | 4 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | | 5 | 0 | 0 | 0 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 6 | 6 | 8 | | 6 | 0 | 0 | 2 | 2 | 2 | 8 | 8 | | 7 | 0 | 2 | 4 | 8 | |
The stem and Leaf display could show the data’s shape and distribution.
2.
There are 10 customers between age 20 and 29.
3. | Frequency distribution | 20-29 | 10 | 30-39 | 30 | 40-49 | 33 | 50-59 | 16 | 60-69 | 7 | 70-79 | 4 |
4. | Relative frequency distribution | 20-29 | 0.1 | 30-39 | 0.3 | 40-49 | 0.33 | 50-59 | 0.16 | 60-69 | 0.07 | 70-79 | 0.04 |
5. | Percent frequency distribution | 20-29 | 10% | 30-39 | 30% | 40-49 | 33% | 50-59 | 16% | 60-69 | 7% | 70-79 | 4% |
6. | Cumulative frequency distribution | 20-29 | 10 | 20-39 | 40 | 20-49 | 73 | 20-59 | 89 | 20-69 | 96 | 20-79 | 100 |
7.
This is the histogram of ages, which is skewed to the right. It clearly shows the frequency of graph.
Set D
1.
| Single | Married | Male | 3 | 4 | Female | 13 | 80 |
2.
| Single | Married | Row Percentage | Male | 3 | 4 | 7 | Female | 13 | 80 | 93 | Row Percentage | 16 | 84 | 100 |
3. | gender | Male | 7 | Female | 93 |
| Marital Status | Single | 16 | Married | 84 |
4. Compared to male, there are more female customers. In contrast to single, there are more customers married. All in all, the female married customers occupied a large portion of customers.
Set E
Age:
mean= 43.08 median= 42
25th percentile= 32
75th percentile= 50 variance= 153.4885 standard deviation= 12.389 range= 58 coefficient of variation= 28.758%
Outlier
78
32 42 50
Sales: mean= 77.60 median= 59.705
25th percentile= 39.6
75th percentile= 100.9 variance= 3098.585 standard deviation= 55.665 range= 274.36 outliers coefficient of variation= 71.733%
287.59
266.0
253.0
229.5
198.8
39.6 59.705 100.9
Set F 1. With reference to the gender and marital status of customers, it appears that in comparison with male customers, there are more female customers and in contrast to single customers, there are more married customers. All in all, we could easily notice that women married customers occupied a great proportion of total customers since it is a women’s apparel stores. People from 30 to 50 go to the store most frequently, as the bar chart shows, due to the fact that housewife have the time to buy some discount clothes. As is known to all that it is impossible for office workers to spend time choosing cheap clothes. In addition, it seems that more people go to Pelican store for promotional purposes. Furthermore, according to the pie chart, there are five kinds of cards for selection, which are American Express, Discover, Visa, Mastercard and Proprietary Card. Also, from the bar chart we know that most people use proprietary card. Besides, like customer 4, discount price is more than sales price, which means this customer used the coupons released by pelican store to buy lots of goods, thus gaining huge amount of benefits. On the other hand, thanks to the 5 items bought by this customer, Pelican Store also promoted the sales. From this perspective, it created mutual benefits between Pelican Store and customers. In summary, from those statistics collected from the tabulation, it seems that lots of female married customers are willing to buy the products, especially ages from 30 to 50.
2. Initially, I would like to advise that the Pelican Store need to add some new methods of payment to expand its market. For instance, some shopping card could be taken into account of the choice of payment, which may attract more customers to come. Besides, though it seems that many customers use the discount to pay for the clothes, there are still some customers who didn’t get the discount coupons. This problem could be solved by increasing the number of discount coupons released. From this set of data, seldom do elders go to Pelican Store. This phenomenon due in part to its location. If the Pelican Store could establish some affiliated store beside the housing district, the Pelican Store could receive a wider range of customers. However, even if there is no denying that Pelican Store is a successful business, some facets also need some improvement.