ELEMENTARY STATISTICS USING EXCEL
7th Edition
ISBN: 9780136921721
Author: Triola
Publisher: RENT PEARS
expand_more
expand_more
format_list_bulleted
Question
Chapter 1.1, Problem 28BSC
To determine
To find: Whether the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A sociologist wants to determine if the life expectancy of people in Africa is less than
the life expectancy of people in Asia. The data obtained is shown in the table below.
Africa
Asia
= 63.3 yr.
1
X,=65.2 yr.
2
o, = 9.1 yr.
= 7.3 yr.
n1
= 120
= 150
an attempt to develop a model of wine quality as judged by wine experts, data on alcohol content and wine quality was collected from variants of a particular wine. From a sample of 12wines, a model was created using the percentages of alcohol to predict wine quality. For those data, SR=18,671 and SST=27,382.Use this information to complete parts (a) through (c) below. Please complete part 3(B) ONLY.
Question content area bottom
Part 1
a. Determine the coefficient of determination,
r2,
and interpret its meaning.
r2=0.682
(Round to three decimal places as needed.)
Part 2
Interpret the meaning of r2.
It means that
68.2
of the variation in
wine quality
can be explained by the variation in
alcohol content.
(Round to one decimal place as needed.)
Part 3
b. Determine the standard error of the estimate.
SYX=
(Round to four decimal places as needed.)
Please, give me answer immediatly.
Chapter 1 Solutions
ELEMENTARY STATISTICS USING EXCEL
Ch. 1.1 - Prob. 1BSCCh. 1.1 - 2. Reported Versus Measured In a survey of 1046...Ch. 1.1 - 3. Statistical Significance Versus Practical...Ch. 1.1 - Prob. 4BSCCh. 1.1 - Prob. 5BSCCh. 1.1 - Prob. 6BSCCh. 1.1 - Consider the Source. In Exercises 5–8, determine...Ch. 1.1 - Consider the Source. In Exercises 5–8, determine...Ch. 1.1 - Sampling Method. In Exercises 9–12, determine...Ch. 1.1 - Sampling Method. In Exercises 9–12, determine...
Ch. 1.1 - Prob. 11BSCCh. 1.1 - Prob. 12BSCCh. 1.1 - Prob. 13BSCCh. 1.1 - Prob. 14BSCCh. 1.1 - Prob. 15BSCCh. 1.1 - Statistical Significance and Practical...Ch. 1.1 - Prob. 17BSCCh. 1.1 - Prob. 18BSCCh. 1.1 - Prob. 19BSCCh. 1.1 - Prob. 20BSCCh. 1.1 - Prob. 21BSCCh. 1.1 - Prob. 22BSCCh. 1.1 - Prob. 23BSCCh. 1.1 - Prob. 24BSCCh. 1.1 - Prob. 25BSCCh. 1.1 - Prob. 26BSCCh. 1.1 - Prob. 27BSCCh. 1.1 - Prob. 28BSCCh. 1.1 - Prob. 29BSCCh. 1.1 - What’s Wrong? In Exercises 25–28, identify what is...Ch. 1.1 - What’s Wrong? In Exercises 25–28, identify what is...Ch. 1.1 - Prob. 32BSCCh. 1.1 - Prob. 33BSCCh. 1.1 - Prob. 34BSCCh. 1.1 - Prob. 35BSCCh. 1.1 - Prob. 36BSCCh. 1.1 - Prob. 37BSCCh. 1.1 - 30. Checking Job Applicants In a study conducted...Ch. 1.1 - Prob. 39BSCCh. 1.1 - Prob. 40BSCCh. 1.1 - Prob. 41BSCCh. 1.1 - Prob. 42BSCCh. 1.1 - Prob. 43BSCCh. 1.1 - Prob. 44BSCCh. 1.1 - Prob. 45BBCh. 1.1 - Prob. 46BBCh. 1.1 - Prob. 47BBCh. 1.2 - Prob. 1BSCCh. 1.2 - Prob. 2BSCCh. 1.2 - Prob. 3BSCCh. 1.2 - Prob. 4BSCCh. 1.2 - Prob. 5BSCCh. 1.2 - Prob. 6BSCCh. 1.2 - Prob. 7BSCCh. 1.2 - Prob. 8BSCCh. 1.2 - Prob. 9BSCCh. 1.2 - Prob. 10BSCCh. 1.2 - Prob. 11BSCCh. 1.2 - Prob. 12BSCCh. 1.2 - Prob. 13BSCCh. 1.2 - Prob. 14BSCCh. 1.2 - Prob. 15BSCCh. 1.2 - Prob. 16BSCCh. 1.2 - Prob. 17BSCCh. 1.2 - In Exercises 13–20, determine whether the data are...Ch. 1.2 - Prob. 19BSCCh. 1.2 - In Exercises 13–20, determine whether the data are...Ch. 1.2 - Prob. 21BSCCh. 1.2 - Prob. 22BSCCh. 1.2 - In Exercises 21–28, determine which of the four...Ch. 1.2 - Prob. 24BSCCh. 1.2 - In Exercises 21–28, determine which of the four...Ch. 1.2 - Prob. 26BSCCh. 1.2 - Prob. 27BSCCh. 1.2 - In Exercises 21–28, determine which of the four...Ch. 1.2 - Prob. 29BSCCh. 1.2 - Prob. 30BSCCh. 1.2 - Prob. 31BSCCh. 1.2 - Prob. 32BSCCh. 1.2 - Prob. 33BBCh. 1.2 - Prob. 34BBCh. 1.3 - Prob. 1BSCCh. 1.3 - Prob. 2BSCCh. 1.3 - Prob. 3BSCCh. 1.3 - Prob. 4BSCCh. 1.3 - Prob. 5BSCCh. 1.3 - Prob. 6BSCCh. 1.3 - Prob. 7BSCCh. 1.3 - Prob. 8BSCCh. 1.3 - Prob. 9BSCCh. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - Prob. 12BSCCh. 1.3 - Prob. 13BSCCh. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - Prob. 15BSCCh. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - Critical Thinking: What’s Wrong? In Exercises...Ch. 1.3 - Critical Thinking: What’s Wrong? In Exercises...Ch. 1.3 - Critical Thinking: What’s Wrong? In Exercises...Ch. 1.3 - Prob. 24BSCCh. 1.3 - Prob. 25BSCCh. 1.3 - Prob. 26BSCCh. 1.3 - Prob. 27BSCCh. 1.3 - Prob. 28BSCCh. 1.3 - Prob. 29BBCh. 1.3 - Prob. 30BBCh. 1.3 - Prob. 31BBCh. 1.3 - Prob. 32BBCh. 1.3 - Prob. 33BBCh. 1.3 - Prob. 34BBCh. 1.3 - Prob. 35BBCh. 1.3 - Prob. 36BBCh. 1.3 - Prob. 37BBCh. 1.4 - Prob. 1BSCCh. 1.4 - Prob. 2BSCCh. 1.4 - Prob. 3BSCCh. 1.4 - Prob. 4BSCCh. 1.4 - Prob. 5BSCCh. 1.4 - Prob. 6BSCCh. 1.4 - Prob. 7BSCCh. 1.4 - Prob. 8BSCCh. 1.4 - Prob. 9BSCCh. 1.4 - Prob. 10BSCCh. 1.4 - Prob. 11BSCCh. 1.4 - Prob. 12BSCCh. 1.4 - Prob. 13BBCh. 1.4 - Prob. 14BBCh. 1 - Prob. 1CQQCh. 1 - Prob. 2CQQCh. 1 - Prob. 3CQQCh. 1 - Prob. 4CQQCh. 1 - Prob. 5CQQCh. 1 - Prob. 6CQQCh. 1 - Prob. 7CQQCh. 1 - Prob. 8CQQCh. 1 - Prob. 9CQQCh. 1 - Prob. 10CQQCh. 1 - Prob. 1RECh. 1 - Prob. 2RECh. 1 - Prob. 3RECh. 1 - Prob. 4RECh. 1 - Prob. 5RECh. 1 - Prob. 6RECh. 1 - Prob. 7RECh. 1 - Prob. 8RECh. 1 - Prob. 9RECh. 1 - Prob. 10RECh. 1 - Prob. 1CRECh. 1 - Prob. 2CRECh. 1 - Prob. 3CRECh. 1 - Prob. 4CRECh. 1 - Prob. 5CRECh. 1 - Prob. 6CRECh. 1 - Prob. 7CRECh. 1 - Prob. 8CRECh. 1 - Prob. 9CRECh. 1 - Prob. 10CRECh. 1 - Prob. 11CRECh. 1 - Prob. 12CRECh. 1 - Prob. 1EPCh. 1 - Prob. 2EPCh. 1 - Prob. 1FDDCh. 1 - Prob. 2FDDCh. 1 - Prob. 3FDDCh. 1 - Prob. 4FDD
Knowledge Booster
Similar questions
- Urban Travel Times Population of cities and driving times are related, as shown in the accompanying table, which shows the 1960 population N, in thousands, for several cities, together with the average time T, in minutes, sent by residents driving to work. City Population N Driving time T Los Angeles 6489 16.8 Pittsburgh 1804 12.6 Washington 1808 14.3 Hutchinson 38 6.1 Nashville 347 10.8 Tallahassee 48 7.3 An analysis of these data, along with data from 17 other cities in the United States and Canada, led to a power model of average driving time as a function of population. a Construct a power model of driving time in minutes as a function of population measured in thousands b Is average driving time in Pittsburgh more or less than would be expected from its population? c If you wish to move to a smaller city to reduce your average driving time to work by 25, how much smaller should the city be?arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardInfant Mortality Rates. In the article “Children’s Environmental Index,” the ZPG (September, 1997) provided data for 219 U.S. cities on 20 variables that measure aspects of the quality of life for children. In this exercise, we consider the relationship between infant mortality rate (1990–1994) and the following 11 predictor variables. 1. Density (population per square mile) 2. Birth rate per 1000 population (1988) 3. Percentage of births to teens (1994) 4. Physicians per 1000 population (1995) 5. Student-to-teacher ratio in schools (1993–1994) 6. Student drop-out rate (1990) 7. Unemployment rate (1995) 8. Percentage of children in poverty (1989) 9. Violent crimes per 1000 population (1995) 10. Percentage of juvenile arrests (1995) 11. Pounds of toxic releases per 1000 population (1994) We will use the data in the table on pages B-145–B-147, obtained from the article, for 50 cities chosen randomly from the 219 cities considered. Use the technology of your choice to do the following. a.…arrow_forward
- HYDROMETEOROLOGYarrow_forwardA paper gives data on x = change in Body Mass Index (BMI, in kilograms/meter?) and y = change in a measure of depression for patients suffering from depression who participated in a pulmonary rehabilitation program. The table below contains a subset of the data given in the paper and are approximate values read from a scatterplot in the paper. BMI Change (kg/m²) 0.5 -0.5 0.1 0.7 0.8 1 1.5 1.2 1 0.4 0.4 Depression Score Change -1 4 4 5 8 13 14 17 18 12 14 The accompanying computer output is from Minitab. Fitted Line Plot Depression score change = 6.512 + 5.472 BMI change 5.26270 20- R-Sq R-Sq (adj) 19.88% 27.16% 15- 10- 5- 0- -0.5 0.0 0.5 1.0 1.5 BMI change R-są 5.26270 27.16% Coefficients Term Coef SE Coef T-Value P-Value VIF 6.512 5.472 Constant 2.26 2.88 0.0164 BMI change 2.83 1.93 0.0823 1.00 Regression Equation Depression score change = 6.512 + 5.472 BMI change (a) What percentage of observed variation in depression score change can be explained by the simple linear regression…arrow_forwardCell Phone Radiation Listed below are the measured radiation absorption rates (in W/kg) corresponding to these cell phones: iPhone 5S, BlackBerry Z30, Sanyo Vero, Optimus V, Droid Razr, Nokia N97, Samsung Vibrant, Sony Z750a, Kyocera Kona, LG G2, and Virgin Mobile Supreme. The data are from the Federal Communications Commission.arrow_forward
- 1arrow_forward1. In an investigation of environmental causes of disease, data were collected on the annual mortality rate (deaths per 100 000) for males in 61 large towns in England and Wales. In addition, the water hardness was recorded as the calcium concentration (parts per million, ppm) in the drinking water. Below, we provide some descriptive statistics for both variables, i.e. mortality and calcium concentration. (a) For each variable (i.e. calcium concentration and mortality) describe its distribution in shape.(b) For each variable, are there any outliers in the sample? (Explain.)(c) Suppose that the towns in the sample are either South or North of Derby.arrow_forwardCell Phone Radiation Listed below are the measured radiation absorption rates (in W/kg) corresponding to these cell phones: iPhone 5S, BlackBerry Z30, Sanyo Vero, Optimus V, Droid Razr, Nokia N97, Samsung Vibrant, Sony Z750a, Kyocera Kona, LG G2, and Virgin Mobile Supreme. The data are from the Federal Communications Commission (FCC). The media often report about the dangers of cell phone radiation as a cause of cancer. The FCC has a standard that a cell phone absorption rate must be 1.6 W/kg or less. If you are planning to purchase a cell phone, are any of the measures of center the most important statistic? Is there another statistic that is most relevant? If so, which one?arrow_forward
- Refer to the data presented in Exercise 2.86. Note that there were 50% more accidents in the 25 to less than 30 age group than in the 20 to less than 25 age group. Does this suggest that the older group of drivers in this city is more accident- prone than the younger group? What other explanation might account for the difference in accident rates?arrow_forwardDoctors are interested in the relationship between the dosage of a medicine and the time required for a patient's recovery. Table 2 shows, for a sample of 10 patients, dosage levels (in grams) and recovery times (in hours). These patients have similar characteristics except for medicine dosages. Table 2: Dosage Level and Recovery Time Patient Dosage Level Recovery Time 1 1.2 25 2 1.3 28 3 1.0 40 4 1.4 38 1.5 10 6. 1.8 9. 7 1.2 27 8. 1.3 30 9. 1.4 16 10 1.3 18 a. Estimate the linear regression of recovery time on dosage level. b. Compute R2 and interpret it. c. Perform an F test of goodness of fit at the 5% significance level.arrow_forwardPlease answer the following question using the images provided for data in the images. 1. Which of the following time periods will have the largest annual average increase in the percentage of jobs that could be fully automated (based on the provided images attached)? A) 2020-2028 B) 2028-2030 C) 2030-2035 D) 2035-2040 E) 2040-2050arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt