Questions and Answers of Elementary Statistics Excel

When randomly selecting adults, let M denote the event of randomly selecting a male and let B denote the event of randomly selecting someone with blue eyes. What does P(M\B) represent? Is P(M\B) the
Find the probability of randomly selecting a driver and getting one who was not killed given that the driver was using a seatbelt. Use the data in the accompanying table and express all results in
In the New Jersey Pick 6 lottery game, a bettor selects six different numbers, each between 1 and 49. Winning the top prize requires that the selected numbers match those that are drawn, but the
Let A = the event of getting at least one defective iPhone when 3 iPhones are randomly selected with replacement from a batch. Write a statement describing event A̅.
Standard tests, such as the SAT or ACT or MCAT, tend to make extensive use of multiple-choice questions because they are easy to grade using software. If one such multiple choice question has
Let A denote the event of placing a $1 straight bet on the New Jersey Pick 3 lottery and winning. There are 1000 different ways that you can select the three digits (with repetition allowed) in this
When randomly selecting an adult, A denotes the event of selecting someone with blue eyes. What do P(A) and P(A̅) represent?
If one driver is randomly selected, find the probability he or she was using a seatbelt. Use the data in the accompanying table and express all results in decimal form. (The data are from ?Mortality
What does the symbol ! represent? Six different people can stand in a line 6! different ways, so what is the actual number of ways that six people can stand in a line?
Data Set 15 ?Presidents? in Appendix B lists the numbers of years that U.S. presidents lived after their first inauguration. As of this writing, five of the presidents are still alive and after their
Five pulse rates randomly selected from Data Set 1 ?Body Data? in Appendix B have a mean of 78.0 beats per minute. Four of the pulse rates are 82, 78, 56, and 84. a. Find the missing value. b. We
The following are the ratings of males by females in an experiment involving speed dating.Use the given data to construct a boxplot and identify the 5-number summary.
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.P85
Refer to Data Set 3 ?Body Temperature? in Appendix B and use the body temperatures for 12:00 AM on day 2. Refer to the indicated data set in Appendix B. Use software or a calculator to find the
Refer to Data Set 3 ?Body Temperatures? in Appendix B and use the body temperatures for 12:00 AM on day 2. Do the results support or contradict the common belief that the mean body temperature is
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.P25
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.P75
Use the F-scale measurements from the tornadoes listed in Data Set 22 ?Tornadoes? in Appendix B. Be careful to account for missing data. Refer to the indicated data set in Appendix B. Use software
Use the F-scale measurements from the tornadoes listed in Data Set 22 ?Tornadoes? in Appendix B. Among the 500 tornadoes, how many have missing F-scale measurements? (Caution: In some technologies,
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.P50
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.P40
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.Q3
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.Q1
Use the same list of Sprint airport data speeds (Mbps) given for this exercise. Find the indicated percentile or quartile.P60
Use the following cell phone airport data speeds (Mbps) from Sprint. Find the percentile corresponding to the given data speed. 9.6 Mbps 0.2 0.5 0.3 0.5 0.3 0.3 0.6 0.3 0.3 0.3 0.5 0.4 0.4 0.4 0.5
Use the following cell phone airport data speeds (Mbps) from Sprint. Find the percentile corresponding to the given data speed. 0.7 Mbps 0.2 0.5 0.3 0.5 0.3 0.3 0.6 0.3 0.3 0.3 0.5 0.4 0.4 0.4 0.5
Use the following cell phone airport data speeds (Mbps) from Sprint. Find the percentile corresponding to the given data speed. 13.0 Mbps 0.2 0.5 0.3 0.5 0.3 0.3 0.6 0.3 0.3 0.3 0.5 0.4 0.4 0.4 0.5
Use the following cell phone airport data speeds (Mbps) from Sprint. Find the percentile corresponding to the given data speed. 2.4 Mbps 0.2 0.5 0.3 0.5 0.3 0.3 0.6 0.3 0.3 0.3 0.5 0.4 0.4 0.4 0.5
In the 87th Academy Awards, Eddie Redmayne won for best actor at the age of 33 and Julianne Moore won for best actress at the age of 54. For all best actors, the mean age is 44.1 years and the
Consider a sample of sleep times taken from the population of all adults living in Alaska. Identify the symbols used for the sample mean, population mean, sample standard deviation, population
In a recent year, scores on the Medical College Admission Test (MCAT) had a mean of 25.2 and a standard deviation of 6.4. Identify the MCAT scores that are significantly low or significantly
For a sample of 100 sleep times, give the names of the values that constitute the 5-number summary. (The actual values can’t be identified; just give the names of those values.)
A large sample of sleep times includes values ranging from a low of 4 hours to a high of 10 hours. Use the range rule of thumb to estimate the standard deviation.
For a sample of 80 sleep times, approximately how many of those times are less than Q3?
Examine the distribution shown in the histogram from Exercise 5. Does it appear that the sample data are from a population with a normal distribution? Why or why not?Exercise 5 18 16 14 12 10 2 3 7 8
A larger sample of 50 sleep times (hours) has a mean of 6.3 hours and a standard deviation of 1.4 hours. What is the z score for a sleep time of 5 hours?
The accompanying histogram depicts outcomes of digits from the Florida Play 4 lottery. What is the major flaw in this histogram? 18 16 14 12 10 8. 01 2 3 45 6 7 8 9 Digit Kouanbas
If the sleep time of 0 hours is included with the sample data given in Exercise 1, is it an outlier? Why or why not?Exercise 1As part of the National Health and Nutrition Examination Survey, subjects
The standard deviation of the sample values in Exercise 1 is 1.3 hours. What is the variance (including units)?Exercise 1As part of the National Health and Nutrition Examination Survey, subjects were
Refer to the boxplots shown below that are drawn on the same scale. One boxplot represents weights of men, and the other boxplot represents weights of women. Which boxplot represents weights ofwomen?
The 20 subjects used in Data Set 8 ?IQ and Brain Size? in Appendix B have weights with a standard deviation of 20.0414 kg. What is the variance of their weights? Be sure to include the appropriate
In what sense are the mean, median, mode, and midrange measures of “center”?
What is the mode of the sample values listed in Exercise 1?Exercise 1As part of the National Health and Nutrition Examination Survey, subjects were asked how long they slept the preceding night, and
What is the median of the sample values listed in Exercise 1?Exercise 1As part of the National Health and Nutrition Examination Survey, subjects were asked how long they slept the preceding night,
LeBron James, one of the most successful basketball players of all time, has a height of 6 feet 8 inches, or 203 cm. Based on statistics from Data Set 1 “Body Data” in Appendix B, his
As part of the National Health and Nutrition Examination Survey, subjects were asked how long they slept the preceding night, and the following times (hours) were reported:8, 7, 5, 7, 4, 7, 6, 7, 8,
In 1986, the New York City subway fare cost $1, and as of this writing, the current cost is $2.50, so the 1986 price was multiplied by 2.5. In the accompanying graph, the large bill is 2.5 times as
A histogram is to be constructed from the measured breaking points (in pounds) of tested car seatbelts. Identify two key features of a histogram of those values that would suggest that the data have
The Beams Seatbelts company manufactures—well, you know. When a sample of seatbelts is tested for breaking point (measured in kilograms), the sample data are explored. Identify the important
How would the shape of the histogram change if the vertical scale uses relative frequencies expressed in percentages instead of the actual frequency counts as shown here?
Give the approximate values of the class width, and the lower and upper class limits of the class depicted in the bar farthest to the left.
a. After collecting the average (mean) global temperatures for each of the most recent 100 years, we want to construct the graph that is most appropriate for these data. Which graph is best?b. After
In recent years, there has been much discussion about the distribution of wealth of adults in the United States. If you plan to conduct original research by somehow obtaining the amounts of wealth of
What is the approximate number of quarters depicted in the three bars farthest to the left?
Use the total game playing times to create a stemplot. What does the stemplot reveal about the distribution of the data?
As a quality control manager at Texas Instruments, you find that defective calculators have various causes, including worn machinery, human error, bad supplies, and packaging mistreatment. Which of
If we collect a sample of blood platelet counts much larger than the sample included with Exercise 3, and if our sample includes a single outlier, how will that outlier appear in a
Assume that you want to create the histogram for Exercise 3 in a way that exaggerates the differences among the times. Describe how the histogram from Exercise 3 can be modified to accomplish that
A stemplot of the same cookies summarized in Exercise 1 is created, and the first row of that stemplot is 1 | 99. Identify the values represented by that row of the stemplot.Data from Exercise
For each of the following, estimate the value of the linear correlation coefficient r for the given paired data obtained from 50 randomly selected adults.a. Their heights are measured in inches (x)
Listed below are blood platelet counts (1000 cells/?L) randomly selected from adults in the United States. Why does it not make sense to construct a histogram for this data set? 191 286 263 193 193
Using the same frequency distribution from Exercise 1, how many cookies are included? ChocolateChips ......................
What is a scatterplot and how does it help us?
The population of heights of adult males is normally distributed. If we obtain a voluntary response sample of 5000 of those heights, will a histogram of the sample heights be bell-shaped?
For the frequency distribution from Exercise 1, find the following.a. Class limits of the first classb. Class boundaries of the first classc. Class midpoint of the first class
Using the same frequency distribution from Exercise 1, identify the class boundaries of the first class and identify the class limits of the first class.
Refer to the accompanying frequency distribution that summarizes the numbers of chocolate chips found in each cookie in a sample of Chips Ahoy regular chocolate chip cookies (from Data Set 28
A study has shown that there is a correlation between body weight and blood pressure. Higher body weights are associated with higher blood pressure levels. Can we conclude that gaining weight is a
Heights of adult males are normally distributed. If a large sample of heights of adult males is randomly selected and the heights are illustrated in a histogram, what is the shape of that histogram?
Refer to the accompanying table summarizing service times (seconds) of McDonald’s dinners. How many individuals are included in the summary? Is it possible to identify the exact values of all of
In this section we use r to denote the value of the linear correlation coefficient. Why do we refer to this correlation coefficient as being linear?
When the author was negotiating a contract for the faculty and administration at a college, a dean presented the argument that if faculty receive a 4% raise and administrators receive a 4% raise,
The HIV Trials Network is conducting a study to test the effectiveness of two different experimental HIV vaccines. Subjects will consist of 80 pairs of twins. For each pair of twins, one of the
A New York Times editorial criticized a chart caption that described a dental rinse as one that “reduces plaque on teeth by over 300%.” What is wrong with this statement?Answer the given
Currently, there is no approved vaccine for the prevention of infection by West Nile virus. A clinical trial of a possible vaccine is being planned to include subjects treated with the vaccine while
Continental Airlines ran ads claiming that lost baggage is “an area where we’ve already improved 100% in the past six months.” What is wrong with this statement?Answer the given questions,
A clinical trial of Lipitor treatments is being planned to determine whether its effects on diastolic blood pressure are different for men and women.Identify which of these designs is most
An ad for Big Skinny wallets included the statement that one of their wallets “reduces your filled wallet size by 50%–200%.” What is wrong with this statement?Answer the given questions, which
Lunesta is a drug designed to treat insomnia. In a clinical trial of Lunesta, amounts of sleep each night are measured before and after subjects have been treated with the drug.Identify which of
Researchers from the National Institutes of Health want to determine the current rates of marijuana consumption among adults living in states that have legalized the use of marijuana. They conduct a
As part of a project in a statistics class, students report the last four digits of their Social Security numbers, and the average (mean) of those digits is computed to be 4.7.Identify the level of
Samples of subjects with and without heart disease were selected, then researchers looked back in time to determine whether they took aspirin on a regular basis.Indicate whether the observational
The first Super Bowl attended by the author was Super Bowl XLVIII. On the first play of the game, the Seattle defense scored on a safety. The defensive players wore jerseys numbered 31, 28, 41, 56,
In a survey conducted by Opinion Research Corporation, 1000 adults were asked to identify “what is inappropriate in the workplace.” Of the 1000 subjects, 70% said that miniskirts were not
Phase II of the Nurses’ Health Study was started in 1989 with 116,000 female registered nurses. The study is ongoing.Indicate whether the observational study used is cross-sectional, retrospective,
Body temperatures (in degrees Fahrenheit) listed in Data Set 3 ?Body Temperatures? in Appendix B. Determine which of the four levels of measurement (nominal, ordinal, interval, ratio) is most
The electronic cigarette maker V2 Cigs sponsored a poll showing that 55% of smokers surveyed say that they feel ostracized “sometimes,” “often,” or “always.”Identify what is wrong.
The author rated the movie Star Wars: The Force Awakens with 5 stars on a scale of 5 stars.Determine which of the four levels of measurement (nominal, ordinal, interval, ratio) is most appropriate.
In a USA Today online poll, 951 Internet users chose to respond, and 57% of them said that they prefer drinking bottled water instead of tap water.Identify what is wrong.
Baseball statistician Bill James records the years in which the baseball World Series is won by a team from the National League.Determine which of the four levels of measurement (nominal, ordinal,
In a poll sponsored by the Idaho Potato Commission, 1000 adults were asked to select their favorite vegetables, and the favorite choice was potatoes, which were selected by 26% of the
In a study of fast food service times, a researcher records the time intervals of drive-up customers beginning when they place their order and ending when they receive their order.Determine which of
A medical researcher tested for a difference in systolic blood pressure levels between male and female students who are 12 years of age. She randomly selected four males and four females for her
Colors of M&Ms (red, orange, yellow, brown, blue, green) listed in Data Set 27 “M&M Weights” in Appendix BDetermine which of the four levels of measurement (nominal, ordinal, interval,
Considering the source of the data, does that source appear to be biased in some way? Refer to the data in the table below. The entries are white blood cell counts (1000 cells ,?L) and red blood
For the presidential election of 2016, ABC News conducts an exit poll in which voters are asked to identify the political party (Democratic, Republican, and so on) that they registered with.Determine
The Physicians’ Health Study involved 22,071 male physicians. Based on random selections, 11,037 of them were treated with aspirin and the other 11,034 were given placebos. The study was stopped
U.S. News & World Report periodically provides its rankings of national universities, and in a recent year the ranks for Princeton, Harvard, and ale were 1, 2, and 3, respectively.Determine which
Given that the data are matched and considering the units of the data, does it make sense to use the difference between each white blood cell count and the corresponding red blood cell count? Why or
The Insurance Institute for Highway Safety collects data consisting of the numbers of motor vehicle fatalities caused by driving while texting.Determine whether the data are from a discrete or

Showing 300 - 400 of 478