Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 51SE
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Grade points are assigned such that an A receives 4 points, a B receives 3 points, a C receives 2 points, a D receives 1 point, and a F receives 0 points. Grades are weighted according to credit hours (units). If a student receives an A in a four-unit class, a D in a two-unit class, a B in a three-unit class and a C in a three-unit
class, what is the student's grade point average?
O A. 2.75
O B. 1.75
O C. 3.00
O D. 2.50
Click to select your answer.
DELL
XXX
EVD
disc RW
DELL
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:
Excel File: data02-51.xlsx
Outcome
Hit
No Hit
Allison Fealey
Senior
Junior
Outcome
15
Hit
No Hit
25
75
175
Outcome
Allison Fealey
0.375
0.35
Emily Janson
Calculate the batting average of each player in her senior year.
Senior
Hit
0.3
No Hit
Combined 2-Year Batting
A. Fealey
E. Janson
Emily Janson
Junior
Total At-Bats
40
250
Total At-Bats
200
120
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…
A market researcher's claim is that women spend more time each day on Facebook than men. If p1 represents the proportion of women on Facebook and p2 represents the proportion of men on Facebook, how would the researcher's claim be represented?
a.
p1 = p2
b.
p1 > p2
c.
p1 < p2
Chapter 2 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Ch. 2.1 - The response to a question has three alternatives:...Ch. 2.1 - A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 - Prob. 4ECh. 2.1 - In alphabetical order, the six most common last...Ch. 2.1 - Nielsen Media Research provided the list of the 25...Ch. 2.1 - The Canmark Research Center Airport Customer...Ch. 2.1 - Prob. 8ECh. 2.1 - Nearly 1.8 million bachelor's degrees and over...Ch. 2.1 - VirtualTourist provides ratings for hotels...
Ch. 2.2 - Consider the following data. a. Develop a...Ch. 2.2 - Consider the following frequency distribution...Ch. 2.2 - Prob. 13ECh. 2.2 - Prob. 14ECh. 2.2 - Prob. 15ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - A doctor's office staff studied the waiting times...Ch. 2.2 - CBSSports.com developed the Total Player Ratings...Ch. 2.2 - Based on the tons handled in a year, the ports...Ch. 2.2 - The London School of Economics and the Harvard...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Entrepreneur magazine ranks franchises using...Ch. 2.2 - The following data show the year-to-date percent...Ch. 2.2 - Prob. 24ECh. 2.2 - Prob. 25ECh. 2.2 - The Flying Pig Half-Marathon (13.1 miles) had...Ch. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - The Daytona 500 is a 500-mile automobile race held...Ch. 2.3 - The following crosstabulation shows the average...Ch. 2.3 - Prob. 31ECh. 2.3 - The following crosstabulation shows the number of...Ch. 2.4 - Prob. 36ECh. 2.4 - Consider the following data on two categorical...Ch. 2.4 - Prob. 38ECh. 2.4 - Prob. 39ECh. 2.4 - Prob. 40ECh. 2.4 - Prob. 41ECh. 2.4 - Prob. 42ECh. 2.4 - The Northwest regional manager of an outdoor...Ch. 2 - Approximately 1.5 million high school students...Ch. 2 - Data showing the population by state in millions...Ch. 2 - A startup company's ability to gain funding is a...Ch. 2 - Prob. 49SECh. 2 - Prob. 50SECh. 2 - Western University has only one women's softball...Ch. 2 - Prob. 53SECh. 2 - Prob. 57SECh. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Prob. 2.1.2CPCh. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Case Problem 2Motion Picture Industry The motion...Ch. 2 - Prob. 2.2.2CPCh. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...
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
- A 10-yr-old competes in gymnastics. For several competitions she received the following "All-Around" scores: 36.9, 35.4, 38.6, and 35.2. Her coach recommends that gymnasts whose "All-Around" scores average at least 38.1 move up to next level. What "All-Around" scores in the next competition would result in the child being eligible to move up? The child needs a score of (Choose one) V to move up to next level of competition.arrow_forwardA 12-year-old competes in gymnastics. For several competitions she received the following "All-Around" scores: 38.7, 38.2, 37.7, and 38.8. Her coach recommends that gymnasts whose "All-Around" scores average at least 35 move up to the next level. What "All-Around" scores in the next competition would result in the child being eligible to move up? The child needs a score of (at least/at most) ________ to move up to next level of competition.arrow_forwardHere are the top 10 season hitting percentages for members of two baseõall teams, and you must determine which is the best-hitting team, defined as the average. You have to decide which type of average you use and why. Do this by hand or use SPSS.arrow_forward
- Bicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine. Brand Weight Price ($) FELT F5 17.8 2,100 PINARELLO Paris 16.1 6,250 ORBEA Orca GDR 14.9 8,370 EDDY MERCKX EMX-7 15.9 6,200 BH RC1 Ultegra 17.2 4,000 BH Ultralight 386 13.1 8,600 CERVELO S5 Team 16.2 6,000 GIANT TCR Advanced 2 17.1 2,580 WILIER TRIESTINA Gran Turismo 17.6 3,400 SPECIALIZED S-works Amira SL4 14.1 8,000 a. Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. (Round your numerical values to the nearest integer). b. Compute r2. (Round your answer to three decimal places.) Did the…arrow_forwardThe 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 highest level of education for the head of household (U.S. Census Bureau website, 2013). Only households in which the head has a high school diploma or more are included. Highest level of Education Under$25,000 $25,000 to $49,999 $50,000 to $99,999 $100,000 and over Total High school graduate 9880 9970 9441 3482 32,773 Bachelor's degree 2484 4164 7666 7817 22,131 Master's degree 685 1205 3019 4094 9003 Doctoral degree 79 160 422 1076 1737 Total 13,128 15,499 20,548 16,469 65,644 a. Develop a joint probability table.b. What is the probability of the head of one of these households having a master’s degree or more education?c. What is the probability of a household headed by someone with a high school diploma earning $100,000 or more?d. What is the probability…arrow_forwardCostume designers are fashion designers that design costumes for the performing arts and for motion picture and television productions. They research the styles worn during the period in which the performance takes place, or work with directors to select and create appropriate attire. They must stay within the costume budget for the production. An upcoming play requires 6 bunny costumes. Each costume requires 3 square yards of faux fur. Faux fur costs $9.50 per square yard and the costume budget for the bunny costumes is $200. What is the total cost of material for the bunny costumes? $arrow_forward
- A school psychologist wants to test the effectiveness of a new method of teaching art. She recnuits 700 sixth-grade students and randomly divides them into two groups. Group 1 is taught by means of the new method, while grouD 2 is taught by traditional methods. The same teacher is assigned to teach both groups. At the end of the year, an achievement test is administered and the results of the two groups are compared. Complete parts (a) through (h) below. (a) What is the response variable in this experiment? O A. The score of group 2 on the achievement test O B. The scores on the achievement tests of both group 1 and group 2 O C. The score of group 1 on the achievement test O D. The students' ability in art (b) Is the response variable qualitative or quantitative? O A. The response variable is qualitative because it is a characteristic. O B. The response variable is quantitative because it is a measurement. O C. The response variable is quantitative because it is a characteristic. The…arrow_forwardDetermine how various attributes impact the purchase of a car. There are four attributes, each with three levels. • Brand: Ford = 0, Chrysler = 1, GM =2 • MPG: 15 MPG = 0, 20 MPG = 1, 25 MPG = 2 Horsepower (HP): 100 HP = 0, 150 HP = 1, 200 HP = 2 • Price: $18,000 = 0, $21,000 = 1, $24,000 = 2 The nine product profiles ranked below were evaluated by a consumer: (note - the table should be reproduced using the dummy variables) |(F, C, GM) |(15, 20, 25) |(100,150, 200) (18000, 21000, 24000) Trial Brand MPG Power Price Rank 4 2 1 1 2 7 2 1. 3 4 1. 1. 1. 2 1 9. 7 2. 2 8 8. 2 1 5 9 1 1 Q27. For this market segment, rank the product attributes from most important to least important. Price > MPG = HP > Brand O Price > MPG > HP > Brand O MPG = Price > HP > Brand MPG > HP > Price > Brand 2. 1. 2. 56arrow_forwardAn amateur golfer wishes to determine if there is a difference between the drive distances of her two favorite drivers. (A driver is a specialized club for driving the golf ball down range.) She hits fourteen balls with driver A and 10 balls with driver B. The drive distances (in yards) for the trials are show below. Driver A 265 278 299 314 243 248 275 276 265 266 277 248 276 282Driver B 233 220 217 239 235 245 261 194 272 233Assume that the populations are approximately normal. Can you conclude that there is a difference in the mean drive distances for the two drivers? Use the α = 0.05 level of significance. Use 6-step p-value method.arrow_forward
- The boxplots below show the real estate values of single-family homes in two neighboring cities (in thousands of dollars). Statstown Medianville 0 20 40 60 80 100 120 140 Annual Income Which city has more households? A. Statstown B. O Medianville C. O Both cities have the same number of households. D. It is impossible to tell from the boxplots.arrow_forwardA national chain of department stores ranks its 750,000 salespeople by the monetary value of their sales. Rafael's sales are at the 94 percentile. Maya's sales are at the 82nd percentile. (a) Which of the following must be true about Rafael's and Maya's sales? Maya's sales were higher in value than Rafael's sales. O Both Rafael and Maya had sales higher In value than the median. O The value of Rafael's sales were $1200 more than Maya's. O The values of both Rafael's and Maya's sales were in the bottom half of all of the salespeople. (b) Which of the following must be true about Rafael's sales? O Rafael had sales lower in value than about 94% of the salespeople. O The value of Rafael's sales were about 94% of the chain's total. O Rafael had sales higher in value than about 94% of the salespeople. O The value of Rafael's sales were about 6% of the chain's total. Explanation Check C Ō hp O X 5 Ⓒ2022 McGraw Hill LLC. All Rights Reserved. Terms of Use | Privacy Center Access ✔arrow_forwardThe course credit hours and grades for a student's fall semester at college are given in the table below. At the college, an A is worth six quality points, a B four points, a C two points, and a D one point. The grade-point average at the college is calculated as a weighted average, with quality points for each course weighted by the credit hours for that course. What is the student's grade-point average? Credit hours: 2 3 4 4 3 Grade: A В ..... The student's grade-point average is (Round to two decimal places as needed.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Elementary Geometry For College Students, 7eGeometryISBN:9781337614085Author:Alexander, Daniel C.; Koeberlein, Geralyn M.Publisher:Cengage,
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY