4 points4 points Chapter 2 Answer all questions on a separate piece of paper. You must show ALL work, including Excel worksheets, to receive full credit. Use the following description to answer question 1. The PC laptop computer business has become quite competitive over the last seven years. Below is a listing of the market share for the major brand names who manufacture laptops for 2003. Dell 15% Emachines 6% Gateway 15% Hewlet Packard 20% IBM 10% Sharpe 4% Sony 18% Toshiba 12% 1. (A) Using Excel, create a pie chart to describe the data above. (B) Using Excel, create a bar graph to describe the data above. 2. Indicate whether the following variables are categorical (qualitative) or quantitative. a. Model of automobile b. Flavor of ice cream c. Religious denomination d. Test score out of 100 e. Miles per gallon of gasoline f. Top three television networks g. Length of birth contraction in seconds GO TO NEXT PAGE ÆUse the following description to answer questions 3 and 7. It used to be that American cars were built larger, heavier and with bigger motors compared to cars built by Japanese car maker. Consequently, Japanese cars typically got better gas mileage compared to American cars. To find out if this trend has continued, a consumer advocate researcher randomly selected a group of 2002 model American cars and a group of 2002 model Japanese cars and measured the miles per gallon for each car. The data collected are presented below: American cars: 23 28 18 22 23 16 32 25 22 23 13 15 15 18 Japanese cars: 21 38 17 28 21 33 28 30 22 28 21 18 20 22 3. Answer the data above to answer the questions above: a. What is the purpose of collecting the data above? b. Identify the type of measurement (N.O.I.R.) of the dependent variable reported above. c. Using Excel, create two histograms: One from the data from American car makers, and one from the data from the Japanese car makers. d. Describe the shape of the distribution (i.e., skewness) for each car maker. e. Based on the histograms you created, which car maker has the larger mean? f. Based on the histograms you created, which car maker has the larger spread or standard deviation? g. Which car maker has the largest outlier? 4. Using Excel, answer the following questions using the car data from the previous page: a. What is the modal (mode) miles per gallon for each car maker? b. Provide an interpretation for your answer in part A. c. What effect would adding a single outlier to the data collected for each car maker have on the mode for each group? d. What is the median miles per gallon for each car maker? e. Provide an interpretation for your answer in part D. f. What effect would adding a single outlier to the data collected for each car maker have on the median for each group? g. What is the mean miles per gallon for each car maker? h. Provide an interpretation for your answer in part G. i. What effect would adding a single outlier to the data collected for each car maker have on the mean for each group? j. Which of the three measures of central tendency do you feel best summarizes the data collected? Explain your answer and explain why you didn’t choose the other two measures. 5. Using Excel, answer the following questions using the car data from the previous page: a. What is the range for each car maker? b. What effect would adding a car that got 8 miles per gallon have on the range for each group? c. What is the sample standard deviation for each car maker? d. Provide an interpretation for your answer in part C. e. What effect would adding a car that got 58 miles per gallon have on the sample standard deviation for each car maker? 6. What is the five number summary for each car