Consider the same data as in question 2 but now in four columns which provide average grade in years 1-4 and the data on how often classes are skipped (school skip). Since the average grade is ordinal, a regression analysis provides a better means to confirm a linear relationship between average grade and years. Follow the steps below to conduct a regression analysis. (a) Use Excel to find the correlation coefficient for average grade and classes skipped for each of the four years. (b) Identify the year that has the strongest linear relationship. Using the data for this year, use Excel to perform a full regression analysis including a scatter plot with regression line plotted. Include the regression line equation and coefficient of determination on the graph. (Hint: Use classes skipped as the explanatory variable.) (c) Based on the correlation coefficient and the analysis in (b), do you feel that frequency of classes skipped is a good predictor of average grade for the year under study? Explain by making reference to relevant numerical measures where appropriate.

the excel data is there

0271 X 1 1 O F 2 1 4 www.schoolhp.1.00 725 3 796 2 73.1 2 58 1 1 CH www school.4.00 6922 4 77.57 1 77 2 1 7620 1 GO werage school 7791 753 677 14.1 9.40 23.5 7389 779 726 653 68 87.44 7391 2 2 3 1 2 2 1 3 1 72.67 753 796 57.57 22 65.67 1 1 2 2 2 744 64 78.14 E 2 2 1 1 2 2 2 2 1 LE 14 E 75.1 74 3 2 1 4 M 813 841 725 50 25.62 717 PE 2 1 2 2 3 2 2 1 72.00 691 werage school ka 1.00 745 2 75 2 2 5 784 2 5 63.8 2 71.7H 1 72 1 144 3 . 2 72 1 12 6 3 13 78. 1 14 75.89 2 15 8.4 3 16 582 3 27 70.4 2 76.6 2 15 72 3 20 2 1 76.1 2 22 4 23 738 24 74 25 662 3 26 27 716 28 71.4 2 29 2014 30 547 1 31 643 2 32 72 33 58 2 34 85.4 35 79.1 2 36 58.11 3 37 74.5 1 38 78.56 3 39 59 1 40 52 41 796 4 E9 1 2 2 2 3 02 301 4 75 767 52 940 14.45 72 689 739 819 7891 8 694 66.5 13 772 79.4 655 66.56 761 2 3 3 2 4 2 3 2 52.56 26 22 7111 5.11 53.11 762 63.9 698 619 S 4 1 2 2 E E 717 79.27 91.08 77.17 73.6 9 23 2008 6511 2 1 5 2 2 2 2 3 2 3 722 75.33 3 1 2 2 1 3 2 636 2 > 2 3 823 832 62.11 78.33 8125 1 3 1 2 2 3 4 2 35:1 81.1 2.50 79.7 82.25 66,6 63 757 RE 1982 2222 34 836 20:33 8113 816 735 71 B2 655 1655 1 2 1 2 2 2 553 25.91 3 CF LH Sheet2 Sheets Sheet She Sheet + Ready MacBook Air 0271 X fx A 3 D 3 F 0 H M N 0 2 E E B65 72.67 65.78 1 1 18 2 1 3 2 1 4 2 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 50 2 3 4 2 1 4 3 4 4 2 3 1 4 2 1 1 2 2 3 4 2 3 1 4 2 3 3 4 3 3 1 1 4 2 3 3 2 2 1 4 2 82 57.75 60.3 77.5 10.4 82.7 73.5 77.7 755 64.25 68.25 70.22 775 80.2 50.7 566 67.75 S4 74 8955 54 66.7 71 619 72.7 53.75 848 759 258 803 5822 845 83.7 702 734 82 59.4 5225 74.7 342 73.9 65.56 782 20.1 67.89 GSG +6035 79.3 79,6 65.67 6422 56.5 56.33 72 82 saa 73.6 73 6189 75.9 62.86 87.2 64.22 735 1655 0.86 72.25 82.9 814 13.42 725 75.5 77 7331 64.91 30 751 3.09 65.14 9.5 63.75 549 889 E 1 2 2 1 4 2 3 3 4 3 2 1 2 2 1 3 2 2 4 2 2 1 EM 2 2 1 3 63 64 65 66 57 87.73 72 69 726 74.8 70.1 65 76,6 749 84.25 69.56 671 02.67 605 75.8 8733 73.85 753 75 57 7436 61.43 91.09 688 78.78 72.8 81.92 918 824 68.67 631 56 20.22 3656 911 553 665 75.54 75.1 106 69 1 1 1 2 3 2 4 1 2 2 1 2 2 2 2 1 1 3 1 3 1 2 1 79) 59 20 71 72 73 74 75 76 77 78 79 80 4 2 1 2 1 1 3 1 2 1 2 2 2 2 2 2 2 2 1 2 1 77.67 67 925 68 79.64 76.7 R0.21 90.1 8522 76.45 7174 E 3 3 1 3 1 1 2 2 2 2. 2 1 2 1 1 2 3 81.1 886 835 69.82 65 81 EB 2 1 2 2 1 2 1 1 2 2 $ 52.63 327 126 899 69.6 06 652 84 82.4 705 72 ERE Shoot 1 7318 57.5 29 1 89 5 She Shot Sheet Sheet1 + Ready Ca West General Paste Cooy Format B 1 n Merge & Center 5 Conditional Format Cat 0271 x x A U D E F 0 H 1 1 L M N 0 696 792 745 56. 11 754 8173 36 83 84 85 16 87 18 9 90 T E 69.8 78.8 70.9 71.56 71 29.7 LOW 900 EL 2 2 1 2 4 1 2 2 1 2 3 3 2 2 2 1 2 3 1 2 3 1 2 2 774 80.9 792 RS 54 R35 3.45 85.78 25 715 TO 78.33 325 748 75.38 755 13 79.5 13.7 32 71.9 2011 9.33 29.1 655 783 633 64.25 772 sea 83.25 76.55 73.27 21 E 666 81.9 64 67.8 67.67 11.4 727 5238 63.6 543 79 66 6 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 so 1 3 1 4 2 1 3 3 3 3 71 3091 627 9 1 1 2 1 1 2 2 2 3 2 1 2 1 2 3 2 4 1 2 2 1 2 2 2 1 3 71.00 B01 72.25 70.83 72.2 67.44 75.1 69.33 81 53.00 68.71 604 59.2 75.7 6.89 65.11 507 795 726 63:22 87.18 822 75.75 303 696 29.3 83 B015 76.89 783 821 745 696 789 624 2 3 2 2 1 1 3 1 2 2 6178 75 784 72.1 R44 88.5 ER 772 1 2 1 1 2 1 1 2 2 2 1 3 2 2 1 4 2 2 3 1 2 2 . 2 2 . 3 1 5 2 2 2 2 1 1 1 1 1 3 1 2 1 3 1 1 2 2 1 1 1 3 2 2 2 3 1 1 1 2 873 75.4 7201 76. 19:30 79.5 75.56 87 72.35 7655 79.31 615 10 110 112 113 E 2 115 116 117 312 119 120 121 122 123 365 79.67 72.4 74.4 818 79.7 75:33 71.6 765 67 1 2 1 1 2 2 3 4 25 753 75.7 857 7.43 7035 7589 7625 752 151) 12.4 35 825 822 757 821 732 20.58 796 11 57,75 82.45 8332 21.00 745 2 2 1 1 3 1 1 2 2 1 1 2 2 2 3 2 TO EEES > Shouc Sheet Sheet Sheet1 Road VIEW X Cut Copy Calibri (tody) - 12 A- WpText General Paste Format BIU. Merge Center C Canon Formatting Car bala 0271 2 X A B D E + H 1 14 M N O D M22 613 873 174 125 126 127 123 129 894 2 2 2 2 3 4 2 703 693 54 27.75 65.5 59.6 35 60.55 33 53 718 2 7222 54.75 2 1 2 2 2 3 72 9.21 3 2 2 1 2 1 2 3 OET TET CET SA 1 724 29 71 175 075 E TE 783 561 40 1.33 154 135 3 1 2 3 1 M4 2 2 3 2 3 3 2 2 2 1 5 2 2 1 4 1 2 1 TE 2 1 2 1 2 2 2 29 YLL THE TA 29.33 950 LET 1 ISS 1 2 1 1 2 1 612 6 4 72.7 2 1 2 103 78.01 59. 802 887 64 765 17 545 . 257 665 746 7.73 12 6213 7211 842 RE 32 18 202 85 773 1 TE 543 3 744 715 72 733 ES 2 OC 138 129 140 145 142 143 1.44 145 145 147 14 23 150 151 152 193 154 255 2 14.42 77 2 1 3 1 2 2 3 2 1 2 2 2 4 2 2 1 2 2 2 2 3 1 7409 59 11-2 2 3 2 1 1 25.22 85 522 2 1 2 3 2 1 1 2 1 1 1 3 3 ts ER 682 7.67 7457 72 263 711 3 1 1 1 2 2 2 3 69 575 594 75 669 55.86 899 71.5 25 7244 64 805 58.6 15 2015 536 6512 36.44 0.78 72.1 555 77.64 67 2 2 2 2 1 1 2 2 1 1 156 157 156 150 160 161 162 163 164 2 2 2 OP 70.4 11 703 513 5867 56 852 72.6 1 2 3 2 1 19 71.45 AS 75 1 1 7 2 2 3 665 63 88 873 736 1 1 3 1 4 753 Shoot Show Shoot het Body MacBook B C D 1 a H M N 165 166 167 2 E 168 2 3 3 3 1 3 2 2 3 7435 65 7 711 32.75 7.00 16 170 171 172 2009 64.67 09.11 733 307 65.9 778 65.7 717 73.1 3 785 682 TR 3 2 2 2 1 2 2 2 2 173 23.4 67.5 669 16 755 63.44 79 752 753 542 76 76.6 02 62.9 616 70.3 70.9 57.8 50.6 50.4 67.25 692 78 174 175 176 2 2 2 2 2 2 2 2 2 2 2 1 2 2 2 2 2 3 2 2 743) 5455 77.27 735 82.9 73.75 82.67 78.55 78.33 771 WA 23 731 75.4 69.23 72 783 677 638 KO 2 1.72 178 2 1 2 3 2 2 2 1 2 4 2 2 1 2 3 179 180 181 182 1 184 IBS 186 187 1 3 2 2 2 2 2 2 4 2 1 1 62.73 7173 74.4 63.22 57.63 62 6125 737 BOR 734 713 759 60.11 53.8 70.5 73 7183 765 685 7073 2 2 4 3 2 2 2 1 2 2 2 2 1 3 2 2 2 3 2 2 2 2 1 1 3 3 2 2 2 2 2 2 1 75.7 1.64 29.00 26.63 262 83 75.1 79.2 20:55 80.7 775 223 68.67 74.9 78.25 80.7 1522 R26 85.63 30.73 60.63 66.63 785 72.4 29.13 813 71.6 27.09 78.18 65.63 73.5 811 79.36 715 762 E 19 190 191 192 193 194 195 196 197 198 199 3 2 2 598 77.2 14 12.67 79.1 78 53 526 77.22 711 30.11 785 63.91 72.71 771 756 68.75 596 9.6 752 73.75 75.3 715 585 72 75 67.75 3 2 3 2 1 1 2 2 3 2 1 3 1 3 1 1 3 E 1 2 19 2 1 3 3 200 1 686 68.7 72.92 4 6 201 202 203 204 205 723 3 1 2 2 3 1 2 3 1 2 1 3 1 1 1 2 1 2 2 3 73.4 50 72.5 79.6 77.1 78.62 7175 22.4 3. 80.2 625 711 3 1 2 2 2 . Sheet2 Sheets Shoot Sheet Sheet + Ready Paste GO Format B 1 U Mars A Car C%. 5 . Conditional Format Gel Farming ways 0271 X fo A 5 D 1 F G 1 L M N 0 F 74 22 774 79.6 75 CO 25:45 724 1 1 2 2 4 1 835 M.44 16.30 235 743 1 1 2 2 3 1 3 73 2.00 10.54 745 71 72 698 719 R2 718 1 206 207 20 200 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 225 230 8.5 78, 75.75 8.4 61 8233 77 so 291 75.22 728 72.1 73.5 73.91 57.25 11 3 1 2 1 2 3 2 2 2 75 526 20:27 1. 899 14.1 73.5 733 793 703 R2 64 41 R18 56.5 35 29.09 29.09 1473 79.5 72 2 1 2 3 4 2 2 1 1 2 2 2 4 1 1 4 4 2 1 2 1 2 2 1 1 2 2 3 2 73.2 676 738 758 1 R3.25 GA 1 2 1 2 3 1 1 3 3 3 2 2 3 1 2 2 2 2 3 2 1 2 2 2 1 1 2 1 1 2 3 3 2 1 1 3 2 2 73 56.75 75 79 734 653 723 32 72.22 59.9 3 2 3 1 2 3 1 2 2 518 5733 7927 3 73 71.27 B4 723 67.79 692 822 12 2 3 1 2 1 2 1 2 2 2 1 2 2 TEC 99 CEE 232 233 234 235 236 724 06 10.4 22.17 72764 79 316 301 0 76.71 788 54 185 1 2 1 2 3 2 1 2 2 2 05 847 12 202 1 E LEZ PEZ 65.4 1 1 1 2 1 2 1 753 87.64 76.71 788 576 62.22 36 723 711 23 745 78.67 662 229 2.40 201 242 243 2:44 245 246 74 $3.9 79.11 25.11 73.86 755 7745 62.4 741 4 2 2 2 1 3 2 2 154 7282 801 857 74.33 793 765 2.63 2 1 1 3 1 2 2 2 E 77.11 76.78 27.11 591 73 2 2 3 18 2 3 70.67 7435 Shout Shed so Set Read MacBook Format Marge & Center mant Conditional Format Cel Formatting Styles 0271 x fe A C D G H 1 M N o 75.6 75 55.2 2 1 2 72.3 77.91 621 72.6 658 75.9 77.5 73.9 962 L'EL ST69 EEL 2 1 3 3 2 1 1 77.55 36 36 75.46 89.5 72 73 77.67 847 75 2 1 2 7 1 E 1 69 2 4 2 3 1 3 2 1 2 4 5 29.09 766 63 2 1 2 2 1 3 2 3 3 2 3 2 2 1 3 3 1 3 29.5 63.86 61.17 7956 70 3 2 2 3 3 2 4 1 1 4 3 1 3 4 715 705 736 61.33 60 807 59.5 7333 57.4 62.5 72.9 63.6 422 80.5 74.8 SL 2 B0 355 714 69.7 6 61.62 746 606 75 73.4 31.44 1 1 247 245 249 250 251 252 253 254 255 256 257 2:58 259 260 263 262 263 264 265 266 267 28 269 220 22: 222 273 274 275 275 277 278 279 280 281 282 283 284 285 286 27 76.22 76.91 56.25 3 3 1 2 3 75.4 83.6 7025 04 36 75.6 3 79.82 75.11 ELS 70.67 68.9 71 57.63 63.71 130 72.18 689 649 72 78.35 73 25.7 71.38 79.5 75.4 03 726 813 4 70.75 785 4.45 7233 144 695 722 764 25 67 669 2 3 2 3 1 12 3 4 1 1 2 4 1 4 1 2 3 3 3 1 1 2 1 1 1 71 741 73.6 20.17 72.22 57.71 708 663 26.6 63.44 10.18 2 78.58 789 3 1 2 2 2 + 2 2 1 1 2 1 2 82.25 77 4 2 2 1 2 2 1 2 EST 30 77.11 84 7171 7864 414 2 2 2 1 3 2 2 1 2 3 1 . 2 1 E 69.75 79.6 611 554 707 63.4 64.7 71 2.6 545 ES 665 76.33 54.63 616 695 545 57 713 785 622 27.8 1 3 2 2 2 1 3 1 3 2 2 1 1 74 63.91 79.55 374 B36 67.45 1 4. 2 1 1 1 2 1 1 345 Sht Sheet Sheet Sheet Ready MacBook Air Format Merge Center TE Conditional Format Cal 0221 X f C 0 E 7 D H 1 N O a 28 29 290 1 346 79.1 824 7 742 63.5 16 812 BS 792 74 75.00 54.78 5 22.45 824 73 12.25 75 706 M 93. 25.2 393 27 73 273 75 61 1 1 1 2 3 2 09 t'89 1 1 3 2 2 1 3 3 1 1 1 1 2 2 0 292 293 294 295 295 297 298 293 300 301 302 303 304 305 570 1 1 2 2 2 2 3 2 1 5 1 3 1 3 4 2. 1 2 2 5 1 1 1 1 2 2 2 2 1 3 1 1 1 1 2 2 3 1 1 2 2 59.7 626 RO6 10.2 72.5 5733 561 812 + 855 78.92 5444 2 1 1 2 2 3 1 1 2 2 4 1 2 2 2 4 RSS 755 52.25 10 LOE BOE EN 309 1 3 3 2 3 7 OTE ITE ZEE 1 75 57.75 87 81 71.1 67.63 66.5 08 67.9 30 67.44 44.33 69.9 29 20.4 69.5 6211 614 761 72 7171 6767 72.22 54 5589 275 853 64.44 22.5 58.89 61.18 753 84.89 7225 Show 25.4 50,6 212 83.4 62.4 80 722 56 5089 se 614 55 81.6 22.5 67.43 1 1 1 2 1 79.57 636 14 14 72.7 5268 50 85.6 716 MS 7522 64 753 09 673 739 57.67 70 753 75.56 7171 9.25 664 614 545 824 362 71.15 714 72.11 59.00 7644 52.73 792 1 2 2 2 1 3 4 2 3 3 2 2 1 1 314 315 316 117 7 7530 3275 761 19 7914 779 778 7529 78 73.9 25.67 692 69.57 67.70 7323 795 2 2 1 2 3 3 3 3 3 2 1 2 2 1 1 1 2 1 4 2 1 4 BIE 7 E 320 321 222 3 2 2 2 90 ELE 24 325 326 327 328 329 1 3 3 62.89 50.9 25.1 19.4 214 Shoot 1 2 1 2. 1 1 1 3 1 3 2 3 1 23.17 22 6986 23:56 27.91 91.67 803 2 2 2 1 2 3 3 Shod Sheet Sheet + MacBook Air 0271 x vf B c. D G H 1 1 N E 65.57 80 71 632 3 1 2 1 68.6 77.44 603 57 685 793 69.5 724 84 56 738 71.23 79.5 8144 773 68 87.33 926 82 788 73 3 1 2 1 2 2 1 1 2 2 3 1 2 2 4 2 2 1 3 2 1 1 1 2 2 1 98 4 TER 16 2 2 1 1 2 2 1 2 3 2 2 1 3 2 E 816 56.4 29 563 782 71.1 505 731 647 714 2 3 72.73 84 65.8 753 735 79.45 86.56 79.2 81.62 76.44 2 86 70.2 60 52.7 79 77.67 53.56 12.4 53.78 14.6 74.6 78. 7711 330 331 332 333 334 25 336 337 338 339 340 341 342 343 344 345 345 347 3.48 349 350 351 352 353 356 355 356 357 358 359 360 361 362 363 354 365 366 367 368 369 270 733 55 771 72.44 743 84.57 71.57 873 86.3 702 61.57 5838 76.92 68.9 63.13 71.5 62.5 81.5 74.7 791 22.5 77.11 556 68 70 6738 8122 57.67 67.1 64.2 3 1 1 2 1 2 2 3 1 1 3 2 2 2 2 1 2 1 2 4 3 2 1 3 2 2 3 2 1 2 2 2 2 1 2 2 4 3 2 3 1 1 1 2 1 1 1 72.64 75.42 24.91 32.56 70.57 67.22 30.1 29.88 844 25,6 30.6 80.78 78.33 EL 3 2 2 1 1 2 1 3 1 2 1 3 2 2 1 1 2 72.9 2 1 2 1 BLA 81.75 746 72 787 68.75 574 32.6 55.6 611 715 5411 2 1 2 1 1 2 3 2 2 E E 6063 714 73. S. 60.44 845 205 65.92 5836 65.4 773 725 622 37.14 22.91 6945 33.9 2 2 1 2 2 3 2 1 3 586 70 31 751 5638 8.00 72.55 7825 75.83 63 72.73 8109 646 62.83 823 7588 88.4 2 807 4 1 1 2 3 1 1 80.3 722 70 61.5 68.09 68 55 83.1 713 741 546 742 55 73 1 2 1 1 1 1 1 1 2 1 2 2 Sheet2 Sheets Shoot Sheet Sheet1 + Ready Farm Marge & Carter Conditional Format Call Formatting Table Styles D271 X fx D E F D 1 1 M N O 99 77.1 SOR 19 3 2 2 3 1 2 1 9.4 7 732 64 684 84.4 831 263 817 50S 2 2 1 3 1 3 1 4 1 1 1 30 56 815 89.22 1 3 2 2 2 2 2 1 1 1 4 2 371 372 373 374 375 376 377 378 379 380 381 382 38 350 3.85 385 357 388 87.5 61 71 893 RE 834 8243 72.11 I 1 853 65.56 719 35.4 8811 1.9 79.2 638 77.4 563 715 831 55.7 721 64 1 1 1 3 1 2 15 2 1 3 3 2 2 2 1 2 1 4 64 1 2 3 1 1 2 3 139 78.25 61.71 88 68.6 81.45 144 66.7 TA 78 7156 765 ROS 6178 77.56 25.2 E 692 74.7 82.7 613 713 818 68.8 73.6 705 732 66.63 712 SOS 699 071 55 682 72.5 73.89 2 1 4 2 1 2 1 1 3 2 1 4 3 2 2 2 2 2 1 2 1 2 2 2 2 69 75.58 65.63 700 668 713 54.1 77.38 62.33 645 25 883 E 2 3 1 1 4 3 2 1 3 2 2 2 2 1 4 3 BOS 390 391 392 393 3944 395 396 397 398 399 400 401 402 403 404 E 2 2 1 1 2 E 8155 6133 78.18 175 2622 692 805 78 64 701 76.27 264 669 87.4 77 75.6 675 714 26.77 3313 38 SS 205 74.7 90.63 683 1 2 2 1 2 1 4 4 2 52.5 723 6438 73.5 83 501 653 105 1 4 2 4 4 1 1 2 4 2 2 2 2 3 3 1 2 3 1 1 818 72 728 61.17 72.5 23.25 801 17.1 59 736 749 744 7122 776 Sheet 773 78 59.88 75.6 72.45 80.1 884 545 735 25.08 74.67 77.56 52.3 4 2 2 1 1 1 2 2 1 3 406 407 408 409 410 411 412 E 636 3 1 1 2 2 1 2 2 1 765 2 2 2 2 1 Sheet 765 65.9 79.2 Shot 76 79 79.17 85.9 11 CAS Sheet + Ready Formatting Table Style 0271 ox # C D 1 F D H 1 N 1 70 0 1 413 414 415 75.2 72.30 1 E 1 1 2 416 725 73.63 80 723 60 628 40.33 70 77.56 814 65.4 417 439 419 420 121 422 423 434 425 425 1 1 3 3 2 1 79.00 75.13 RBS 72. 67.9 73.45 6163 77 85.55 8464 1 1 2 1 1 2 M 73 743 79.23 759 66.45 77.92 S13 80 292 34.56 71.29 3 1 2 2 3 2 3 2 SL 427 E 428 429 430 722 745 74.82 719 8422 78.11 72.7 804 373 72.54 75.27 7.08 785 8633 3255 2 2 2 2 1 3 2 1 2 1 2 1 4 3 2 1 2 3 3 1 2 3 2 3 3 2 3 2 2. 2 1 2 3 4 3 2 3 4 4 2 3 3 2 2 2 2 3 2 3 3 3 5 2 433 IS 2 1 1 1 2 4 3 1 2 2 2 3 1 3 1 2 2 1 2 2 4 2 3 2 4 2 2 2 2 3 2 757 75.2 713 825 75 712 686 804 604 586 65 54.4 536 58.75 S 61 70.8 70.6 572 57.6 79.6 75 72.8 684 562 7189 66.6 65.11 712 774 Shot 677 68.09 548 62 46.75 83.4 77.73 57 58.25 696 75.2 67 82.4 7455 22.78 781 87.2 67.43 50.67 54 55.67 55.89 59.58 60 54,7 76.38 77.11 58.5 711 77.6 72.8 72.3 56 60.89 7145 70.33 72.1 73.6 73.5 Sheets 435 435 437 438 439 40 441 442 44 444 445 446 447 448 44 450 451 452 453 1 2 1 1 2 2 5 3 2 2 3 4 1 2 3 2 2 1 1 3 66.2 65 55 742 12.18 SE 91 63.33 724 3.11 75.67 67.25 685 73 715 1078 693 74.4 744 4 4 1 2 2 2 2 1 2 3 3 84.6 82 72.38 65 69.7 72. 66.63 65.2 45 BORA 78.22 172 46.29 266 8:42 79.18 1 6.75 E 1 3 3 2 2 1 733 74.2 69.4 6767 74.7 779 763 1 2 3 1 2 Sheet1 Sheeta Shoot + Ready Paste B 1 Format > Mere & Center $ % Conditional Format Call Formatting as Table Styles 271 X fx A B C D E F G H K M N 0 4 5 2 3 1 1 1 4 3 72.4 784 65 73 77.4 62 574 615 79 751 684 67.1 672 2 3 3 1 1 3 3 1 2 2 3 2 3 3 2 1 2 2 725 10.4 66.78 20.1 79.1 57 75.4 693 80.44 782 71.36 717 72.8 BOB 77.58 82 25 8325 72.25 1 2 762 22:36 52 69.11 80.55 73.75 81.18 77.27 32.27 744 798 7125 66 748 56.8 77.56 75.06 82.27 72.89 62.89 788 77.1 75.4 75.91 81 81 75.7 2 2 2 3 1 2 2 1 2 2 1 1 2 1 3 1 2 3 2 1 2 2 77.83 762 1 2 3 2 79.6 72.78 66 76.2 80.8 B2 71 25 82.4 84 81.55 3 1 1 3 2 1 2 1 73.89 69.5 Shoot CH