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

Business Data Analysis - Essay ExampleThe diffusion of sales from each guest is polld to identify the most important customers. The call times for various calls are analyzed to identify the number of employees that need to be kept. Based on the analysis done, it is evident that company needs to analyze its performance with respect to quarter as well as profit center. The company needs to clear 5 employees making sales calls. At the same time, the company was able to identify the most profi control panel customers on whom it needs to focus on. Introduction medal McRae has recently joined Handy Hydraulics for selective information analysis and strategic planning. In ordering 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 in like manner collected the data regarding the machines and the days when they are working and various alternatives to regenera te the existing 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 profitable and least profitable customers. ... answers Answer 1 a.) Histograms and relative relative frequence distributions of the companys insouciant average order size for quarters 1 and 2 In the simplest of terms, histogram can be define as a series of contiguous bars or rectangles representing frequency of the data in given intervals (Black, 2009). Histogram is a very useful tool to analyze the frequencies of different class interval. The daily average order size 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 dodge 1 The frequency 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 graph 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 both the seasons can be thought of following a normal curve. For Q2, the highest frequency is in the range of 100-119, while 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 distribution for the to tal number of orders