Question 2.11

The following table shows the results of a survey that asked users of the Internet to identify their favorite search engine. These data can be found in the Excel file search engine.xlsx. (For your information, Baidu is a Chinese-language search engine.) Google Google Yahoo Google Yahoo Google Other Yahoo Yahoo Bing Google Google Baidu Baidu Google Google Google Yahoo Google Google Bing Google Google Google Google Google Google Google Google Google a. Using Excel, construct a frequency distribution for these data. b. Using the results from part a, calculate the relative fre-quencies for each search engine. c. Construct a vertical bar chart for these data.

Question 2.23

Construct a stem and leaf display for the following data, which also can be found in the Excel file Prob 2-23 data .xlsx. 72 120 83 79 137 99 75 86 71 122 87 125 130 111 134 118 110 97 116 139 112 115 80 100 94 73 86 90 78 78 107 101 87 90 126 134 120 107 111

Question 2.36

The following data show the average monthly revenue a store earned per customer by selling six different types of cell phones:

Phone	Average Revenue Per Customer ($)
iPhone	95
Blackberry	85
LG	60
Samsung	55
Motorola	55
Prepaid	20

a. Construct a vertical bar chart for these data.

b. Construct a horizontal bar chart for these data.

Question 2.41

2.41 AutoBeef is a Web site to which customers post complaints about their cars. The following table lists the number of complaints and the type of complaints posted about used Ford Explorers: Complaint Frequency Transmission 721 Body 437 Wheels 164 Drivetrain 139 Windows 89 Engine 55 Interior 45 Electrical 44 Steering 42 Suspension 41 Air conditioner/heater 26 Brakes 22 Other 47 Based on: http://www.carcomplaints.com/Ford/Explorer/2002. Construct a Pareto chart for these data