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

Business Data Analysis - Essay Example Histogram for the First Quarter Average Order Size Figure 1.3. Histogram for the Second Quarter Average Order Size Table 1.2. Relative Frequency Distribution for the First Quarter Average Order Size Order Size Intervals Frequency Relative Frequency 0-20 0 0.00 20-40 0 0.00 40-60 0 0.00 60-80 0 0.00 80-100 2 0.03 100-120 8 0.13 120-140 17 0.27 140-160 19 0.31 160-180 10 0.16 180-200 4 0.06 200-220 1 0.02 220-240 1 0.02    62 1 Table 1.3. Relative Frequency Distribution for the Second Quarter Average Order Size Order Size Intervals Frequency Relative Frequency 0-20 0 0.00 20-40 0 0.00 40-60 0 0.00 60-80 0 0.00 80-100 1 0.02 100-120 10 0.16 120-140 24 0.38 140-160 19 0.30 160-180 5 0.08 180-200 3 0.05 200-220 2 0.03    64 1 (b) Construct similar quarterly charts for the company’s total number of orders per day. ... Relative Frequency Distribution for the Third Quarter Orders Q3 Order Intervals Frequency Relative Frequency 100-110 0 0.00 110-120 1 0.02 120-130 1 0.02 130-140 4 0.06 140-150 2 0.03 150-160 14 0.22 160-170 16 0.25 170-180 13 0.21 180-190 10 0.16 190-200 1 0.02 200-210 1 0.02    63 1 Table 1.5. Relative Frequency Distribution for the Fourth Quarter Orders Q4 Order Intervals Frequency Relative Frequency 100-110 0 0.00 110-120 0 0.00 120-130 2 0.03 130-140 2 0.03 140-150 5 0.08 150-160 10 0.16 160-170 15 0.23 170-180 9 0.14 180-190 8 0.13 190-200 8 0.13 200-210 3 0.05 210-220 1 0.02 220-230 0 0.00 230-240 0 0.00 240-250 1 0.02    64 1 Table 1.6. Relative Frequency Distribution for the First Quarter Orders Q1 Order Intervals Frequency Relative Frequency 100-110 0 0.00 110-120 1 0.02 120-130 1 0.02 130-140 1 0.02 140-150 3 0.05 150-160 3 0.05 160-170 9 0.15 170-180 12 0.19 180-190 14 0.23 190-200 7 0.11 200-210 4 0.06 210-220 5 0.08 220-230 1 0.02 230-240 1 0.02    62 1 Table 1.7. Relative Frequency Distribution for the Second Quarter Orders Q2 Order Intervals Frequency Relative Frequency 100-110 1 0.02 110-120 0 0.00 120-130 0 0.00 130-140 0 0.00 140-150 2 0.03 150-160 7 0.11 160-170 7 0.11 170-180 19 0.30 180-190 13 0.20 190-200 9 0.14 200-210 4 0.06 210-220 1 0.02 220-230 1 0.02    64 1 (c) What changing patterns are evident in the data from quarter to quarter? What are some possible explanations? The histograms and relative frequency distributions of the average order size for the first and second quarters are both uni-modal and negatively skewed. This indicates that data are concentrated to the right of the mean. This supports Laurel’s trending assumptions that â€Å"orders will be more frequent and for smaller amounts than before†. Meanwhile, the histograms