Question: 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

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.

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

Step by Step Solution

3.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To solve this problem we will proceed through the following steps Step 1 Create a Frequency Table for MPG Classes First we need to decide the classes ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

609ab36e04cfb_30904.pdf

180 KBs PDF File

Word file Icon

609ab36e04cfb_30904.docx

120 KBs Word File

Students Have Also Explored These Related Mathematics Questions!