Business Data Analysis Essay Example | Topics and Well Written Essays - 3500 words

Business info Analysis - Essay ExampleThe distribution of gross revenue from each customer is analyzed to identify the around important customers. The counter times for various calls be analyzed to identify the number of employees that need to be kept. Based on the analysis done, it is evident that follow needs to analyze its performance with respect to quarter as well as profit center. The company needs to have 5 employees making gross revenue calls. At the same time, the company was able to identify the most advantageous customers on whom it needs to management on. Introduction Laurel McRae has recently joined Handy Hydraulics for data analysis and strategic planning. In order to analyze the performance of the sales of the organization, Laurel collected the data for the sales for third and fourth quarter of 1990 and first and second quarter of 1991. She also collected the data regarding the machines and the days when they are works and various alternatives to replace the ex isting system. Number of calls received per hour was collected to analyze the sales call being made and number of employees that shall be entrusted with the responsibility of handling calls. She also collected data regarding sales from each customer. This data enables Laurel find the companys most profi defer and least profi panel customers. ... answers Answer 1 a.) Histograms and relative frequency distributions of the companys mundane average order sizing for quarters 1 and 2 In the simplest of terms, histogram can be defined as a series of contiguous bars or rectangles representing frequency of the data in given intervals (Black, 2009). Histogram is a very usable tool to analyze the frequencies of different class interval. The daily average order size of it can be calculated as dividing the total sales by total orders. The table below shows the frequency table for the organizations daily average order size for Q1 and Q2 Range Frequency Q1 Frequency Q2 220 0 0 Table 1 The fre quency distribution table for daily average order size for Q1 and Q2 As can be seen from the table, majority of the frequency is concentrated towards the middle. The frequencies for Q1 as well as Q2 are 0 for all the intervals till the average order size of 59. While there is no daily average order size above 220 for Q1, there is no daily average order size above 200 for Q2. The best way to analyze this frequency distribution table is to analyze the histogram. The represent below shows the histogram for the companys daily average order size for Q1 and Q2 Figure 1 Histogram of companys daily average order size for Q1 and Q2 As can be seen from the graph, the frequency for some(prenominal) the seasons can be thought of following a normal curve. For Q2, the highest frequency is in the range of 100-119, eyepatch for Q1, the highest frequency is in the range of 120-139. b.) Quarterly charts for the companys total number of orders per day The table below shows the frequency distributio n for the total number of orders