10. Calculate the mean and median for all of the quantitative variables in the "Data set 1" spreadsheet on moodle. Also, calculate standard deviation and variance for the "Hours spent out door" and "Hours spent on TV"using excel or google sheets. (3 marks) Determine the first and third quartiles and graph the box plot for the "POTUTOR" column, and submit excel/google sheets document along with your answers to the previous questions of this assignment. (3 marks) How to read the Data set 1 columns? I GENDER: 1 is male and 2 is female VOLENTEE: this shows volunteer tutoring hours PRETUTOR: this shows the grade before receiving the tutoring service POTUTOR: this shows the grade after receiving the tutoring service DRIVE: 1 means that the person drives and 2 means that the person does not drive JOB: 1 means that the person works and 2 means that the person does not work Formatting Table Font Clipboard H12 Alinment Number 18.4656437560915 GENDER VOLUNTEE PRETUTOR POTUTOR 1 23.46 111.00 126.46 2 72.46 145.56 91.96 2 102.85 112.38 166 08 1 48.85 594.89 250.15 1 26.16 163.54 369.64 1 117.52 399.50 516.87 1 58.18 401.65 449.98 2 74.87 360.74 108.71 1 8.81 558.09 577.38 2 17.34 501.74 41.22 2 23.71 568.31 426 86 1 7.21 323.15 308.75 2 104.45 523.44 131 34 1 25.80 424.41 21.03 2 120.16 230.79 266.60 1 155.95 290.47 30.96 1 97.13 8.78 353 61 1 43.99 113.98 318.97 2 121.77 349.11 504.17 2 6.23 585.73 376.51 1 16.90 396.29 593.51 2 123.08 445.56 366.12 2 37.87 172.79 204.03 1 3720 222.28 343.54 2 102.49 393.52 13.15 2 160.27 23.48 521.19 2 39 80 487 48 188.65 1 56.87 335.62 70.81 1 8.87 361.41 401.50 1 124.04 453.66 214.38 1 20.13 64.63 2.13 2 9.89 225.15 118.20 2 31.59 448.97 573 59 1R 72 56909 63.62 BADM 221 data 1 DRIVE 2 1 2 2 2 2 2 1 2 1 1 2 2 2 2 2 2 1 1 2 2 1 2 1 1 1 2 1 2 2 2 1 1 JOB spent outdoors during the week spent on TV or social media 1 15.45 13.25 2 12.77 22.35 2 2.79 3.86 1 21.01 7.04 1 23 6.46 1 18.62 13.31 2 11.42 14.18 1 20.72 10.93 2 6.08 12.16 1 4.89 12.35 2 30.49 18.47 1 15.84 5.68 1 11.02 21.21 1 9.23 10.70 2 24.95 22.21 1 14.45 3.96 1 25.13 23.85 1 8,59 2.84 1 12.14 3.26 2 17.07 18.46 1 15,94 16.70 1 14.28 3.62 2 10.73 12.22 2 24.14 11.63 2 27.84 64 2 23.87 12.80 1 5.14 8.74 1 15 75 8.69 2 27.54 4.88 1 14.38 4.75 2 13.13 3.07 1 10.95 13.94 1 16.83 02 2.75 12.31 1 Home Page Layou BU Normal Custom X cut Wrap Text Anal - 10 to Copy Merge & Center Conditional Format as Neutre Formatting Table - 7 Number sle Format Painter Clipboard H35 Font Alignment 12.314398985356 E NNNN 3 2 3 4 5 37 50 51 52 53 54 E 1 16.73 1 113.55 2 116 37 1 145.62 2 59.01 2 83.40 1 117.93 2 34 61 2 129.93 1 11.24 1 88.55 1 111.19 2 157.21 1 53.04 2 87.82 1 128.66 2 21.35 2 93.97 2 165.08 1 54.64 1 89.96 1 85.29 1 47.38 2 58.33 1 154.74 2 68.57 2 16.08 1 56 09 2 104.29 1 107.71 2 126 36 1 34.43 1 24 07 1 2 BADM 221 data 1 568.98 266.85 428 20 346.31 28.39 315.65 213.00 285.08 585.63 407 23 420.07 15.04 743 469.04 532.40 319.41 118 64 407.45 284.32 246.33 299.43 161.05 37.57 335.90 455.67 36.15 430.39 95.66 247 12 581.24 432.18 216.41 360 55 398.78 19707 D 63.63 250.97 257.50 468.17 534.90 321.72 563.69 385.94 486.60 90.36 473.72 399.48 420.75 361.47 318.36 33.11 381.56 337.69 409.84 394.94 377.69 37.42 545 24 231.93 348.74 69.23 429 15 554.98 521.86 524 82 149.71 335.00 291.66 401.54 550.11 2 2 2 2 1 2 1 2 1 1 2 1 1 1 2 2 2 1 2. 1 1 1 2 2 1 2 2 1 2 1 1 1 1 1 1 2 2 2 2 2 1 2 1 2 2 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 2 1 1 1 2 2.75 12.53 3.25 27.34 6.51 28.92 25.83 1.81 24.29 22.18 11.65 27.31 6.92 29.05 17.90 12.12 18.82 7.07 22.10 21.40 24.75 28 29.53 9.52 8.44 14.14 29.24 20.15 17.60 17.53 13.67 11 66 10.52 27 83 12.31 22.41 9.09 2.12 1.31 23.84 13.86 16 13.66 7.96 2.44 8.99 23.02 17.83 20.47 11 9.66 11.82 18.63 9.02 4.01 14.97 2.20 8.58 5.44 19.18 2.03 22.05 4.82 6.00 1.30 55 56 57 59 62 63 50 4.98 61 59 74 91 62.00 9.13 13.81 26.77 2.48 - 10 Wrap Text Aria Copy Format Painter te Merge & Center - Conditional Format as Neutral Formatting Table - Paste Number Font Alignment Clipboard H69 2.48009093105792 E 1 1 1 71 1 2 2 1 73 74 75 76 73 78 30 BE 1 2 2 1 2 2 1 2 2 2 1 1 1 1 2 2 1 1 2 1 2 2 1 2 2 1 1 1 2 1 82 B 74.91 62.00 81.53 16.68 121.91 6.26 29 35 48 44 112.37 127 88 134.93 118.08 805 66.24 38 41 122.00 148 25 30.61 46.99 116.85 151.63 20.63 85.29 19.70 155 35 86.90 45 60 108 30 108.16 143 28 10.95 68 34 95 21 141 67 34 85 2 1 1 2 2 2 1 1 1 1 2 1 1 1 1 1 2 1 2 2 1 1 398.78 197.07 264.93 316.65 17.06 302.76 23 24 18.37 25.55 536 21 393.11 3 62 39.82 23.09 2.15 131.42 115.44 570.72 404.70 334 27 343.41 58.97 128.80 557.77 494.83 496 27 368.71 203 68 561.11 141.11 496.46 160.30 57.59 83.19 401.54 550.11 308 06 8.49 386.07 87 89 562.63 594.09 44.46 468.39 518.29 302 96 169 82 441 27 525 67 106.06 473.75 284 54 135.46 213.49 343 55 524.78 583 63 345 08 355 28 409.46 390 86 466 23 387 84 489 26 29491 552.76 68 152.73 2 1 2 2 1 1 1 2 2 1 2. 2 2 1 2 1 1 1 1 2 1 1 2 2 2 1 2 27.83 26.77 7.28 8.94 8.54 5.87 6.26 10.28 22.88 29.64 1254 1.81 9.80 10.04 4.83 21.32 3.51 29.98 13.28 20.49 24.45 14.69 16.59 21.83 19.38 23.71 23.88 4.94 22.62 87 25.23 2 12 27.48 5.51 13.81 2.48 23.77 21.94 22.19 7.70 7.55 19.90 18.10 16.74 8.91 15.69 8.15 12.49 17.91 13.90 19.57 4.12 4.71 6.31 13.31 3.52 15.46 14.09 .94 5.07 22.93 2.40 3.62 16.76 6.34 21.05 7.84 1883 30 1 94 95 96 2 2 1 2 2 1 2 2 1 2 2 2 1 2 2 10 102 BADM 221 data 1 10. Calculate the mean and median for all of the quantitative variables in the "Data set 1" spreadsheet on moodle. Also, calculate standard deviation and variance for the "Hours spent out door" and "Hours spent on TV"using excel or google sheets. (3 marks) Determine the first and third quartiles and graph the box plot for the "POTUTOR" column, and submit excel/google sheets document along with your answers to the previous questions of this assignment. (3 marks) How to read the Data set 1 columns? I GENDER: 1 is male and 2 is female VOLENTEE: this shows volunteer tutoring hours PRETUTOR: this shows the grade before receiving the tutoring service POTUTOR: this shows the grade after receiving the tutoring service DRIVE: 1 means that the person drives and 2 means that the person does not drive JOB: 1 means that the person works and 2 means that the person does not work Formatting Table Font Clipboard H12 Alinment Number 18.4656437560915 GENDER VOLUNTEE PRETUTOR POTUTOR 1 23.46 111.00 126.46 2 72.46 145.56 91.96 2 102.85 112.38 166 08 1 48.85 594.89 250.15 1 26.16 163.54 369.64 1 117.52 399.50 516.87 1 58.18 401.65 449.98 2 74.87 360.74 108.71 1 8.81 558.09 577.38 2 17.34 501.74 41.22 2 23.71 568.31 426 86 1 7.21 323.15 308.75 2 104.45 523.44 131 34 1 25.80 424.41 21.03 2 120.16 230.79 266.60 1 155.95 290.47 30.96 1 97.13 8.78 353 61 1 43.99 113.98 318.97 2 121.77 349.11 504.17 2 6.23 585.73 376.51 1 16.90 396.29 593.51 2 123.08 445.56 366.12 2 37.87 172.79 204.03 1 3720 222.28 343.54 2 102.49 393.52 13.15 2 160.27 23.48 521.19 2 39 80 487 48 188.65 1 56.87 335.62 70.81 1 8.87 361.41 401.50 1 124.04 453.66 214.38 1 20.13 64.63 2.13 2 9.89 225.15 118.20 2 31.59 448.97 573 59 1R 72 56909 63.62 BADM 221 data 1 DRIVE 2 1 2 2 2 2 2 1 2 1 1 2 2 2 2 2 2 1 1 2 2 1 2 1 1 1 2 1 2 2 2 1 1 JOB spent outdoors during the week spent on TV or social media 1 15.45 13.25 2 12.77 22.35 2 2.79 3.86 1 21.01 7.04 1 23 6.46 1 18.62 13.31 2 11.42 14.18 1 20.72 10.93 2 6.08 12.16 1 4.89 12.35 2 30.49 18.47 1 15.84 5.68 1 11.02 21.21 1 9.23 10.70 2 24.95 22.21 1 14.45 3.96 1 25.13 23.85 1 8,59 2.84 1 12.14 3.26 2 17.07 18.46 1 15,94 16.70 1 14.28 3.62 2 10.73 12.22 2 24.14 11.63 2 27.84 64 2 23.87 12.80 1 5.14 8.74 1 15 75 8.69 2 27.54 4.88 1 14.38 4.75 2 13.13 3.07 1 10.95 13.94 1 16.83 02 2.75 12.31 1 Home Page Layou BU Normal Custom X cut Wrap Text Anal - 10 to Copy Merge & Center Conditional Format as Neutre Formatting Table - 7 Number sle Format Painter Clipboard H35 Font Alignment 12.314398985356 E NNNN 3 2 3 4 5 37 50 51 52 53 54 E 1 16.73 1 113.55 2 116 37 1 145.62 2 59.01 2 83.40 1 117.93 2 34 61 2 129.93 1 11.24 1 88.55 1 111.19 2 157.21 1 53.04 2 87.82 1 128.66 2 21.35 2 93.97 2 165.08 1 54.64 1 89.96 1 85.29 1 47.38 2 58.33 1 154.74 2 68.57 2 16.08 1 56 09 2 104.29 1 107.71 2 126 36 1 34.43 1 24 07 1 2 BADM 221 data 1 568.98 266.85 428 20 346.31 28.39 315.65 213.00 285.08 585.63 407 23 420.07 15.04 743 469.04 532.40 319.41 118 64 407.45 284.32 246.33 299.43 161.05 37.57 335.90 455.67 36.15 430.39 95.66 247 12 581.24 432.18 216.41 360 55 398.78 19707 D 63.63 250.97 257.50 468.17 534.90 321.72 563.69 385.94 486.60 90.36 473.72 399.48 420.75 361.47 318.36 33.11 381.56 337.69 409.84 394.94 377.69 37.42 545 24 231.93 348.74 69.23 429 15 554.98 521.86 524 82 149.71 335.00 291.66 401.54 550.11 2 2 2 2 1 2 1 2 1 1 2 1 1 1 2 2 2 1 2. 1 1 1 2 2 1 2 2 1 2 1 1 1 1 1 1 2 2 2 2 2 1 2 1 2 2 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 2 1 1 1 2 2.75 12.53 3.25 27.34 6.51 28.92 25.83 1.81 24.29 22.18 11.65 27.31 6.92 29.05 17.90 12.12 18.82 7.07 22.10 21.40 24.75 28 29.53 9.52 8.44 14.14 29.24 20.15 17.60 17.53 13.67 11 66 10.52 27 83 12.31 22.41 9.09 2.12 1.31 23.84 13.86 16 13.66 7.96 2.44 8.99 23.02 17.83 20.47 11 9.66 11.82 18.63 9.02 4.01 14.97 2.20 8.58 5.44 19.18 2.03 22.05 4.82 6.00 1.30 55 56 57 59 62 63 50 4.98 61 59 74 91 62.00 9.13 13.81 26.77 2.48 - 10 Wrap Text Aria Copy Format Painter te Merge & Center - Conditional Format as Neutral Formatting Table - Paste Number Font Alignment Clipboard H69 2.48009093105792 E 1 1 1 71 1 2 2 1 73 74 75 76 73 78 30 BE 1 2 2 1 2 2 1 2 2 2 1 1 1 1 2 2 1 1 2 1 2 2 1 2 2 1 1 1 2 1 82 B 74.91 62.00 81.53 16.68 121.91 6.26 29 35 48 44 112.37 127 88 134.93 118.08 805 66.24 38 41 122.00 148 25 30.61 46.99 116.85 151.63 20.63 85.29 19.70 155 35 86.90 45 60 108 30 108.16 143 28 10.95 68 34 95 21 141 67 34 85 2 1 1 2 2 2 1 1 1 1 2 1 1 1 1 1 2 1 2 2 1 1 398.78 197.07 264.93 316.65 17.06 302.76 23 24 18.37 25.55 536 21 393.11 3 62 39.82 23.09 2.15 131.42 115.44 570.72 404.70 334 27 343.41 58.97 128.80 557.77 494.83 496 27 368.71 203 68 561.11 141.11 496.46 160.30 57.59 83.19 401.54 550.11 308 06 8.49 386.07 87 89 562.63 594.09 44.46 468.39 518.29 302 96 169 82 441 27 525 67 106.06 473.75 284 54 135.46 213.49 343 55 524.78 583 63 345 08 355 28 409.46 390 86 466 23 387 84 489 26 29491 552.76 68 152.73 2 1 2 2 1 1 1 2 2 1 2. 2 2 1 2 1 1 1 1 2 1 1 2 2 2 1 2 27.83 26.77 7.28 8.94 8.54 5.87 6.26 10.28 22.88 29.64 1254 1.81 9.80 10.04 4.83 21.32 3.51 29.98 13.28 20.49 24.45 14.69 16.59 21.83 19.38 23.71 23.88 4.94 22.62 87 25.23 2 12 27.48 5.51 13.81 2.48 23.77 21.94 22.19 7.70 7.55 19.90 18.10 16.74 8.91 15.69 8.15 12.49 17.91 13.90 19.57 4.12 4.71 6.31 13.31 3.52 15.46 14.09 .94 5.07 22.93 2.40 3.62 16.76 6.34 21.05 7.84 1883 30 1 94 95 96 2 2 1 2 2 1 2 2 1 2 2 2 1 2 2 10 102 BADM 221 data 1