Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

6th Edition

ISBN: 9781337115186

Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran

Publisher: Cengage Learning

See similar textbooks

Concept explainers

Estimation

A new framework of data analysis where the new statistical methods are used for interpreting the results and analyzing the data is known as estimation in statistics.

Videos

Textbook Question

Chapter 3, Problem 65SE

Worker Productivity and Insomnia. U.S. companies lose $63.2 billion per year from workers with insomnia. Accordign to a 2013 article in the Wall Street Journal, workers lose an average of 7.8 days of productivity per year due to lack of sleep. The following data show the number of hours of sleep attained during a recent night for a sample of 20 workers.

Chapter 3, Problem 65SE, Worker Productivity and Insomnia. U.S. companies lose $63.2 billion per year from workers with

a. What is the mean number of hours of sleep for this sample?
b. What is the variance? Standard deviation?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 3, Problem 64SE

Chapter 3, Problem 66SE

Students have asked these similar questions

14 A survey is conducted to determine whether would prefer to work at home, if given the 20 office employees of a certain company chance. The overall results are shown in the first bar graph, and the results broken down by gender are presented in the second. a. Interpret the results of each graph. b. Discuss the added value in including gen- der in the second bar graph. (The second bar graph in this problem is called a side by side bar graph and is often used to show results broken down by two or more variables.) c. Compare the side by side bar graph with the two pie charts that you made for Question 6. Which of the two methods is best for comparing two groups, in your opinion? A Would you prefer to work at home? (n=20) 60 50 40 Percent 20 30 20 30 10 0 No Yes Prefer to work at home? (10 males, 10 females) 80 Percent 60 00 40 40 20- No Yes No Yes Female Male

Frequency 12 Suppose that a random sample of 270 gradu- ating seniors are asked what their immediate priorities are, including whether buying a house is a priority. The results are shown in the following bar graph. a. The bar graph is misleading; explain why. b. Make a new bar graph that more fairly presents the results. Is Buying a House a Priority? 300 250 200 150 100 50 0 Yes No Undecided

Frequency 11 A polling organization wants to find out what voters think of Issue X. It chooses a random sample of voters and asks them for their opinions of Issue X: yes, no, or no opinion. I organize the results in the following bar graph. a. Make a frequency table of these results (including the total number). brocb. Evaluate the bar graph as to whether it biz s b fairly represents the results. of beau no STORE TO OW! vd wob spind 550 540 500 vd 480 420 360 300 250 240 Yes No Undecided Opinion on Issue X

Chapter 3 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 3.1 - 1. Consider a sample with data values of 10, 20,...Ch. 3.1 - 2. Consider a sample with data values of 10, 20,...Ch. 3.1 - 3. Consider the following data and corresponding...Ch. 3.1 - Prob. 4E Ch. 3.1 - Prob. 5E Ch. 3.1 - Prob. 6E Ch. 3.1 - 7. The average number of minutes Americans commute...Ch. 3.1 - Middle-Level Manager Salaries. Suppose that an...Ch. 3.1 - 9. Which companies spend the most money on...Ch. 3.1 - Advertising Spending. Which companies spend the...

