Download the SkyDio Drone Sales Journal dataset in Excel. Note the sales price and cost of each

Question:

Download the SkyDio Drone Sales Journal dataset in Excel. Note the sales price and cost of each sale. In Excel, calculate the gross margin percentage

(Sales Price–Cost)/Sales Price for each sale (or row in the sales journal). Use either the descriptive statistics tool featured in Excel’s Data Analysis ToolPak or Excel functions to compute the summary statistics and answer the following questions.

Required:

a. Create a histogram of the gross margin percentages. Submit this screenshot to your instructor if assigned.

b. How many transactions were for 47 percent or higher?

c. How many transactions were for 40 percent or lower?

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

Step by Step Answer:

Related Book For  book-img-for-question

Accounting Information Systems

ISBN: 9781266370373

4th Edition

Authors: Vernon Richardson, Chengyee Chang, Rod Smith

Question Posted: