Question

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 .

9. Answer will vary you can add more analysis.

Answer 1