Question

In: Statistics and Probability

Rob Whitner is the owner of Whitner Autoplex. Rob’s father founded the dealership in 1964, and for more than 30 years, they sold exclusively Pontiacs.


 
Case Study (Due: March 28 2019 – Hard copy) – Maximum 3 student in a group.  
Rob Whitner is the owner of Whitner Autoplex. Rob’s father founded the dealership in 1964, and for more than 30 years, they sold exclusively Pontiacs. In the early 1990s, Rob’s father’s health began to fail, and Rob took over more of the day-to-day operation of the dealership. At this same time, the automobile business began to change-dealers began to sell vehicles from several manufacturers-and Rob was faced with some major decisions. The first came when another local dealer, who handles Volvos, Saabs, and Volkswagens, approached Rob about purchasing his dealership. More recently, the local Chrysler dealership got into difficulty and Rob bought them out. So, now, on the same lot, Rob sells the complete line of Pontiacs, the expensive Volvos, Saabs, Volkswagens, and the Chrysler products, including the popular Jeep line. Whitner Pontiac employs 83, including 23 full-time sales people. Because of the diverse product line, there is considerable variation in the selling price of the vehicles. A top-of-the-line Volvo sells for more than twice the price of a Pontiac Grand Am. Rob would like you to develop some tables and charts that he could review monthly and would like you to report where the selling prices tend to cluster, where the variation is in the selling prices, and to note any trends.
(Reference: Chapter 2 and 3 of the text book. Note: The data set is attached, see instruction in the bottom).
WHITNER AUTOPLEX DATA
Price($000)
Buyer’s Age
23.197
46
23.372
48
20.454
40
23.591
40
26.651
46
27.453
37
17.266
32
18.021
29
28.683
38
30.872
43
19.587
32
23.169
47
35.851
56
19.251
42
20.047
28
24.285
56
24.324
50
24.609
31
28.67
51
15.546
26
15.935
25
19.873
45
25.251
56
25.277
47
28.034
38
24.533
51
27.443
39
19.889
44
20.004
46
17.357
28
20.155
33
19.688
35
23.657
35
26.613
42
20.895
35
20.203
36
23.765
48
25.783
53
26.661
46
32.277
55
20.642
39
21.981
43
24.052
56
25.799
44
15.794
30
18.263
39
35.925
53
17.399
29
17.968
30
20.356
44
21.442
41
21.722
41
19.331
35
22.817
51
19.766
44
20.633
51
20.962
49
22.845
41
26.285
44
27.896
37
29.076
42
32.492
51
18.89
31
21.74
39
22.374
53
24.571
55
25.449
40
28.337
46
20.642
35
23.613
47
24.22
58
30.655
51
22.442
41
17.891
33
20.818
46
26.237
47
20.445
34
21.556
43
21.639
37
24.296
47
Instructions:
1. Must be typed and use excel where necessary.
2. Create two frequency distribution table. One for price and another for age. Both table should include lower limit upper limit, midpoint, width, frequency, relative frequency and cumulative frequency.
3. Draw histogram and frequency polygon using excel for both price and age.
4. Write a short note about your findings (maximum half page)
5. Create two descriptive statistics table one for price and another for age using excel (Descriptive statistics should include mean, variance, standard deviation, 1st quartile, median, 3rd quartile, mode etc)
6. Create two Box plot one for price and another for age.
7. Write another short note about your findings (maximum half page)
8. For excel command check chapter 2 and 3.
9. Answer will vary you can add more analysis.

Solutions

Expert Solution


Related Solutions

Rob Whitner is the owner of Whitner Autoplex. Rob’s father founded the dealership in 1964, and for more than 30 years, they sold exclusively Pontiacs
  Case Study (Due: March 28 2019 – Hard copy) – Maximum 3 student in a group. Worth: 10% Rob Whitner is the owner of Whitner Autoplex. Rob’s father founded the dealership in 1964, and for more than 30 years, they sold exclusively Pontiacs. In the early 1990s, Rob’s father’s health began to fail, and Rob took over more of the day-to-day operation of the dealership. At this same time, the automobile business began to change-dealers began to sell vehicles...
