QRB501 QRB/501 Executive Management Presentation Week 6

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 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.