Reference no: EM132730912
Assignment: Instructions: 1. On the landing page, type in the name of your state and then the name of your city or place.
2. Click on "Get Data Profile."
3. On the new page, you will see links to 4 sets of information on your area:
• Social
• Education
• Housing
• Demographic
4. Choose any two variables you think might be related and find them using the links to the related set. In the tables, locate the variables you chose to work with. For example, you could use the number of rooms (in a house) under Housing and household incomes and benefits under Economy.
5. Find the values for each of your two variables for several years. For example, you might use the number of rooms and household income for 2012- 2017.
6. Use Excel to make a scatterplot and to find the correlation coefficient. You should then have 6 points on the scatterplot, one for each year.
Share your scatterplot and correlation coefficient in your post and use them to address the following in your discussion post:
1. Why did you think a relationship exists between the two variables you chose?
2. Based on the Excel scatterplot and output
• State what type of relationship exists: Negative, positive, or none.
• Describe the relationship in words, including what happens to one as the other changes. For example, as the number of rooms in a house increases, does the family income increase?
3. Does the statistical information you obtained support or refute your alternative hypothesis that a relationship exists?
• How?
• If you did not find a relationship, why do you think that is?
4. What is the value of knowing there is a correlation between the variables? For example, what businesses might flourish in a wealthy area?
5. Would another variable better explain the relationship?
6. How might the city use such information to make improvements? For example, if you found a relationship between crime and poverty, would it make sense to address poverty as a priority?
7. Can you conclude that one variable is causing the other? Why or why not?
Please be sure to validate your opinions and ideas with citations and references in APA format.