payment methods are qualitative data times, these have been converted to quantitative data type by assigning numerical values to it. 1 - Type of Customer Promotional 2 - Regular 3- Walk In 2 - Globuy Charge 3- Master Method of Payment 1 - Visa Card Card 4- AMEX Engine Type Total Diesel 36 Gasoline 37 Grand Total 73 Method of Payment Grand Type of Customer Visa Globuy Charge Card MasterCard AMEX Total Promotional 21 0 12 3 36 Regular 0 37 0 0 37 Walk In 11 0 9 7 27 Grand Total 32 37 21 10 100 The above table has been created in MS Excel, after applying the formulas. The analysis states that the least used payment method is AMEX, while Globuy Charge Card is most widely used payment method. Another interesting finding is that only regular customers are using the Globuy Charge Card. The promotional customers are mostly using the VISA card as payment method. Recommendation The statistical analysis of the data revealed several facts. The dataset is positively skewed; hence management should expect most of the sales with in the $ 150 mark. The walk in customers are providing highest sales per customer, hence management should focus on increasing the number of walk in customers. Incidentally, at present the walk in customers are lowest in number. Company can also focus on the Visa card and Globuy Charge card holders, in order to generate more revenue. This statement is supported by the analysis that the most of the existing customers of Markole Stores are using these cards. Company has advertising on the target audience having these cards.
payment methods are qualitative data times, these have been converted to quantitative data type by assigning numerical values to it. Type of Customer 1 - Promotional 2 - Regular 3- Walk In Method of Payment 1 - Visa 2 - Globuy Charge Card 3- Master Card 4- AMEX Engine Type Total Diesel 36 Gasoline 37 Grand Total 73 Method of Payment Type of Customer Visa Globuy Charge Card MasterCard AMEX Grand Total Promotional 21 0 12 3 36 Regular 0 37 0 0 37 Walk In 11 0 9 7 27 Grand Total 32 37 21 10 100 The above table has been created in MS Excel, after applying the formulas. The analysis states that the least used payment method is AMEX, while Globuy Charge Card is most widely used payment method. Another interesting finding is that only regular customers are using the Globuy Charge Card. The promotional customers are mostly using the VISA card as payment method. Recommendation The statistical analysis of the data revealed several facts. The dataset is positively skewed; hence management should expect most of the sales with in the $ 150 mark. The walk in customers are providing highest sales per customer, hence management should focus on increasing the number of walk in customers. Incidentally, at present the walk in customers are lowest in number. Company can also focus on the Visa card and Globuy Charge card holders, in order to generate more revenue. This statement is supported by the analysis that the most of the existing customers of Markole Stores are using these cards. Company has advertising on the target audience having these cards.
Data-Analysis-Report-Sample.docx