Reference no: EM132729446
Assignment: Instructions: For this discussion, you are to use the following website:
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.
|
How do you manage your privacy and self-disclosures online
: Instagram, Snapchat, and Facebook are undoubtedly dominating the world of online social networking, and the willingness of many users to self-disclose.
|
|
What is the retailer effective cost of trade credit
: A large retailer obtains merchandise under the credit terms of 1/15, net 45, What is the retailer effective cost of trade credit
|
|
Screening for disease is important process in epidemiology
: Screening for disease is an important process in epidemiology. What are some characteristics of a good screening test and what are some ways you could evaluate
|
|
Calculate return on equity and earnings per share
: Spyder Mann has expected sales of $250 million a year. Calculate return on equity (ROE) and earnings per share (EPS) if expansion is financed by equity.
|
|
What happens to one as the other changes
: 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.
|
|
What is the company average accounts receivable
: The company averages $3,500 in sales each day (all customers take credit). What is the company's average accounts receivable
|
|
Discussing the career field
: Locate on the internet an example of a professional PowerPoint presentation discussing the career field that you are interested in entering.
|
|
Explain the pros of ratio analysis
: Explain the pros and cons of these methods of financial statement analysis: ratio analysis, vertical analysis, and horizontal analysis.
|
|
How much cash will be freed up
: Williams & Sons last year reported sales of $12 million, cost of goods sold (COGS) of $10 million, how much cash will be freed up
|