Math IA
maxwuxiang
book2.xlsSheet1
| study time〔X〕 | Math average 〔Y〕 | |||||
| 30 | 93 | -1.5 | 19.1 | -28.65 | 2.25 | 364.81 |
| 25 | 86 | -6.5 | 12.1 | -78.65 | 42.25 | 146.41 |
| 20 | 72 | -11.5 | -1.9 | 21.85 | 132.25 | 3.61 |
| 15 | 53 | -16.5 | -20.9 | 344.85 | 272.25 | 436.81 |
| 35 | 77 | 3.5 | 3.1 | 10.85 | 12.25 | 9.61 |
| 25 | 76 | -6.5 | 2.1 | -13.65 | 42.25 | 4.41 |
| 30 | 75 | -1.5 | 1.1 | -1.65 | 2.25 | 1.21 |
| 30 | 56 | -1.5 | -17.9 | 26.85 | 2.25 | 320.41 |
| 15 | 55 | -16.5 | -18.9 | 311.85 | 272.25 | 357.21 |
| 30 | 80 | -1.5 | 6.1 | -9.15 | 2.25 | 37.21 |
| 25 | 68 | -6.5 | -5.9 | 38.35 | 42.25 | 34.81 |
| 50 | 90 | 18.5 | 16.1 | 297.85 | 342.25 | 259.21 |
| 20 | 75 | -11.5 | 1.1 | -12.65 | 132.25 | 1.21 |
| 60 | 80 | 28.5 | 6.1 | 173.85 | 812.25 | 37.21 |
| 20 | 65 | -11.5 | -8.9 | 102.35 | 132.25 | 79.21 |
| 60 | 90 | 28.5 | 16.1 | 458.85 | 812.25 | 259.21 |
| 10 | 50 | -21.5 | -23.9 | 513.85 | 462.25 | 571.21 |
| 50 | 95 | 18.5 | 21.1 | 390.35 | 342.25 | 445.21 |
| 10 | 42 | -21.5 | -31.9 | 685.85 | 462.25 | 1017.61 |
| 70 | 100 | 38.5 | 26.1 | 1004.85 | 1482.25 | 681.21 |
| 31.5 | 73.9 | |||||
| 4238 | 5805 | 5067.8 |
Sheet2
Sheet3
x
x
-
Y
Y
-
)
)(
(
y
y
x
x
-
-
2
)
(
x
x
-
2
)
(
y
y
-
Average
Sum
