Returning to the Fine Shirt Company, use the three tables contained in file P4_22.MDB to perform the

Question:

Returning to the Fine Shirt Company, use the three tables contained in file P4_22.MDB to perform the following: 

a. Find all of the records from the Orders table that correspond to orders placed in 1998 by the customer The Shirt on Your Back for shirts designed to be worn by both men and women. Return to Excel the fields OrderDate, Description, Gender, UnitsOrdered, UnitPrice, Discount, and a calculated field revenue. Note that revenue equals UnitsOrdered* UnitPrice*(1-Discount) 

b. Analyze the distribution of revenues associated with order records identified above. Be sure to consider measures of central location, variability, and skewness in characterizing this distribution. 

c. Repeat parts a and b with the same criteria except that the analysis should now focus on the orders placed in 1999. Summarize the differences between the revenue distributions for 1998 and 1999.

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

Step by Step Answer:

Related Book For  answer-question

Managerial Statistics

ISBN: 9780534389314

1st Edition

Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe

Question Posted: