Essentials Of Business Analytics
Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 8P

Reports have found that many U.S. adults would rather live in a different type of community than the one in which they are living now. A national survey of 2,260 adults asked: “Where do you live now?” and “What do you consider to be the ideal community?” Response options were City (C), Suburb (S), Small Town (T), or Rural (R). A representative portion of this survey for a sample of 100 respondents is as follows:

Chapter 2, Problem 8P, Reports have found that many U.S. adults would rather live in a different type of community than the

  1. a. Provide a percent frequency distribution and a histogram for each question.
  2. b. Where are most adults living now?
  3. c. Where do most adults consider the ideal community to be?
  4. d. What changes in living areas would you expect to see if people moved from where they currently live to their ideal community?

a.

Expert Solution
Check Mark
To determine

Create a percent frequency distribution and histogram for each question.

Answer to Problem 8P

The percent frequency distribution for each question is as follows:

Where do you live now?

Living areaFrequencyPercent frequency
C3232100×100=32
R1616100×100=16
S2626100×100=26
T2626100×100=26

What do you consider to be the ideal community?

Living areaFrequencyPercent frequency
C2424100×100=24
R2121100×100=21
S2525100×100=25
T3030100×100=30

The histogram for each question is as follows:

Where do you live now?

Essentials Of Business Analytics, Chapter 2, Problem 8P , additional homework tip  1

What do you consider to be the ideal community?

Essentials Of Business Analytics, Chapter 2, Problem 8P , additional homework tip  2

Explanation of Solution

Frequency distribution:

It is a table that summarizes the frequency of data values in each of several nonoverlapping bins.

Percent frequency distribution:

It is a table that summarizes the percentage of data values in each of the nonoverlapping bins.

Step-by-step procedure to obtain frequency data using EXCEL:

  • Select A1:B101.
  • Select Insert > PivotTable.
  • Under Select a table or range, enter “$A$1:$A$101” in Table/Range.
  • Click OK.
  • Drag Where do you live now? to Rows.
  • Drag Where do you live now? to ∑ Values.
  • Click on Where do you live now? in ∑ Values.
  • Select Value Field Settings.
  • In Summarize value field by, choose Count and click OK.
  • Now, click on Where do you live now? and Count of Where do you live now? in Drag fields between areas below and Remove Field.
  • Drag What do you consider to be the ideal community? to Rows.
  • Drag What do you consider to be the ideal community? to ∑ Values.
  • Click on What do you consider to be the ideal community? in ∑ Values.
  • Select Value Field Settings.
  • In Summarize value field by, choose Count and click OK.

Outputs obtained is as follows:

Essentials Of Business Analytics, Chapter 2, Problem 8P , additional homework tip  3

Essentials Of Business Analytics, Chapter 2, Problem 8P , additional homework tip  4

The percent frequency distribution for each question is computed as follows:

Where do you live now?

Living areaFrequencyPercent frequency
C3232100×100=32
R1616100×100=16
S2626100×100=26
T2626100×100=26
Total100100

What do you consider to be the ideal community?

Living areaFrequencyPercent frequency
C2424100×100=24
R2121100×100=21
S2525100×100=25
T3030100×100=30
Total100100

Step-by-step procedure to plot histogram using EXCEL:

  • Select Insert.
  • Choose Insert Column or Bar Chart under Charts.
  • In Series Options, enter Gap Width as 0%.

Similarly, the histogram for the other question also obtained.

Thus, the percent frequency distribution and histogram are obtained.

b.

Expert Solution
Check Mark
To determine

Find the community where most adults are living now.

Answer to Problem 8P

The most adults are living in City (C).

Explanation of Solution

From Part (a), it is clear that for the question “Where do you live now?”, the percent frequency for City (C) is 32, which is highest when compared to other community.

Therefore, the most adults are living in City (C).

c.

Expert Solution
Check Mark
To determine

Find the community where most adults consider the ideal community to be.

Answer to Problem 8P

The community where most adults consider the ideal community is Small Town (T).

Explanation of Solution

From Part (a), it is clear that for the question “What do you consider to be the ideal community?”, the percent frequency for Small Town (T) is 30, which is highest when compared to other community.

Therefore, the most adults are living in Small Town (T).

d.

Expert Solution
Check Mark
To determine

Explain the expected changes in living areas if people moved from where they currently live to their ideal community.

Explanation of Solution

The percent frequency distribution is obtained in Part (a). The difference between the percent frequencies for ideal community and currently living community is computed as follows:

Living areaLiving nowIdeal communityDifference
C32242432=8
R16212116=5
S26252526=1
T26303026=4

It is clear that there is no substantial change in Suburb living (S). However, the difference in percent between ideal community and currently living community is high for Small Town (T) and Rural (R). Hence, it would be expected that living in City (C) would decline, whereas, living in Small Towns (T) and Rural (R) would increase.

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!
Students have asked these similar questions
An Arts group holds a raffle.  Each raffle ticket costs $2 and the raffle consists of 2500 tickets.  The prize is a vacation worth $3,000.    a. Determine your expected value if you buy one ticket.     b. Determine your expected value if you buy five tickets.     How much will the Arts group gain or lose if they sell all the tickets?
Please show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy.        Consider the following game.  It costs $3 each time you roll a six-sided number cube.  If you roll a 6 you win $15.  If you roll any other number, you receive nothing.   a) Find the expected value of the game.         b) If you play this game many times, will you expect to gain or lose money?
= 12:02 WeBWorK / 2024 Fall Rafeek MTH23 D02 / 9.2 Testing the Mean mu / 3 38 WEBWORK Previous Problem Problem List Next Problem 9.2 Testing the Mean mu: Problem 3 (1 point) Test the claim that the population of sophomore college students has a mean grade point average greater than 2.2. Sample statistics include n = 71, x = 2.44, and s = 0.9. Use a significance level of a = 0.01. The test statistic is The P-Value is between : The final conclusion is < P-value < A. There is sufficient evidence to support the claim that the mean grade point average is greater than 2.2. ○ B. There is not sufficient evidence to support the claim that the mean grade point average is greater than 2.2. Note: You can earn partial credit on this problem. Note: You are in the Reduced Scoring Period. All work counts for 50% of the original. Preview My Answers Submit Answers You have attempted this problem 0 times. You have unlimited attempts remaining. . Oli wwm01.bcc.cuny.edu

Chapter 2 Solutions

Essentials Of Business Analytics

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.
Similar questions
SEE MORE QUESTIONS
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
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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