The data on the U5mort worksheet below represent female lite
The data on the U5mort worksheet below represent female literacy (FemLit0 and under-five mortality (U5Mort) for one hundred and fourteen countries of the world, each having more that one million inhabitants. the data were taken from the state of the Worlds Children (2001). Use these data to caluclate B1 and Bo for FemLit as a predictor of U5Mort.
| FemLit | U5mort |
| 16 | 257 |
| 54 | 41 |
| 29 | 295 |
| 96 | 22 |
| 99 | 30 |
| 98 | 5 |
| 98 | 5 |
| 48 | 89 |
| 98 | 6 |
| 19 | 156 |
| 28 | 107 |
| 78 | 83 |
| 85 | 40 |
| 98 | 17 |
| 58 | 122 |
| 53 | 154 |
| 98 | 6 |
| 27 | 172 |
| 22 | 198 |
| 96 | 12 |
| 77 | 41 |
| 92 | 31 |
| 54 | 207 |
| 95 | 14 |
| 96 | 8 |
| 98 | 5 |
| 81 | 49 |
| 86 | 35 |
| 38 | 52 |
| 73 | 42 |
| 10 | 105 |
| 27 | 176 |
| 98 | 5 |
| 98 | 5 |
| 24 | 75 |
| 98 | 5 |
| 53 | 101 |
| 63 | 60 |
| 22 | 181 |
| 16 | 200 |
| 42 | 129 |
| 69 | 42 |
| 99 | 10 |
| 44 | 98 |
| 78 | 52 |
| 69 | 46 |
| 45 | 128 |
| 98 | 6 |
| 81 | 11 |
| 98 | 4 |
| 81 | 35 |
| 99 | 42 |
| 69 | 118 |
| 98 | 5 |
| 95 | 65 |
| 48 | 111 |
| 77 | 32 |
| 92 | 134 |
| 67 | 22 |
| 44 | 156 |
| 34 | 211 |
| 79 | 9 |
| 12 | 235 |
| 33 | 183 |
| 78 | 23 |
| 87 | 33 |
| 97 | 80 |
| 31 | 53 |
| 23 | 203 |
| 78 | 112 |
| 77 | 70 |
| 28 | 104 |
| 98 | 5 |
| 98 | 6 |
| 67 | 47 |
| 7 | 275 |
| 47 | 187 |
| 98 | 4 |
| 57 | 16 |
| 33 | 112 |
| 92 | 27 |
| 63 | 112 |
| 90 | 32 |
| 89 | 52 |
| 94 | 42 |
| 87 | 6 |
| 96 | 24 |
| 50 | 180 |
| 70 | 25 |
| 23 | 118 |
| 18 | 316 |
| 86 | 4 |
| 66 | 69 |
| 96 | 6 |
| 88 | 19 |
| 47 | 109 |
| 98 | 4 |
| 73 | 30 |
| 82 | 141 |
| 92 | 30 |
| 33 | 143 |
| 97 | 20 |
| 74 | 48 |
| 50 | 131 |
| 98 | 6 |
| 98 | 8 |
| 97 | 17 |
| 99 | 58 |
| 90 | 23 |
| 88 | 40 |
| 36 | 119 |
| 60 | 202 |
| 82 | 90 |
Solution
Let us find linear regression equation using the given data.
Step 1: Find X?Y and X2 as it was done in the table below.
Step 2: Find the sum of every column:
?X=7754 , ?Y=8679 , ?X?Y=404706 , ?X2=621406
Step 3: Use the following equations to find a and b:
ab=?Y??X2??X??XYn??X2?(?X)2=8679?621406?7754?404706113?621406?77542?223.401=n??XY??X??Yn??X2?(?X)2=113?404706?7754?8679113?621406?(7754)2??2.136
Step 4: Substitute a and b in regression equation formula
y = a + b?x= 223.401 ? 2.136?x
Hence regression equation is y = -2.136x+223.401
| X | Y | X?Y | X?X |
| 16 | 257 | 4112 | 256 |
| 54 | 41 | 2214 | 2916 |
| 29 | 295 | 8555 | 841 |
| 96 | 22 | 2112 | 9216 |
| 99 | 30 | 2970 | 9801 |
| 98 | 5 | 490 | 9604 |
| 98 | 5 | 490 | 9604 |
| 48 | 89 | 4272 | 2304 |
| 98 | 6 | 588 | 9604 |
| 19 | 156 | 2964 | 361 |
| 28 | 107 | 2996 | 784 |
| 78 | 83 | 6474 | 6084 |
| 85 | 40 | 3400 | 7225 |
| 98 | 17 | 1666 | 9604 |
| 58 | 122 | 7076 | 3364 |
| 53 | 154 | 8162 | 2809 |
| 98 | 6 | 588 | 9604 |
| 27 | 172 | 4644 | 729 |
| 22 | 198 | 4356 | 484 |
| 96 | 12 | 1152 | 9216 |
| 77 | 41 | 3157 | 5929 |
| 92 | 31 | 2852 | 8464 |
| 54 | 207 | 11178 | 2916 |
| 95 | 14 | 1330 | 9025 |
| 96 | 8 | 768 | 9216 |
| 98 | 5 | 490 | 9604 |
| 81 | 49 | 3969 | 6561 |
| 86 | 35 | 3010 | 7396 |
| 38 | 52 | 1976 | 1444 |
| 73 | 42 | 3066 | 5329 |
| 10 | 105 | 1050 | 100 |
| 27 | 176 | 4752 | 729 |
| 98 | 5 | 490 | 9604 |
| 98 | 5 | 490 | 9604 |
| 24 | 75 | 1800 | 576 |
| 98 | 5 | 490 | 9604 |
| 53 | 101 | 5353 | 2809 |
| 63 | 60 | 3780 | 3969 |
| 22 | 181 | 3982 | 484 |
| 16 | 200 | 3200 | 256 |
| 42 | 129 | 5418 | 1764 |
| 69 | 42 | 2898 | 4761 |
| 99 | 10 | 990 | 9801 |
| 44 | 98 | 4312 | 1936 |
| 78 | 52 | 4056 | 6084 |
| 69 | 46 | 3174 | 4761 |
| 45 | 128 | 5760 | 2025 |
| 98 | 6 | 588 | 9604 |
| 81 | 11 | 891 | 6561 |
| 98 | 4 | 392 | 9604 |



