Business Analytics (2nd Edition)
2nd Edition
ISBN: 9780321997821
Author: James R. Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 12PE
The Excel file EEO Employment Report shows the number of people employed in different professions for various racial and ethnic groups. Find the proportion of men and women in each ethnic group for the total employment and in each profession.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Find the median age for the 16 countries with over 100 million population (besides the US).
Conduct a mini census by counting the living members of your extended family noting the age of everyone. Include four generations, if possible.Create a table and include total population plus percentages of each generation.Analyze the age patterns in your family and note the issues that are specifically important to each group.
The average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for typical Cheyenne residences.
Average Monthly Gas
Number of
Bill for Last Year
Age
Square Footage
Rooms
$70.20
16
2537
6
$81.33
2
3437
8
$45.86
27
976
6
$59.21
11
1713
7
$117.88
16
3979
11
$57.78
2
1328
7
$47.01
27
1251
6
$52.89
4
827
5
$32.90
12
645
4
$67.04
29
2849
5
$76.76
1
2392
7
$60.40
26
900
5
$44.07
14
1386
5
$26.68
20
1299
4
$62.70
17
1441
6
$45.37
13
562
4
$38.09
10
2140
4
$45.31
22
908
6
$52.45
24
1568
5
$96.11
27
1140
10…
Chapter 4 Solutions
Business Analytics (2nd Edition)
Ch. 4 - Data obtained from a county auditor in the Excel...Ch. 4 - In the Excel file Facebook Survey, find the...Ch. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - Prob. 4PECh. 4 - Prob. 5PECh. 4 - Prob. 6PECh. 4 - Prob. 7PECh. 4 - Prob. 8PECh. 4 - Prob. 9PECh. 4 - Prob. 10PE
Ch. 4 - A marketing study of 800 adults in the 18—34 age...Ch. 4 - The Excel file EEO Employment Report shows the...Ch. 4 - In the Excell file Bicycle Inventory, find the...Ch. 4 - In the Sales Transactions database, find the...Ch. 4 - In the Excel file Economic Poll, find the...Ch. 4 - In the Excel file Facebook Survey, use a...Ch. 4 - In the Excel file Cell Phone Suivey, use...Ch. 4 - Using PivotTables, find the average and standard...Ch. 4 - Prob. 19PECh. 4 - Prob. 20PECh. 4 - Prob. 21PECh. 4 - Prob. 22PECh. 4 - Call centers have high turnover rates because of...Ch. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 25PECh. 4 - Prob. 26PECh. 4 - Prob. 27PECh. 4 - Prob. 28PECh. 4 - Prob. 29PECh. 4 - Prob. 30PECh. 4 - Prob. 31PECh. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 33PECh. 4 - Prob. 34PECh. 4 - Prob. 35PECh. 4 - Prob. 36PECh. 4 - Prob. 37PECh. 4 - Prob. 38PE
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 accompanying table gives the population of 6 regions in 2008 and the area of these regions. Use the table to answer the following questions. Complete parts (a) through (c) below. LOADING... Click the icon to view the data table. a. Determine and report the rankings of the population density by dividing each population by the number of square miles to get the population density (in people per square mile). Use rank 1 for the highest density and 6 for the lowest density. Region Population Area (square miles) Population Density Rank Rate A 12,459,500 49,919 nothing ▼ 3 4 6 1 5 2 B 12,982,395 59,329 nothing ▼ 4 1 6 2 5 3 C 18,345,648 45,938 nothing ▼ 2 6 1 4 3 5 D 19,433,196 49,599 nothing ▼ 1 4 6 3 2 5 E 24,385,213 267,477 nothing ▼ 3 1 2 5 4 6 F 36,784,071 150,713 nothing ▼ 5 3 6 4 1 2 (Round to two decimal places as…arrow_forwardGuadalajara Tours' daily sightseeing trip has a capacity of 55 people. Each day, tour officials record the number of people making the trip. The data for a selection of 22 summer days are as follows. 31, 36, 41, 42, 43, 43, 46, 46, 46, 47, 47, 49, 51, 51, 51, 51, 52, 52, 52, 54, 54, 54 Send data to calculator Send data to Excel Frequency 10- 10 6+ 4 4. 2+ 1. 0- 30 35 40 45 50 55 Number of people on trip OMean (a) For these data, which measures of central tendency take more than one value? Choose all that apply. OMedian Mode ONone of these measures OMean (b) Suppose that the measurement 31 (the smallest measurement in the data set) were OMedian replaced by 15. Which measures of central OMode tondoncu would bo offoctod by the chano02 Explanation Check O 2021 McGraw-Hill Education. All Rights Reserved. Terms of Use Privacy Access APA pe here to search 99+arrow_forwardfind 10th pr for given data 45,85,98,7,56,78,56,34,25,96,85arrow_forward
- Construct a vertical and horizontal bar graph for the number of employees (in thousands) of a sample of the largest tech companies as of 2014arrow_forwardGuadalajara Tours' daily sightseeing trip has a capacity of 55 people. Each day, tour officials record the number of people making the trip. The data for a selection of 22 summer days are as follows. 34, 37, 41, 41, 42, 43, 46, 47, 48, 49, 49, 49, 51, 52, 52, 52, 52, 53, 53, 53, 54, 54 Send data to calculator Send data to Excel Frequency 10 10 8. 6- 4 2. 45 50 55 35 Number of people on trip 30 40 6. 4.arrow_forwardFind the mean for the given data set, 89,110,145,160,185arrow_forward
- Please no written by hand and no emage The National Assessment for Educational Progress (NAEP) is a U.S. government organization that assesses the performance of students and schools at all levels across the United States. The following table presents the percentage of eighth-grade students who were found to be proficient in mathematics and the percentage who were found to be proficient in reading in each of the ten most populous states. Use excels to find: StatePercentage Proficient in ReadingPercentage Proficient in MathematicsCalifornia6059Texas7378New York7570Florida6668Illinois7570Pennsylvania7977Ohio7976Michigan7366Georgia6764North Carolina7173 Activities: Construct a scatterplot with reading proficiency on the horizontal axis and math proficiency on the vertical axis. Is there a linear relationship? Compute the correlation between reading proficiency and math proficiency. Is the linear association positive or negative? Weak or strong?arrow_forwardfind 5 number summary for given data 2,5,8,9,11,15,14,16,18,20,25,30,35,40,48,50arrow_forwardMarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales. Car Sales Manufacturer Jan.-Nov.2017 Jan.-Nov.2018 GM (Est.) 2,691,493 2,654,568 Ford 2,334,290 2,265,590 Toyota 2,211,533 2,205,762 Fiat Chrysler 1,887,430 2,038,684 Honda 1,492,112 1,449,713 Nissan 1,455,238 1,345,157 Hyundai 621,961 612,225 Subaru 584,614 615,594 Kia 546,629 542,245 Mercedes (includes Sprinter) 332,990 318,012 BMW 271,432 276,657 VW 309,395 322,017 Mazda 262,577 274,455 Audi 199,534 200,558 Tesla (Est.) 40,320 106,050 Land Rover 66,759 81,526 Volvo 71828 89437 Mitsubishi 95,185 109,088 Porsche 51,507 53,116 MINI 42,494 40,887 Jaguar 36,180 27,021 Others 18,901 17,251 smart…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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Elementary Geometry For College Students, 7eGeometryISBN:9781337614085Author:Alexander, Daniel C.; Koeberlein, Geralyn M.Publisher:Cengage,
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
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
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Hypothesis Testing - Solving Problems With Proportions; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=76VruarGn2Q;License: Standard YouTube License, CC-BY
Hypothesis Testing and Confidence Intervals (FRM Part 1 – Book 2 – Chapter 5); Author: Analystprep;https://www.youtube.com/watch?v=vth3yZIUlGQ;License: Standard YouTube License, CC-BY