Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
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
bartleby

Videos

Question
Chapter 2.1, Problem 9E

a.

To determine

Construct the percent frequency distribution of field of study for the various degrees.

a.

Expert Solution
Check Mark

Answer to Problem 9E

The percent frequency distribution for bachelor’s degree is as follows:

Bachelor’s degreePercent frequency
B21%
CSE9%
E6%
H16%
NSM8%
O24%
SBS16%

The percent frequency distribution for Master’s degree is as follows:

Master’s degreePercent frequency
B27%
CSE9%
E24%
H8%
NSM2%
O24%
SBS6%

Explanation of Solution

Calculation:

The fields of studies in which a bachelor’s degrees and a master’s degree are provided, are given for a sample of 100 graduates. The respective categories are Business (B), Computer science and Engineering (CSE), Education (E), Natural sciences and Mathematics (NSM), Social and Behavioral sciences (SBS) and Other (O).

For Bachelor’s degree:

Frequency:

The frequencies are calculated by using the tally mark. Here, the number of times each class repeats is the frequency of that particular class.

Here, “B” is the category, which is repeated for 21 times in the data set and thus, 21 is the frequency for the category B.

Similarly, the frequencies of the remaining categories are given below:

Bachelor’s degreeTallyFrequency
B|||||||||||||||||21
CSE||||||||9
E|||||6
H|||||||||||||16
NSM|||||||||||||||8
O||||||||||||||||||||24
SBS|||||||||||||16
Total100

Relative frequency:

The general formula for the relative frequency is,

RelativeFrequency = FrequencyTotal frequency.

Therefore,

RelativeFrequencyfor B (Business)=21100=0.21

Similarly, the relative frequencies for the remaining types of classes are obtained below:

Bachelor’s degreeFrequencyRelative frequency
B2121100=0.21
CSE99100=0.09
E66100=0.06
H1616100=0.16
NSM88100=0.08
O2424100=0.24
SBS1616100=0.16
Total100100100=1

Percentage frequency distribution:

The general formula for the percent frequency is,

Percent Frequency=RelativeFrequency×100.

Therefore,

Percent Frequencyfor B (Business)=0.21×100=21%

The percent frequencies for the remaining types of categories of education fields for Bachelor’s degree are obtained below:

Bachelor’s degreeRelative frequencyPercent frequency
B0.2121%
CSE0.099%
E0.066%
H0.1616%
NSM0.088%
O0.2424%
SBS0.1616%
Total1.00100

For Master’s degree:

Here, “B” is the department, which is repeated for 27 times in the data set and thus, 27 is the frequency for the category business (B).

Similarly, the frequencies of remaining types of departments are given below:

Master’s degreeTallyFrequency
B||||||||||||||||||||||27
CSE||||||||9
E||||||||||||||||||||24
H|||||||8
NSM||2
O||||||||||||||||||||24
SBS|||||6
Total100

Relative frequency:

RelativeFrequencyfor B (Business)=27100=0.27

Similarly, the relative frequencies for the remaining types of classes (PPG) are obtained below:

Master’s degreeFrequencyRelative frequency
B2727100=0.27
CSE99100=0.09
E2424100=0.24
H88100=0.08
NSM22100=0.02
O2424100=0.24
SBS66100=0.06
Total100100100=1

Percentage frequency distribution:

Percent Frequencyfor B (Business)=0.27×100=27%

The percent frequencies for the remaining types of categories of education fields for Master’s degree are obtained below:

Master’s degreeRelative FrequencyPercent frequency
B0.2727%
CSE0.099%
E0.2424%
H0.088%
NSM0.022%
O0.2424%
SBS0.066%
Total1.00100

b.

To determine

Construct the bar charts for the two degrees.

b.

Expert Solution
Check Mark

Answer to Problem 9E

  • The bar chart for Bachelor’s degree is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 2.1, Problem 9E , additional homework tip  1

  • The bar chart for Bachelor’s degree is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 2.1, Problem 9E , additional homework tip  2

Explanation of Solution

Calculation:

The bar charts can be obtained using software.

Bachelor’s degree:

Software procedure:

Step-by-step procedure to draw the bar chart using EXCEL software:

  • Open an EXCEL sheet.
  • Enter the fields of study in Bachelor’s degree and the corresponding frequencies in columns A and B respectively, under the headings of Bachelor’s degree in cell A1 and Percent Frequency in cell B1.
  • Select the entered data along with the headings.
  • Choose Insert > Column > 2-D Column > Clustered Column.
  • Choose Layout > Chart Title > Above Chart and enter Bar Chart for Bachelor’s Degree.
  • Choose Layout > Axis Title > Primary Horizontal Axis Title > Title Below Axis and enter Bachelor’s Degree Field of Study.
  • Choose Layout > Axis Title > Primary Vertical Axis Title > Rotated Title and enter Percent Frequency.

Hence, the bar chart for the Bachelor’s degree data is obtained using EXCEL software.

  • Master’s degree:

Software procedure:

Step-by-step procedure to draw the bar chart using EXCEL software:

  • Open an EXCEL sheet.
  • Enter the fields of study in Master’s degree and the corresponding frequencies in columns A and B respectively, under the headings of Master’s degree in cell A1 and Percent Frequency in cell B1.
  • Select the entered data along with the headings.
  • Choose Insert > Column > 2-D Column > Clustered Column.
  • Choose Layout > Chart Title > Above Chart and enter Bar Chart for Master’s Degree.
  • Choose Layout > Axis Title > Primary Horizontal Axis Title > Title Below Axis and enter Master’s Degree Field of Study.
  • Choose Layout > Axis Title > Primary Vertical Axis Title > Rotated Title and enter Percent Frequency.

