# Get questions and answers for Elementary Statistics Excel

## GET Elementary Statistics Excel TEXTBOOK SOLUTIONS

1 Million+ Step-by-step solutions

What is the probability that fewer than three of the five flights arrive on time?

In a survey, cell phone users were asked which ear they use to hear their cell phone, and the table is based on their responses (based on data from “Hemispheric Dominance and Cell Phone Use,” by Seidman et al., JAMA Otolaryngology—Head & Neck Surgery, Vol. 139, No. 5).

P(x)
Left .......................... 0.636
Right ........................ 0.304
No preference......... 0.060

Determine whether a probability distribution is given. If a probability distribution is given, find its mean and standard deviation. If a probability distribution is not given, identify the requirements that are not satisfied.

In a recent year, the author wrote 181 checks. Find the probability that on a randomly selected day, he wrote at least one check.

Use the Poisson distribution to find the indicated probabilities.

If 12 adult smartphone users are randomly selected, find the probability that fewer than 3 of them use their smartphones in meetings or classes.

Based on data from Bloodjournal.org, 10% of women 65 years of age and older have anemia, which is a deficiency of red blood cells. In tests for anemia, blood samples from 8 women 65 and older are combined. What is the probability that the combined sample tests positive for anemia? Is it likely for such a combined sample to test positive?

A researcher collects a simple random sample of grade-point averages of statistics students, and she calculates the mean of this sample. Under what conditions can that sample mean be treated as a value from a population having a normal distribution?

Data Set 1 “Body Data” in Appendix B includes the heights of 147 randomly selected women, and heights of women are normally distributed. If you were to construct a histogram of the 147 heights of women in Data Set 1, what shape do you expect the histogram to have? If you were to construct a normal quantile plot of those same heights, what pattern would you expect to see in the graph?

Data set 1

Sketch a graph showing the shape of the distribution of bone density test scores.

Assume that scores on a bone mineral density test are normally distributed with a mean of 0 and a standard deviation of 1.

Weights of golden retriever dogs are normally distributed. Samples of weights of golden retriever dogs, each of size n = 15, are randomly collected and the sample means are found. Is it correct to conclude that the sample means cannot be treated as being from a normal distribution because the sample size is too small? Explain.

After constructing a histogram of the ages of the 147 women included in Data Set 1 “Body Data” in Appendix B, you see that the histogram is far from being bell-shaped. What do you now know about the pattern of points in the normal quantile plot?

Data set 1

Find the score separating the lowest 9% of scores from the highest 91%.

Assume that scores on a bone mineral density test are normally distributed with a mean of 0 and a standard deviation of 1.

Data set 29 “Coin Weights” in Appendix B includes weights of 20 one-dollar coins. Given that the sample size is less than 30, what requirement must be met in order to treat the sample mean as a value from a normally distributed population? Identify three tools for verifying that requirement.

Data set 29

Identify the two requirements necessary for a normal distribution to be a standard normal distribution.

For a randomly selected subject, find the probability of a score greater than -2.93.

Assume that scores on a bone mineral density test are normally distributed with a mean of 0 and a standard deviation of 1.

The accompanying histogram is constructed from the diastolic blood pressure measurements of the 147 women included in Data Set 1 “Body Data” in Appendix B. If you plan to conduct further statistical tests and there is a loose requirement of a normally distributed population, what do you conclude about the population distribution based on this histogram?

Data set 1

Each week, Nielsen Media Research conducts a survey of 5000 households and records the proportion of households tuned to 60 Minutes. If we obtain a large collection of those proportions and construct a histogram of them, what is the approximate shape of the histogram?

For a randomly selected subject, find the probability of a score between 0.87 and 1.78.

Assume that scores on a bone mineral density test are normally distributed with a mean of 0 and a standard deviation of 1.

The normal quantile plot represents the ages of presidents of the United States at the times of their inaugurations. The data are from Data Set 15 “Presidents” in Appendix B.

Data set 15

Refer to the continuous uniform distribution depicted in Figure 6-2 and described in Example 1. Assume that a passenger is randomly selected, and find the probability that the waiting time is within the given range.

Greater than 3.00 minutes

Figure 6-2

The normal quantile plot represents weights (pounds) of the contents of cans of Diet Pepsi from Data Set 26 “Cola Weights and Volumes” in Appendix B.

Data set 26

Refer to the continuous uniform distribution depicted in Figure 6-2 and described in Example 1. Assume that a passenger is randomly selected, and find the probability that the waiting time is within the given range.

Less than 4.00 minutes

Figure 6-2

Find the probability that a randomly selected woman has a normal diastolic blood pressure level, which is below 80 mm Hg.

