Analyzing Spreadsheets

Standard

To analyze the data we decided to group it by Customer Segment to begin. We used the total profits, order count and profit/order equations to see what the data could tell us through the Customer Segment. What we found was that the Corporate segment created the largest total profits with $599,746 and the lowest was the Consumer segment with $287,960. The largest order count to no surprise went to the Corporate segment again with 3076, but instead of the Consumer being the lowest order count, in this analysis portion the segment with the smallest order count was Small Business with 1642. Following the trend, the Corporate segment had the greatest profit/order with $195 and Home Office had the lowest profit/order with $157. Overall, Corporate segments were the most profitable and successful in the superstore sales.

Leave a Reply

Your email address will not be published. Required fields are marked *