Construct a frequency histogram of the data set

Reference no: EM131672526

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

Reference no: EM131672526

Questions Cloud

Responsibilities to listen and communicate with physicians : All of the following were organizational responsibilities to listen and communicate with physicians

Provide two positive examples of cross-cultural influences : Provide two positive examples of cross-cultural influences to the people of your country. Why would they be considered positive?

Common to both process mapping and root cause analysis : Which of the following activities are common to both process mapping and root cause analysis?

What are most prominent elements to understanding two acts : What are the most prominent elements to understanding these two acts? How do they impact the employee and the organization?

Construct a frequency histogram of the data set : Using Excel, construct a frequency histogram of the data set. Use the guidelines in the class notes. What would be more appropriate measure of central tendency

Identify total costs of quality by category : Costs-of-quality analysis. Safe Travel produces car seats for children from newborn to 2 years old. Safe Travel's only problem with its car seats was stitching.

Explore the stanford prison experiment website : Explore the Stanford Prison Experiment Website. Next, identify at least two (2) ethical considerations involved in Milgram's experiment .

Discuss the reasonable accommodation concept : How can business, schools, and organizations determine what needs to be done to meet the reasonable accommodation concept?

Describe a time when you had a positive moment of truth : Describe a time when you had a positive moment of truth and a negative moment of truth as a guest. Describe how negative experience could have been improved.

User Account

All Pages