Companies increasingly use social media to engage current and potential customers. One important objective is to encourage content sharing with members of people's own personal networks. To help determine why people share corporate social media content, a dataset with a sample of 495 corporate social media posts is shown in two Question 4 tabs in the Final Exam Workbook., including the following variables: Post ID # Paid - dummy variable that indicates whether the company paid for the content (1=yes, 0=no) Comments - the number of comments made on the post Likes - the number of people who liked the post Shares - the number of people who shared the post

a. Using the data in the first tab, labeled "Question 4-parts a,b,c,d,e,f,g", determine the sample correlation coefficient, r, between Likes and Shares. Test the alternative hypothesis that the correlation between Likes and Shares 0. Specifically, what are the test statistic and the pvalue for that test statistic? For = .05, what do you conclude about the relationship between the variables?

Post ID # Paid Comments Likes Shares 1 0 4 79 17 2 0 5 130 29 3 0 0 66 14 4 1 58 1572 147 5 0 19 325 49 6 0 1 152 33 7 1 3 249 27 8 1 0 325 14 9 0 0 161 31 10 0 3 113 26 11 0 0 233 19 12 0 0 88 18 13 0 0 90 14 14 0 5 137 10 15 1 2 577 20 16 0 4 86 18 17 0 2 40 12 18 1 15 678 20 19 0 4 54 17 20 0 0 34 8 21 0 3 66 12 22 0 0 0 0 23 0 0 16 2 24 0 0 72 24 25 0 3 99 19 26 0 0 88 18 27 0 10 412 72 28 0 0 100 17 29 0 36 523 63 30 1 18 143 13 31 0 33 107 22 32 0 1 27 11 33 0 2 155 47 34 0 4 98 23 35 0 2 56 17 36 0 6 172 21 37 0 0 96 17 38 1 16 76 8 39 0 11 227 31 40 0 1 44 14 41 0 7 216 39 42 1 6 187 18 43 0 7 26 3 44 1 7 29 10 45 0 0 47 11 46 1 4 57 10 47 0 4 174 36 48 0 6 18 8 49 0 0 77 15 50 0 1 12 1 51 0 1 48 9 52 1 24 285 28 53 0 9 202 31 54 0 4 64 19 55 0 4 66 13 56 1 2 65 14 57 0 2 164 54 58 0 0 40 13 59 0 3 76 11 60 1 4 139 17 61 1 8 101 14 62 1 8 144 10 63 1 10 179 13 64 1 4 219 22 65 0 2 60 7 66 0 19 77 23 67 0 0 48 7 68 1 20 697 70 69 0 0 53 17 70 0 7 84 28 71 1 7 146 9 72 1 17 449 84 73 0 3 226 44 74 1 14 172 47 75 0 2 99 13 76 1 20 411 74 77 0 0 0 0 78 0 4 85 8 79 0 0 56 8 80 0 2 29 7 81 0 2 86 13 82 0 18 370 53 83 0 5 190 57 84 1 2 101 19 85 0 2 99 16 86 1 10 140 8 87 0 2 130 31 88 0 3 270 38 89 0 3 30 6 90 1 2 107 17 91 0 13 331 77 92 0 0 78 13 93 0 9 301 32 94 0 2 111 16 95 0 2 124 22 96 0 5 153 27 97 0 3 51 11 98 0 1 115 26 99 1 7 310 61 100 0 12 328 90 101 1 0 0 0 102 0 26 1505 95 103 0 2 63 14 104 0 0 13 4 105 1 4 59 9 106 0 42 955 139 107 0 9 181 32 108 0 17 193 28 109 0 7 125 16 110 0 4 217 50 111 0 2 28 4 112 0 4 117 18 113 1 2 79 16 114 0 0 15 2 115 1 0 4 2 116 0 1 431 26 117 0 0 7 0 118 0 0 7 2 119 0 0 6 2 120 0 6 186 40 121 0 1 1 2 122 0 1 3 2 123 0 0 7 2 124 0 3 198 41 125 0 0 9 1 126 0 0 4 1 127 0 0 3 0 128 0 0 8 2 129 0 0 7 3 130 0 1 7 2 131 0 0 11 1 132 0 2 28 4 133 0 0 56 12 134 0 0 32 16 135 0 4 32 3 136 0 0 129 25 137 1 4 77 19 138 0 15 143 44 139 0 2 227 36 140 1 60 859 90 141 1 10 377 60 142 1 3 41 9 143 1 6 76 14 144 0 0 189 15 145 0 0 80 14 146 0 3 148 28 147 1 0 24 11 148 0 24 302 41 149 0 2 166 32 150 1 47 358 49 151 0 7 161 25 152 0 13 319 55 153 0 0 54 16 154 0 16 117 30 155 0 1 115 21 156 0 30 187 35 157 1 1 84 13 158 0 6 363 40 159 0 6 244 32 160 0 22 290 98 161 0 4 243 41 162 1 0 113 19 163 1 2 77 5 164 1 8 485 64 165 0 144 1622 208 166 1 6 99 16 167 0 3 188 26 168 0 2 30 6 169 0 38 163 27 170 0 6 179 40 171 0 5 204 34 172 1 2 165 22 173 1 29 1047 98 174 0 2 234 40 175 0 7 250 42 176 0 4 154 36 177 1 20 150 29 178 0 4 102 8 179 1 1 226 44 180 0 6 345 121 181 0 11 68 11 182 0 0 62 10 183 0 5 223 35 184 0 0 61 6 185 1 1 104 12 186 0 3 146 15 187 1 2 102 15 188 0 9 766 43 189 0 0 63 7 190 1 3 113 17 191 0 6 442 42 192 0 9 278 43 193 0 2 64 7 194 0 1 52 7 195 1 0 30 2 196 0 33 1155 102 197 1 2 139 25 198 0 0 40 5 199 1 2 53 15 200 0 4 220 19 201 0 2 114 16 202 1 0 39 3 203 0 4 859 68 204 0 5 137 20 205 0 1 54 11 206 1 2 74 22 207 1 6 98 3 208 0 2 264 21 209 0 3 36 11 210 1 1 11 3 211 1 4 435 31 212 0 2 114 10 213 0 2 17 9 214 0 41 15 1 215 0 3 87 10 216 0 16 227 28 217 0 2 86 8 218 0 6 179 27 219 0 1 74 11 220 1 18 332 54 221 0 2 80 21 222 0 9 95 17 223 1 3 188 26 224 1 6 109 11 225 0 64 367 25 226 0 9 102 19 227 0 2 113 20 228 0 0 94 20 229 1 6 14 1 230 0 1 43 10 231 0 1 98 21 232 0 3 13 1 233 0 12 237 45 234 0 4 112 23 235 0 2 101 25 236 1 10 145 31 237 0 6 535 83 238 0 4 118 22 239 0 9 484 79 240 1 18 315 76 241 1 372 5172 790 242 0 4 154 30 243 0 0 73 15 244 0 0 96 19 245 0 1 98 19 246 1 1 53 14 247 1 4 71 10 248 0 6 194 34 249 0 6 226 42 250 1 11 238 51 251 0 10 755 58 252 1 30 47 8 253 1 2 126 32 254 1 4 104 10 255 0 10 167 26 256 0 9 152 41 257 1 0 128 15 258 0 13 234 43 259 0 2 61 16 260 1 0 66 9 261 0 7 529 60 262 1 3 42 10 263 0 2 75 24 264 0 13 61 13 265 0 26 162 7 266 1 2 47 4 267 1 6 696 28 268 1 7 215 47 269 1 22 534 31 270 0 1 143 27 271 0 18 46 7 272 0 36 98 14 273 1 0 25 5 274 0 23 204 44 275 1 11 202 5 276 0 7 148 39 277 0 1 40 8 278 0 1 71 17 279 0 0 104 13 280 1 1 34 4 281 0 11 129 12 282 0 4 72 18 283 1 0 15 3 284 1 14 102 9 285 0 103 469 33 286 0 5 57 5 287 0 0 23 2 288 0 5 141 26 289 0 0 19 5 290 0 1 71 23 291 0 0 72 21 292 0 5 54 7 293 0 5 93 19 294 0 0 62 10 295 0 0 78 16 296 0 0 14 1 297 0 11 231 43 298 1 1 72 16 299 1 9 197 28 300 1 4 330 29 301 0 0 148 7 302 0 2 208 28 303 0 12 148 28 304 1 4 154 26 305 0 3 142 18 306 0 8 107 20 307 0 0 22 3 308 0 2 84 13 309 0 2 59 12 310 1 3 65 14 311 1 0 24 4 312 0 9 186 23 313 0 0 58 17 314 0 2 74 14 315 0 2 180 44 316 1 18 168 49 317 0 0 36 5 318 0 2 51 6 319 1 2 67 14 320 0 20 1372 47 321 1 2 57 6 322 0 2 33 10 323 0 1 79 17 324 1 3 97 22 325 0 16 617 58 326 1 7 139 34 327 0 20 199 32 328 0 1 107 26 329 0 0 50 10 330 0 0 64 20 331 0 2 55 10 332 0 1 142 37 333 0 2 72 9 334 0 4 79 16 335 1 25 244 44 336 0 25 307 58 337 0 6 212 36 338 0 2 95 17 339 0 5 194 33 340 1 6 101 29 341 0 3 46 14 342 1 3 156 20 343 0 37 821 90 344 0 1 58 13 345 1 12 155 23 346 0 45 1639 122 347 0 3 155 32 348 1 4 166 33 349 1 6 210 39 350 0 4 400 25 351 0 2 98 18 352 0 12 138 38 353 0 3 148 16 354 0 2 267 40 355 0 1 144 29 356 0 25 256 54 357 0 3 72 24 358 0 0 87 18 359 0 1 129 36 360 1 1 179 30 361 0 9 194 33 362 0 1 124 32 363 0 4 304 47 364 1 12 138 39 365 0 4 41 9 366 1 2 163 35 367 0 45 407 76 368 1 17 447 123 369 1 7 38 11 370 0 2 93 26 371 1 0 59 16 372 1 0 286 30 373 0 0 66 13 374 1 8 236 51 375 1 2 152 11 376 1 51 1998 128 377 0 8 186 18 378 0 11 235 34 379 0 1 64 22 380 0 2 92 28 381 0 3 53 13 382 1 5 140 38 383 0 0 48 8 384 1 0 112 14 385 0 0 35 5 386 0 4 37 3 387 1 0 48 14 388 1 6 766 109 389 0 1 96 18 390 0 1 57 13 391 0 3 114 21 392 0 1 51 6 393 1 1 87 27 394 0 5 81 11 395 0 1 71 18 396 0 9 164 52 397 1 5 91 26 398 1 9 329 38 399 1 4 128 17 400 0 1 379 40 401 0 1 52 24 402 0 1 63 26 403 0 2 97 25 404 1 2 56 9 405 0 1 36 7 406 0 4 138 26 407 0 7 142 24 408 0 1 75 15 409 1 1 89 14 410 1 2 63 16 411 1 3 176 29 412 0 7 227 15 413 0 3 25 6 414 0 0 0 0 415 0 1 27 11 416 0 0 39 14 417 0 0 61 13 418 0 0 32 7 419 0 0 2 0 420 0 8 109 3 421 0 0 32 6 422 0 2 68 15 423 0 0 6 1 424 0 4 213 13 425 0 0 2 0 426 0 0 3 0 427 0 0 6 0 428 0 0 4 0 429 0 0 4 1 430 0 12 211 14 431 0 1 15 1 432 0 11 95 4 433 1 16 127 0 434 0 0 136 13 435 0 2 32 15 436 0 1 76 9 437 0 1 28 7 438 1 0 0 0 439 0 10 664 97 440 0 1 62 10 441 0 0 48 20 442 1 1 55 7 443 1 10 197 21 444 1 6 88 24 445 1 2 59 6 446 1 6 234 26 447 0 3 148 21 448 0 0 96 29 449 0 4 49 15 450 0 3 98 27 451 0 14 198 70 452 0 5 159 53 453 1 1 22 6 454 0 6 154 18 455 0 5 128 32 456 1 2 129 32 457 0 146 1546 181 458 0 5 79 11 459 1 19 214 78 460 1 8 134 34 461 0 9 268 36 462 0 4 128 38 463 1 3 47 21 464 1 1 200 37 465 0 5 264 36 466 0 10 193 61 467 0 4 114 13 468 0 7 160 57 469 0 0 46 15 470 1 4 136 42 471 0 0 73 13 472 1 0 65 19 473 1 7 579 47 474 0 1 101 5 475 0 1 74 31 476 0 7 84 36 477 0 56 360 99 478 1 0 5 2 479 0 3 187 36 480 0 2 69 26 481 0 2 82 24 482 0 0 12 2 483 0 2 56 25 484 0 1 44 21 485 0 21 277 80 486 0 1 74 28 487 0 1 79 30 488 1 1 105 46 489 0 0 128 9 490 0 17 185 55 491 0 10 125 41 492 0 5 53 26 493 0 0 53 22 494 0 4 93 18 495 0 7 91 38