Solutions Essentials of Modern Business Statistics with Microsoft Office Excel - 7th Edition - Chapter2

2.1 The response to a question has three alternatives: A, B, and C. A sample of 120 responses provides 60 A, 24 B, and 36 C. Show the frequency and relative frequency distributions.
Get solution

2.2 A partial relative frequency distribution is given....
a. What is the relative frequency of class D?
b. The total sample size is 200. What is the frequency of class D?
c. Show the frequency distribution.
d. Show the percent frequency distribution.

Get solution

2.3 A questionnaire provides 58 Yes, 42 No, and 20 No-Opinion answers.
a. In the construction of a pie chart, how many degrees would be in the section of the pie showing the Yes answers?
b. How many degrees would be in the section of the pie showing the No answers?
c. Construct a pie chart.
d. Construct a bar chart.

Get solution

2.4 For the 2010–2011 viewing season, the top five syndicated programs were Wheel of Fortune (WoF), Two and Half Men (THM), Jeopardy (Jep), Judge Judy (JJ), and the Oprah Winfrey Show (OWS) (Nielsen Media Research website, April 16, 2012). Data indicating the preferred shows for a sample of 50 viewers follow....
a. Are these data categorical or quantitative?
b. Provide frequency and percent frequency distributions.
c. Construct a bar chart and a pie chart.
d. On the basis of the sample, which television show has the largest viewing audience? Which one is second?

Get solution

2.5 In alphabetical order, the six most common last names in the United States are Brown, Johnson, Jones, Miller, Smith, and Williams (The World Almanac, 2012). Assume that a sample of 50 individuals with one of these last names provided the following data....Summarize the data by constructing the following:
a. Relative and percent frequency distributions
b. A bar chart
c. A pie chart
d. Based on these data, what are the three most common last names?

Get solution

2.6 Nielsen Media Research provided the list of the 25 top-rated single shows in television history (The World Almanac, 2012). The following data show the television network that produced each of these 25 top-rated shows....
a. Construct a frequency distribution, percent frequency distribution, and bar chart for the data.
b. Which network or networks have done the best in terms of presenting top-rated television shows? Compare the performance of ABC, CBS, and NBC.

Get solution

2.7 The Canmark Research Center Airport Customer Satisfaction Survey uses an online questionnaire to provide airlines and airports with customer satisfaction ratings for all aspects of the customers’ flight experience (airportsurvey website, July, 2012). After completing a flight, customers receive an e-mail asking them to go to the website and rate a variety of factors, including the reservation process, the check-in process, luggage policy, cleanliness of gate area, service by flight attendants, food/beverage selection, on-time arrival, and so on. A five-point scale, with Excellent (E), Very Good (V), Good (G), Fair (F), and Poor (P), is used to record customer ratings. Assume that passengers on a Delta Airlines flight from Myrtle Beach, South Carolina, to Atlanta, Georgia, provided the following ratings for the question, “Please rate the airline based on your overall experience with this flight.” The sample ratings are shown below....
a. Use a percent frequency distribution and a bar chart to summarize these data. What do these summaries indicate about the overall customer satisfaction with the Delta flight?
b. The online survey questionnaire enabled respondents to explain any aspect of the flight that failed to meet expectations. Would this be helpful information to a manager looking for ways to improve the overall customer satisfaction on Delta flights? Explain.

Get solution

2.8 Data for a sample of 55 members of the Baseball Hall of Fame in Cooperstown, New York, are shown here. Each observation indicates the primary position played by the Hall of Famers: pitcher (P), catcher (H), 1st base (1), 2nd base (2), 3rd base (3), shortstop (S), left field (L), center field (C), and right field (R)....
a. Construct frequency and relative frequency distributions to summarize the data.
b. What position provides the most Hall of Famers?
c. What position provides the fewest Hall of Famers?
d. What outfield position (L, C, or R) provides the most Hall of Famers?
e. Compare infielders (1, 2, 3, and S) to outfielders (L, C, and R).

Get solution

2.9
Get solution

2.10 VirtualTourist provides ratings for hotels throughout the world. Ratings provided by 649 guests at the Sheraton Anaheim Hotel, located near the Disneyland Resort in Anaheim, California, can be found in the WEBfile named HotelRatings (VirtualTourist website, February 25, 2013). Possible responses were Excellent, Very Good, Average, Poor, and Terrible.
a. Construct a frequency distribution.
b Construct a percent frequency distribution.
c Construct a bar chart for the percent frequency distribution.
d Comment on how guests rate their stay at the Sheraton Anaheim Hotel.
e Results for 1679 guests who stayed at Disney’s Grand Californian provided the following frequency distribution.
...Compare the ratings for Disney’s Grand Californian with the results obtained for the Sheraton Anaheim Hotel.
Get solution

2.11 Consider the following data....
a. Develop a frequency distribution using classes of 12–14, 15–17, 18–20, 21–23, and 24–26.
b. Develop a relative frequency distribution and a percent frequency distribution using the classes in part (a).

Get solution

2.12 Consider the following frequency distribution....Construct a cumulative frequency distribution and a cumulative relative frequency distribution.
Get solution

2.13 Construct a histogram for the data in exercise 12.
Get solution

2.14 Consider the following data....
a. Construct a dot plot.
b. Construct a frequency distribution.
c. Construct a percent frequency distribution.

Get solution

2.15 Construct a stem-and-leaf display for the following data....
Get solution

2.16 Construct a stem-and-leaf display for the following data. Use a leaf unit of 10....
Get solution

2.17 A doctor’s office staff studied the waiting times for patients who arrive at the office with a request for emergency service. The following data with waiting times in minutes were collected over a one-month period....Use classes of 0–4, 5–9, and so on in the following:
a. Show the frequency distribution.
b. Show the relative frequency distribution.
c. Show the cumulative frequency distribution.
d. Show the cumulative relative frequency distribution.
e. What proportion of patients needing emergency service wait 9 minutes or less?

Get solution

2.18 CBSSports.com developed the Total Player Ratings system to rate players in the National Basketball Association (NBA) based upon various offensive and defensive statistics. The following data show the average number of points scored per game (PPG) for 50 players with the highest ratings for a portion of the 2012–2013 NBA season (CBSSports.com website, February 25, 2013)....Use classes starting at 10 and ending at 30 in increments of 2 for PPG in the following.
a. Show the frequency distribution.
b. Show the relative frequency distribution.
c. Show the cumulative percent frequency distribution.
d. Develop a histogram for the average number of points scored per game.
e. Do the data appear to be skewed? Explain.

f. What percentage of the players averaged at least 20 points per game?

Get solution

2.19 Based on the tons handled in a year, the ports listed below are the 25 busiest ports in the United States (The 2013 World Almanac)....
a. What is the largest number of tons handled? What is the smallest number of tons handled?
b. Using a class width of 25, develop a frequency distribution of the data starting with 25–49.9, 50–74.9, 75–99.9, and so on.
c. Prepare a histogram. Interpret the histogram.

Get solution

2.20 The London School of Economics and the Harvard Business School conducted a study of how chief executive officers (CEOs) spend their day. The study found that CEOs spend on average about 18 hours per week in meetings, not including conference calls, business meals, and public events (The Wall Street Journal, February 14, 2012). Shown below is the time spent per week in meetings (hours) for a sample of 25 CEOs....
a. What is the least amount of time spent per week on meetings? The highest?
b. Use a class width of two hours to prepare a frequency distribution and a percent frequency distribution for the data.
c. Prepare a histogram and comment on the shape of the distribution.

Get solution

2.21
Get solution

2.22 Entrepreneur magazine ranks franchises using performance measures such as growth rate, number of locations, startup costs, and financial stability. The number of locations for the top 20 U.S. franchises follow (The World Almanac, 2012)....Use classes 0–4999, 5000–9999, 10,000–14,999, and so forth to answer the following questions.
a. Construct a frequency distribution and a percent frequency distribution of the number of U.S. locations for these top-ranked franchises.
b. Construct a histogram of these data.
c. Comment on the shape of the distribution.

Get solution

2.23 The following data show the year to date percent change (YTD % Change) for 30 stockmarket indexes from around the word (The Wall Street Journal, August 26, 2013)....
a. What index has the largest positive YTD % Change?
b. Using a class width of 5 beginning with – 20 and going to 40, develop a frequency distribution for the data.
c. Prepare a histogram. Interpret the histogram, including a discussion of the general shape of the histogram.
d. Use The Wall Street Journal or another media source to find the current percent changes for these stock market indexes in the current year. What index has had the largest percent increase? What index has had the smallest percent decrease? Prepare a summary of the data.

Get solution

2.24
Get solution

