Prior To Beginning Work On This Assignment, Read Chapter 4 O

Prior To Beginning Work On This Assignment Read Chapter 4 Of Your Tex

Prior to beginning work on this assignment, read Chapter 4 of your textbook, including the Brief Case “Cost of Living” at the end of Chapter 4 on page 143 and access the Numbeo Northern America: Current Cost of Living Index by City (numbeo.com). In this assignment, you will analyze the Cost of Living Index and the Groceries Index for seven U.S. cities and create a scatterplot to identify the relationships between the variables. You may choose any seven U.S. cities you wish.

Go to the Numbeo Northern America: Current Cost of Living Index by City (numbeo.com) and follow these steps:

- Select seven cities and note their “Cost of Living Index” and “Groceries Index” values.

- Develop a table with three columns: City, Groceries Index (independent variable), and Cost of Living Index (dependent variable). Include a header row and seven rows of data for each city.

- Using Excel or a similar software, insert or draw a scatterplot of the data set.

- Add the regression line (trend line) to the scatterplot.

- Display the equation of the trend line and the R-squared value on the chart by formatting the trend line options accordingly.

In your paper:

- Cite the URL of the Numbeo website and provide a complete APA reference for this source.

- Include the table with your data and a screenshot or image of the scatterplot with the equation and R-squared value.

- Analyze your findings regarding the cities that show the strongest and weakest relationships between the Groceries Index and the Cost of Living Index.

- Assess the overall relationship between these two indices across the cities studied.

Your paper should include:

- A separate title page with the title in bold, your name, the institution name (University of Arizona Global Campus), course name and number, instructor’s name, and due date.

- An introduction paragraph ending with a clear thesis statement that states the purpose of your paper.

- A body that discusses your data, analysis, and interpretation.

- A conclusion paragraph summarizing your findings.

Ensure you use academic voice and incorporate at least one additional credible source beyond the course textbook. All sources must be cited in APA style within the text and on a references page. Follow APA formatting guidelines throughout.