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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!