2.25 Each year America.EdU ranks the best paying college degrees in America. The following data show the median starting salary, the mid-career salary, and the percentage increase from starting salary to mid-career salary for the 20 college degrees with the highest midcareer salary (America.EdU website, August 29, 2013).......
a. Using a class width of 10, construct a histogram for the percentage increase in the starting salary.
b. Comment on the shape of the distribution.
c. Develop a stem-and-leaf display for the percentage increase in the starting salary.
d. What are the primary advantages of the stem-and-leaf display as compared to the histogram?

Get solution

2.26 The 2011 Cincinnati Flying Pig Half-Marathon (13.1 miles) had 10,897 finishers (Cincinnati Flying Pig Marathon website). The following data show the ages for a sample of 40 half-marathoners....
a. Construct a stretched stem-and-leaf display.
b. What age group had the largest number of runners?
c. What age occurred most frequently?

Get solution

2.27 The following data are for 30 observations involving two categorical variables, x and y. The categories for x are A, B, and C; the categories for y are 1 and 2....
a. Develop a crosstabulation for the data, with x as the row variable and y as the column variable.
b. Compute the row percentages.
c. Compute the column percentages.
d. What is the relationship, if any, between x and y?

Get solution

2.28 The following observations are for two quantitative variables, x and y....
a. Develop a crosstabulation for the data, with x as the row variable and y as the column variable. For x use classes of 10–29, 30–49, and so on; for y use classes of 40–59, 60–79, and so on.
b. Compute the row percentages.
c. Compute the column percentages.
d. what is the relationship, if any, between x and y?

Get solution

2.29 The Daytona 500 is a 500-mile automobile race held annually at the Daytona International Speedway in Daytona Beach, Florida. The following crosstabulation shows the automobile make by average speed of the 25 winners from 1988 to 2012 (The 2013 World Almanac)....
a. Compute the row percentages.
b. What percentage of winners driving a Chevrolet won with an average speed of at least 150 miles per hour?
c. Compute the column percentages.
d. What percentage of winning average speeds 160–169.9 miles per hour were Chevrolets?

Get solution

2.30 The following crosstabulation shows the average speed of the 25 winners by year of the Daytona 500 automobile race (The 2013 World Almanac)....
a. Calculate the row percentages.
b. What is the apparent relationship between average winning speed and year? What might be the cause of this apparent relationship?

Get solution

2.31 Recently, management at Oak Tree Golf Course received a few complaints about the condition of the greens. Several players complained that the greens are too fast. Rather than react to the comments of just a few, the Golf Association conducted a survey of 100 male and 100 female golfers. The survey results are summarized here....
a. Combine these two crosstabulations into one with Male and Female as the row labels and Too Fast and Fine as the column labels. Which group shows the highest percentage saying that the greens are too fast?
b. Refer to the initial crosstabulations. For those players with low handicaps (better players), which group (male or female) shows the highest percentage saying the greens are too fast?
c. Refer to the initial crosstabulations. For those players with higher handicaps, which group (male or female) shows the highest percentage saying the greens are too fast?
d. What conclusions can you draw about the preferences of men and women concerning the speed of the greens? Are the conclusions you draw from part (a) as compared with parts (b) and (c) consistent? Explain any apparent inconsistencies.

Get solution

2.32 The following crosstabulation shows the number of households (1000s) in each of the four regions of the United States and the number of households at each income level (U.S. Census Bureau website, August 2013)....
a. Compute the row percentages and identify the percent frequency distributions of income for households in each region.
b. What percentage of households in the West region have an income level of $50,000 or more? What percentage of households in the South region have an income level of $50,000 or more?
c. Construct percent frequency histograms for each region of households. Do any relationships between regions and income level appear to be evident in your findings?
d. Compute the column percentages. What information do the column percentages provide?
e. What percent of households with a household income of $100,000 and over are from the South region? What percentage of households from the South region have a household income of $100,000 and over? Why are these two percentages different?

Get solution

2.33 Each year Forbes ranks the world’s most valuable brands. A portion of the data for 82 of the brands in the 2013 Forbes list is shown in Table 2.12 (Forbes website, February 4, 2014). The data set includes the following variables: Brand: The name of the brand. Industry: The type of industry associated with the brand, labeled Automotive & Luxury, Consumer Packaged Goods, Financial Services, Other, Technology.  Brand Value ($ billions): A measure of the brand’s value in billions of dollars developed by Forbes based on a variety of financial information about the brand. 1-Yr Value Change (%): The percentage change in the value of the brand over the previous year. Brand Revenue ($ billions): The total revenue in billions of dollars for the brand.
a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for Brand Value ($ billions).
b. Prepare a frequency distribution for the data on Industry.
c. Prepare a frequency distribution for the data on Brand Value ($ billions).TABLE 2.12 DATA FOR 82 OF THE MOST VALUABLE BRANDS...
d. How has the crosstabulation helped in preparing the frequency distributions in parts (b) and (c)?
e. What conclusions can you draw about the type of industry and the brand value?

Get solution

2.34 Refer to Table 2.12.
a. Prepare a crosstabulation of the data on Industry (rows) and Brand Revenue ($ billions). Use class intervals of 25 starting at 0 for Brand Revenue ($ billions).
b. Prepare a frequency distribution for the data on Brand Revenue ($ billions).
c. What conclusions can you draw about the type of industry and the brand revenue?
d. Prepare a crosstabulation of the data on Industry (rows) and the 1-Yr Value Change (%). Use class intervals of 20 starting at –60 for 1-Yr Value Change (%).
e. Prepare a frequency distribution for the data on 1-Yr Value Change (%).

f. what conclusions can you draw about the type of industry and the 1-year change in value?

Get solution

2.35 The U.S. Department of Energy’s Fuel Economy Guide provides fuel efficiency data for cars and trucks (Fuel Economy website, September 8, 2012). A portion of the data for 149 compact, midsize, and large cars is shown in Table 2.13. The data set contains the following variables:Size: Compact, Midsize, and LargeDisplacement: Engine size in litersCylinders: Number of cylinders in the engineDrive: All wheel (A), front wheel (F), and rear wheel (R)Fuel Type: Premium (P) or regular (R) fuelCity MPG: Fuel efficiency rating for city driving in terms of miles per gallonHwy MPG: Fuel efficiency rating for highway driving in terms of miles per gallonThe complete data set is contained in the file named FuelData2012.
a. Prepare a crosstabulation of the data on Size (rows) and Hwy MPG (columns). Use classes of 15–19, 20–24, 25–29, 30–34, 35–39, and 40–44 for Hwy MPG.
b. Comment on the relationship beween Size and Hwy MPG.
c. Prepare a crosstabulation of the data on Drive (rows) and City MPG (columns). Use classes of 10–14, 15–19, 20–24, 25–29, 30–34, and 35–39, and 40–44 for City MPG.
d. Comment on the relationship between Drive and City MPG.
e. Prepare a crosstabulation of the data on Fuel Type (rows) and City MPG (columns). Use classes of 10–14, 15–19, 20–24, 25–29, 30–34, 35–39, and 40–44 for City MPG.

f. Comment on the relationship between Fuel Type and City MPG.
TABLE 2.13 FUEL EFFICIENCY DATA...
Get solution

2.36 The following 20 observations are for two quantitative variables, x and y....
a. Develop a scatter diagram for the relationship between x and y.
b. What is the relationship, if any, between x and y?

Get solution

2.37 Consider the following data on two categorical variables. The first variable, x, can take on values A, B, C, or D. The second variable, y, can take on values I or II. The following table gives the frequency with which each combination occurs....
a. Construct a side-by-side bar chart with x on the horizontal axis.
b. Comment on the relationship between x and y.

Get solution

2.38 The following crosstabulation summarizes the data for two categorical variables, x and y. The variable x can take on values Low, Medium, or High and the variable y can take on values Yes or No....
a. Compute the row percentages.
b. Construct a stacked percent frequency bar chart with x on the horizontal axis.

Get solution

2.39 A study on driving speed (miles per hour) and fuel efficiency (miles per gallon) for midsize automobiles resulted in the following data:...
a. Construct a scatter diagram with driving speed on the horizontal axis and fuel efficiency on the vertical axis.
b. Comment on any apparent relationship between these two variables.

Get solution

2.40 The Current Results website lists the average annual high and low temperatures (degrees Fahrenheit) and average annual snowfall (inches) for 51 major U.S. cities, based on data from 1981 to 2010. The data are contained in the WEBfile named Snow. For example, the average low temperature for Columbus, Ohio, is 44 degrees and the average annual snowfall is 27.5 inches.
a. Construct a scatter diagram with the average annual low temperature on the horizontal axis and the average annual snowfall on the vertical axis.
b. Does there appear to be any relationship between these two variables?
c. Based on the scatter diagram, comment on any data points that seem to be unusual.

Get solution