Assume that women have diastolic blood pressure measures that are normally distributed with a mean of 70.2 mm Hg and a standard deviation of 11.2 mm Hg (based on Data Set 1 “Body Data” in Appendix B).

Data set 1

The normal quantile plot represents service times during the dinnerhours at Dunkin’ Donuts (from Data Set 25 “Fast Food” in Appendix  B).

Data set 25

Refer to the continuous uniform distribution depicted in Figure 6-2 and described in Example 1. Assume that a passenger is randomly selected, and find the probability that the waiting time is within the given range.

Between 2 minutes and 3 minutes

Figure 6-2

Find the probability that a randomly selected woman has a diastolic blood pressure level between 60 mm Hg and 80 mm Hg.

Assume that women have diastolic blood pressure measures that are normally distributed with a mean of 70.2 mm Hg and a standard deviation of 11.2 mm Hg (based on Data Set 1 “Body Data” in Appendix B).

Data set 1

The normal quantile plot represents the distances (miles) that tornadoes traveled (from Data Set 22 “Tornadoes” in Appendix B).

Data set 22

Refer to the continuous uniform distribution depicted in Figure 6-2 and described in Example 1. Assume that a passenger is randomly selected, and find the probability that the waiting time is within the given range.

Between 2.5 minutes and 4.5 minutes

Figure 6-2

Find P90, the 90th percentile for the diastolic blood pressure levels of women.

Assume that women have diastolic blood pressure measures that are normally distributed with a mean of 70.2 mm Hg and a standard deviation of 11.2 mm Hg (based on Data Set 1 “Body Data” in Appendix B).

Data set 1

If 16 women are randomly selected, find the probability that the mean of their diastolic blood pressure levels is less than 75 mm Hg.

Assume that women have diastolic blood pressure measures that are normally distributed with a mean of 70.2 mm Hg and a standard deviation of 11.2 mm Hg (based on Data Set 1 “Body Data” in Appendix B).

Data set 1

Find the area of the shaded region. The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

Find the indicated IQ score and round to the nearest whole number. The graphs depict IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15 (as on the Wechsler IQ test).

Find the area of the shaded region. The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

Find the indicated IQ score and round to the nearest whole number. The graphs depict IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15 (as on the Wechsler IQ test).

Find the indicated IQ score and round to the nearest whole number. The graphs depict IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15 (as on the Wechsler IQ test).

Find the indicated IQ score and round to the nearest whole number. The graphs depict IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15 (as on the Wechsler IQ test).

Find the indicated z score. The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

Find the indicated z score. The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

Find the indicated z score. The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

Find the indicated z score. The graph depicts the standard normal distribution of bone density scores with mean 0 and standard deviation 1.

Find P99, the 99th percentile. This is the bone density score separating the bottom 99% from the top 1%.

Assume that a randomly selected subject is given a bone density test. Bone density test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the bone density test score corresponding to the given information. Round results to two decimal places.

Find P10, the 10th percentile. This is the bone density score separating the bottom 10% from the top 90%.

Assume that a randomly selected subject is given a bone density test. Bone density test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the bone density test score corresponding to the given information. Round results to two decimal places.

If bone density scores in the bottom 2% and the top 2% are used as cutoff points for levels that are too low or too high, find the two readings that are cutoff values.

Assume that a randomly selected subject is given a bone density test. Bone density test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the bone density test score corresponding to the given information. Round results to two decimal places.

Find the bone density scores that can be used as cutoff values separating the lowest 3% and highest 3%.

Assume that a randomly selected subject is given a bone density test. Bone density test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the bone density test score corresponding to the given information. Round results to two decimal places.

Find the indicated critical value. Round results to two decimal places.

z0.10

Find the indicated critical value. Round results to two decimal places.

z0.02

Find the indicated critical value. Round results to two decimal places.

z0.04

Find the indicated critical value. Round results to two decimal places.

z0.15

The Framingham Heart Study was started in 1948 and is ongoing. Its focus is on heart disease.

Indicate whether the observational study used is cross-sectional, retrospective, or prospective.

Less than -1.23

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Less than -1.96

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Less than 1.28

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Less than 2.56

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Greater than 0.25

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Greater than -3.05

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Greater than -2.00

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Greater than 0.18

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between 2.00 and 3.00

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Less than 0

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Greater than -3.75

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Less than 4.55

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between -4.27 and 2.34

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between -1.00 and 5.00

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between -3.00 and 3.00

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between -2.00 and 2.00

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between -2.75 and -0.75

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between and -2.55 and -2.00

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Between 1.50 and 2.50

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Assume that a randomly selected subject is given a bone density test. Those test scores are normally distributed with a mean of 0 and a standard deviation of 1. In each case, draw a graph, then find the probability of the given bone density test scores. If using Excel instead of Table A-2, round answers to four decimal places.

Greater than 0

