Quantitative Analysis Assignment
Quantitative Analysis Assignment.
Please use the attached fileSampleSalesData.xlsx and complete the following:
a. Please use the descriptive statistics tool to analyze with appropriate measures of central tendency and dispersion the fields “sales” and “profit” and “profit margin”.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Nowb. Please calculate out the following percentiles for the field “sales”: 10th, 25th, 50th, 75th, and 90th percentile.
c. Please use the Pivot Table tool to analyze “sales” by region. The analysis should include the number of sales by each region (count), the total amount of sales (sum) by each region, the average sales amount by each region, and the standard deviation of sales by each region.
Ensure it is done in excel and the document is ATTACHED, NOT SCREENSHOTTED.
Clearly label questions and answers
Quantitative Analysis Assignment