Question: The table below shows primary school enrollment for a certain country. Here,x represents the number of years after1820, andy represents the enrollment percentage. Use Excel
The table below shows primary school enrollment for a certain country. Here,x
represents the number of years after1820, andy represents the enrollment percentage. Use Excel to find thebest 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