Here is a 95% confidence interval estimate of the proportion of adults who say that the law goes easy on celebrities: 0.692 < p < 0.748 (based on data from a Rasmussen Reports survey). What is the best point estimate of the proportion of adults in the population who say that the law goes easy on celebrities?

Write a brief statement that correctly interprets the confidence interval given in Exercise 1 “Celebrities and the Law.”

Exercise 1

Here is a 95% confidence interval estimate of the proportion of adults who say that the law goes easy on celebrities: 0.692 < p < 0.748 (based on data from a Rasmussen Reports survey). What is the best point estimate of the proportion of adults in the population who say that the law goes easy on celebrities?

For the survey described in Exercise 1 “Celebrities and the Law,” find the critical value that would be used for constructing a 99% confidence interval estimate of the population proportion.

Exercise 1

Here is a 95% confidence interval estimate of the proportion of adults who say that the law goes easy on celebrities: 0.692 < p < 0.748 (based on data from a Rasmussen Reports survey). What is the best point estimate of the proportion of adults in the population who say that the law goes easy on celebrities?

What is the level of measurement of these data (nominal, ordinal, interval, ratio)? Are the original unrounded arrival times continuous data or discrete data?

Listed below are the arrival delay times (min) of randomly selected American Airlines flights that departed from JFK in New York bound for LAX in Los Angeles. Negative values correspond to flights that arrived early and ahead of the scheduled arrival time. Use these values for Exercise.

Given the sample data from Exercise 2, which of the following are not possible bootstrap samples?

a. 12, 19, 13, 43, 15

b. 12, 19, 15

c. 12, 12, 12, 43, 43
d. 14, 20, 12, 19, 15

e. 12, 13, 13, 12, 43, 15, 19

USA Today reported that 40% of people surveyed planned to use accumulated loose change for paying bills. The margin of error was given as ± 3.1 percentage points. Identify the confidence interval that corresponds to that information.

Exercise 1

Here is a 95% confidence interval estimate of the proportion of adults who say that the law goes easy on celebrities: 0.692 < p < 0.748 (based on data from a Rasmussen Reports survey). What is the best point estimate of the proportion of adults in the population who say that the law goes easy on celebrities?

The examples in this section all involved no more than 20 bootstrap samples. How many should be used in real applications?

Express the confidence interval using the indicated format. (The confidence intervals are based on the proportions of red, orange, yellow, and blue M&Ms in Data Set 27 “M&M Weights” in Appendix B.)

Express the confidence interval 0.270 ± 0.073 in the form of p̂ - E < p < p̂ + E.

Data set 27

Confidence level is 95%, σ is not known, and the normal quantile plot of the 17 salaries (thousands of dollars) of Miami Heat basketball players is as shown.

Assume that we want to construct a confidence interval. Do one of the following, as appropriate:

(a) Find the critical value tα/2,

(b) Find the critical value zα/2,

(c) State that neither the normal distribution nor the t distribution applies.

Express the confidence interval using the indicated format. (The confidence intervals are based on the proportions of red, orange, yellow, and blue M&Ms in Data Set 27 “M&M Weights” in Appendix B.)

Express the confidence interval (0.0169, 0.143) in the form of p̂ - E < p < p̂ + E.

Data set 27

Refer to Exercise 7 “Requirements” and assume that sample of 12 voltage levels appears to be from a population with a distribution that is substantially far from being normal. Should a 95% confidence interval estimate of s be constructed using the x2 distribution? If not, what other method could be used to find a 95% confidence interval estimate of s?

Exercise 7

A quality control analyst has collected a random sample of 12 smartphone batteries and she plans to test their voltage level and construct a 95% confidence interval estimate of the mean voltage level for the population of batteries. What requirements must be satisfied in order to construct the confidence interval using the method with the t distribution?

Express the confidence interval using the indicated format. (The confidence intervals are based on the proportions of red, orange, yellow, and blue M&Ms in Data Set 27 “M&M Weights” in Appendix B.)

Express 0.179 < p < 0.321 in the form of p̂ ± E.

Data set 27

Express the confidence interval using the indicated format. (The confidence intervals are based on the proportions of red, orange, yellow, and blue M&Ms in Data Set 27 “M&M Weights” in Appendix B.)

Express 0.0434 < p < 0.217 in the form of p̂ ± E.

Data set 27

Refer to Exercise 7 “Requirements” and assume that the requirements are satisfied. Find the critical value that would be used for constructing a 95% confidence interval estimate of m using the t distribution.

Exercise 7

A quality control analyst has collected a random sample of 12 smartphone batteries and she plans to test their voltage level and construct a 95% confidence interval estimate of the mean voltage level for the population of batteries. What requirements must be satisfied in order to construct the confidence interval using the method with the t distribution?

