Please I need this wednesday thanks
magicman
WEEK4ASSIGNMENT.xlsSheet1
| ASSIGNMENT 4 - CORRELATION and CONFIDENCE INTERVALS | |||||
| [Overtype your name in this cell] | |||||
| A study about the effect of music on human intelligence sponsored by Musicthatmakesyoudumb.com revealed the following: | |||||
| This study was a random sample of schools' radio station "Top 10" list and the schools' average SAT scores. | |||||
| Music Genre | Number of Schools that have this Genre in their top 10 list | Average SAT 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 | |||
| Source: | |||||
| http://musicthatmakesyoudumb.virgil.gr/music.php | |||||
| 1) | Count how many music genres there are. | 2pts | |||
| 2) | Calculate the Mean (Average) SAT Score. | 2pts | |||
| 3) | In your own words, define Standard Deviation. | ||||
| 4) | Calculate the Standard Deviation for SAT scores. | 2pts | |||
| 5) | In your own words define Statistical Significance (alpha α). | 2pts | |||
| 6) | Given a 95% Level of confidence, what is the Level of Significance (alpha)? | 2pts | |||
| 7) | In your own words define Confidence Intervals. (2pts) | ||||
| 8) | Calculate the Margin of Error (E) for SAT scores | 2pts | |||
| 9) | What is the Upper Limit of the Confidence Interval | 2pts | |||
| 10) | What is the Lower Limit of the Confidence Interval | 2pts | |||
| 11) | In your own words define the Correlation Coefficient (3pts) | ||||
| 12) | Calculate the correlation coefficient R = | 3pts | |||
| 13) | Calculate the regression sum of squares R2 = | 3pts | |||
| 14) | Based on your calculation of the correlation coefficient what can you conclude? (4pts) | ||||
| You have been asked by the CEO of your company to develop a measurement to optimize the company's web site based on the following information. Be sure to do the calculations for all three columns of data. | |||||
| Traffic in Number of Visits per Month | Monthly Revenue | Monthly Cost per Visit | |||
| January | 22,314 | 243,898 | 0.38 | ||
| February | 26,789 | 298,761 | 0.24 | ||
| March | 36,751 | 389,657 | 0.21 | ||
| April | 48,301 | 546,792 | 0.19 | ||
| May | 51,329 | 675,982 | 0.13 | ||
| June | 57,634 | 786,455 | 0.11 | ||
| July | 63,498 | 897,645 | 0.09 | ||
| August | 69,045 | 989,732 | 0.06 | ||
| 15) | Calculate n = | 3pts | |||
| 16) | Calculate the Mean = | 3pts | |||
| 17) | Calculate the Standard Deviation = | 3pts | |||
| 18) | Given a 95% Level of confidence, what is the Level of Significance (alpha)? | 3pts | |||
| 19) | Calculate the Margin of Error | 3pts | |||
| 20) | Calculate the Upper Limit | 3pts | |||
| 21) | Calculate the Lower Limit | 3pts | |||
| 22) | Calculate the correlation coefficient between Traffic in Visits per Month and Monthly Revenue | 3pts | |||
| 23) | Calculate the correlation coefficient between Traffic in Visitors per Month and Monthly Cost per Visitor | ||||
| 3pts | |||||
| 24) | Graph a Scatterplot comparing Monthly Revenue to Visitor Traffic. | 4pts | |||
| 25) | Graph a Scatterplot comparing Traffic in Visitors per Month to Cost per Visit. | 4pts | |||
| 26) | Based on your calculations, which one has a positive relationship? Explain. (5pts) | ||||
| 27) | Based on your calculations, would you predict revenue to rise or fall? Explain. (5pts) | ||||
| 28) | A researcher states that a sequel to a successful movie will also be a success. Explain why this correlation is correct. (5pts) | ||||
| 29) | A researcher states that games with high levels of difficulty discourage players. Why is this correlation inaccurate? (5pts) | ||||
| 30) | A publication states that fireworks in a concert increase revenue. Is this a reasonable correlation? Why or why not? (6pts) | ||||
| 31) | A study reveals that games inhibit critical thinking. Is this a reasonable correlation? Why or why not? (6pts) |
STA 3026 Assignment 4- Week 4: Correlation
The objectives of this assignment are to help you:
Demonstrate understanding of correlation terminology and its interpretation.
Demonstrate how to calculate correlation between two groups of data
Calculate confidence intervals
Make quantitative predictions based on linear regression
Construct graphs
In this assignment, you will demonstrate your knowledge of the terms and concepts in Chapter 10 and other previously learned concepts of Even You Can Learn Statistics (EYCLS). Please answer the questions in this file, in the marked boxes.
Be sure to follow these guidelines:
1. Use the concepts from the textbook and notes.
2. Use the Excel calculator for the confidence intervals to construct the intervals for this assignment.
3. In the essay questions, make sure to be clear and thorough. Your answers should be at least 1 paragraph, with 5 complete sentences.
4. Name your file (last name)A4
Please answer all the questions.
6 Point values are listed for each question. Deductions as follow:
-1 point for incomplete/partly correct answers
-2 points for incorrect answers
All the points the question is worth will be deducted for blank answers.
