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 3, Problem 39PE
The Excel File Rin’s Gym provides sample data on member body charactenstics and gym activity. Create PivotTables to find:
- a cross-tabulation of gender and body type versus BMI classification.
- average running times, run distance, weight lifting days, lifting session times, and time spent in the gym by gender.
Summarize your concIusions
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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…
Suppose the average monthly residential natural gas bill in a certain town is $67.95. How is the average monthly gas bill for a home in this town related to the square footage, number of rooms, and age of the home? The following tables shows the average monthly gas bill over the past year, square footage, number of rooms, and age for a sample of 20 homes.
Average Monthly GasBill for Last Year
Age
SquareFootage
Rooms
$70.20
16
2,537
6
$81.33
2
3,457
8
$45.86
27
976
6
$59.21
12
1,713
7
$117.88
16
3,979
10
$55.78
2
1,328
7
$47.01
27
1,251
6
$52.89
4
827
5
$32.90
12
645
4
$67.04
29
2,849
5
$76.76
1
2,372
7
$60.40
26
900
6
$44.07
14
1,386
5
$28.68
20
1,299
4
$62.70
17
1,441
6
$45.37
13
542
4
$38.09
10
2,140
4
$45.31
22
908
6
$52.45
25
1,568
5
$94.11
27
1,140
10
(a)
Develop an estimated regression equation that can be used to predict a residence's average monthly gas bill for last year given its age. (Use x1 for age. Round your numerical values…
a. Complete the last column of a copy of this table.
Ago
Number of People
Proportion of
Population
Under 18
74,181,467
0.2403
18–44
112,806,642
45-64
81,489,445
0.2639
65 and Over
40,267,984
Total
308,745,538
Source: Age and Sex Composition: 2010, Census Briefs, www.census.gov/prod/
cen2010/briefs/c2010br-03.pdf
Chapter 3 Solutions
Business Analytics (2nd Edition)
Ch. 3 - Create a line chart for the closing prices for all...Ch. 3 - Create a pie chart showing the breakdown of...Ch. 3 - The Excel tile Facebook Survey provides data...Ch. 3 - A national homebuilder builds single-family homes...Ch. 3 - Create a bubble chart for the first five colleges...Ch. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...Ch. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Apply three different colors of data bars to...
Ch. 3 - For the Store and Regional Sales database, apply a...Ch. 3 - For the Excel file Closing Stock Prices, Apply...Ch. 3 - Convert the Store and Regional Sales database to...Ch. 3 - Prob. 14PECh. 3 - Prob. 15PECh. 3 - Prob. 16PECh. 3 - Prob. 17PECh. 3 - In the Purchase Orders database, conduct a Pareto...Ch. 3 - Use Excels filtering capability to (1) extract all...Ch. 3 - Prob. 20PECh. 3 - The Excel file Credit Risk Date Provides...Ch. 3 - Prob. 22PECh. 3 - Prob. 23PECh. 3 - A community health-status survey obtained the...Ch. 3 - Prob. 25PECh. 3 - Prob. 26PECh. 3 - Prob. 27PECh. 3 - Prob. 28PECh. 3 - Prob. 29PECh. 3 - Prob. 30PECh. 3 - Find the 10th and 90th percentiles and 1st, 2nd,...Ch. 3 - Construct cross-tabulations of Gender versus...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Use PivotTables to construct a cross-tabulation...Ch. 3 - Create a PivotTable to find the average amount of...Ch. 3 - Use PivotTables to find the number of loans by...Ch. 3 - Use PivotTables to find the number of sales...Ch. 3 - Create a PivotTable for the data in the Excel file...Ch. 3 - The Excel File Rins Gym provides sample data on...Ch. 3 - Create useful dashboards for each of the following...Ch. 3 - A marketing researcher surveyed 92 individuals,...
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 price per share of stock for a sample of companies was recorded at the beginning of the first financial quarter and then again at the end of the first financial quarter. How stocks perform during the first quarter is an indicator of what is ahead for the stock market and the economy. Use the sample data in the file StockQuarter to answer the following. Click on the datafile logo to reference the data. Beginning of 1st end of 1stCompany Quarter QuarterBank of New York Mellon 53.82 54.19 Kraft Foods 77.02 55.70 E.I. du Pont de Nemours and Company 109.00 102.57 Consolidated Edison 83.58 79.95 Johnson & Johnson 139.23 126.01 Union Pacific…arrow_forwardPlease answer the questions in the photo and explain. Thank youarrow_forwardhow many sports played male vs female based on the dataarrow_forward
- A researcher from the ministry of education wants to find out if there is an academic difference in students from different parishes in Jamaica based on the CSEC examinations. He selected 20 students who completed the exam from three parishes; St James, St Ann, Kingston. He will assess them based on their English and Mathematics scores. Use the provided data to do the following questions. See the tablw below t answer Questions ID Parish English Mathematics 1 StJames 90 92 2 StJames 83 83 3 StJames 80 70 4 StJames 82 65 5 StJames 90 92 6 StJames 95 94 7 StJames 98 66 8 StJames 96 77 9 StJames 81 78 10 StJames 84 80 11 StJames 63 70 12 StJames 71 66 13 StJames 72 68 14 StJames 66 69 15 StJames 75 75 16 Kingston 79 74 17 kingston 67 63 18 kingston 65 62 19 kingston 65 77 20 kingston…arrow_forwardA research center conducts an extensive survey consisting of an interview and medical examination with a representative sample of about 5000 people a year. The interview includes demographic, socioeconomic, dietary, and other health-related questions. The examination consists of medical, dental, and physiological measurements, as well as laboratory tests administered by highly trained medical personnel. Describe the sample, the population, the Who and the What of this study. Describe the sample and the population. Choose the correct answer below. O A. The population is all the employees at the research center. The sample is the group of employees that actually conducted the survey. B. The population is all people. The sample is the 5000 people each year that partake in this survey. O C. In this case, the sample and population are both the 5000 people each year that partake in this survey. O D. The population is the 5000 people each year that partake in this survey. The sample is the…arrow_forwardFind the 5 number summary for the data shown below. 57 50 13 70 68 11 30 26 38 35 5 number summary:_,_,_,_,_arrow_forward
- Show the five-number summary for the following data: 5, 14, 17, 9, 8, 13, 16, 11, 6arrow_forwardConsider the following data set. Give the five number summary listing values in numerical order: Data set: 38, 58, 98, 67, 77, 52, 51, 55, 60, 38, 88, 43, 74, 83, 94, 35arrow_forwardIdentify whether the following data set is a population or a sample. A news reporter is conducting a study of Phoenix High School teachers. The reporter determined the average annual salary of all of the teachers at Phoenix High School. a) Sample b) Populationarrow_forward
arrow_back_ios
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher: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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Sampling Methods and Bias with Surveys: Crash Course Statistics #10; Author: CrashCourse;https://www.youtube.com/watch?v=Rf-fIpB4D50;License: Standard YouTube License, CC-BY
Statistics: Sampling Methods; Author: Mathispower4u;https://www.youtube.com/watch?v=s6ApdTvgvOs;License: Standard YouTube License, CC-BY