Mba-504: 1-3 Descriptive Analysissouthern New Hampshire Univ

MBA-504: 1-3 Descriptive AnalysisSouthern New Hampshire University 09:27:09 GMT -05:00Module 1 Excel Superstore General ObservationsThis analysis will collect, analyze, interpret, and present data from the Superstore Excel Workbook. I will be calculating the mean, median, and mode from the sales, quantity, discount, and profit attributes. I will also be describing my initial observations on the data presented in the Superstore Excel Workbook.There are twenty-one columns of data describing sales, profits, dates, orders, locations, etc. between the years of 2015 and 2018. My first observation is a correlation between profit and discount. Generally, the higher the discount, the lower the profit. This can be said of many businesses who use discounts and coupons to not necessarily make a large profit from that discount, but to bring in more business that will give overall higher profits. Even with these discounts, the mode is 0%, meaning that most of the sales do not offer any discount at all while the mean (average) discount is 16%. This is an important indication when calculating total profits so that adjustments can be made to the number of discounts to ensure maximum profits.With 3,203, the west region has the highest number of sales. At only