I need help with this please

12:32 + . . . E fx X V Sheet1 + A B C D E F G H J K L M N 0 11 ASSIGNMENT 4 - CORRELATION and CONFIDENCE INTERVALS 12 13 [overtype your name in this cell] 15 A study about the effect of music on human intelligence sponsored by Musicthatmakesyoudumb.com revealed the following: 16 This study was a random sample of schools' radio station "Top 10" list and the schools' average SAT scores. Number of Schools that have this Genre in their Average SA Music Genre top 10 list T Score Alternative 1,679 1,152 Classic Rock 809 1,162 Emo 12 1,095 Hip Hop 10 1,104 Jazz 36 1,142 Indie 425 1,174 Christian 25 1.097 Metal 30 1,082 Misc 147 1,238 Pop 332 1,113 Rock 1,881 1,160 30 Source: 31 http://musicthatmakesyoudumb.virgil.gr/music.php 32 1) Count how many music genres there are. E 2pts 3 2) Calculate the Mean (Average) SAT Score. 12pts 34 3) In your own words, define Standard Deviation 35 36 37 4) culate the Standard Deviation for SAT scores. 2pts 38 39 5 In your own words define Statistical Significance (alpha a). 2pts 40 41 42 Given a 95% Level of confidence, what is the 2pts Level of Significance (alpha)? 13 6 44 7) In your own words define Confidence Intervals. (2pts) 45 ; 8) culate the Margin of Error (E) for SAT scores 2pts 47 : is the Upper Limit of the Confidence Interva 2pts 18 10) it is the Lower Limit of the Confidence Interval 2pts 49 11) In your own words define the Correlation Coefficient (3pts 50 51 52 12 Calculate the correlation coefficient R = 3pts 53 13) Calculate the regression sum of squares R2 3pts 54 65 14) Based on your calculation of the correlation coefficient what can you conclude? (4pts) 56 57 58 59 60 61 O