Business data analysis Essay Example | Topics and Well Written Essays - 1750 words

Business data analysis - Essay Example Additionally they have decided to analyse the operating cost of the copier machines compared to various alternatives as well as phone call data for sales reps and the sales report for active customers over the past year. Laurel plans to use these records to provide management with information that can assist in some way in the decision making process. Introduction This paper represents an analysis of the operations of HH Industries. The company has employed an analyst to provide information that will help the company to make decisions. This information has to be presented to management in such a way that they can understand and so will make informed decisions regarding the way forward. 1.1 Frequency Distribution Tables and Histograms for Quarter 1 and 2 Laurel has prepared frequency distribution tables and histograms for quarter 1 and quarter 2 of 1991. These can be found in Appendix 1. The table and chart for Quarter 1 1991 shows the frequency of the average daily order size for Jan uary to March 1991. The information in the table and chart indicates that orders valued between $120 and $140 occurred most frequently for a total of 19 days for the quarter. This was followed by orders ranging from $100 to $120 (17 days), $140 to $160 (10 days) and $80 to $100 (8 days) respectively. The data in Appendix 1 (a) also shows the frequency distribution and histogram for quarter 2 of 1991. The Table and histogram provides information on the frequencies of the average daily order size for April to June 1991. It shows that orders valued from $100 to $120 occurred most frequently – 24 days for the quarter. This was followed by orders ranging from $120 to $140 (19 days), $80 to $100 (10 days) and $140 to $160 (6 days) respectively. 1.2 Frequency Distribution and Histogram of Total Daily Orders for all Four Quarters The frequency distribution and histogram of the total daily orders for Quarter 3 of 1990 which are shown in Appendix 1 (b) indicates that daily orders of 15 0 to 160 occurred most frequently at 16 days during the quarter. This was followed by daily orders of 140 to 150 which occurred 14 times for the quarter, 160 to 170 which occurred 13 days for the quarter and 170 to 180 which occurred for a total of 10 days during the quarter. The frequency distribution and histogram of the total daily orders for Quarter 4 of 1990 indicates that daily orders of 160 to 170 occurred most frequently at 15 days during the period. This was followed by daily orders of 150 to 160 which occurred 10 days for the period, 170 to 180 which occurred 9 days for the quarter, and 180 to 190 and 190 to 200 which occurred for a total of 8 days each during the quarter. The frequency distribution and histogram of the total daily orders for Quarter 1 of 1991 indicates that daily orders of 170 to 180 occurred most frequently at 14 days during the period. This was followed by daily orders of 160 to 170 which occurred 12 times for the period,