QNT 275 Week 2 Apply: Connect Week 2 Case | eBooks | Education

QNT 275 Week 2 Apply: Connect Week 2 Case

QNT 275 Week 2 Apply: Connect Week 2 Case PLDZ-7409
In Stock
$ 12.99 USD
UopTutorialStore
Buy and Download   > Description

QNT 275 Week 2 Apply: Connect Week 2 Case

https://plus.google.com/u/0/108200033792883877670/posts/dWT4sDYbQKM

 

QNT 275 Week 2 Apply: Connect Week 2 Case

 

Part 1

You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot.

Review the Week 2 Data Set.

Create and calculate the following in Excel®:

 

 

 

    1. Create a Pie Chart which summarizes colors of the cars in the sample.

 

 

    1. Create a Bar Chart which summarizes the frequency of the models of the cars in the sample.

 

 

    1. Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample.

       

       

       

       

        • Calculate the mean Days in Inventory for the cars in the sample.

       

       

        • Compare that to the median and the mode.

       

       

       

       

 

 

    1. Highlight the value that would be a better representation of the “typical” price of a car in inventory?

 

 

    1. Calculate the standard deviation of the Days in Inventory for the cars in the sample.

 

 

    1. Calculate the 5 number summary for the suggested retail prices of the cars in the sample. This consists of the 1st, 2nd, 3rd, 4th quartile and the IQR.

 

 

 

Note: Part 1 is not submitted. It is only to be completed in preparation for Part 2.

Part 2

Reference your Excel® spreadsheet from Part 1.

Complete the Week 2 Case in Connect.

Note: You have only 1 attempt available to complete assignments.

 

 

 

QNT 275 Week 2 Apply: Connect Week 2 Case https://plus.google.com/u/0/108200033792883877670/posts/dWT4sDYbQKM QNT 275 Week 2 Apply: Connect Week 2 Case Part 1 You manage the inventory for a car dealership. Your management would like you to
Recent Reviews Write a Review
0 0 0 0 reviews