D2L Module 3 Assignment - CSC2 X D2L Module 3 Assignment - CSC2 X *CSC 220 : Applied Probability X G go nationalu.brightspace.com/d21/Ims/dropbox/user/folder_submit_files.d21?ou=81515&isprv=0&db=438647&cfql=1 R Instructions Use MS Excel or Google Sheets to complete the computational questions. Use the data provided in airquality .xIsx to complete the following tasks. The dataset contains daily air quality measurements in New York, May to September 1973. More about the variables can be found here https://www.rdocumentation.org/packages/datasets/versions/3.6.2/topics/airquality 1. Watch the one of following videos to add the data analysis add-in toolpak to Excel: https://www.youtube.com/watch?v=_yNxLFagKgw https://www.youtube.com/watch?v=B60rozw34Sc 2. Using the Data Analysis tool in Excel, provide descriptive statistics for the four numerical variables of ozone, temp, wind, and solar. 3. Using the Data Analysis tool in Excel, calculate the pairwise correlation between the four variables of ozone, temp, wind, and solar. Provide this correlation matrix. 4. Use the following scale to interpret the results. Re-arrange your correlation coefficients in the following table to fill in the blanks: N Relationship Correlation Coefficient Strength Type: positiveegative 1 Ozone vs Temperature Ozone vs 2 Solar 3 Ozone vs Wind the online calculator found Submit Cancel cistatistics.com/tests/tsinglesample/default.aspx , 70D2L Module 3 Assignment - CSC2 X D2L Module 3 Assignment - CSC2 X *CSC 220 : Applied Probability x C nationalu.brightspace.com/d21/Ims/dropbox/user/folder_submit_files.d21?ou=81515&isprv=0&db=438647&cfql=1 R 5. Using the online calculator found at https://www.socscistatistics.com/tests/tsinglesample/default.aspx , conduct 1-sample t-test to test the hypothesis that ozone's average was 70 ppb. State your null and alternative hypotheses. Interpret the results in one sentence. 6. Using the Data Analysis tool in Excel, conduct a 2-sample t-test to test the hypothesis that ozone's average was the same as wind's. State your null and alternative hypotheses. Interpret the results in one sentence. 7. Using the Data Analysis tool in Excel, conduct a 2-sample t-test to test the hypothesis that ozone's average was the same as solar's. State your null and alternative hypotheses. Interpret the results in one sentence. Submit all your answers in a word document. Make sure you have a title page with your details. Available on Jun 17, 2024 12:01 AM. Access restricted before availability starts. Available until Jun 23, 2024 11:59 PM. Access restricted after availability ends. Hide Rubrics Rubric Name: Module 3 Assignment Rubric Print Criteria Level 4 Level 3 Level 2 Level 1 Criterion 100 points 80 points 60 points 0 points Score Criterion Question approached Question approached Question attempted, but Question blank, incorrect / 100 nd allT Format Organize Collaborate Table Text Media Comment 125% Chart Shape Sheet Insert Add Category View Zoom Air Quality Sheet Name Air Quality Solar Wind emp Month Day Ozone 41 190 7.4 Background 0O 36 118 72 149 12.6 74 12 62 18 313 11.5 300 14.3 56 19 Duplicate Sheet 28 321 14.9 66 23 299 8.6 65 Delete Sheet 99 13.8 59 19 8 19 20.1 61 194 8.6 69 303 5.9 74 16 256 3.7 69 290 9.2 66 274 10.9 68 65 13.2 58 334 11.5 64 307 12 66 78 18.4 57 322 1.5 68 44 9.7 62 0O 9.7 11 320 6.6 73 4 9.7 61 32 92 12 61 66 16.6 57 266 14.9 58 299 57 13 12 67 252 14.9 81 223 5.7 79 279 7.4 76 34 286 3.6 78 287 9.7 74 242 67 30 16.1 34 186 9.2 84 E 220 8.6 85 30 264 14.3 79 29 127 3.7 82 273 6.9 87 291 13.8 90 323 11.5 87 259 10.9 93 250 9.2 92 148 82 19 13.8 80 14 332T Format Organize Collaborate Media Comment 125% Insert Table Chart Text Shape Sheet Add Category View Zoom Air Quality Sheet Name 71 291 13.8 Air Quality 39 323 11.5 27 259 10.9 93 28 250 3.2 92 23 148 82 Background 19 332 13.8 30 17 322 11.5 79 21 191 14.9 77 37 284 20.7 72 Duplicate Sheet 9.2 65 20 37 120 11.5 73 Delete Sheet 10.3 76 13 137 135 150 5.3 77 49 59 1.7 76 32 91 4 .6 76 25 250 6.3 76 64 135 75 00 127 8 40 78 77 47 .0.3 73 97 98 11.5 80 31 14.9 77 83 30 95 138 8 135 269 4.1 84 248 9.2 85 236 9.2 81 101 10.9 84 175 4.6 83 314 10.9 83 276 5.1 88 97 267 6.3 92 97 272 5.7 92 85 175 7.4 89 139 8.6 82 264 14.3 73 175 14.9 81 291 14.9 91 33 48 14.3 80 48 260 6.9 81 274 10.3 82 6.3 84 18 61 285 79 187 5.1 87 19 63 220 11.5 85 20 16 6.9 74 258 9.7 81 295 11.5 82 294 8.6 86 108 223 8 85 20 81 3.6 82T Format Organize Collaborate 125% Insert Table Chart Text Shape Media Comment Sheet Add Category View Zoom Air Quality Sheet Name 64 135 8 15 Air Quality 127 78 40 77 47 10.3 73 97 98 11.5 80 Background 97 31 14.9 77 95 138 33 135 269 4.1 84 O VOUAWNHO OOO NOM 85 49 248 9.2 Duplicate Sheet 236 9.2 81 101 10.9 84 Delete Sheet 175 4.6 83 314 10.9 83 276 5.1 88 267 6.3 92 97 272 5.7 92 175 7.4 10 85 89 31 139 8.6 82 11 12 264 14.3 73 175 14.9 81 13 291 14.9 91 18 14.3 80 260 6.9 81 35 274 10.3 82 285 6.3 84 87 79 187 5.1 63 220 11.5 85 16 6.9 74 258 9.7 81 295 11.5 82 294 8.6 86 223 85 81 3.6 82 82 12 86 213 7.4 88 275 7.4 86 253 7.4 83 254 9.2 81 39 33 6.9 81 24 13.8 81 16 77 7.4 82 333 6.9 86 324 7.4 85 00 00 00 00 00 00 00 00 00 00 00 327 1. 6 87 255 89 229 10.3 90 207 00 90 222 92 18 8.6 86 17 137 11.5Format Organize T Collaborate Text Shape Media Comment Sheet 125% Insert Table Chart Add Category View Zoom Sheet Name Air Quality 35 Air Quality 108 223 8 81 3.6 82 82 12 86 88 82 213 7.4 86 Background 50 275 7.4 253 7.4 83 64 254 9.2 81 59 39 83 6.9 81 Duplicate Sheet 9 24 3.8 81 16 77 7.4 82 Delete Sheet 333 5.9 86 324 7.4 85 327 16 87 255 4 89 229 0.3 90 207 90 00 222 8.6 92 11 137 11.5 86 12 192 11.5 86 273 11.5 82 13 28 157 80 14 65 9 .7 15 55 64 11.5 79 LO.3 77 16 22 71 59 51 6.3 79 115 7.4 76 244 10.9 78 190 10.3 78 259 15.5 77 36 14.3 72 255 2.6 75 212 9.7 79 238 3.4 81 215 8 86 153 5.7 88 97 76 203 9.7 225 2.3 94 237 6 .3 96 188 6.3 94 167 6.9 91 197 5.1 92 183 2.8 93 189 4.6 93 7.4 87 47 95 32 92 15.5 84 20 252 10.9 30 23 220 10.3 78 230 10.9 3.7 73 24 259Format Organize T Collaborate Table Text Shape Media Comment Sheet 125% Insert Chart Add Category View Zoom Sheet Name Air Quality 79 15 Air Quality 55 64 11.5 71 10.3 77 22 51 79 59 6.3 115 7.4 76 23 78 Background 31 244 10.9 78 44 190 10.3 77 21 259 15.5 36 14.3 72 Duplicate Sheet 55 255 2.6 75 45 212 9.7 79 Delete Sheet 81 68 238 3.4 215 86 73 8 153 5.7 88 25 76 203 9.7 97 225 2.3 94 18 237 6 .3 96 188 6.3 94 167 6.9 91 197 5.1 92 183 2.8 93 189 4.6 93 47 95 7.4 87 92 15.5 84 32 20 252 10.9 80 78 23 220 10.3 21 230 10.9 75 24 259 9.7 73 236 14.9 81 11 44 259 15.5 76 21 28 238 5.3 77 24 10.9 71 71 13 112 11.5 237 5.9 78 46 13.8 67 18 224 76 13 27 10.3 24 238 0.3 68 16 201 82 238 2.6 64 13 14 9.2 71 139 10.3 81 49 LO.3 69 14 20 16.6 193 6.9 70 30 38 145 13.2 14 191 14.3 75 18 131 76 00 68 20 223 11.5