0% found this document useful (0 votes)
7 views1 page

right

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 1

FLORANO, ALEIZA NICOLE B.

BBE4301/B3C

ANSWER Solve for the unknown by considering X & Y as populations:


ANSWER You must use MS Excel for Pearson's R value and/or online calculator for the other unknowns.
1. Pearson R 0.67 STUDENT X Y XY X2 Y2
1 55 205 11275 3025 42025 250
2 54 198 10692 2916 39204
2. Co D 0.45 3 52 203 10556 2704 41209
200
4 50 201 10050 2500 40401
5 50 186 9300 2500 34596
3 X Y 6 48 203 9744 2304 41209 150
Standard Deviation 6.74 10.09 7 47 195 9165 2209 38025
Mean 43.35 190.25 8 46 188 8648 2116 35344 100
Skewness 0.09 -0.87 9 46 192 8832 2116 36864
Kurtosis -1.17 0.90 10 45 195 8775 2025 38025
50
Values use for Pearson's R 11 43 190 8170 1849 36100
N 20 12 40 188 7520 1600 35344
∑X 867 13 40 194 7760 1600 37636 0
30 35 40 45 50 55 60
∑Y 3805 14 38 165 6270 1444 27225
∑XY 165854 15 38 170 6460 1444 28900
∑X 2
38493 16 37 185 6845 1369 34225
∑Y2 725937 17 36 188 6768 1296 35344
18 36 194 6984 1296 37636
a 146.96 19 34 180 6120 1156 32400
b 1.00 20 32 185 5920 1024 34225
r 0.67 TOTAL 867 3805 165854 38493 725937

You might also like