Concept explainers
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:
- a. Provide a percent frequency distribution and a histogram for each question.
- b. Where are most adults living now?
- c. Where do most adults consider the ideal community to be?
- d. What changes in living areas would you expect to see if people moved from where they currently live to their ideal community?
a.
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 area | Frequency | Percent frequency |
C | 32 | |
R | 16 | |
S | 26 | |
T | 26 |
What do you consider to be the ideal community?
Living area | Frequency | Percent frequency |
C | 24 | |
R | 21 | |
S | 25 | |
T | 30 |
The histogram for each question is as follows:
Where do you live now?
What do you consider to be the ideal community?
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:
The percent frequency distribution for each question is computed as follows:
Where do you live now?
Living area | Frequency | Percent frequency |
C | 32 | |
R | 16 | |
S | 26 | |
T | 26 | |
Total | 100 | 100 |
What do you consider to be the ideal community?
Living area | Frequency | Percent frequency |
C | 24 | |
R | 21 | |
S | 25 | |
T | 30 | |
Total | 100 | 100 |
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.
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.
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.
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 area | Living now | Ideal community | Difference |
C | 32 | 24 | |
R | 16 | 21 | |
S | 26 | 25 | |
T | 26 | 30 |
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?
Chapter 2 Solutions
Essentials Of Business Analytics
- There are four white, fourteen blue and five green marbles in a bag. A marble is selected from the bag without looking. Find the odds of the following: The odds against selecting a green marble. The odds in favour of not selecting a green marble The odds in favor of the marble selected being either a white or a blue marble. What is true about the above odds? Explainarrow_forwardPlease 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. 1. The probability of a soccer game in a particular league going into overtime is 0.125. Find the following: a. The odds in favour of a game going into overtime. b. The odds in favour of a game not going into overtime. c. If the teams in the league play 100 games in a season, about how many games would you expect to go into overtime?arrow_forwardexplain the importance of the Hypothesis test in a business setting, and give an example of a situation where it is helpful in business decision making.arrow_forward
- A college wants to estimate what students typically spend on textbooks. A report fromthe college bookstore observes that textbooks range in price from $22 to $186. Toobtain a 95% confidence level for a confidence interval estimate to plus or minus $10,how many students should the college survey? (We may estimate the populationstandard deviation as (range) ÷ 4.)arrow_forwardIn a study of how students give directions, forty volunteers were given the task ofexplaining to another person how to reach a destination. Researchers measured thefollowing five aspects of the subjects’ direction-giving behavior:• whether a map was available or if directions were given from memory without a map,• the gender of the direction-giver,• the distances given as part of the directions,• the number of times directions such as “north” or “left” were used,• the frequency of errors in directions. Identify each of the variables in this study, and whether each is quantitative orqualitative. For each quantitative variable, state whether it is discrete or continuous. Was this an observational study or an experimental study? Explain your answer.arrow_forwardexplain the difference between the confident interval and the confident level. provide an example to show how to correctly interpret a confidence interval.arrow_forward
- Sketch to scale the orbit of Earth about the sun. Graph Icarus’ orbit on the same set of axesWhile the sun is the center of Earth’s orbit, it is a focus of Icarus’ orbit. There aretwo points of intersection on the graph. Based on the graph, what is the approximate distance between the two points of intersection (in AU)?arrow_forwardThe diameters of ball bearings are distributed normally. The mean diameter is 67 millimeters and the standard deviation is 3 millimeters. Find the probability that the diameter of a selected bearing is greater than 63 millimeters. Round to four decimal places.arrow_forwardSuppose you like to keep a jar of change on your desk. Currently, the jar contains the following: 22 Pennies 27 Dimes 9 Nickels 30 Quarters What is the probability that you reach into the jar and randomly grab a penny and then, without replacement, a dime? Express as a fraction or a decimal number rounded to four decimal places.arrow_forward
- A box contains 14 large marbles and 10 small marbles. Each marble is either green or white. 9 of the large marbles are green, and 4 of the small marbles are white. If a marble is randomly selected from the box, what is the probability that it is small or white? Express as a fraction or a decimal number rounded to four decimal places.arrow_forwardCan I get help with this step please? At a shooting range, instructors can determine if a shooter is consistently missing the target because of the gun sight or because of the shooter's ability. If a gun's sight is off, the variance of the distances between the shots and the center of the shot pattern will be small (even if the shots are not in the center of the target). A student claims that it is the sight that is off, not his aim, and wants the instructor to confirm his claim. If a skilled shooter fires a gun at a target multiple times, the distances between the shots and the center of the shot pattern, measured in centimeters (cm), will have a variance of less than 0.33. After the student shoots 28 shots at the target, the instructor calculates that the distances between his shots and the center of the shot pattern, measured in cm, have a variance of 0.25. Does this evidence support the student's claim that the gun's sight is off? Use a 0.025 level of significance. Assume that the…arrow_forwardThe National Academy of Science reported that 38% of research in mathematics is published by US authors. The mathematics chairperson of a prestigious university wishes to test the claim that this percentage is no longer 38%. He has no indication of whether the percentage has increased or decreased since that time. He surveys a simple random sample of 279 recent articles published by reputable mathematics research journals and finds that 123 of these articles have US authors. Does this evidence support the mathematics chairperson's claim that the percentage is no longer 38 % ? Use a 0.02 level of significance. Compute the value of the test statistic. Round to two decimal places.arrow_forward
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill