Resources: Week Five Learning Team Assignment, University of Phoenix Material: Summer Historical Inventory Data, University of Phoenix Material: Winter Historical Inventory Data, and University of Phoenix Material: Z-table
Calculate the mode, median, and mean in Microsoft® Excel® using the data from your Week Five assignment.
Compute the standard deviation in Microsoft® Excel® using the data from your Week Five assignment.
Prepare a 10- to 12-slide presentation for the Executive Management Team Assignment of your company in which you:
· Include a description of the current inventory system.
· Include the raw data used.
· Generate a frequency distribution of the data using Microsoft® Excel®.
· Generate a normal distribution of the data using Microsoft® Excel®.
· Compare the mode, median, and mean of the data.
· Compare the range with the standard deviation of the data.
Include speaker notes in which you explain:
· How the frequency distribution might be used to better understand and improve the inventory system.
· How the normal distribution might be used to better understand and improve the inventory system.
· Which measure of central tendency most accurately depicts the inventory data?
· Which measure of dispersion most accurately depicts the inventory data?
Format your presentation consistent with APA guidelines.