Part 1: to be completed in excel® you manage the inventory for a car

Order now Get a quote

Home
Homework Essay Help
Part 1: to be completed in excel® you manage the inventory for a car

Part 1: to be completed in Excel®

You manage the inventory for a car dealership. Data on current inventory can be found in the Week 2 Data Set. Management would like you to assess current inventory on the dealership lot.

Using the Week 2 Data Set, create and calculate the following in Excel®:

Create a pie chart which summarizes colors of the cars in the sample.
Create a bar chart which summarizes the number of each of the models of cars in the sample.
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. Also, do the following:
- Compare the mean to the median and the mode.
- Highlight the value that would be a better representation of the “typical” price of a car in inventory.
Calculate the standard deviation of the Days in Inventory for the cars in the sample.
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.

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

Type of paper

Academic level

Pages 275 words

We`ll send you the first draft for approval by at

Price: $36

Formatting (MLA, APA, Chicago, custom, etc.)
Title page & bibliography
24/7 customer support
Amendments to your paper when they are needed
Chat with your writer

275 word/double-spaced page
12 point Arial/Times New Roman
Double, single, and custom spacing

We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

1
You give us the details

Complete a brief order form to tell us what kind of paper you need.
2
We find you a top writer

One of the best experts in your discipline starts working on your essay.
3
You get the paper done

Enjoy writing that meets your demands and high academic standards!

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

Swift delivery

Our writing service can deliver your short and urgent papers in just 4 hours!
Professional touch

We find you a pro writer who knows all the ins and outs of your subject.
Easy order placing/tracking

Create a new order and check on its progress at any time in your dashboard.
Help with any kind of paper

Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
Experts in 80+ subjects

Our pro writers can help you with anything, from nursing to business studies.
Calculations and code

We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ

Take your studies to the next level with our experienced specialists