11. A sample of 30 used cars sold by an auto dealership in 2009 revealed that...
11. A sample of 30 used cars sold by an auto dealership in 2009 revealed that the correlation between selling price and number of kilometres driven was −0.45. We want to test, at the 1% significance level, if there is a negative linear relationship in the population between selling price and number of kilometres driven. According to the p-value given in the table, our conclusion would be to reject the null hypothesis and conclude that the sample evidence supports the...
More wealth was created in the last 30 years than at any time in Canadian history,...
More wealth was created in the last 30 years than at any time in Canadian history, yet there were significant increases in poverty and food bank use during the same period. How might a structural functionalist explain this trend? How might a conflict theorist explain this trend? Which explanation do you find most compelling? 350 words, please!
Blake, who is married and the father of two, is 30 years old and expects to...
Blake, who is married and the father of two, is 30 years old and expects to continue to work until the age of 65. He earns $85,000 per year and expects annual salary increases of 2% over his working life. He also expects inflation to be 3% during that time. His personal risk-free discount rate is 6%, his consumption is 20%, and his marginal tax rate is 28%. Determine Blake's human life value.
Top Quality Food Ltd. (TQF) is a medium-sized private food-processing company founded more than twenty years...
Top Quality Food Ltd. (TQF) is a medium-sized private food-processing company founded more than twenty years ago by Ray Smith. TQF is located in Newmarket and mainly provides frozen chicken, pork, and beef products to grocery stores and restaurants in the greater Toronto area and its surroundings. Ray is the CEO and sole common shareholder of the company. In recent decades, consumers pursue healthy lifestyle and tend to eat less meat but more fruits and vegetables. In noticing this market...
Founded in 1846, Hood is a Charlestown company with more than $2 billion in annual sales....
Founded in 1846, Hood is a Charlestown company with more than $2 billion in annual sales. The company has 15 plants and uses filling machines for its gallon milk containers. There is some variation in the actual amount of milk that goes into the container. The machine can go out of adjustment and put a mean amount either less or more than one-gallon containers. To monitor the filling process, the production manager for the Sacramento plant selects a simple random...
Oceanside County has operated a municipal swimming pool and aquatic center for more than 30 years....
Oceanside County has operated a municipal swimming pool and aquatic center for more than 30 years. Local patrons, as well as tourists, enjoy reasonable rates for swimming lessons, swimming meets, and general swimming. Ten years ago, the aquatic center was quite profitable, so the county created an Enterprise Fund and moved accounting for the swimming operations from the General Fund to the new Enterprise Fund. Over the years, however, interest in swimming has declined and the aquatic center usage has...
At 64, Dr. Shaefer has been an internist for more than 30 years. He entered practice...
At 64, Dr. Shaefer has been an internist for more than 30 years. He entered practice at the end of what has since been termed the "golden age" of medicine, before DRGs and managed care, when physicians made treatment decisions and carried them through unchallenged by third parties. After completing his residency, he joined a small group practice in the same city. The group practice has since grown to more than 20 physicians. Along the way, Dr. Shaefer was able...
Is there evidence that the mean annual salary of a Tesla owner is more than $253500?...
Is there evidence that the mean annual salary of a Tesla owner is more than $253500? Data was collected from 36 Tesla owners across the US. The mean annual salary of those 36 Tesla owners was $254000 with a standard deviation of $1057.  Answer this question,  at the 1% significance level, by performing the following steps of a hypothesis test . a) Complete the null and alternative hypotheses by typing into the box as indicated. Ho : mu   (Type one:  <, =, >)...
Express Auto, an automobile mega- dealership with more than 600 employees that represents 22 brands has...
Express Auto, an automobile mega- dealership with more than 600 employees that represents 22 brands has received a very discouraging set of survey results. Customer satisfaction scores have fallen for the ninth straight quarter. Customer complaints include: It was hard to get prompt feedback from mechanics by phone. Salespeople often did not return phone calls. The finance people seemed “pushy”. New cars were often not properly cleaned or had minor items that needed immediate repair or adjustment. Cars often had...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT