New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
business statistics communicating
Statistics For Managers Using Microsoft Excel 9th Global Edition David Levine, David Stephan, Kathryn Szabat - Solutions
3.56 What are the differences among the various measures of variation, such as the range, interquartile range, variance, standard deviation, and coefficient of variation, and what are the advantages and disadvantages of each?
3.55 What does the Z score measure?
3.54 What is meant by the property of variation?
3.53 How do you interpret the first quartile, median, and third quartile?
3.52 What are the differences among the mean, median, and mode, and what are the advantages and disadvantages of each?
3.51 What is meant by the property of central tendency?
3.50 What are the properties of a set of numerical data?
3.49 There are several different types of fat in a person’s body.Some can have a negative effect on your health and contribute to sickness, while others are beneficial and vital for your health. It also helps in preserving the body temperature, cushioning joints and protecting internal organs.
3.48 The file Diamonds contains prices of cut diamonds (in Singapore dollars), along with associated data on weight, color, clarity, and ratings agency for a selected sample of diamonds.Source: Data extracted from Journal of Statistics Education, https://www2.stetson.edu/~jrasp/data.htm.a.
3.47 Movie companies need to predict the gross receipts of individual movies once a movie has debuted. The data, shown below and stored in Potter Movies , are the first weekend gross, the U.S. gross, and the worldwide gross (in $millions) of the eight Harry Potter movies:Title First Weekend
3.46 The file Cereals lists the calories and sugar, in grams, in one serving of seven breakfast cereals:Cereal Calories Sugar Kellogg’s All Bran 80 6 Kellogg’s Corn Flakes 100 2 Wheaties 100 4 Nature’s Path Organic Multigrain Flakes 110 4 Kellogg’s Rice Krispies 130 4 Post Shredded Wheat
3.45 A study of 267 college students investigated the impact of smartphones on student connectedness and out-of-class involvement.One finding showed that students reporting a higher perceived usefulness of smartphones in educational settings used their smartphone a higher number of times to send or
3.44 The following is a set of data from a sample of n = 11 items:X 7 5 8 3 6 10 12 4 9 15 18 Y 21 15 24 9 18 30 36 12 27 45 54a. Compute the covariance.b. Compute the coefficient of correlation.c. How strong is the relationship between X and Y? Explain.APPLYING THE CONCEPTS
3.43 The file Child Mortality Rate contains data on male child mortality rate by cause in India for the year 2017. This data has been measured as the number of deaths of male children aged 1 to 4 years old per 100,000 children.Source: Data extracted from Our World in Data,
3.42 The file Asia Population contains the total population(in million) of all Asian countries for the year 2018.a. Compute the mean, variance, and standard deviation for the population.b. What proportion of these countries has a total population within{1 standard deviation of the mean, within {2
3.41 The Big Mac index was created by The Economist in 1986 as a lighthearted guide to whether currencies are at their “correct” level.The file BigMacIndex072018 contains the dollar price (rounded to two decimals) of a Big Mac burger in 56 countries as of July 2018.Source: Data extracted from
3.40 The Human Resource department of a particular company is analyzing the total salary paid to its 1,150 employees. The HR has determined that the average salary, m, for the total number of employees is $5,620, and that the standard deviation, s, is $577.50.a. According to the empirical rule,
3.39 The file McDonalds Stores contains the number of McDonald’s stores per 100,000 population located in each of the 50 U.S.states as of September 13, 2018.Source: Data extracted from Usatoday.com, “Is your state ‘lovin’ it’?” bit.ly/2vFGoay.a. Calculate the mean, variance, and
3.37 The following is a set of data for a population with N = 10:8 2 9 13 15 7 11 9 12 5a. Compute the population mean.b. Compute the population standard deviation.3.38 The following is a set of data for a population with N = 7:24 37 16 21 26 32 44a. Compute the population mean.b. Compute the
3.36 A bank branch located in a commercial district of a city has the business objective of developing an improved process for serving customers during the noon-to-1:00 p.m. lunch period. The bank collects the waiting time, the number of minutes that elapses from when a customer joins the waiting
3.35 The file Employment contains the percentage share of total employment in services and industry in Thailand for the 15-year period 2003–2017.Source: Data extracted from https://ourworldindata.org/grapher/share-of-employment-in-agriculture-industry-and-services?time=1991..2017&country=THA.For
3.34 The FIFA World Cup was one of the biggest sporting events of 2018. The file World Cup 2018 Players contains the data of the players of 32 teams that qualified for the event. A dummy variable is included to indicate whether a player is also a captain.Source: Data adapted from
3.33 A financial services call center monitors call duration, the amount of time spent speaking to customers on the phone. The file Call Duration contains the data for time, in seconds, agents spent talking to 50 customers.a. Calculate the first quartile (Q1), the third quartile (Q3), and the
3.32 The file Mobile Commerce contains the mobile commerce penetration values, the percentage of the country population that bought something online via a mobile phone in the past month, for 24 of the world’s economies.Source: Data extracted from “Mobile commerce share by country
3.31 The file Accounting Partners contains the number of partners in a cohort of rising accounting firms that have been tagged as“firms to watch.”Source: Data extracted from 2019 Top 100 Firms, Bloomberg BNA, accounting today.com.a. Calculate the first quartile (Q1), the third quartile (Q3),
3.30 The following is a set of data from a sample of n = 8:9 14 11 8 4 5 0 1a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.a. If the value 5 in the sample data is changed to 7,
3.29 The following is a set of data from a sample of n = 5:-3 - 9 7 3 0a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.d. If the value –9 in the sample data is changed to –7,
3.28 The following is a set of data from a sample of n = 6:-14 2 8 6 3 - 9a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.d. Compare your answer in (c) with that from Problem 3.2
3.27 The following is a set of data from a sample of n = 9:4 9 1 6 4 2 4 8 9a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.d. Compare your answer in (c) with that from Problem 3.3
3.32 The file Mobile Commerce contains the mobile commerce penetration values, the percentage of the country population that bought something online via a mobile phone in the past month, for 24 of the world’s economies.Source: Data extracted from “Mobile commerce share by country
3.31 The file Accounting Partners contains the number of partners in a cohort of rising accounting firms that have been tagged as“firms to watch.”Source: Data extracted from 2019 Top 100 Firms, Bloomberg BNA, accounting today.com.a. Calculate the first quartile (Q1), the third quartile (Q3),
3.30 The following is a set of data from a sample of n = 8:9 14 11 8 4 5 0 1a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.a. If the value 5 in the sample data is changed to 7,
3.29 The following is a set of data from a sample of n = 5:-3 - 9 7 3 0a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.d. If the value –9 in the sample data is changed to –7,
3.28 The following is a set of data from a sample of n = 6:-14 2 8 6 3 - 9a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.d. Compare your answer in (c) with that from Problem 3.2
3.27 The following is a set of data from a sample of n = 9:4 9 1 6 4 2 4 8 9a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range.b. List the five-number summary.c. Construct a boxplot and describe its shape.d. Compare your answer in (c) with that from Problem 3.3
3.25 Using the three-year return percentage variable in Retirement Funds :a. Construct a table that computes the mean for each combination of market cap, risk, and rating.b. Construct a table that computes the standard deviation for each combination of market cap, risk, and rating.c. What
3.24 Using the three-year return percentage variable in Retirement Funds :a. Construct a table that computes the mean for each combination of type, market cap, and rating.b. Construct a table that computes the standard deviation for each combination of type, market cap, and rating.c. What
3.23 Using the three-year return percentage variable in Retirement Funds :a. Construct a table that computes the mean for each combination of type, market cap, and risk.b. Construct a table that computes the standard deviation for each combination of type, market cap, and risk.c. What conclusions
3.22 In 2016 through 2018, the value of precious metals fluctuated greatly. The data (stored in Metals ) represent the total rate of return (in percentage) for platinum, gold, and silver from 2016 through 2018:a. Compute the geometric mean rate of return per year for platinum, gold, and silver from
3.21 The file Indices contains data that represent the total rate of return percentage for the Dow Jones Industrial Average (DJIA), the Standard & Poor’s 500 (S&P 500), and the technology-heavy NASDAQ Composite (NASDAQ) from 2015 through 2018.a. Compute the geometric mean rate of return per year
3.20 The Dow Jones Industrial Average is a stock market index that measures the stock performance of 30 large-cap, industrial corporations. Presently, the Dow includes companies like Apple, Walmart, Microsoft, and Boeing. In 2017, it posted a total stock market return of 29.11% and a total return
3.19 The S&P 500 Index was begun in 1926, then known as the Composite Index, and originally composed of 90 stocks. In 1957, the index adopted its current format of measuring the stock performance of 500 companies listed on U.S. stock exchanges. In 2017, it posted a total stock market return of
3.17 collect a new set of data, this time for 20 younger patients.Their findings are stored in the file BBS_Younger:50 45 47 52 42 41 44 43 55 54 54 53 46 56 39 55 44 51 39 40a. Compute the mean and median.b. Compute the variance, standard deviation, range, coefficient of variation, and Z scores.
3.18 Suppose that the researchers at the hospital from Problem
3.17 The Berg Balance Scale (BBS), named after its developer Katherine Berg, is a popular clinical test of a person’s static and dynamic balance abilities. It is measured on a scale of 0 to 56; the higher the value, the better the score. The cut-off score is 45, which means that a score less than
3.16 A financial services call center monitors call duration, the amount of time spent speaking to customers on the phone. The file Call Duration contains the data for time, in seconds, agents spent talking to 50 customers:a. Calculate the mean, median, and mode.b. Calculate the range, variance,
3.15 Analyze the data given in the file Employment and determine if there is any difference in the share of total employment in services and industry in Thailand for the 15-year period 2003–2017.Source: Data extracted from Our World in Data,
3.14 The file Mobile Commerce contains the mobile commerce penetration values, the percentage of the country population that bought something online via a mobile phone in the past month, for 24 of the world’s economies.Source: Data extracted from Statistica.com, bit.ly/2vsnjv8.a. Calculate the
3.13 The file Country Population contains the data of a randomly selected sample of world population by country (in million) in the year 2019.Source: Data extracted from Our World in Data, https://ourworldindata.org/grapher/population-by-country-gapminder+un.a. Compute the mean, median, and mode.b.
3.12 The file Consumption contains the average per capita beef availability, which is used here as a measure of consumption, and is measured in kilograms per year for the past 15 years in the United States.(Note: This figure does not account for consumption-level waste therefore actual per capita
3.11 The FIFA World Cup was one of the biggest sporting events of 2018. The file World Cup 2018 Players contains data about the players from 32 teams that qualified for the event. A dummy variable is included to indicate whether a player is also a captain.Source: Data adapted from
3.10 The file Mobile Speed contains the overall download and upload speeds in Mbps for eight carriers in the United States.Carrier Download Speed Upload Speed Verizon 53.3 17.5 T-Mobile 36.3 16.9 AT&T 37.1 12.9 Metro PCS 32.8 13.0 Sprint 32.5 4.0 Boost 29.4 3.7 Straight Talk 31.1 15.6 Cricket 6.5
3.9 According to the national statistical institute of the United Kingdom, Office for National Statistics, the median income in the UK remains nearly the same from 1977 to financial year ending 2018. The median and mean incomes were calculated using the Consumer Prices Index and are relative to the
3.8 Apple is launching a new iPhone model. The marketing manager samples the last five days of sales at two different Apple outlet stores and records the results as follows:Outlet A Outlet B 575 328 292 418 398 492 502 531 379 304a. For each of the two outlet stores, calculate the mean, median, and
3.7 Salary Data & Career Research Center (Malaysia) reported the following summary for the annual salaries of two of the most popularly browsed jobs in the country, Account Executive and Project Engineer.Job Median (Salary)Account Executive RM 36,237 Project Engineer 45,638 Source: Data extracted
3.6 Suppose that an investor earns a 20% rate of return in Year 1, 6% in Year 2, and 1% in Year 3 for a particular stock. Compute the geometric mean rate of return per year.
3.5 Suppose that the annual rate of return for a particular company’s stock for the first two years was 15% and –5%, respectively. Compute the geometric mean rate of return per year. (Note: A rate of return of 15% is recorded as 0.15 and a rate of return of –5% is recorded as –0.05.)
3.4 The following set of data is from a sample of n = 6:–0.5 3.6 –0.1 5.7 8.3 7.7a. Compute the mean, median, and mode.b. Compute the range, variance, standard deviation, and coefficient of variation.c. Compute the Z scores. Are there any outliers?d. Describe the shape of the data set.
3.3 The following set of data is from a sample of n = 10:2 64 52 58 79 87 95 96 93 89a. Compute the mean, median, and mode.b. Compute the range, variance, standard deviation, and coefficient of variation.c. Compute the Z scores. Are there any outliers?d. Describe the shape of the data set.
3.2 The following set of data is from a sample of n = 10:8 14 19 85 32 24 28 10 5 32a. Compute the mean, median, and mode.b. Compute the range, variance, standard deviation, and coefficient of variation.c. Compute the Z scores. Are there any outliers?d. Describe the shape of the data set.
3.1 The following set of data is from a sample of n = 5:10 18 9 22 5a. Compute the mean, median, and mode.b. Compute the range, variance, standard deviation, and coefficient of variation.c. Compute the Z scores. Are there any outliers?d. Describe the shape of the data set.
1. Review these data (stored in AMS2-1 ). Identify the variables that are important in describing the customer service problems.For each variable you identify, construct the graphical representation you think is most appropriate and explain your choice.Also, suggest what other information
2.109 Referring to the results from Problem 2.100 on page 114 concerning the weights of Boston and Vermont shingles, write a report that evaluates whether the weights of the pallets of the two types of shingles are what the company expects. Be sure to incorporate tables and charts into the report.
2.108 (Class Project) Cross-classify each student in the class by gender (male, female) and current employment status (yes, no) so that the instructor can tally the results.a. Construct a table with either row or column percentages, depending on which you think is more informative.b. What would you
2.107 (Class Project) Have each student in the class respond to the question, “Which carbonated soft drink do you most prefer?” so that the instructor can tally the results into a summary table.a. Convert the data to percentages and construct a Pareto chart.b. Analyze the findings.
2.106 A/B testing allows businesses to test a new design or format for a web page to determine if the new web page is more effective than the current one. Web designers decide to create a new call-to-action button for a web page. Every visitor to the web page was randomly shown either the original
2.105 The file Currency contains the exchange rates of the Canadian dollar, the Japanese yen, and the English pound from 1980 to 2019, where the Canadian dollar, the Japanese yen, and the English pound are expressed in units per U.S. dollar.a. Construct time-series plots for the yearly closing
2.104 The data stored in Drink represent the amount of soft drink in a sample of 50 consecutively filled 2-liter bottles.a. Construct a time-series plot for the amount of soft drink on the Y axis and the bottle number (going consecutively from 1 to 50)on the X axis.b. What pattern, if any, is
2.103 The file Natural Gas contains the U.S. monthly average commercial and residential price for natural gas in dollars per thousand cubic feet from January 2008 through December 2018.Source: Data extracted from “U.S. Natural Gas Prices,” eia.org, March 30, 2019.For the commercial price and
2.102 The file Protein contains calorie and cholesterol information for popular protein foods (fresh red meats, poultry, and fish).Source: U.S. Department of Agriculture.a. Construct frequency and percentage distributions for the number of calories.b. Construct frequency and percentage
2.101 College basketball in the United States is big business with television contracts in the billions of dollars and coaches’ salaries in the millions of dollars. The file Coaches Pay contains the total pay for coaches for a recent year and whether the school was a member of a major conference
2.100 Studies conducted by a manufacturer of Boston and Vermont asphalt shingles have shown product weight to be a major factor in customers’ perception of quality. Moreover, the weight represents the amount of raw materials being used and is therefore very important to the company from a cost
2.99 Download speed of an Internet connection is of great importance to both individuals and businesses in a community. The file City Download Speeds contains the download speed in Mbps for 100 United States cities with the fastest download speeds.Source: Data extracted from
2.98 The file CD Rates contains the yields for one-year certificates of deposit (CDs) and for five-year CDs for 46 financial institutions selling CDs in Lake Worth, Florida, as of April 5, 2019.Source: Data extracted and compiled from www.bankrate.com, April 5, 2019.a. Construct a stem-and-leaf
2.97 The Super Bowl, watched by close to 200 million Americans, is also a big event for advertisers. The file Super Bowl Ad Ratings contains the rating of ads that ran between the opening kickoff and the final whistle.Source: Data extracted from www.admeter.usatoday.com/results/2019.For ads that
2.96 The file Rate Beer Top 50 contains the alcohol percentage, alcohol by volume, number of ratings (count), rank, and average score as of July 2018 for the top 50 beers in the world.Source: Data extracted from https://bit.ly/2BcTBMo.a. Construct a percentage histogram for the count, the alcohol
2.95 One of the major measures of the quality of service provided by an organization is the speed with which the organization responds to customer complaints. A large family-held department store selling furniture and flooring, including carpet, had undergone a major expansion in the past several
2.94 The Air Travel Consumer Report, a monthly product of the Department of Transportation’s Office of Aviation Enforcement and Proceedings (OAEP), is designed to assist consumers with information on the quality of services provided by airlines. The report includes a summary of consumer
2.93 The following data stored in Food Consumption represents the pounds per capita of fresh food and packaged food consumed in the United States, Japan, and Russia in a recent year.COUNTRY FRESH FOOD United States Japan Russia Eggs, nuts, and beans 88 94 88 Fruit 124 126 88 Meat and seafood 197
2.92 Suppose that the owner of the restaurant in Problem 2.91 also wants to study the demand for dessert during the same time period. She decides that in addition to studying whether a dessert was ordered, she will also study the gender of the individual and whether a beef entrée was ordered. Data
2.91 The owner of a restaurant that serves Continental-style entrées has the business objective of learning more about the patterns of patron demand during the Friday-to-Sunday weekend time period. Data were collected from 630 customers on the type of entrée ordered and were organized in the
2.90 B2B marketers in North America were surveyed about content marketing usage, organization, and success. Content marketers were asked about how content marketing is structured within their organization and how they would describe their organization’s commitment to content marketing. The tables
2.89 The following table stored in Movie Types represents the market share (in number of movies, gross in millions of dollars, and millions of tickets sold) of each type of movie in 2018:Type Number Gross($millions)Tickets(millions)Original screen play 306 3977.5 443.4 Based on fiction book or
2.88 The following table shown in the file Textbook Costs shows the breakdown of the costs of a typical college textbook.Revenue Category Percentage %Publisher 66.06 Page, printing, ink 4.62 Editorial production 24.93 Marketing 11.60 Freight 0.77 Misc. overhead 1.74 Profit 22.4 Bookstore 22.20
2.87 What is the difference between a time-series plot and sparklines?
2.86 What is the difference between a drill-down and a slicer?
2.85 What type of insights can you gain from a contingency table that contains three variables that you cannot gain from a contingency table that contains two variables?
2.84 How can a multidimensional table differ from a two-variable contingency table?
2.83 What are the three different ways to break down the percentages in a contingency table?
2.82 Why is it said that the main feature of a Pareto chart is its ability to separate the “vital few” from the “trivial many”?
2.81 What is the difference between a time-series plot and a scatter plot?
2.80 Compare and contrast the bar chart for categorical data with the histogram for numerical data.
2.79 What are the advantages and disadvantages of using a bar chart, a pie chart, a doughnut chart, and a Pareto chart?
2.78 Why would you construct a summary table?
2.77 How do histograms and polygons differ in construction and use?
2.76 Figures 2.5 and 2.6 on pages 82 and 83, show a bar chart and a pie chart for the risk level for the retirement fund data.a. Create an exploded pie chart, a doughnut chart, a cone chart, and a pyramid chart that show the risk level of retirement funds.b. Which graphs, either seen in Figures 2.5
2.75 Figure 2.4 on page 81 shows a bar chart and a pie chart for what employed adults did the last time they were sick.a. Create an exploded pie chart, a cone chart, or a pyramid chart that shows how employed adults who work outside the home responded to being sick.b. Which graphs either seen in
2.74 Deanna Oxender Burgess of Florida Gulf Coast University conducted research about corporate annual reports (see D. Rosato,“Worried About Corporate Numbers? How About the Charts?,”nyti.ms/2GedlQu). Burgess found that even slight distortions in a chart changed readers’ perception of the
2.73 Examine the following visualization, adapted from a management consulting white paper.a. Describe at least one good feature of this visual display.b. Describe at least one bad feature of this visual display.c. Redraw the graph, by using the Exhibit 2.1 best practices. When managers believe
2.72 Examine the following visualization, adapted from one that appeared in the post “Who Are the Comic Book Fans on Facebook?”, as reported by graphicspolicy.com.a. Describe at least one good feature of this visual display.b. Describe at least one bad feature of this visual display.c. Redraw
Showing 3100 - 3200
of 7675
First
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Last
Step by Step Answers