Question

3. Create a frequency table for classes of MPG, including frequency and relative frequency for the...

3. Create a frequency table for classes of MPG, including frequency and relative frequency for the cars in the sample.

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

Sample Car # Color MPG Suggest Retail Price Option Package Days in Inventory
1 Grey 27.6 $    24,390.00 LX 1
2 Grey 32.4 $    21,780.00 Touring 10
3 Blue 33.2 $    21,149.00 Touring 28
4 Black 34.7 $    22,069.00 LX 21
5 Blue 27.2 $    22,532.00 Touring 16
6 Blue 26.6 $    20,345.00 Touring 22
7 Red 37.3 $    22,112.00 EX 12
8 Silver 34.9 $    21,289.00 Touring 23
9 Silver 29.6 $    24,871.00 LX 15
10 Silver 32.3 $    25,389.00 EX 8
11 Grey 31.9 $    25,998.00 EX 28
12 Red 26.4 $    19,713.00 LX 55
13 Black 34.8 $    25,213.00 EX 2
14 Silver 35.9 $    24,467.00 Touring 33
15 Black 34.6 $    21,402.00 LX 17
16 Black 33.3 $    20,351.00 LX 14
17 Grey 33.1 $    23,732.00 Touring 1
18 Red 37.5 $    24,558.00 Touring 2
19 Red 27.8 $    19,167.00 LX 18
20 Red 36.1 $    19,903.00 Touring 22
21 Blue 28.8 $    22,140.00 Touring 19
22 Red 26.2 $    22,180.00 EX 41
23 Silver 27.4 $    23,120.00 Touring 33
24 Black 34.9 $    19,837.00 Touring 21
25 Red 36.5 $    24,666.00 EX 31
26 Red 26.3 $    19,446.00 EX 35
27 Blue 31.4 $    23,954.00 Touring 11
28 Blue 30.9 $    21,201.00 LX 3
29 Red 27.4 $    21,346.00 EX 26
30 Red 36 $    19,406.00 EX 31

Homework Answers

Answer #1

I have created frequency table for MPG including relative frequency. Here I have created class having width 2 MPG. And in that classes I have classified all the observations. In that table observation equal to upper class limit is excluded from the same class.

Sr.No Class Limits for MPG Frequency Relative Freqency
1 0-26 0 0
2 26-28 9 0.3
3 28-30 2 0.066666667
4 30-32 3 0.1
5 32-34 5 0.166666667
6 34-36 6 0.2
7 36-38 5 0.166666667
Total 30 1

To find the relative frequency, divide thefrequency by the total frequency.

b) Mean days for the inventory for the cars in sample is 19.966667.

Median is 20 and Mode is 1.

In this example you have to prefer value of mean which is a better representation of the  "typical" price of a car in inventory.

Thank you...

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Is there a significant difference in mean Highway MPG between expensive and cheap cars? I understand...
Is there a significant difference in mean Highway MPG between expensive and cheap cars? I understand that I must conduct a hypothesis test and confidence interval for two means. I have found the mean for cheap cars to be 33.6, the standard deviation 5.57; the mean for expensive cars 26.1, the standard deviation 2.14. Please use both the critical values method and p-value method to determine if there is a significant difference. Be mindful of outliers (cheap cars outlier=50, expensive...
Create two frequency tables based on two separate questions from your survey. Create a bar graph...
Create two frequency tables based on two separate questions from your survey. Create a bar graph and a pie chart based on the data in the frequency tables. Determine the class intervals and create frequency distribution for each of the frequency tables. Create one frequency polygon of the data from the frequency distribution. please data collected (time stamp with 3 multiple choice questions) Timestamp   If given the opportunity would you work from home?   Do you consider working from home more...
Use the data below for Questions 2.5-2. B. Transmission: 1 = automatic, and 2 = standard....
Use the data below for Questions 2.5-2. B. Transmission: 1 = automatic, and 2 = standard. Color: 1 = blue, 2 = tan, 3 = white, 4 = red, 5 = black, and 6 = green. Subject Car Color Miles Driven -Typical Week Transmission 1 1 51 1 2 1 10 2 3 2 10 2 4 3 24 2 5 4 78 1 6 5 68 2 7 3 50 1 8 2 15 1 9 3 3 1...
Using the pivot table that you just created, determine which of the color types sold the...
Using the pivot table that you just created, determine which of the color types sold the least amount of yards using =MIN() Using the pivot table that you just created, determine which of the color types sold the largest amount of yards using =MAX() If Saeko wants to expand the colors in both the best selling and the worst selling color type, which two color types should she buy? Least amount sold: 5194 Largest amount sold: 7229 What colors should...
The Student Government Association is interested in an estimate of the mean number of hours students...
The Student Government Association is interested in an estimate of the mean number of hours students work per week. They take a simple random sample of 89 students. The data they collected can be found in the column labeled “Number of hours worked per week”. Use the sample data to construct a 95% confidence interval for the mean number of hours worked. Write one or two sentences to communicate to the Student Government Association the estimate and the margin of...
Assignment Statement Use the skeleton file starter code (below) to create the following classes using inheritance:...
Assignment Statement Use the skeleton file starter code (below) to create the following classes using inheritance: ⦁   A base class called Pet ⦁   A mix-in class called Jumper ⦁   A Dog class and a Cat class that each inherit from Pet and jumper ⦁   Two classes that inherit from Dog: BigDog and SmallDog ⦁   One classes that inherit from Cat: HouseCat The general skeleton of the Pet, Dog, and BigDog classes will be given to you (see below, "Skeleton", but...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the new accounting period. All real accounts are closed but not the nominal accounts. All balance sheet accounts are closed. All temporary accounts are closed but not the permanent accounts. All permanent accounts are closed but not the nominal accounts. 4.A wholesaler is an intermediary that buys products from manufacturers or other wholesalers and sells them to consumers.Immersive Reader (1 Point) True False 5.The Merchandise...
BIOCHEMISTRY ASSIGNMENT Please use your understanding to address the few concerns below * Required Index Number:...
BIOCHEMISTRY ASSIGNMENT Please use your understanding to address the few concerns below * Required Index Number: * Your answer Program: Choose BSc Midwifery BSc Nursing 1.When starch and amylase are mixed in the presence of iodine solution, the blue-black colour rapidly disappears. This is due to the formation of which molecule? * a) glucose b) glycogen c) sucrose d) maltose 2.Which of the following enzyme groups can catalyse oxidation reactions? * a) phosphorylases b) isomerases c) hydrolases d) dehydrogenases 3.Enzymes...
1. A bat uses very high frequencies so: a. He will kill the insects he's hunting...
1. A bat uses very high frequencies so: a. He will kill the insects he's hunting b. We won't hear them c. The sound waves will be small compared to the insects d. The sound waves will be large compared to the insects e. He can tune in to KMET for the weather report 2. Bees see somewhat into the ultraviolet. This is because: a. They use radar b. They can see in the dark c. They evolved with a...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...