According to the Bureau of Transportation, American Airlines had an on time arrival rate of 80.3% for a given year. Assume that this statistic is based on a sample of 1000 randomly selected American Airlines flights. Find the 99% confidence interval estimate of the percentage of all American Airlines flights that arrive on time.

In general, what does “degrees of freedom” refer to? For the sample data described in Exercise 7 “Requirements,” find the number of degrees of freedom, assuming that you want to construct a confidence interval estimate of m using the t distribution.

Exercise 7

A quality control analyst has collected a random sample of 12 smartphone batteries and she plans to test their voltage level and construct a 95% confidence interval estimate of the mean voltage level for the population of batteries. What requirements must be satisfied in order to construct the confidence interval using the method with the t distribution?

Confidence level is 90%, s is not known, and the histogram of 61 player salaries (thousands of dollars) is as shown.

Assume that we want to construct a confidence interval. Do one of the following, as appropriate:

(a) Find the critical value tα/2,

(b) Find the critical value zα/2,

(c) State that neither the normal distribution nor the t distribution applies.

Find the sample size required to estimate the mean IQ of professional musicians. Assume that we want 98% confidence that the mean from the sample is within three IQ points of the true population mean. Also assume that σ = 15.

Here are summary statistics for randomly selected weights of newborn girls:

n = 205, x̅ = 30.4 hg, s = 7.1 hg (based on Data Set 4 “Births” in Appendix B). The confidence level is 95%.

Assume that we want to construct a confidence interval. Do one of the following, as appropriate:

(a) Find the critical value tα/2,

(b) Find the critical value zα/2,

(c) state that neither the normal distribution nor the t distribution applies.

Confidence level is 99%, s = 3342 thousand dollars, and the histogram of 61 player salaries (thousands of dollars) is shown in Exercise 6.

Assume that we want to construct a confidence interval. Do one of the following, as appropriate:

(a) Find the critical value tα/2,

(b) Find the critical value zα/2,

(c) state that neither the normal distribution nor the t distribution applies.

Exercise 6

Confidence level is 90%, s is not known, and the histogram of 61 player salaries (thousands of dollars) is as shown.

A quality control analyst has collected a random sample of 12 smartphone batteries and she plans to test their voltage level and construct a 95% confidence interval estimate of the mean voltage level for the population of batteries. What requirements must be satisfied in order to construct the confidence interval using the method with the t distribution?

Using the methods of this chapter, identify the distribution that should be used for testing a claim about the given population parameter.

a. Mean

b. Proportion

c. Standard deviation

A formal hypothesis test is to be conducted using the claim that the mean height of men is equal to 174.1 cm.

a. What is the null hypothesis, and how is it denoted?

b. What is the alternative hypothesis, and how is it denoted?

c. What are the possible conclusions that can be made about the null hypothesis?

d. Is it possible to conclude that “there is sufficient evidence to support the claim that the mean height of men is equal to 174.1 cm”?

Repeat Exercise 9 “Heights of Mothers and Daughters” using all of the heights of mothers and daughters listed in Data Set 5 “Family Heights” in Appendix B.

Exercise 9

Data set 5

What does it mean when we say that the rank correlation test has an efficiency rating of 0.91 when compared to the parametric test for linear correlation?

After ranking the combined list of professor evaluations given in Exercise 1, find the sum of the ranks for the female professors.

Exercise 1

a. Which of the following terms is sometimes used instead of “nonparametric test”: normality test; abnormality test; distribution-free test; last testament; test of patience?

b. Why is the term that is the answer to part (a) better than “nonparametric test”?

There is a 3.9% rate of positive drug test results among workers in the United States (based on data from Quest Diagnostics). Assuming that this statistic is based on a sample of size 2000, construct a 95% confidence interval estimate of the percentage of positive drug test results. Write a brief statement that interprets the confidence interval.

In a recent year, the players on the New York Yankees baseball team had salaries with a mean of \$7,052,129 and a median of \$2,500,000. Explain how the mean and median can be so far apart.

What is a major advantage of the Wilcoxon signed-ranks test over the sign test when analyzing data consisting of matched pairs?

Refer to Data Set 23 “Old Faithful” in Appendix B for the time intervals before eruptions of the Old Faithful geyser. Use a 0.05 significance level to test the claim that those times are from a population with a median of 90 minutes.

Data set 23

Use the data from the preceding exercise and test the claim that the rate of positive drug test results among workers in the United States is greater than 3.0%. Use a 0.05 significance level.

Showing 1 - 100 of 382
Join SolutionInn Study Help for
1 Million+ Textbook Solutions
Learn the step-by-step answers to your textbook problems, just enter our Solution Library containing more than 1 Million+ textbooks solutions and help guides from over 1300 courses.