DJI Mavic is attempting to understand its sales and cost structure to allocate appropriate personnel to its

Question:

DJI Mavic is attempting to understand its sales and cost structure to allocate appropriate personnel to its sales force. Download the DJI Mavic Drone Sales Journal data set in Excel. Note the sales price and cost of each sale. Either use the descriptive statistics tool featured in Excel’s Analysis ToolPak or Excel functions to compute the summary statistics and answer the following questions.

a. What is the average sales price for all items sold?

b. What is the standard deviation of the sales price for all items sold?

c. What is the range of costs for all items sold?

d. What is the lowest cost for all items sold?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Business Analytics

ISBN: 9781265454340

1st Edition

Authors: Vernon Richardson, Marcia Watson

Question Posted: