Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 4, Problem 1.22PE
Use PivotTables to construct cross-tabulations for (1) gender and preferred style and (2) gender and purchase influence in the Excel file Retail Survey.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Each week the Wall Street Journal and Harris Interactive track the opinions and experiences of college recruiters for large corporations and summarize the results in the Business School Survey. Data have been gathered for the top 10 business schools from a list of 76 and is summarized below.
Please complete the questions below and upload this document and your EXCEL document to the portal in CANVAS.
School
Ranking
Enrollment
(# of full-time students)
Annual Tuition
($)
Mean GMAT
% with Job Offer
Average Salary ($)
Dartmouth
1
503
38,400
704
89
119,800
Michigan
2
1873
33,076
690
91
105,986
Carnegie Mellon
3
661
38,800
691
93
95,531
Northwestern
4
2650
38,844
700
94
117,060
Yale
5
468
36,800
696
86
104,018
Pennsylvania
6
1840
40,458
716
92
117,471
California Berkeley
7
1281
21,512
701
92
112,699
Columbia
8
1796
38,290
709
95
126,319
North…
Please help with part d. Thanks!
What is ranked data?
Chapter 4 Solutions
Business Analytics
Ch. 4 - Explain the science of statistics.Ch. 4 - What is a metric? How does it differ from a...Ch. 4 - Explain the difference between a discrete and a...Ch. 4 - Describe the four types of measurement scales and...Ch. 4 - What is a frequency distribution?Ch. 4 - Explain how to calculate a relative frequency.Ch. 4 - State how to use Excel for constructing frequency...Ch. 4 - State the features and limitations of the Excel...Ch. 4 - What does an ogive display?Ch. 4 - Prob. 2.6CYU
Ch. 4 - Prob. 3.1CYUCh. 4 - Prob. 3.2CYUCh. 4 - Prob. 3.3CYUCh. 4 - What is a cross-tabulation?Ch. 4 - Prob. 4.2CYUCh. 4 - Explain the difference between a population and a...Ch. 4 - List and explain the common measures of location...Ch. 4 - Prob. 5.3CYUCh. 4 - Prob. 5.4CYUCh. 4 - Prob. 5.5CYUCh. 4 - Prob. 5.6CYUCh. 4 - Prob. 5.7CYUCh. 4 - Prob. 5.8CYUCh. 4 - Prob. 6.1CYUCh. 4 - Use Excel to find the mean and variance for the...Ch. 4 - Prob. 7.1CYUCh. 4 - Prob. 7.2CYUCh. 4 - Prob. 8.1CYUCh. 4 - Prob. 8.2CYUCh. 4 - Prob. 9.1CYUCh. 4 - Prob. 9.2CYUCh. 4 - Prob. 9.3CYUCh. 4 - What rules are typically used to identify...Ch. 4 - Prob. 10.2CYUCh. 4 - Summarize statistical tools that are typically...Ch. 4 - Prob. 11.2CYUCh. 4 - What are the principles of statistical thinking?Ch. 4 - Prob. 12.2CYUCh. 4 - Prob. 12.3CYUCh. 4 - A survey handed out to individuals at a major...Ch. 4 - Prob. 1.2PECh. 4 - Identify each of the variables in the Excel file...Ch. 4 - Prob. 1.4PECh. 4 - Prob. 1.5PECh. 4 - Prob. 1.6PECh. 4 - Prob. 1.7PECh. 4 - Prob. 1.8PECh. 4 - Prob. 1.9PECh. 4 - Prob. 1.10PECh. 4 - Prob. 1.11PECh. 4 - Prob. 1.12PECh. 4 - Use a PivotTable to construct a frequency...Ch. 4 - Prob. 1.14PECh. 4 - Prob. 1.15PECh. 4 - Prob. 1.16PECh. 4 - Prob. 1.17PECh. 4 - Prob. 1.18PECh. 4 - Prob. 1.19PECh. 4 - Prob. 1.20PECh. 4 - Use a PivotTable to construct a cross-tabulation...Ch. 4 - Use PivotTables to construct cross-tabulations for...Ch. 4 - Prob. 1.23PECh. 4 - Prob. 1.24PECh. 4 - Prob. 1.25PECh. 4 - Compute the mean, median, midrange, and mode for...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - Considering the data in the Excel file Home Market...Ch. 4 - In the Excel file Facebook Survey, find the range,...Ch. 4 - Prob. 1.30PECh. 4 - For the Excel file Tablet Computer Sales, find the...Ch. 4 - The Excel file Atlanta Airline Data provides...Ch. 4 - Prob. 1.33PECh. 4 - Prob. 1.34PECh. 4 - Apply the Descriptive Statistics tool for subsets...Ch. 4 - Use the Descriptive Statistics tool to summarize...Ch. 4 - Prob. 1.38PECh. 4 - The Data worksheet in the Excel file Airport...Ch. 4 - Prob. 1.40PECh. 4 - Prob. 1.41PECh. 4 - Prob. 1.42PECh. 4 - Prob. 1.43PECh. 4 - Prob. 1.44PECh. 4 - Prob. 1.45PECh. 4 - Prob. 1.46PECh. 4 - Prob. 1.47PECh. 4 - Prob. 1.48PECh. 4 - Prob. 1.49PECh. 4 - Prob. 1.50PECh. 4 - Prob. 1.51PECh. 4 - Prob. 1.52PECh. 4 - Prob. 1.53PECh. 4 - In the Excel file Debt and Retirement Savings, use...Ch. 4 - Prob. 1.55PECh. 4 - Prob. 1.56PECh. 4 - Prob. 1.57PECh. 4 - Prob. 1.58PECh. 4 - Prob. 1.59PECh. 4 - In the Excel file Weddings, determine the...Ch. 4 - Prob. 1.61PECh. 4 - The Excel file Beverage Sales lists a sample of...Ch. 4 - For the Presidents Inn Guest Database, find the...Ch. 4 - Prob. 1.64PECh. 4 - For the Excel file Credit Risk Data, compute the...Ch. 4 - Compute the z-scores for the data in the Excel...Ch. 4 - Prob. 1.67PECh. 4 - In the Excel file Weddings, find the mean, median,...Ch. 4 - Use the following approaches to analyze the survey...Ch. 4 - Prob. 1.70PECh. 4 - A producer of computer-aided design software for...Ch. 4 - Prob. 1.72PECh. 4 - Prob. 1.73PECh. 4 - A Midwest pharmaceutical company manufactures...Ch. 4 - Find the mean and variance of a deck of 52 cards,...Ch. 4 - Elizabeth Burke has received several questions...
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 researcher wants to analyse whether there is a relationship between country of origin of International students in Sydney and the suburb they currently live in. Suggest data collection approach for the researcher.arrow_forwardHow can I gather data about the gender pay gap in Canada and how policies in the public and private sector affect it and use that data to make a box plot to represent itarrow_forwardSuppose you need to summarize ordinal data in a bar graph. How would you arrange the categories of data on the horizontal axis? Is it possible to make the order of the data apparent in a pie chart?arrow_forward
- On December 17, 2007 baseball writer John Hickey wrote an article for the Seattle P-I about increases to ticket prices for Seattle Mariners games during the 2008 season. The article included a data set that listed the average ticket price for each MLB team, the league in which the team plays (AL or NL), the number of wins during the 2007 season and the cost per win (in dollars). The data for the 16 National League teams are shown below. league price wins cost/win team Arizona Diamondbacks NL 19.68 90 35.40 Atlanta Braves NL 17.07 84 32.89 Chicago Cubs NL 34.30 85 65.33 cincinnati Reds NL 17.90 72 40.32 Colorado Rockies NL 14.72 90 26.67 Florida Marlins NL 16.70 71 38.13 Houston Astros NL 26.66 73 59.11 Los Angeles Dodgers 20.09 82 34.64 NL Milwaukee Brewers NL 18.11 83 35.37 N.Y. Mets NL 25.28 88 46.56 Philadelphia Phillies 26.73 89 48.69 NL Pittsburgh Pirates NL 17.08 68 40.67 San Diego Padres NL 20.83 89 38.15 San Francisco Giants NL 24.53 71 56.00 St. Louis Cardinals NL 29.78 78…arrow_forwardExplain how the interquartile range of a data set can be used to identify outliers.arrow_forwardHow will a high outlier in a data set affect the mean and median?arrow_forward
- Create a side-by-side boxplot for vitamin D level vs. NewAge and a side- by-side boxplot for vitamin D level vs. country. Create a scatterplot to show the relationship between vitamin D level and Age. Compare these two side-by-side boxplots and the scatterplot and explain your findings. • Note: Write appropriate captions for the tables, graphs, and outputs.arrow_forward2. Sketch a Pie chart for the variable Phone. Describe the data distribution.iPhone iPhone iPhone iPhone iPhone iPhone iPhone iPhone iPhone iPhoneiPhone iPhone iPhone iPhone iPhone Motorola Samsung Samsung Samsung Samsungarrow_forwardCreate a stem-and-leaf plot from the following data set listing the ages of 19 people attending a seminar on higher education: {9, 12, 13, 15, 17, 18, 18, 19, 19, 20, 21, 21, 21, 23, 24, 24, 25, 26, 30} . Upload your response. UPLOAD WDITEDarrow_forward
- Please answer letter barrow_forwardGive an example of a set of data that might be better represented by the median than the mean. Explain why.arrow_forwardExercise 2 Histogram, Ogive, Frequency polygon, Pie chart, Stem-Leaf plot and Box Plot are different types of data presenting in Statistics. Write down a compari- son table for all; it should cover: a short definition, its figure, the advantages and the disadvantages.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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
Introduction to Statistical Quality Control (SQC); Author: FORSEdu;https://www.youtube.com/watch?v=c18FKHUDZv8;License: Standard YouTube License, CC-BY
[DAXX] Introduction to Statistical Quality Control; Author: The Academician;https://www.youtube.com/watch?v=ypZGDxjSM60;License: Standard Youtube License