Quantitative Analysis

Please use the file SampleSalesData.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.

Make sure to attach the excel document showing work, and all answers