QRB 501 Week 6 Learning Team Assignment Executive Management Presentation

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.