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 26BSC
To determine
To find: The issue that can be found by the given data during a statistical analysis of the data.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Department of Research and Development of Unilever Sdn Bhd has conducted a
study to improve the quality of production line by measured the weight (in ounces)
of 50 bars of soap. The results are as shown in Table 2(b).
Table 2(b) Weight of soap
11
12
12
12
13
13
13
13
13
14
14
14
14
14
15
15
15
15
15
15
15
15
15
16
16
16
16
16
16
16
16
16
17
17
17
17
17
17
17
17
17
18
18
18
18
18
18
18
19
20
(1) Calculate the mean, standard deviation and variance.
(ii) By using 6 of class interval, construct a histogram for this data.
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.)
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_forwardQ5 a) Demographic data from 126 countries is obtained for the year 2017. It is hypothesized that life expectancy (Y) is dependent on number of under five deaths (X2) , polio immunization coverage (D), Per capita Govt. Exp. on Health Care (X3) (in Rs crores), Per Capita GNI (in Rs crores) (X4) and Average number of years of Schooling (Xs). Polio immunization coverage =1 if yes and 0 otherwise. Following regressions were estimated: MODEL 1: = 0.903 – 0.561X2¡ + 2.008 X3i + 0.553X4¿ + 0.778 X5i + 3.638 D (0.405) se = (1.280) (0.765) (0.712) (0.491) R? = 0.787 RSS = 1339.8 MODEL 2: P, = 1.379 + 0.594 X31 + 2.139 D se = (0.406) (0.465) R? = 0.677 RSS = 1567.28 i. Is it a time series or a cross sectional data ii. Show model 2 is a restricted version of model 1 and what is the restriction? iii. Test for the statistical significance of the restriction at 5% level. iv. Construct a 95% confidence interval for true per capita government health expenditure in model II and check whether it is…arrow_forward
- The article cited in Exercise 4 also investigated the effects of the factors on glucose consumption (in g/L). A single measurement is provided for each combination of factors (in the article, there was some replication). The results are presented in the following table. Glucose Consumption 68.0 -1 -1 -1 -1 -1 77.5 -1 -1 98.0 1. 1. -1 98.0 -1 -1 74.0 -1 77.0 -1 97.0 98.0 Compute estimates of the main effects and the interactions. a. Is it possible to compute an error sum of squares? Explain. Are any of the interactions among the larger effects? If so, which ones? d. Assume that it is known from past experience that the additive model holds. Add the sums of squares for the interactions, and use that result in place of an error sum of squares to test the hypotheses that the main effects are equal to 0. Ъ. C.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_forwardM3arrow_forward
- Archaeologists can determine the diets of ancient civilizations by measuring the ratio of carbon-13 to carbon-12 in bones found at burial sites. Large amounts of carbon-13 suggest a diet rich in grasses such as maize, while small amounts suggest a diet based on herbaceous plants. The article "Climate and Diet in Fremont Prehistory: Economic Variability and Abandonment of Maize Agriculture in the Great Salt Lake Basin" (J. Coltrain and S. Leavitt, American Antiquity, 2002:453-485) reports ratios, as a difference from a standard in units of parts per thousand, for bones from individuals in several age groups. The data are presented in the following table. Ratio Age Group (years) 0-11 17.2 18.4 17.9 16.6 19.0 18.3 13.6 13.5 18.5 19.1 19.1 13.4 12-24 14.8 17.6 18.3 17.2 10.0 11.3 10.2 17.0 18.9 19.2 25-45 18.4 13.0 14.8 18.4 12.8 17.6 18.8 179 18.5 17.5 18.3 15.2 10.8 19.8 1 19.2 15.4 13.2 46+ 15.5 18.2 12.7 15.1 18.2 18.0 14.4 10.2 16.7 Construct an ANOVA table. You may give a range for…arrow_forwardplease answer question attacharrow_forwardCan someone please help me with part c on question 1?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
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
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt