Administration consultant project

· Group 3 – FedEx

· Scenario: FedEx has reached out to your consulting group for assistance. FedEx would like to build a new location in Zzyzx, California. Data has been collected from a sample of shipments based on different regional centers surrounding Zzyzx.

· Q1: Look at the data and use descriptive statistics (mean, median, modes, graphs, tables, boxplots, etc.). Choose some of these and describe them to the company.

· Q2: Is there a difference in average profit between corporate (column: corporate) and non-corporate (column: noncorp) sales?

· Q3: Is there a correlation between the percent discount provided (column: discount) and the total sales (column: sales)?

· Q4: Does the Shipping Cost (column: shipcost) predict Sales (column: sales)?

· Q5: Is there any association between Ship Mode (column: shipmode) and Customer Segment (column: segment)?

· Tips: What graphs will you choose to show? Sometimes a table looks better than a graph, or the other way around! What recommendations will you make? “I don’t know” isn’t the answer the company or shareholders want to hear!