Start off with an introduction and a statement of task such as in this example link Then the collected data (attached file) needs to be organized into a table

Start off with an introduction and a statement of task such as in this example link: Then the collected data (attached file) needs to be organized into a table such as in the example provided. From this data find Pearson’s Correlation Coefficient, plot a Scatter Graph and calculate the Least Squares Regression, calculate chi square test, include a Null Hypothesis and an Alternative Hypothesis, include observation values, limitations and conclusion. YouTube’s most viewed videos (http://youtube.com) Data “ Comments and Views 200 variables: 1. Gangnam Style “ PSY 2,268,756,919 (5,370,593) “ K-Pop 2. Baby “ Justin Bieber 1,145,161,989 (6,753,874) “ R&B 3. Dark Horse “ Katy Perry 859,488,196 (377,022) “ Hip hop 4. Roar “ Katy Perry 834,276,832 (377,010) “ Dance-Pop 5. Party Rock Anthem “ LMFAO 833,338,209 (654,155) “ EDM 6. Love The Way You Lie “ Eminem ft. Rihanna 825,723,931 (611,616) “ Hip hop 7. Waka waka “ Shakira 818,698,220 (774,578) “ Pop 8. On the Floor “ Jennifer Lopez ft. Pitbull 814,724,644 (430,844) “ EDM 9. Gentleman “ Psy 807,866,184 (1,131,287) “ K-pop 10. Bailando “ Enrique Iglesias ft. Descemer Bueno & Gente De Zona 772,067,266 (98,396) “ Dance-pop 11. Wrecking Ball “ Miley Cyrus “ 751,673,564 (1,139,236) “ Pop 12. Counting Stars “ OneRepublic 701,072,354 (130,877) “ Pop 13. All About That Bass “ Meghan Trainor 672,992,034 (336,336) “ Pop 14. Thrift Shop “ Macklemore & Ryan Lewis featuring Wanz 669,575,124 (430,457) “ Hip hop 15. Call Me Maybe “ Carly Rae Jepsen 655,247,359 (610,310) “ Pop 16. Danza Kuduro “ Don Omar featuring Lucenzo 651,730,285 (187,544) “ Dance 17. Shake It Off “ Taylor Swift 650,107,112 (323,232) “ Pop 18. The Lazy Song “ Bruno Mars 628,062,738 (456,206) “ Reggae 19. Blank Space “ Taylor Swift 627,103,689 (331,107) “ Electropop 20. Propuesta Indecente “ Romeo Santos 621,116,503 (68,016) “ Bachata 21. Rolling in the Deep “ Adele 619,601,589 (378,683) “ Pop 22. Ai Se Eu Te Pego “ Michel Telo 619,160,710 (320,682) “ Pop 23. Bad Romance “ Lady Gaga 617,118,186 (1,141,814) “ Pop 24. What Makes You Beautiful “ One Direction 613,122,249 (1,048,896) “ Pop 25. Somebody That I Used to Know “ Gotye ft. Kimbra 612,381,050 (503,765) “ Indie 26. Happy “ Pharrell Williams 602,681,779 (136,151) “ Soul 27. Chandelier “ Sia 598,891,804 (237,170) “ Pop 28. Not Afraid “ Eminem 598,621,829 (1,072,431) “ Hip hop 29. Wake Me Up “ Avicii featuring Aloe Blacc 576,317,996 (164,466) “ EDM 30. Rain Over Me “ Pitbull featuring Marc Anthony 564,436,202 (185,319) “ Pop 31. Let Her Go “ Passenger 561,415,621 (133,100) “ Indie 32. Oppa Is Just My Style “ Psy ft. Hyuna 551,444,825 (403,574) “ K-Pop 33. Firework “ Katy Perry 545,171,947 (596,186) “ Dance 34. Timber “ Pitbull ft. Ke$ha 544,211,781 (87,292) “ Pop 35. Diamonds “ Rihanna 543,272,920 (209,124) “ Electronic 36. El Pollito Pio “ Pulcino Pio 531,530,850 (92,623) “ Novelty 37. The Gummy Bear Song “ Gummibear 528,886,448 (166,078) “ Novelty 38. Just the Way You Are “ Bruno Mars 520,662,559 (209,798) “ R&B 39. We Can’t Stop “ Miley Cyrus 517,411,816 (1,013,264) “ R&B 40. Animals “ Martin Garrix 509,029,272 (116,659) “ Electro 41. Wiggle “ Jason Derulo ft. Snoop Dogg 508,968,122 (80,434) “ Trap 42. Darte un Beso “ Prince Royce 500,057,003 (68,839) “ Bachata 43. The Fox “ Ylvis 498,104,371 (870,314) “ Novelty 44. Can’t Remember to Forget You “ Shakira ft. Rihanna 495,676,918 (176,509) “ New Wave 45. Fancy “ Iggy Azalea 494,126,422 (183,266) “ Electro-hop 46. La La La “ Naughty Boy ft. Sam Smith 490,361,009 (188,310) “ R&B 47. La La La “ Shakira ft. Carlinhos Brown 475,233,671 (153,358) “ Electro house 48. Super Bass “ Nicki Minaj 472,510,652 (532,353) “ Hip hop 49. Burn “ Ellie Goulding 467,171,890 (112,330) “ Pop 50. Never Say Never “ Justin Bieber ft. Jaden Smith 462,666,415 (511,464) “ Pop 51. Beauty And A Beat “ Justin Bieber ft. Nicki Minaj 460,126,134 (591,204) “ EDM 52. Someone Like You “ Adele 455,984,269 (235,409) “ Soul 53. Last Friday Night “ Katy Perry 452,991,186 (411,994) “ K-Pop 54. Scream & Shout “ will.i.am ft. Britney Spears 449,443,222 (298,224) “ Electro 55. Problem “ Ariana Grande ft. Iggy Azalea 449,420,574 (173,967) “ R&B 56. We Found Love “ Rihanna ft. Calvin Harris 445,262,323 (240,811) “ Electro 57. Party in the USA “ Miley Cyrus 443,383,574 (678,700) “ Synthpop 58. Royals “ Lorde 442,431,905 (175,846) “ Pop 59. Rude “ MAGIC! 440,870,256 (96,028) “ Pop 60. Let It Go “ Idina Menzel 428,066,178 (191,220) “ Pop 61. Give Me Everything “ Pitbull ft. Ne-Yo, Afrojack, Nayer 427,384,379 (146,685) “ Electro 62. All of Me “ John Legend 422,697,136 (80,194) “ R&B 63. What’s My Name? “ Rihanna ft. Drake 421,715,005 (234,098) “ Electro 64. Grenade “ Bruno Mars 421,703,055 (328,450) “ R&B 65. Anaconda “ Nicki Minaj 412,727,802 (428,779) “ Hip hop 66. International Love “ Pitbull ft. Chris Brown 411,940,949 (170,726) “ Dance 67. Summer “ Calvin Harris 410,770,273 (50,345) “ Electro 68. You Belong With Me “ Taylor Swift 399,867,740 (225,762) “ Pop 69. One Time “ Justin Bieber 394,712,306 (610,834) “ Pop 70. Price Tag “ Jessie J ft. B.o.B 394,610,964 (227,648) “ Hip hop 71. 23 “ Mike WiLL Made-It 393,341,714 (253,030) “ Trap 72. Boyfriend “ Justin Bieber 389,102,951 (744,904) “ R&B 73. Only Girl “ Rihanna 388,178,245 (145,283) “ Dance 74. Titanium “ David Guetta ft. Sia 383,315,830 (181,751) “ House 75. Stay “ Rihanna ft. Mikky Ekko 374,848,639 (140,080) “ Pop 76. One Thing “ One Direction 374,084,136 (498,256) “ Pop 77. Blurred Lines “ Robin Thicke ft. T.I., Pharrell 372,847,292 (195,191) “ R&B 78. Just Give Me A Reason “ Pink ft. Nate Ruess 370,815,134 (119,143) “ Pop 79. Single Ladies “ Beyonce 365,513,286 (102,160) “ R&B 80. Paradise “ Coldplay 365,106,173 (226,869) “ R&B 81. Live While We’re Young “ One Direction 364,155,727 “ Pop 82. November Rain “ Guns N’ Roses 350,967,572 (597,581) “ Rock 83. One More Night “ Maroon 5 349,409,259 (108,698) “ Pop 84. Uptown Funk “ Mark Ronson ft. Bruno Mars 350,149,783 (133,572) “ Funk 85. Limbo “ Daddy Yankee 346,267,565 (88,712) “ Pop 86. One More Night “ Maroon 5 350,343,773 (108,698) “ Pop 87. Wide Awake “ Katy Perry 346,033,476 (206,775) “ Dance-Pop 88. Story Of My Life “ One Direction 337,215,153 (537,112) “ Pop 89. E.T. “ Katy Perry ft. Kanye West 329,313,907 (430,072) “ Electronic 90. Locked Out Of Heaven “ Bruno Mars 327,792,457 (120,149) “ Rock 91. Come & Get It “ Selena Gomez 327,504,441 (304,194) “ Electropop 92. Mirror “ LIL WAYNE ft. Bruno Mars 326,965,659 (296,418) “ Hip hop 93. Best Song Ever “ One Direction 326,271,080 (887,610) “ Dance-pop 94. Thinking Out Loud “ Ed Sheeran 326,791,552 (102,729) “ Soul 95. Break Free “ Ariana Grande ft. Zedd 323,452,008 (172,794) “ EDM 96. Play Hard “ David Guetta ft. Ne-Yo, Akon 317,805,186 (100,556) “ Electro house 97. Sexy And I Know It “ LMFAO 317,282,002 (530,548) “ Electropop 98. Dance Again “ Jennifer Lopez ft. Pitbull 314,743,761 (102,815) “ Dance-pop 99. Man Down “ Rihanna 313,485,954 (158,946) “ Reggae 100. We Are Young “ Fun. ft. Janelle Monae 309,357,767 (189,054) “ Indie pop 101. Imagine Dragons “ Radioactive 309,071,131 (200,934) “ Alternative Rock 102. David Guetta “ She Wolf 308,204,414 (136,602) “ Dance 103. #SELFIE “ The Chainsmokers 307,087,521 (134,432) “ EDM 104. Rihanna “ Rude Boy 300,305,339 (150,068) “ Hip hop 105. Adele “ Set Fire to the Rain 298,774,715 (125,532) “ Pop 106. Wisin “ Adrenalina ft. Jennifer Lopez, Ricky Martin 298,936,673 (29,062) “ Electropop 107. Chris Brown “ Look At Me Now ft. Lil Wayne, Busta Rhymes 298,105,994 (268,397) “ Hip hop 108. Flo Rida “ Whistle 298,036,913 (136,515) “ Pop rap 109. Justin Bieber “ Somebody To Love Remix ft. Usher 297,525,799 (347,390) “ Dance-pop 110. Rihanna “ Where Have You Been 296,349,624 (170,418) “ Dance-pop 111. Demi Lovato “ Heart Attack 295,478,329 (286,393) “ Electropop 112. MACKLEMORE & RYAN LEWIS “ CAN’T HOLD US FEAT. RAY DALTON 293,025,648 (170,618) “ Hip hop 113. Katy Perry “ The One That Got Away 290,443,469 (194,620) “ Pop 114. Bruno Mars “ When I Was Your Man 287,730,506 (105,992) “ Pop 115. Katy Perry “ Part Of Me 287,467,896 (206,265) “ Power Pop 116. SKRILLEX “ Bangarang feat. Sirah 286,032,282 (267,508) “ Dubstep 117. Jessie J, Ariana Grande, Nicki Minaj “ Bang Bang ft. Ariana Grande, Nicki Minaj 282,987,048 (104,924) “ Pop 118. Taylor Swift “ We Are Never Ever Getting Back Together 281,306,962 (207,677) “ Dance-Pop 119. Sam Smith “ Stay With Me 280,415,547 (64,261) “ Soul 120. Eminem “ When I’m Gone 276,203,568 (239,729) “ Hip hop 121. Eminem “ The Monster (Explicit) ft. Rihanna 275,062,445 (94,126) “ Hip hop 122. Maroon 5 “ Moves Like Jagger ft. Christina Aguilera 274,905,206 (127,157) “ Dance Pop 123. Jesse & Joy “ Corre! 273,913,815 (59,080) “ Pop 124. David Guetta & Showtek “ Bad ft. Vassy 273,666,736 (27,501) “ Electro house 125. J. Balvin “ Ay Vamos 274,609,308 (34,581) “ Reggae 126. Jason Derulo “ œTalk Dirty feat. 2 Chainz 271,309,537 (86,265) “ R&B 127. Enrique Iglesias “ El Perdedor (Pop) ft. Marco Antonio Solis 268,811,639 (30,970) “ Pop 128. Beyoncé “ Drunk in Love (Explicit) ft. JAY Z 267,613,467 (98,854) “ R&B 129. One Direction “ Kiss You 267,354,314 (544,484) “ Power Pop 130. Justin Timberlake “ Mirrors 267,306,136 (114,950) “ Synthpop 131. Enrique Iglesias “ Loco ft. Romeo Santos 267,112,281 (31,625) “ Bachata 132. David Guetta “ Turn Me On ft. Nicki Minaj 266,358,793 (134,904) “ Dance 133. System Of A Down “ Chop Suey 266,326,454 (192,800) “ Metal 134. Avril Lavigne “ Girlfriend 266,104,097 (83,298) “ Pop punk 135. Bruno Mars “ It Will Rain 264,392,354 (136,971) “ Soul 136. Beyoncé “ Halo 263,778,952 (64,273) “ Pop 137. Selena Gomez & The Scene “ Love You Like A Love Song 263,470,234 (259,040) “ Electropop 138. Christina Perri “ A Thousand Years 263,366,069 (140,309) “ Soul 139. John Newman “ Love Me Again 262,992,717 (77,830) “ Pop 140. Katy Perry “ This Is How We Do 262,292,778 (98,270) “ Dance-Pop 141. Calvin Harris “ I Need Your Love ft. Ellie Goulding 261,660,571 (64,849) “ Electro house 142. B.o.B “ Airplanes ft. Hayley Williams of Paramore 260,370,402 (169,284) “ Hip hop 143. Pitbull “ Feel This Moment ft. Christina Aguilera 257,922,612 (88,952) “ Dance-Pop 144. Iggy Azalea “ Black Widow ft. Rita Ora 257,134,995 (86,411) “ Trap 145. The Black Eyed Peas “ The Time 255,104,855 (92,649) “ Hip hop 146. 50 Cent “ In Da Club 253,091,658 (87,891) “ Hip hop 147. Chris Brown “ Loyal 253,342,723 (74,653) “ Hip hop 148. Beyonce “ Run the World 251,412,652 (276,466) “ Pop 149. Flo Rida “ Wild Ones ft. Sia 249,196,503 (79,782) “ Dance-pop 150. Swedish House Mafia “ Don’t You Worry Child ft. John Martin 246,588,045 (106,333) “ EDM 151. Clean Bandit “ Rather Be ft. Jess Glynne 246,435,862 (32,475) “ Pop 152. Alexandra Stan “ Mr Saxobeat 244,591,295 (91,411) “ Dance 153. LMFAO “ Sorry For Party Rocking 241,740,472 (193,250) “ EDM 154. J Balvin, Farruko “ 6 AM ft. Farruko 242,515,180 (19,831) “ Hip hop 155. Wisin & Yandel “ Follow The Leader ft. Jennifer Lopez 240,756,626 (60,109) “ Pop 156. One Direction “ One Way Or Another 240,461,579 (373,687) “ Rock 157. Selena Gomez & The Scene “ Naturally 237,791,798 (161,561) “ Electropop 158. Justin Bieber “ As Long As You Love Me ft. Big Sean 237,780,243 (404,810) “ Pop 159. Stromae “ Papaoutai 236,987,656 (93,592) “ House 160. Nirvana “ Smells Like Teen Spirit 234,464,620 (233,331) “ Rock 161. Taylor Swift “ 22 234,042,931 (231,424) “ Dance-pop 162. Katy Perry “ Hot N Cold 232,546,434 (68,239) “ Synthpop 163. Nicky Romero “ Toulouse 222,486,678 (127,534) “ EDM 164. Edward Maya & Vika Jigulina “ Stereo Love 231,978,255 (108,580) “ Dance 165. Ed Sheeran “ Give Me Love 231,312,804 (86,356) “ Rock 166. I Just Had Sex “ The Lonely Island (feat. Akon) 228,562,848 (410,102) “ Hip hop 167. Taylor Swift “ I Knew You Were Trouble 228,340,046 (243,121) “ Electropop 168. Rihanna “ Don’t Stop The Music 227,637,465 (32,659) “ Dance-pop 169. Pitbull “ I Know You Want Me 227,051,092 (113,548) “ Hip house 170. Linkin Park “ Numb 226,526,164 (131,199) “ Alternative rock 171. Miley Cyrus “ 7 Things 225,932,206 (379,920) “ Pop 172. Michael Jackson “ Thriller 226,146,732 (346,128) “ Dance-pop 173. Nicki Minaj “ Starships 225,700,230 (228,641) “ Dance 174. Ariana Grande “ The Way ft. Mac Miller 224,692,848 (280,616) “ Pop 175. Shakira “ Hips Don’t Lie ft. Wyclef Jean 223,350,912 (72,229) “ Pop 176. Lady Gaga “ Alejandro 222,551,077 (356,591) “ Synthpop 177. Nicky Romero “ Toulouse 222,486,678 (127,534) “ EDM 178. Empire State of Mind “ JAY Z ft. Alicia Keys 221,427,041 (5,556) “ Hip hop 179. Marc Anthony “ Vivir Mi Vida 221,534,872 (32,865) “ Salsa 180. Justin Bieber “ One Less Lonely Girl 220,740,066 (252,502) “ Pop 181. Kesha “ TiK ToK 220,587,140 (138,459) “ Electropop 182. Lady Gaga “ Telephone ft. Beyoncé 220,215,262 (171,786) “ Electropop 183. Miley Cyrus “ The Climb 220,103,489 (240,212) “ Pop 184. Avicii “ Wake Me Up 219,393,402 (164,468) “ EDM 185. Wisin & Yandel “ Algo Me Gusta De Ti ft. Chris Brown, T-Pain 219,449,123 (48,322) “ Pop 186. Imagine Dragons “ Demons 219,009,117 (78,330) “ Indie 187. Avril Lavigne “ Wish You Were Here 216,868,508 (144,547) “ Rock 188. Lady Gaga “ Poker Face 215,613,993 (133,097) “ Synthpop 189. Eminem “ Beautiful 215,321,710 (171,051) “ Hip hop 190. Avril Lavigne “ What The Hell 213,539,023 (169,367) “ Pop 191. The Cranberries “ Zombie 213,170,893 (85,288) “ Rock 192. Sam Smith “ I’m Not The Only One 213,554,271 (48,100) “ Soul 193. Flo Rida “ Good Feeling 210,419,555 (94,684) “ Hip house 194. Daft Punk “ Get Lucky 210,106,825 (149,475) “ Funk 195. Taylor Swift “ Love Story 210,114,259 (88,782) “ Pop 196. Nelly “ Just A Dream 209,964,702 (113,615) “ Pop 197. Rihanna “ Unfaithful 209,628,988 (60,935) “ R&B 198. Selena Gomez & The Scene “ Who Says 208,542,371 (240,768) “ Pop 199. Justin Bieber “ Never Let You Go 207,722,687 (250,599) “ Pop 200. Avril Lavigne “ When You’re Gone 207,084,435 (103,084) “ Rock