[Solved] Identifying Relationships Between Variables

Assignment Prompt & Instructions

Prior to beginning work on this assignment:
– Read Chapters 4 and 5 in your textbook.
– Review the interactive, The Probability Game, to synthesize your understanding of different data visualization tools.
In this assignment, you will analyze the Cost-of-Living Index and Groceries Index for seven United States cities. You will then create a scatterplot to represent the relationships between the variables. In the end, you will describe the implications of your analysis in your assignment. You may choose any seven United States cities you wish.
Go to the [Northern America: Current Cost of Living Index by CityLinks to an external site.](https://www.numbeo.com/cost-of-living/region_rankings_current.jsp?region=021) webpage and follow the directions below to get started:
– Identify seven cities and note the “Cost of Living Index” and “Groceries Index” values.
– In your Excel spreadsheet or tool of your choice, develop a table with three columns with the following titles:
– City
– Groceries Index (independent variable)
– Cost of Living Index (dependent variable)
– Enter details for all seven cities under these column headers. You will then have a table with seven rows representing each city in one row.
– Now, insert or draw a scatterplot of the above data set.
– Display the regression line (also called the trend line, linear model, or line of best fit). To do so in Excel, select anywhere in the scatterplot. Select the plus sign, and at the bottom of Chart Elements, select “Trend line.”
– Display the equation for the trend line and R2 value on the graph. To do so in Excel, right-select the trend line. Review the options on the right of the chart under “Format Trendline…” and scroll to the bottom to select the boxes for “Display Equation on chart” and “Display R-squared value on chart” options.
In your assignment,
– Provide the URL and complete an APA reference for the URL. For assistance formatting your reference list, refer to [_APA: Formatting Your References List_Links to an external site.](https://writingcenter.uagc.edu/format-your-reference-list) resource.
– Provide the table with your data and your spreadsheet of the graph with the equation and R2 value. For assistance on when and how to use tables, refer to [_Tables, Images, & Appendices_Links to an external site.](https://writingcenter.uagc.edu/tables-images-appendices) resources.
– Assess the relationship between the Groceries Index and the Cost of Living Index in the cities you studied. How do these indices help you identify the best and worst cities in the list regarding cost?
– Summarize how this week’s visualization and probability tools helped you in your analysis.
The Identifying Relationships Between Variable assignment
– must be two to three double-spaced pages in length (not including title and references pages, charts or tables), and formatted according to [_APA Style_Links to an external site.](https://writingcenter.uagc.edu/apa-style) as outlined in the Writing Center’s [_APA Formatting for Microsoft Word_Links to an external site.](https://writingcenter.uagc.edu/apa-formatting-microsoft-word) resource.
– must include a separate title page with the following:
– title of paper in bold font
– Space should appear between the title and the rest of the information on the title page.
– student’s name
– name of institution
– course name and number
– instructor’s name
– due date
– must utilize academic voice. Review the [_Academic Voice_Links to an external site.](https://writingcenter.uagc.edu/academic-voice) resource for additional guidance.
– must include an introduction and conclusion paragraph.
– Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
– For assistance on writing [_Introductions & Conclusions_Links to an external site.](https://writingcenter.uagc.edu/introductions-conclusions) as well as [_Writing a Thesis Statement_Links to an external site.](https://writingcenter.uagc.edu/writing-a-thesis), refer to the Writing Center resources.
– must use at least one credible source in addition to the course text.
– The [_Scholarly, Peer-Reviewed, and Other Credible Sources_Links to an external site.](https://content.bridgepointeducation.com/curriculum/file/e5359309-7d3c-4a21-a410-44d59303ccef/1/Scholarly%20Peer-Reviewed%20and%20Other%20Credible%20Sources.pdf) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
– To assist you in completing the research required for this assignment, review [_Quick and Easy Library Research_Links to an external site.](https://ashford.mediaspace.kaltura.com/media/Ashford+University+Library+Quick+%27n%27+Dirty/0_bcsbcjee) tutorial,
– must document any information used from sources in APA Style as outlined in the Writing Center’s [_APA: Citing Within Your Paper_Links to an external site.](https://writingcenter.uagc.edu/apa-citing-within-your-paper) guide.
– must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.
– Review the [_APA: Formatting Your References List_Links to an external site.](https://writingcenter.uagc.edu/format-your-reference-list) resource in the Writing Center for specifications.