2.41 People often wait until middle age to worry about having a healthy heart. However, recent studies have shown that earlier monitoring of risk factors such as blood pressure can be very beneficial (The Wall Street Journal, January 10, 2012). Having higher than normal blood pressure, a condition known as hypertension, is a major risk factor for heart disease. Suppose a large sample of individuals of various ages and gender was selected and that each individual’s blood pressure was measured to determine if they have hypertension. For the sample data, the following table shows the percentage of individuals with hypertension....
a. Develop a side-by-side bar chart with age on the horizontal axis, the percentage of individuals with hypertension on the vertical axis, and side-by-side bars based on gender.
b. What does the display you developed in part (a), indicate about hypertension and age?
c. Comment on differences by gender.

Get solution

2.42 Smartphones are advanced mobile phones with Internet, photo, music, and video capability (The Pew Research Center, Internet & American Life Project, 2011). The following survey results show smartphone ownership by age....
a. Construct a stacked bar chart to display the above survey data on type of mobile phone ownership. Use age category as the variable on the horizontal axis.
b. Comment on the relationship between age and smartphone ownership.
c. How would you expect the results of this survey to be different if conducted in 2021?

Get solution

2.43 The Northwest regional manager of an outdoor equipment retailer conducted a study to determine how managers at three store locations are using their time. A summary of the results is shown in the following table....
a. Create a stacked bar chart with store location on the horizontal axis and percentage of time spent on each task on the vertical axis.
b. Create a side-by-side bar chart with store location on the horizontal axis and side-by-side bars of the percentage of time spent on each task.
c. Which type of bar chart (stacked or side-by-side) do you prefer for these data? Why?

Get solution

2.44 Approximately 1.5 million high school students take the SAT each year and nearly 80% of the college and universities without open admissions policies use SAT scores in making admission decisions (College Board, March 2009). The current version of the SAT includes three parts: reading comprehension, mathematics, and writing. A perfect combined score for all three parts is 2400. A sample of SAT scores for the combined three-part SAT is as follows....
a. Show a frequency distribution and histogram. Begin with the first class starting at 800 and use a class width of 200.
b. Comment on the shape of the distribution.
c. What other observations can be made about the SAT scores based on the tabular and graphical summaries?

Get solution

2.45
Get solution

2.46 Data showing the population by state in millions of people follow (The World Almanac, 2012)....
a. Develop a frequency distribution, a percent frequency distribution, and a histogram. Use a class width of 2.5 million.
b. Does there appear to be any skewness in the distribution? Explain.
c. What observations can you make about the population of the 50 states?

Get solution

2.47 A startup company’s ability to gain funding is a key to success. The funds raised (in millions of dollars) by 50 startup companies follow (The Wall Street Journal, March 10, 2011)....
a. Construct a stem-and-leaf display.
b. Comment on the display.

Get solution

2.48 Consumer complaints are frequently reported to the Better Business Bureau. In 2011, the industries with the most complaints to the Better Business Bureau were banks; cable and satellite television companies; collection agencies; cellular phone providers; and new car dealerships (USA Today, April 16, 2012). The results for a sample of 200 complaints are contained in the WEBfile named BBB.
a. Show the frequency and percent frequency of complaints by industry.
b. Construct a bar chart of the percent frequency distribution.
c. Which industry had the highest number of complaints?
d. Comment on the percentage frequency distribution for complaints.

Get solution

2.49
Get solution

2.50 The U.S. Census Bureau serves as the leading source of quantitative data about the nation’s people and economy. The following crosstabulation shows the number of households (1000s) and the household income by the level of education for heads of household having received a high school degree or more education (U.S. Census Bureau website, 2013)....
a. Construct a percent frequency distribution for the level of education variable. What percentage of heads of households have a master’s or doctoral degree?
b. Construct a percent frequency distribution for the household income variable. What percentage of households have an income of $50,000 or more?
c. Convert the entries in the crosstabulation into column percentages. Compare the level of education of households with a household income of under $25,000 to the level of education of households with a household income of $100,000 or more. Comment on any other items of interest when reviewing the crosstabulation showing column percentages.

Get solution

2.51 Western University has only one women’s softball scholarship remaining for the coming year. The final two players that Western is considering are Allison Fealey and Emily Janson. The coaching staff has concluded that the speed and defensive skills are virtually identical for the two players, and that the final decision will be based on which player has the best batting average. Crosstabulations of each player’s batting performance in their junior and senior years of high school are as follows:...A player’s batting average is computed by dividing the number of hits a player has by the total number of at-bats. Batting averages are represented as a decimal number with three places after the decimal.
a. Calculate the batting average for each player in her junior year. Then calculate the batting average of each player in her senior year. Using this analysis, which player should be awarded the scholarship? Explain.
b. Combine or aggregate the data for the junior and senior years into one crosstabulation as follows:...Calculate each player’s batting average for the combined two years. Using this analysis, which player should be awarded the scholarship? Explain.
c. Are the recommendations you made in parts (a) and (b) consistent? Explain any apparent inconsistencies.

