Learning Team Assignment Executive Management Presentation Resources

8.Learning Team Assignment: Executive Management PresentationResources: z-table, Week Five Learning Team assignment, University of Phoenix Material: Summer Historical Inventory Data, and University of Phoenix Material: Winter Historical Inventory DataCalculate 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 of your company in which you:oInclude a description of the current inventory system.oInclude the raw data used.oGenerate a frequency distribution of the data using Microsoft Excel.oGenerate a normal distribution of the data using Microsoft Excel.oCompare the mode, median, and mean of the data. oCompare the range with the standard deviation of the data.Include speaker notes in which you explain:oHow the frequency distribution might be used to better understand and improve the inventory systemoHow the normal distribution might be used to better understand and improve the inventory systemoWhich measure of central tendency most accurately depicts the inventory dataoWhich measure of dispersion most accurately depicts the inventory dataFormat your presentation consistent with APA guidelines.