Bundle: Modern Business Statistics With Microsoft Excel, 5th + Cengagenow, 2 Term (12 Months) Printed Access Card
Bundle: Modern Business Statistics With Microsoft Excel, 5th + Cengagenow, 2 Term (12 Months) Printed Access Card
5th Edition
ISBN: 9781305135406
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 2.1, Problem 9E

a.

To determine

Construct the percent frequency distribution for each degree.

a.

Expert Solution
Check Mark

Answer to Problem 9E

The percent frequency distributions for where the adults live now are given below:

ResponsesPercent frequency
C32%
S26%
T26%
R16%
Total100%

The percent frequency distributions for ideal community are given below:

ResponsesPercent frequency
C24%
S25%
T30%
R21%
Total100%

Explanation of Solution

Calculation:

The data represent 46% of adults from Country U who would live in a different type of community than the one where they are living now. A sample of 2,260 adults is surveyed. The response options are City(C), Suburb(S), Small Town(T), or Rural(R).

For living now:

Frequency:

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

Here, “C (city)” is the response data, which is repeated 32 times in the data set and thus, 32 is the frequency for the response “C (city)”.

Similarly, the frequencies of the remaining responses are as follows:

ResponsesTallyFrequency
C||||||||||||||||||||||||||32
S|||||||||||||||||||||26
T|||||||||||||||||||||26
R|||||||||||||16
Total100

Relative frequency:

The general formula for relative frequency is given below:

RelativeFrequency = FrequencyTotal frequency

Therefore, the following value is obtained:

RelativeFrequencyfor C (City)=32100=0.32

Similarly, the relative frequencies for the remaining responses of a class are obtained below:

ResponsesFrequencyRelative frequency
C320.32
S2626100=0.26
T2626100=0.26
R1616100=0.16
Total1001.00

Percentage frequency distribution:

The general formula for percent frequency is given below:

Percent Frequency=RelativeFrequency×100

Therefore, the following value is obtained:

Percent Frequencyfor C "(City)"=0.32×100=32%

The percent frequencies for the remaining responses for living now are obtained below:

ResponsesRelative frequencyPercent frequency
C0.3232%
S0.260.26×100=26%
T0.260.26×100=26%
R0.160.16×100=16%
Total1.00100

For ideal community:

Here, “C (city)” is the response data, which is repeated 24 times in the data set and thus, 24 is the frequency for the response “C (city)”.

Similarly, the frequencies of the remaining types of department fields are given below:

ResponsesTallyFrequency
C||||||||||||||||||||24
S||||||||||||||||||||25
T||||||||||||||||||||||||30
R|||||||||||||||||21
Total100

Relative frequency:

RelativeFrequencyfor C (City)=24100=0.24

Similarly, the relative frequencies for the remaining responses are obtained as follows:

ResponsesFrequencyRelative frequency
C240.24
S2525100=0.25
T3030100=0.30
R2121100=0.21
Total1001.00

Percentage frequency distribution:

Percent Frequencyfor C "(City)"=0.24×100=24%

The percent frequencies for the remaining responses for ideal community are obtained as follows:

ResponsesRelative frequencyPercent frequency
C0.2424%
S0.250.25×100=25%
T0.300.30×100=30%
R0.210.21×100=21%
Total1.00100

b.

To determine

Construct the bar chart for each question.

b.

Expert Solution
Check Mark

Answer to Problem 9E

Output obtained from Excel for the response of the first question is given below:

Bundle: Modern Business Statistics With Microsoft Excel, 5th + Cengagenow, 2 Term (12 Months) Printed Access Card, Chapter 2.1, Problem 9E , additional homework tip  1

Output obtained from Excel for the response of the second question is given below:

Bundle: Modern Business Statistics With Microsoft Excel, 5th + Cengagenow, 2 Term (12 Months) Printed Access Card, Chapter 2.1, Problem 9E , additional homework tip  2

Explanation of Solution

Calculation:

For living now:

Software procedure:

Step-by-step procedure to draw the bar chart for the first question using Excel:

  • In Excel sheet, enter Living now in one column and Frequency in another column.
  • Select the data and then choose Insert > Insert Column Bar Charts.
  • Select Clustered Column Under More Column Charts.
  • For ideal community:

Software procedure:

Step-by-step procedure to draw the bar chart for ideal community using Excel:

  • In Excel sheet, enter Ideal community in one column and Frequency in another column.
  • Select the data and then choose Insert > Insert Column Bar Charts.
  • Select Clustered Column Under More Column Charts.

c.

To determine

Find the community in which most of the adults are living now.

c.

Expert Solution
Check Mark

Answer to Problem 9E

Most of the adults are now living in a city.

Explanation of Solution

For living now, the percentage for city is 32%, which is high when compared to the other communities.

Thus, most of the adults are now living in a city.

d.

To determine

Identify the community that most of the adults consider as the ideal community.

d.

Expert Solution
Check Mark

Answer to Problem 9E

Most of the adults consider the ideal community as a small town.

Explanation of Solution

For ideal community, the percentage for small town is 30%, which is high when compared to the other communities.

Thus, most of the adults consider the ideal community as a small town.

e.

To determine

Identify the changes in living areas that one would expect to see if people moved from where they currently live to their ideal community.

e.

Expert Solution
Check Mark

Explanation of Solution

Calculation:

In order to obtain the changes in living areas when people moved from where they currently live to their ideal community, one would expect to find the difference between the two.

Difference=Ideal community frequencyliving now percent frequency

Therefore, the value is obtained as follows:

Difference for City(C)=24%32%=8%

The differences between the living now and the ideal community are tabulated as follows:

ResponsesLiving nowIdeal communityDifference
C32%24%–8%
S26%25%–1%
T26%30%+4%
R16%21%+5%

From the table, it is observed that the living area “city” has the largest decrease in percentage from living now to ideal community. For suburb, living is steady. For small towns and rural areas, the percentage of living increases.

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

Bundle: Modern Business Statistics With Microsoft Excel, 5th + Cengagenow, 2 Term (12 Months) Printed Access Card

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 - CEO Time in Meetings. The London School of...Ch. 2.2 - Prob. 21ECh. 2.2 - Top U.S. Franchises. Entrepreneur magazine ranks...Ch. 2.2 - Prob. 23ECh. 2.2 - Prob. 24ECh. 2.2 - Prob. 25ECh. 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 - Prob. 29ECh. 2.3 - Refer again to the crosstabulation of household...Ch. 2.3 - 31. Recently, management at Oak Tree Golf Course...Ch. 2.3 - Table 2.12 shows a data set containing...Ch. 2.3 - Prob. 33ECh. 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 - Prob. 40ECh. 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 - Prob. 45SECh. 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 - Prob. 49SECh. 2 - Prob. 50SECh. 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...
Knowledge Booster
Background pattern image
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
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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