Hence, the bar chart for the Master’s degree data is obtained using EXCEL software.

c.

To determine

Find the lowest percentage field of study for each degree.

c.

Expert Solution
Check Mark

Answer to Problem 9E

The lowest percentage field of study for a Bachelor’ degree is Education.

The lowest percentage field of study for a Master’s degree is Natural science and Mathematics.

Explanation of Solution

From the percent frequencies in Part a, it is found that for Bachelor’ degree, the percentage for Education (E) is 6%, which is the lowest when compared to the other categories.

For Master’s degree, the percentage for Natural science and Mathematics (NSM) is 2%, which is the lowest when compared to the other categories.

d.

To determine

Find the highest percentage field of study for each degree.

d.

Expert Solution
Check Mark

Answer to Problem 9E

The highest percentage field of study for a Bachelor’ degree is Others.

The highest percentage field of study for a Master’s degree is Business.

Explanation of Solution

From the percent frequencies in Part a, it is found that for the Other (O) category, the percentage is 24%, which is the highest when compared to the other categories.

For Master’s degree, the percentage for Business (B) is 27%, which is the highest when compared to the other categories.

e.

To determine

Identify the field of study that has the largest increase in percentage from bachelor’s to masters’.

e.

Expert Solution
Check Mark

Answer to Problem 9E

The field of study Education has the largest increase in percentage from bachelor’s to masters’.

Explanation of Solution

Calculation:

In order to the obtain the study field that has the largest increase in percentage from bachelor’s to Masters’ is calculated by obtaining the difference between two respective percentages.

Difference=Master's percent frequencyBachelor's percent frequency

Therefore,

Difference for Business(B)=Master's percent frequency(B)Bachelor's percent frequency(B)=27%21%=6%

The differences between two fields are tabulated below:

FieldBachelor’sMaster’sDifference (Master’s – Bachelor’s)
B21%27%(27 – 21)% = 6%
CSE9%9%(9 – 9)% = 0%
E6%24%(24 – 6)% = 18%
H16%8%(8 – 16)% = –8%
NSM8%2%(2 – 8)% = –6%
O24%24%(24 – 24)% = 0%
SBS16%6%(6 – 16)% = –10%

From the table, it is observed that the field of study Education has the largest increase in percentage (6%) from bachelor’s to masters’ degree.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 2 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Ch. 2.2 - 11. Consider the following data. Develop a...Ch. 2.2 - 12. Consider the following frequency...Ch. 2.2 - Construct a histogram for the data in exercise...Ch. 2.2 - Prob. 14ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Applications 17. A doctor’s office staff studied...Ch. 2.2 - NBA Total Player Ratings. CBSSports.com developed...Ch. 2.2 - Prob. 19ECh. 2.2 - CEO Time in Meetings. The London School of...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Top U.S. Franchises. Entrepreneur magazine ranks...Ch. 2.2 - Prob. 24ECh. 2.2 - Best Paying College Degrees. Each year America.EDU...Ch. 2.2 - Prob. 26ECh. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - Daytona 500 Automobile Makes Average Speeds. The...Ch. 2.3 - Daytona 500 Average Speeds of Winners. The...Ch. 2.3 - 31. Recently, management at Oak Tree Golf Course...Ch. 2.3 - Household Income Levels. The following...Ch. 2.3 - 33. Each year Forbes ranks the world’s most...Ch. 2.3 - Prob. 34ECh. 2.3 - The U.S. Department of Energy's Fuel Economy...Ch. 2.4 - The following 20 observations are for two...Ch. 2.4 - Prob. 37ECh. 2.4 - The following crosstabulation summarizes the data...Ch. 2.4 - Driving Speed and Fuel Efficiency. A study on...Ch. 2.4 - The DATAfile Snow contains average annual snowfall...Ch. 2.4 - Hypertension and Heart Disease. People often wait...Ch. 2.4 - Smartphones are mobile phones with Internet,...Ch. 2.4 - Store Managers Time Study. The Northwest regional...Ch. 2 - SAT Scores. The SAT is a standardized test used by...Ch. 2 - Median Household Incomes. The file MedianHousehold...Ch. 2 - State Populations. Data showing the population by...Ch. 2 - Startup Company Funds. According to the Wall...Ch. 2 - Complaints Reported to BBB. Consumer complaints...Ch. 2 - Stock Price Volatility. The term “beta” refers to...Ch. 2 - Education Level and Household Income. The U.S....Ch. 2 - Prob. 51SECh. 2 - Best Places to Work. Fortune magazine publishes an...Ch. 2 - Prob. 53SECh. 2 - Prob. 54SECh. 2 - Prob. 55SECh. 2 - Prob. 56SECh. 2 - Google has changed its strategy with regard to...Ch. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Motion Picture Industry The motion picture...Ch. 2 - Cincinnati, Ohio, also known as the Queen City,...Ch. 2 - Jon Weideman, first shift foreman for Cut-Rate...
Knowledge Booster
Statistics
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.
Recommended textbooks for you
  • 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
  • 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
    What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
    What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY