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
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 63SE
NCAA Football Coaches Salaries. A 2017 USA Today article reports that NCAA football coaches’ salaries have continued to increase in recent years (USA Today). The annual base salaries for the previous head football coach and the new head football coach at 23 schools are given in the file Coaches.
- a. Determine the
median annual salary for a previous head football coach and a new head football coach. - b. Compute the
range for salaries for both previous and new head football coaches. - c. Compute the standard deviation for salaries for both previous and new head football coaches.
- d. Based on your answers to (a) to (c), comment on any differences between the annual base salary a school pays a new head football coach compared to what it paid its previous head football coach.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A recent survey of 400 americans asked whether or not parents do too much for their young adult children. The results of the survey are shown in the data file. a) Construct the frequency and relative frequency distributions. How many respondents felt that parents do too much for their adult children? What proportion of respondents felt that parents do too little for their adult children? b) Construct a pie chart. Summarize the findings
The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows:
Click on the datafile logo to reference the data.
DATA file
Albuquerque
23.3
Jacksonville
26.2
Phoenix
28.3
Atlanta
28.3
Kansas City
23.4
Pittsburgh
25.0
Austin
24.6
Las Vegas
28.4
Portland
26.4
Baltimore
32.1
Little Rock
20.1
Providence
23.6
Boston
31.7
Los Angeles
32.2
Richmond
23.4
Charlotte
25.8
Louisville
21.4
Sacramento
25.8
Chicago
38.1
Memphis
23.8
Salt Lake City
20.2
Cincinnati
24.9
Miami
30.7
San Antonio
26.1
Cleveland
26.8
Milwaukee
24.8
San Diego
24.8
Columbus
23.4
Minneapolis
23.6
San Francisco
32.6
Dallas
28.5
Nashville
25.3
San Jose
28.5
Denver
28.1
New Orleans
31.7
Seattle
27.3
Detroit
29.3
New York
43.8
St. Louis
26.8
El Paso
24.4
Oklahoma City
22.0
Tucson
24.0
Fresno
23.0
Orlando
27.1
Tulsa
20.1
Indianapolis
24.8
Philadelphia
34.2
Washington, D.C.
32.8
a. What is the mean commute time for…
Morningstar tracks the total return for a large number of mutual funds. The following table shows the total return and the number of funds for four categories of mutual funds.
Click on the datafile logo to reference the data.
DATA file
Type of Fund
Domestic Equity
Number of Funds
Total Return (%)
9191
4.65
International Equity
2621
18.15
Hybrid
1419
2900
11.36
6.75
Specialty Stock
a. Using the number of funds as weights, compute the weighted average total return for these mutual funds. (to 2 decimals)
%
b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
c. Suppose you invested $10,000 in this group of mutual funds and diversified the investment by placing $2000 in Domestic Equity funds, $4000 in International Equity funds, $3000 in Specialty Stock…
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. 4ECh. 3.1 - Prob. 5ECh. 3.1 - Prob. 6ECh. 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. 11ECh. 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. 21ECh. 3.1 - Prob. 22ECh. 3.2 - 23. Consider a sample with data values of 10, 20,...Ch. 3.2 - Prob. 24ECh. 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. 30ECh. 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. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 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. 54ECh. 3.5 - Five observations taken for two variables...Ch. 3.5 - Prob. 56ECh. 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. 70SECh. 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
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.Similar questions
- The days to maturity for a sample of five money market funds are shown here. The dollar amounts invested in the funds are provided. Days to Maturity 20 Dollar Value ($ millions) 20 12 30 7 10 5 6 15 10 Use the weighted mean to determine the mean number of days to maturity for dollars invested in these five money market funds (to 1 decimal). daysarrow_forwardc. What are the first and third quartiles? First Quartiles (to 1 decimals) Third Quartiles (to 4 decimals) × ☑ Which companies spend the most money on advertising? Business Insider maintains a list of the top-spending companies. In 2014, Procter & Gamble spent more than any other company, a whopping $5 billion. In second place was Comcast, which spent $3.08 billion (Business Insider website, December 2014). The top 12 companies and the amount each spent on advertising in billions of dollars are as follows. Click on the datafile logo to reference the data. DATA file Company Procter & Gamble Comcast Advertising ($billions) $5.00 3.08 2.91 Company American Express General Motors Advertising ($billions) $2.19 2.15 ETET AT&T Ford Verizon L'Oreal 2.56 2.44 2.34 Toyota Fiat Chrysler Walt Disney Company J.P Morgan a. What is the mean amount spent on advertising? (to 2 decimals) 2.55 b. What is the median amount spent on advertising? (to 3 decimals) 2.09 1.97 1.96 1.88arrow_forwardMartinez Auto Supplies has retail stores located in eight cities in California. The price they charge for a particular product in each city are vary because of differing competitive conditions. For instance, the price they charge for a case of a popular brand of motor oil in each city follows. Also shown are the number of cases that Martinez Auto sold last quarter in each city. City Price ($) Sales (cases) Bakersfield 34.99 501 Los Angeles 38.99 1425 Modesto 36.00 294 Oakland 33.59 882 Sacramento 40.99 715 San Diego 38.59 1088 San Francisco 39.59 1644 San Jose 37.99 819 Compute the average sales price per case for this product during the last quarter? Round your answer to two decimal places.arrow_forward
- Consider the following data and corresponding weights. xi Weight(wi) 3.2 6 2.0 3 2.5 2 5.0 8 a. Compute the weighted mean (to 2 decimals). b. Compute the sample mean of the four data values without weighting. Note the difference in the results provided by the two computations (to 3 decimals).arrow_forwardExpert only,if you don't know it don't attempt it, no Artificial intelligence or screen shot it solvingarrow_forwardFor context, the image provided below is a quesion from a Sepetember, 2024 past paper in statistical modelingarrow_forward
- For context, the images attached below (the question and the related figure) is from a january 2024 past paperarrow_forwardFor context, the image attached below is a question from a June 2024 past paper in statisical modelingarrow_forwardFor context, the images attached below are a question from a June, 2024 past paper in statistical modelingarrow_forward
- For context, the images attached below (question and related graph) are from a February 2024 past paper in statistical modelingarrow_forwardFor context, the images attached below are from a February 2024 past paper in statistical modelingarrow_forwardFor context, the image provided below is a question from a September, 2024 past paper in statistical modelingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License