Question

In: Statistics and Probability

The table below shows primary school enrollment for a certain country. Here, xx represents the number...

The table below shows primary school enrollment for a certain country. Here, xx represents the number of years after 18201820, and yy represents the enrollment percentage. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.

x   y
0   0.1
5   0.1
10   0.1
15   0.2
20   0.2
25   0.3
30   0.4
35   0.5
40   0.6
45   1.1
50   1.5
55   3.0
60   4.5
65   5.5
70   6.1
75   6.8
80   7.0
85   8.0
90   9.3
95   10.7
100   12.4
105   14.1
110   16.6
115   17.5
120   19.7
125   19.4
130   32.7
135   40.9
140   47.6
145   57.8
150   57.0
155   61.7
160   63.2
165   75.0
170   76.5
175   96.0
180   92.0
185   100.0
190   100.0

Provide your answer below:

y =  x -

Solutions

Expert Solution

X - Mx Y - My (X - Mx)2 (X - Mx)(Y - My)
-95 -27.2359 9025 2587.4103
-90 -27.2359 8100 2451.2308
-85 -27.2359 7225 2315.0513
-80 -27.1359 6400 2170.8718
-75 -27.1359 5625 2035.1923
-70 -27.0359 4900 1892.5128
-65 -26.9359 4225 1750.8333
-60 -26.8359 3600 1610.1538
-55 -26.7359 3025 1470.4744
-50 -26.2359 2500 1311.7949
-45 -25.8359 2025 1162.6154
-40 -24.3359 1600 973.4359
-35 -22.8359 1225 799.2564
-30 -21.8359 900 655.0769
-25 -21.2359 625 530.8974
-20 -20.5359 400 410.7179
-15 -20.3359 225 305.0385
-10 -19.3359 100 193.359
-5 -18.0359 25 90.1795
0 -16.6359 0 0
5 -14.9359 25 -74.6795
10 -13.2359 100 -132.359
15 -10.7359 225 -161.0385
20 -9.8359 400 -196.7179
25 -7.6359 625 -190.8974
30 -7.9359 900 -238.0769
35 5.3641 1225 187.7436
40 13.5641 1600 542.5641
45 20.2641 2025 911.8846
50 30.4641 2500 1523.2051
55 29.6641 3025 1631.5256
60 34.3641 3600 2061.8462
65 35.8641 4225 2331.1667
70 47.6641 4900 3336.4872
75 49.1641 5625 3687.3077
80 68.6641 6400 5493.1282
85 64.6641 7225 5496.4487
90 72.6641 8100 6539.7692
95 72.6641 9025 6903.0897
SS: 123500 SP: 64368.5

Sum of X = 3705
Sum of Y = 1066.1
Mean X = 95
Mean Y = 27.3359
Sum of squares (SSX) = 123500
Sum of products (SP) = 64368.5

Regression Equation = ŷ = bX + a

b = SP/SSX = 64368.5/123500 = 0.52

a = MY - bMX = 27.34 - (0.52*95) = -22.18

ŷ = 0.52X - 22.18


Related Solutions

