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.
Step by Step Answer:
Managerial Statistics
ISBN: 9780534389314
1st Edition
Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe