Question - Richmond Ford, located at 4600 West Broad Street in Richmond, Virginia, is one of the oldest automobile Dealership in the country. A sample of 30 pre-owned vehicles was selected from a population of all preowned vehicles owned by Richmond Ford, and the mileage of each vehicle is recorded below.
|
16,354
|
12,682
|
31,818
|
55,284
|
70,971
|
5,225
|
|
20,859
|
36,934
|
62,495
|
15,761
|
68,414
|
42,695
|
|
74,910
|
45,899
|
34,067
|
65,794
|
10,884
|
57,994
|
|
13,833
|
40,293
|
12,046
|
26,677
|
36,997
|
63,280
|
|
49,303
|
22,190
|
26,286
|
14,076
|
19,984
|
94,208
|
a. Using Excel find the mean, median, mode, range, variance and standard deviation of the data. Attach your output from Excel.
b. Using Excel, construct a frequency histogram of the data set. Use the guidelines in the class notes. Start the first interval 0.5 below the minimum value in the data set. Provide all the details (interval, width, etc.) on how you constructed the histogram. Make sure that you attach the histogram created by Excel. Comment on the shape of the frequency distribution (e.g., is the distribution skewed? Is the distribution approximately mound-shaped and symmetric?) for the data set based on your histogram.
c. Based on the results in part a, construct the intervals and for the data set. Be sure to show your interval below. Based on the results in part b, what percentage of measurements for the data set do you expect to fall in each interval? What percentage of the measurements for the data set actually falls in each interval?
d. What would be the more appropriate measure of central tendency for these data, mean or median? Why?
e. Find an interval that is likely to contain the mileage of all preowned vehicles owned by Richmond Ford. Interpret your interval.
Attachment:- Assignment.rar