Get solution

2.52 Fortune magazine publishes an annual survey of the 100 best companies to work for. The data in the WEBfile named FortuneBest100 shows the rank, company name, the size of the company, and the percentage job growth for full-time employees for 98 of the Fortune 100 companies for which percentage job growth data were available (Fortune magazine website, February 25, 2013). The column labeled Rank shows the rank of the company in the Fortune 100 list; the column labeled Size indicates whether the company is a small company (less than 2500 employees), a midsized company (2500 to 10,000 employees), or a large company (more than 10,000 employees); and the column labeled Growth Rate (%) shows the percentage growth rate for full-time employees.
a. Construct a crosstabulation with Job Growth (%) as the row variable and Size as the column variable. Use classes starting at – 10 and ending at 70 in increments of 10 for Growth Rate (%).
b. Show the frequency distribution for Job Growth (%) and the frequency distribution for Size.
c. Using the crosstabulation constructed in part (a), develop a crosstabulation showing column percentages.
d. Using the crosstabulation constructed in part (a), develop a crosstabulation showing row percentages.
e. Comment on the relationship between the percentage job growth for full-time employees and the size of the company.

Get solution

2.53 Table 2.18 shows a portion of the data for a sample of 103 private colleges and universities. The complete data set is contained in the WEBfile named Colleges. The data include the name of the college or university, the year the institution was founded, the tuition and fees (not including room and board) for the most recent academic year, and the percentage of full time, first-time bachelor’s degree-seeking undergraduate students who obtain their degree in six years or less (The World Almanac, 2012).
a. Construct a crosstabulation with Year Founded as the row variable and Tuition & Fees as the column variable. Use classes starting with 1600 and ending with 2000 in increments of 50 for Year Founded. For Tuition & Fees, use classes starting with 1 and ending 45000 in increments of 5000.
b. Compute the row percentages for the crosstabulation in part (a).
c. What relationship, if any, do you notice between Year Founded and Tuition & Fees?

Get solution

2.54 Refer to the data set in Table 2.18.
a. Construct a crosstabulation with Year Founded as the row variable and % Graduate as the column variable. Use classes starting with 1600 and ending with 2000 in increments of 50 for Year Founded. For % Graduate, use classes starting with 35% and ending with 100% in increments of 5%.
b. Compute the row percentages for your crosstabulation in part (a).
c. Comment on any relationship between the variables.
TABLE 2.18 DATA FOR A SAMPLE OF PRIVATE COLLEGES AND UNIVERSITIES...
Get solution

2.55 Refer to the data set in Table 2.18.
a. Construct a scatter diagram to show the relationship between Year Founded and Tuition & Fees.
b. Comment on any relationship between the variables.

Get solution

2.56 Refer to the data set in Table 2.18.
a. Prepare a scatter diagram to show the relationship between Tuition & Fees and % Graduate.
b. Comment on any relationship between the variables.

Get solution

2.57 Google has changed its strategy with regard to how much and over which media it invests in advertising. The following table shows Google’s marketing budget in millions of dollars for 2008 and 2011 (The Wall Street Journal, March 27, 2012)....
a. Construct a side-by-side bar chart with year as the variable on the horizontal axis. Comment on any trend in the display.
b. Convert the above table to percentage allocation for each year. Construct a stacked bar chart with year as the variable on the horizontal axis.
c. Is the display in part (a) or part (b) more insightful? Explain.

Get solution

2.58 A zoo has categorized its visitors into three categories: member, school, and general. The member category refers to visitors who pay an annual fee to support the zoo. Members receive certain benefits such as discounts on merchandise and trips planned by the zoo. The school category includes faculty and students from day care and elementary and secondary schools; these visitors generally receive a discounted rate. The general category includes all other visitors. The zoo has been concerned about a recent drop in attendance. To help better understand attendance and membership, a zoo staff member has collected the following data:...
a. Construct a bar chart of total attendance over time. Comment on any trend in the data.
b. Construct a side-by-side bar chart showing attendance by visitor category with year as the variable on the horizontal axis.
c. Comment on what is happening to zoo attendance based on the charts from parts (a) and (b).

Get solution