The table below represents the number of young people in a certain city enrolled in the...
The table below represents the number of young people in a certain city enrolled in the academic support and enrichment program of youth services. Here, x represents the number of months from January 2011, and y represents the number of young people enrolled. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places. x   y 0   3199 1   3282 2   3432 3   3245 4   3076 5   3485 6   1524 7   1880...
The table below shows the number of students in each year at a certain university: Year...
The table below shows the number of students in each year at a certain university: Year of study 1 2 3 4 5 6 7 No. of students 300 280 275 175 92 48 30 You would like to select a random sample of 100 students from this university. i. Explain how you would choose a simple random sample. ii. Explain how you would choose a sample using systematic (interval) sampling method. iii. If you use stratified sampling method to...
The table shows the estimated percentage P of the population of a certain country that are...
The table shows the estimated percentage P of the population of a certain country that are mobile-phone subscribers. (End of year estimates are given.) Year 1997 1999 2001 2003 2005 2007 P 2.1 8.2 15.7 25 45.7 62.5 (a) Find the average rate of change of P. (i) From 2003 to 2007 ........................... percentage points per year (ii) From 2003 to 2005 ............................. percentage points per year (iii) From 2001 to 2003 ............................... percentage points per year (b) Estimate the...
The table shows the estimated percentage P of the population of a certain country that are...
The table shows the estimated percentage P of the population of a certain country that are mobile-phone subscribers. (End of year estimates are given.) Year 1997 1999 2001 2003 2005 2007 P 2.1 8.2 15.7 25 45.7 62.5 (c) Estimate the instantaneous rate of growth in 2003 by sketching a graph of P and measuring the slope of a tangent. (Sketch your graph so that it is a smooth curve through the points, and so that the tangent line has...
The table below shows the number of male and female students enrolled in nursing at a university for a certain semester.
The table below shows the number of male and female students enrolled in nursing at a university for a certain semester. A student is selected at random. Complete parts (a) through (d). Nursing majorsNon-nursing majorsTotalMales9810161114Females60017292329Total69627453443(c) Find the probability that the student is not female or a nursing major. P(not being female or being a nursing major)=_______ Round to the nearest thousandth as needed.) (d) Are the events "being male" and "being a nursing major" mutually exclusive? Explain. A. Yes, because one can't be male and...
The table to the right shows the number of​ people, in​ thousands, in a country without...
The table to the right shows the number of​ people, in​ thousands, in a country without health insurance in a certain year. Complete parts​ a) through​ d) below. Insured Uninsured Under 18 years 67 comma 22767,227 7 comma 0537,053 18 to 24 years 21 comma 37221,372 8 comma 8308,830 25 to 34 years 29 comma 10929,109 11 comma 58211,582 35 to 44 years 31 comma 62231,622 8 comma 0258,025 45 to 64 years 67 comma 16167,161 13 comma 03113,031 65...
The table to the right shows the number of​ people, in​ thousands, in a country without...
The table to the right shows the number of​ people, in​ thousands, in a country without health insurance in a certain year. Complete parts​ a) through​ d) below. Insured Uninsured Under 18 years 67 comma 02567,025 7 comma 4337,433 18 to 24 years 21 comma 08721,087 8 comma 8648,864 25 to 34 years 29 comma 33729,337 11 comma 25711,257 35 to 44 years 31 comma 77831,778 8 comma 2798,279 45 to 64 years 67 comma 06267,062 13 comma 46513,465 65...
The following table is used for a number of questions below. The table above shows the...
The following table is used for a number of questions below. The table above shows the responses of a survey of teenagers aged 14-18 when asked at what age they thought they would become financially independent. Age of Financial Independence Number of Responses 16-20 191 21-24 467 25-27 244 28 or older 42 What do the teens expect is the probability of being financially independent before age 25? A recent Gallup poll found that only 14 percent of 24- to...
The table shows the number of people, in thousands, in a country without health insurance in...
The table shows the number of people, in thousands, in a country without health insurance in a certain year. Insured Uninsured UNDER 18 YEARS 67,936 7,627 18 TO 25 YEARS 21,847 8,814 25 TO 34 YEARS 29,993 11,039 35 TO 44 YEARS 31,973 8,799 45 TO 54 YEARS 67,710 13,467 65 YEARS AND OLDER 38,423 757 a) What percentage of the countries' population in the year did not have health insurance and was between the ages of 18 to 24...
The following table shows the number of fifth and sixth grade teachers in a school district...
The following table shows the number of fifth and sixth grade teachers in a school district and the number of students in each of those grades. The number of teachers for each of the grade levels was determined by using the Huntington-Hill apportionment method. The district has decided to hire a new teacher for either the fifth or sixth grade. Number of teachers Number of students Fifth grade 19 607 Sixth grade 23 739 (a) Use the apportionment principle to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT