Questions and Answers of Elementary Statistics Excel

Excel and many other technologies are capable of generating normally distributed data drawn from a population with a specified mean and standard deviation. Bone density test scores are measured as z
Repeat the preceding exercise, assuming that the linear correlation coefficient is r = 0.997. The above exercise is based on the following sample data consisting of numbers of enrolled students (in
Heights (cm) and weights (kg) are measured for 100 randomly selected adult males (from Data Set 1 “Body Data” in Appendix B). The 100 paired measurements yield x̅ = 173.79 cm, y̅ = 85.93 kg, r
Review Exercise 5 involved weather-related U.S. deaths. Among the 450 deaths included in that exercise, 320 are males. Use a 0.05 significance level to test the claim that among those who die in
Excel is capable of generating equally likely random digits between 0 and 9 inclusive. Use Excel to generate 5000 digits between 0 and 9 inclusive and record the results in the accompanying table.
The Allstate insurance company once issued a press release listing zodiac signs along with the corresponding numbers of automobile crashes, as shown in the first and last columns in the table
When testing the claim in Exercise 1, what are the observed and expected frequencies for the last digit of 7? Refer to the sample data in the following table, which summarizes the last digits of the
What is the fundamental difference between one-way analysis of variance and two-way analysis of variance?
Use the procedures described in Section 1-4 to install Excel’s Data Analysis add-in. Also install the XLSTAT add-in (if applicable). After installing these two add-ins, do the following.i. Open
1. Consider the statement that “male symphony conductors live longer.” Identify the specific group that they supposedly live longer than. Does that other group consist of males randomly selected
The focus of this project is to download a data set and manipulate it to work around missing data.a. First, download Data Set 3 “Body Temperatures” in Appendix B from www.TriolaStats.b. Some
• Obtain a printed copy of the two histograms.• Describe the natures of the two distributions (uniform, normal, skewed left, skewed right), and identify possible outliers.• Write a brief
1. Which of the four restaurants appears to have the fastest lunch drive-through service times?2. Which of the four restaurants appears to have the fastest dinner drive-through service times?3. Do
Use the methods from this chapter to explore and compare the cotinine measures in the three groups. Are there any notable differences? Are there any outliers? What do you conclude about the effects
Find the sample size required to estimate the percentage of college students who take a statistics course. Assume that we want 95% confidence that the proportion from the sample is within four
a. Test the given claim using a 0.05 significance level. Does the Salk vaccine appear to be effective?b. For the hypothesis test from part (a), consider the following two errors:• Concluding that
The Ericsson method is one of several methods claimed to increase the likelihood of a baby girl. In a clinical trial, results could be analyzed with a formal hypothesis test with the alternative
The claim is that for 12 AM body temperatures, the mean is μ Use technology to find the P-value or use Table A-3 to find a range of values for the P-value. Table A-3
The claim is that for the duration times (sec) of eruptions of the Old Faithful geyser, the mean is μ = 240 sec. The sample size is n = 6 and the test statistic is t = 1.340. Use technology to find
The claim is that for the widths (yd) of tornadoes, the mean is μ Use technology to find the P-value or use Table A-3 to find a range of values for the P-value. Table A-3
Data Set 3 “Body Temperatures” in Appendix B includes 93 body temperatures measured at 12 AM on day 1 of a study, and the accompanying XLSTAT display results from using those data to test the
A simple random sample of 10 pages from Merriam-Webster’s Collegiate Dictionary is obtained. The numbers of words defined on those pages are found, with these results: n = 10, x̅ = 53.3 words, s =
The proportion of people with blue eyes is equal to 0.35.Identify the type I error and the type II error that correspond to the given claim. (Although conclusions are usually expressed in verbal
Identify the null and alternative hypotheses resulting from the claim that for the people who were aware of the statement, the proportion of women is equal to the proportion of men.Use the following
1. First explore the two proportions of overtime wins. Does there appear to be a difference? If so, how?2. Create a claim to be tested, then test it. Use a hypothesis test as well as a confidence
Which of the following involve independent samples? a. Data Set 14 “Oscar Winner Age” in Appendix B includes pairs of ages of actresses and actors at the times that they won Oscars for Best
For the methods of this section, which of the following statements are true?a. When testing a claim with ten matched pairs of heights, hypothesis tests using the P-value method, critical value
Find the values of x1 (the number of women who were aware of the statement), x2 (the number of men who were aware of the statement), p̂1, p̂2, and the pooled proportion p̅ obtained when testing
Large samples of women and men are obtained, and the hemoglobin level is measured in each subject. Here is the 95% confidence interval for the difference between the two population means, where the
When testing the claim that p1 = p2, a test statistic of z = -1.64 is obtained. Find the P-value for the hypothesis test.Use the following survey results: Randomly selected subjects were asked if
If the values listed in Exercise 2 are changed so that they are expressed in Celsius degrees instead of Fahrenheit degrees, how are hypothesis test results affected? Exercise 2
When using the given sample data to construct a 95% confidence interval estimate of the difference between the two population proportions, the result of (-0.0659, 0.00591) is obtained from
Assume that a P-value of 0.1 is obtained when testing the claim given in Exercise 1 “Biodiversity.” What should be concluded about the null hypothesis? What should be the final conclusion?Use the
Determine whether the following statement is true: When random samples of 50 men and 50 women are obtained and we want to test the claim that men and women have different mean annual incomes, there
When we collect random samples to test the claim that the proportion of female CIA agents stationed in the United States is equal to the proportion of female CIA agents stationed outside the United
Identify the null and alternative hypotheses for using the sample data from Exercise 8 in testing the claim that for differences between right arm systolic blood pressure amounts and left-arm
Repeat Exercise 10 “Heights of Fathers and Sons” using all of the heights of fathers and sons listed in Data Set 5 “Family Heights” in Appendix B. Exercise 10 Data set 5
The linear correlation coefficient r is found to be 0.499, the P-value is 0.393, and the critical values for a 0.05 significance level are {0.878. What should you conclude? The above exercise is
Different hotels on Las Vegas Boulevard (“the strip”) in Las Vegas are randomly selected, and their ratings and prices were obtained from Travelocity. Using technology, with x representing the
Data Set 18 “Speed Dating” in Appendix B includes data from 199 dates. Due to the large size of this data set, the data are available at www.TriolaStats.com. Download the data set and proceed to
Listed below are measures of pain intensity before and after using the drug Duragesic (fentanyl) (based on data from Janssen Pharmaceutical Products, L.P.). The data are listed in order by row, and
Using the lengths (in.), chest sizes (in.), and weights (lb) of bears from Data Set 9 “Bear Measurements” in Appendix B, we get this regression equation: Weight = -274 + 0.426 Length +12.1 Chest
Different samples are collected, and each sample consists of IQ scores of 25 statistics students. Let x represent the standard deviation of the 25 IQ scores in a sample, and let y represent the
Which of the following change if the two variables of enrollment and burglaries are switched: the value of r = 0.499, the P-value of 0.393, the critical values of ± 0.878? The above exercise is
For the same two variables described in Exercise 1, if we find that r = 0, does that indicate that there is no association between those two variables?
Exercise 1 stated that r is found to be 0.499. Does that value change if the actual enrollment values of 53,000, 28,000, 27,000, 36,000, and 42,000 are used instead of 53, 28, 27, 36, and 42? The
If you had computed the value of the linear correlation coefficient to be 1.500, what should you conclude? The above exercise is based on the following sample data consisting of numbers of enrolled
For 50 randomly selected speed dates, attractiveness ratings by males of their female date partners (x) are recorded along with the attractiveness ratings by females of their male date partners (y);
The sample data result in a linear correlation coefficient of r = 0.499 and the regression equation ŷ = 3.83 + 2.39x. What is the best predicted number of burglaries, given an enrollment of 50
Head widths (in.) and weights (lb) were measured for 20 randomly selected bears (from Data Set 9 “Bear Measurements” in Appendix B). The 20 pairs of measurements yield x̅ = 6.9 in., y̅ = 214.3
Identify the following: a. The P-value corresponding to the overall significance of the multiple regression equation b. The value of the multiple coefficient of determination R2 c. The adjusted value
Given that the linear correlation coefficient r is found to be 0.499, what is the proportion of the variation in numbers of burglaries that is explained by the linear relationship between enrollment
For 30 recent Academy Award ceremonies, ages of Best Supporting Actors (x) and ages of Best Supporting Actresses (y) are recorded. The 30 paired ages yield x̅ = 52.1 years, y̅ = 37.3 years, r =
True or false: If there is no linear correlation between enrollment and number of burglaries, then those two variables are not related in any way. The above exercise is based on the following sample
True or false: If the sample data lead us to the conclusion that there is sufficient evidence to support the claim of a linear correlation between enrollment and number of burglaries, then we could
If the sample data were to result in the scatterplot shown here, what is the value of the linear correlation coefficient r? The above exercise is based on the following sample data consisting of
What are the null and alternative hypotheses corresponding to the stated claim? Refer to the sample data in the following table, which summarizes the last digits of the heights (cm) of 300 randomly
Refer to the data given in Exercise 1 and assume that the requirements are all satisfied and we want to conduct a hypothesis test of independence using the methods of this section. Identify the null
The accompanying XLSTAT results shown in the margin are obtained from the data given in Exercise 1. What should be concluded when testing the claim that the leading digits have a distribution that
The display in the margin results from the hypothesis test described in Exercise 1. Assume that the hypothesis test requirements are all satisfied. Identify the test statistic and the P-value
If using a 0.05 significance level to test the stated claim, find the number of degrees of freedom. Refer to the sample data in the following table, which summarizes the last digits of the heights
Given that the P-value for the hypothesis test is 0.501, what do you conclude? Does it appear that the heights were obtained through measurement or that the subjects reported their heights? Refer to
Identify the null and alternative hypotheses corresponding to the stated claim. Refer to the sample data in the following table, which describes the fate of the passengers and crew aboard the
Refer to the results from the 150 subjects in Cumulative Review Exercise 5. a. Find the probability that if 1 of the 150 subjects is randomly selected, the result is a woman who spent the money. b.
What distribution is used to test the stated claim (normal, t, F, chi-square, uniform)? Refer to the sample data in the following table, which describes the fate of the passengers and crew aboard
Given that the P-value for the hypothesis test is 0.000 when rounded to three decimal places, what do you conclude? What do the results indicate about the rule that women and children should be the
The pulse rates in Table 12-3 from Example 1 are reproduced below with fabricated data (in red) used for the pulse rates of females aged 30–49. What characteristic of the data suggests that the
Data Set 26 “Cola Weights and Volumes” in Appendix B lists the weights (lb) of the contents of cans of cola from four different samples: (1) regular Coke, (2) Diet Coke, (3) regular Pepsi, and
Data Set 18 “Speed Dating” in Appendix B includes data from a study of speed dating, and Review Exercise 4 “Speed Dating” includes some of those data in a two-way table with different age
What is the value of the test statistic? What distribution is used with the test statistic? Use the following listed arrival delay times (minutes) for American Airline flights from New York to Los
Does the table given in Exercise 1 constitute a balanced design? Why or why not? Exercise 1
In general, what is one-way analysis of variance used for?
Randomly generated digits are commonly used for a variety of different applications. Pollsters often select telephone numbers by using random digits so that unlisted numbers can be included.
On December 1, 1969, during the Vietnam War, a lottery was used to determine who would be drafted into the U.S. Army, but the lottery generated considerable controversy. The different dates in a year
Some of the nonparametric methods in this chapter use ranks of data. Find the ranks corresponding to these attractiveness ratings (1 = not attractive; 10 = extremely attractive) of males by females
Identify the values of n1, n2, and G that would be used in the runs test for randomness.
For the sign test described in Exercise 1, identify the number of positive signs, the number of negative signs, the number of ties, the sample size n that is used for the sign test, and the value of
If we use a 0.05 significance level to test for randomness, what are the critical values from Table A-10? Based on those values and the number of runs from Exercise 2, what should be concluded about
Using the data in Exercise 1, we can test for no difference between body temperatures at 8 AM and 12 AM by using the sign test or the Wilcoxon signed-ranks test. In what sense does the Wilcoxon
Listed below are foot lengths (cm) and heights (cm) of males from Data Set 2 “Foot and Height” in Appendix B. Which method of nonparametric statistics should be used? What characteristic of the
Assume that we use the runs test of randomness above and below the mean for the monetary value of Google at the end of each year for 20 years and we find that G = 2. What does that value tell us
Consider sample data consisting of genders of criminals charged with hacking computer systems of corporations. Determine whether the following are true or false.a. If the runs test suggests that
Three different judges give the same singers ratings on a scale of 0 to 10. What method of this chapter can be used to determine whether one of the judges is tougher or more lenient than the others,
In an article from the Associated Press, it was reported that researchers “randomly selected 100 New York motorists who had been in an accident and 100 who had not been in an accident. Of those in
Repeat Exercise 8 using all of the paired ages from Data Set 14 “Oscar Winner Age” in Appendix B. Exercise 8 Data set 14 ACTRESSES .......................... ACTORS22
What are process data?
a. Simulate the following process for 20 days: Each day, 200 calculators are manufactured with a 5% rate of defects, and the proportion of defects is recorded for each of the 20 days. The calculators
Identify three specific criteria for determining when a process is out of statistical control.
The accompanying graph was created to depict the results of the survey described in Exercise 1. Is the graph somehow misleading? If so, how?
What is the difference between an R chart and an x̅ chart?
Is the process variation within statistical control? Why or why not? Use the following two control charts that result from testing batches of newly manufactured aircraft altimeters, with 100 in each
Is the process mean within statistical control? Why or why not? Use the following two control charts that result from testing batches of newly manufactured aircraft altimeters, with 100 in each
What is the value of x̅? In general, how is a value of x̅ found? Use the following two control charts that result from testing batches of newly manufactured aircraft altimeters, with 100 in each
If the R̅ chart and x̅ chart both showed that the process of manufacturing aircraft altimeters is within statistical control, can we conclude that the altimeters satisfy the Federal Aviation
Use the numbers of defective child restraint systems given in Exercise 8. Find the mean, median, and standard deviation. What important characteristic of the sample data is missed if we explore the
Examine the following p chart for defective calculator batteries and briefly describe the action that should be taken.
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.
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
What is a major advantage of the Wilcoxon signed-ranks test over the sign test when analyzing data consisting of matched pairs?
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.

Showing 1 - 100 of 478