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 25BSC
To determine
To find: Whether it is sensible to use the difference of the pair of values.
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.
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.)
Q5 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…
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
- pls help ASAParrow_forwardThe 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_forward
- M3arrow_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_forwardArchaeologists 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_forward
- please answer question attacharrow_forwardExercise 2. A study is designed to test whether there is a difference in mean daily calcium intake in adults with normal bone density and adults with osteoporosis. Adults 60 years of age with normal bone density and osteoporosis are selected at random from hospital records and invited to participate in the study. Each participant's daily calcium intake (mg) is measured based on reported food intake and supplements. The data are shown below. Normal Bone Density: 1200 1000 980 900 750 800 Osteoporosis: 890 650 1100 900 400 350 480 Do these data give statistical evidence of differences in mean calcium intake across the two groups? That is, do these data give statistical evidence that the process means, say mean(Y:RE,) and mean(Y:RE2) are different? Here, Y = daily calcium intake (mg), RE, = "Nature generates a 60-year-old with normal bone density" and RE2 ="Nature generates a 60-year-old with osteoporosis." (a) Carefully describe the target of inference. Hint: This will be a difference bw…arrow_forwardPlease give the correct answerarrow_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