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”.

b. 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

"Is this question part of your assignment? We can help"

ORDER NOW