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.

Expert Solution

orchestra answered 2 years ago

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