MBA 504 Excel Workbook1-3 Excel Workbook: Descriptive Statistics and Charts Using ExcelSouthern New Hampshire UniversityMBA 504: Business StatisticsThis report briefly examines customer order data that has been collected by the superstore over the last few years. In this report, I will look at seve...
1-3 Excel Workbook: Descriptive Statistics and Charts Using Excel
Southern New Hampshire University
MBA 504: Business Statistics
This report briefly examines customer order data that has been collected by the superstore
over the last few years. In this report, I will look at several key attributes and how they relate
to the superstore's success. The data breaks the order down into type of order, category a and
category of the order, the location of where the order was generated, dollar amount, discount
amount & the profit made on each order. This data collection also included detailed
information about the customer. The main attributes that I want to focus on in this report are
sales, Quantity, discount, and profit. According to the data provided the average sale is
approximately $230, with a median sales number just above $54. The average unit per sale
was a little over 3.5 units. This is a good sign, a key to staying successful in business is
having returning customers and customers who buy more than one item at a time. Looking
through the customer information, customers are returning multiple orders. Profits range
anywhere from over $8,000 to a loss of over $6,500 with an average of $28.66. Profit
margins are directly reflective of the discounts that apply to each order. The more the
discount, the smaller the profit margin. Based on these initial observations from the data
provided, the superstore is doing well and should be in an advantageous position to grow its
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller newage. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