Ch. 3.1 - Prob. 11E Ch. 3.1 - The Big Bang Theory, a situation comedy...Ch. 3.1 - Automobile Fuel Efficiencies. In automobile...Ch. 3.1 - The data contained in the DATAfile named...Ch. 3.1 - 15. Martinez Auto Supplies has retail stores...Ch. 3.1 - 16. The grade point average for college students...Ch. 3.1 - 17. The following table shows the total return and...Ch. 3.1 - 18. Based on a survey of master’s programs in...Ch. 3.1 - Annual revenue for Corning Supplies grew by 5.5%...Ch. 3.1 - Suppose that at the beginning of Year 1 you...Ch. 3.1 - Prob. 21E Ch. 3.1 - Prob. 22E Ch. 3.2 - 23. Consider a sample with data values of 10, 20,...Ch. 3.2 - Prob. 24E Ch. 3.2 - Consider a sample with data values of 27, 25, 20,...Ch. 3.2 - Price of Unleaded Gasoline. Data collected by the...Ch. 3.2 - Round-Trip Flight Prices. The following table...Ch. 3.2 - The Australian Open is the first of the four...Ch. 3.2 - Air Quality Index. The Los Angeles Times regularly...Ch. 3.2 - Prob. 30E Ch. 3.2 - The results of Accounting Principals’ latest...Ch. 3.2 - Advertising Spend by Companies. Advertising Age...Ch. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - Consistency of Running Times. The following times...Ch. 3.3 - 35. Consider a sample with data values of 10, 20,...Ch. 3.3 - 36. Consider a sample with a mean of 500 and a...Ch. 3.3 - 37. Consider a sample with a mean of 30 and a...Ch. 3.3 - 38. Suppose the data have a bell-shaped...Ch. 3.3 - 39. The results of a national survey showed that...Ch. 3.3 - 40. The energy information Administration reported...Ch. 3.3 - 41. The Graduate Management Admission Test (GMAT)...Ch. 3.3 - 42. Many families in California are using backyard...Ch. 3.3 - According to a Los Angeles Times study of more...Ch. 3.3 - NCAA Basketball Game Scores. A sample of 10 NCAA...Ch. 3.3 - The Wall Street Journal reported that Walmart...Ch. 3.4 - Consider a sample with data values of 27, 25, 20,...Ch. 3.4 - Prob. 47E Ch. 3.4 - Prob. 48E Ch. 3.4 - Prob. 49E Ch. 3.4 - Naples Half-Marathon Times. Naples, Florida, hosts...Ch. 3.4 - Pharmaceutical Company Sales. Annual sales, in...Ch. 3.4 - Cell Phone Companies Customer Satisfaction....Ch. 3.4 - Most Admired Companies. Fortune magazine’s list of...Ch. 3.4 - Prob. 54E Ch. 3.5 - Five observations taken for two variables...Ch. 3.5 - Prob. 56E Ch. 3.5 - The DATAfile TwoStocks contains adjusted monthly...Ch. 3.5 - Driving Speed and Fuel Efficiency. A department of...Ch. 3.5 - Smoke Detector Use and Death Rates. Over the past...Ch. 3.5 - Stock Market Indexes Comparison. The Russell 1000...Ch. 3.5 - Best Private Colleges. A random sample of 30...Ch. 3 - Americans Dining Out. Americans tend to dine out...Ch. 3 - NCAA Football Coaches Salaries. A 2017 USA Today...Ch. 3 - Physician Office Waiting Times. The average...Ch. 3 - Worker Productivity and Insomnia. U.S. companies...Ch. 3 - A study of smartphone users shows that 68% of...Ch. 3 - Work Commuting Methods. Public transportation and...Ch. 3 - Household Incomes. The following data represent a...Ch. 3 - Restaurant Chains’ Sales per Store. The data...Ch. 3 - Prob. 70SE Ch. 3 - NFL Teams Worth. In 2014, the 32 teams in the...Ch. 3 - MLB Team Winning Percentages. Does a major league...Ch. 3 - 73. The days to maturity for a sample of five...Ch. 3 - 74. Automobiles traveling on a road with a posted...Ch. 3 - Annual Returns for Panama Railroad Company Stock....Ch. 3 - Pelican Stores, a division of National Clothing,...Ch. 3 - The motion picture industry is a competitive...Ch. 3 - The pursuit of a higher education degree in...Ch. 3 - Although millions of elephants once roamed across...

Knowledge Booster

$Statistics$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Solution Summary: The author explains how to obtain descriptive statistics using EXCEL by entering the data values of the sample and labeling it as Sample.

Concept explainers

Videos

Want to see the full answer?

Chapter 3 Solutions