Prior to beginning work on this assignment, read Chapter 4 of your textbook, including the “Cost of Living Brief Case” at the end of Chapter 4 on page 143, and access the Numbeo Cost of Living website below:
https://www.numbeo.com/cost-of-living/
In this assignment, you will be analyzing the cost of living in any U.S. city and creating a scatterplot to identify the relationships between variables. You may want to choose the city you live in, the city you were born in, or a city you may be interested in moving to in the future.
Go to the Numbeo Cost of Living (Links to an external site.) web page. In the “Select City” search box, type in the name of your city until it appears in the drop-down menu. Select your desired city. Note: For an accessible version of cost of living data, please contact your instructor.
A summary, along with cost of living index for the city you selected, will be displayed in the box at the top of the page. You will also see a breakdown of items with their associated cost. The first column is the item name, the second column is the cost of the item in your city, and the third column is the range of the cost for that item.
For this assignment, you need the first data item for each category and associated cost listed in the second column. For example, for “Utilities (Monthly),” choose the value for the first item under it—i.e., “Basic (Electricity, Heating, Cooling, Water, Garbage) for 915 sq ft Apartment.” For “Rent Per Month,” choose the value for the first item under it—i.e., “Apartment (1 bedroom) in City Centre.”
It is recommended that you use Excel to compile and analyze the data. Instructions for using Excel and other tools are on pages 139 to 142 of your text. However, you are welcome to use the tool of your choice.
Choose the following categories from the list (in your paper, call them 1–5 as listed below) and the numeric data from the first item listed in the dataset:
Utilities (Monthly)
Basic utilities (electricity, heating, cooling, water, garbage) for 915 square foot apartment
Sports and Leisure
Fitness club, monthly fee for one adult
Childcare
Preschool (or kindergarten), full-day daycare, private, monthly for one child
Rent Per Month
Apartment (1 bedroom) in city centre
Salaries and Financing
Average monthly net salary (After Tax)
In your Excel spreadsheet or tool of your choosing, you will have a table with five rows and two columns. The first column is numbered 1 through 5 and the second column will be the cost associated with the line item under the category for your city. In your Excel spreadsheet or other tool,
Draw a scattered graph of the above selected data set.
Display the regression line (also called trendline, linear model, and line of best fit) for the above categories in your city.
Display the equation for the linear model and the R2 value on the graph. In Excel, right click on the line graph to display the options, scroll down and select the boxes for display equation on chart and display R-squared on chart options.
In your paper,
Provide a URL of the website with your data along with your excel spreadsheet of the graph with equation and R2 value
Analyze your findings on the best and worst predictor among these categories on the cost of living in your city.
Assess the relationship between the variables, including any causation, correlation, or influences between the variables.
The Identifying Relationships Between Variables paper
Must be three double-spaced pages in length (not including any graphs, tables, title, or references pages) and formatted according to APA style
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must utilize academic voice.
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.) as well as Writing a Thesis Statement
Must use at least one credible source in addition to the course text.
The Scholarly, Peer-Reviewed, and Other Credible Sources —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.
Must document any information used from sources in APA style
Must include a separate references page that is formatted according to APA style
attachment
59C0DD51-D6C1-4CA8-A0FD-78AB1FB71189.jpeg
attachment
89B86314-72B7-44A0-BAEA-28FFADC6444C.jpeg
attachment
EF24B052-8984-436C-BBAB-07C8AD582BD5.jpeg
attachment
8C0BEC8F-572D-4226-9D05-109110703246.jpeg
attachment
F5665F34-4F77-4DBB-90FD-4A32337CEBE5.jpeg
attachment
39FC5AEC-0637-4FC3-96B6-D6804DA81360.jpeg
attachment
9516F405-96E1-42E4-A3A4-6EA727D86AC4.jpeg
attachment
6E625CF6-8A6E-4356-A6C4-8EF6CA905229.jpeg
attachment
AECB25AD-F68C-42A6-A4F7-70DF668DFC2B.jpeg
attachment
D5F24D85-C5FF-4453-8071-D35D1CE541BA.jpeg
attachment
2AE5D2FC-FB6E-451D-80CD-0ECFEEE06A0B.jpeg
attachment
CBFFCF33-490B-4264-B747-B163114F5D3F.jpeg
attachment
7FA4DC3F-B5CB-419D-9734-1645ADA249D7.jpeg
attachment
01BB67BF-79C1-4635-97B6-12CA385CB73A.jpeg
attachment
895879CD-B93B-47DE-863D-53D68D288D3F.jpeg
attachment
52632C8D-5276-4994-90FF-4EFE4C0B1B0C.jpeg
attachment
BDAA0109-0B49-4C41-9205-A8C817620835.jpeg
attachment
E12511C1-6049-4F2A-9614-309342533FCD.jpeg
attachment
D731F3D2-048E-448F-ADB1-37201952DB5A.jpeg
attachment
3C253185-E151-4328-A9A4-E2DA4060157C.jpeg
attachment
FCD9C0DE-B038-4BB2-8DFE-E12C9885D497.jpeg
attachment
6EB51794-C9C2-4278-ACF3-A3C7DCDD651B.jpeg
attachment
ADA7A0E0-0679-49CE-A27C-1C7A02F89165.jpeg
attachment
9602AA6C-5665-47E6-8285-893B69819B8D.jpeg
attachment
2538C267-A6E9-4971-BCA5-28B26557CDC3.jpeg
attachment
CF6AD505-F2F9-4084-B509-9DC08F7BD5D1.jpeg
attachment
194F8EB4-9FE0-4269-9923-F2B01C3A284D.jpeg
attachment
5CAE4242-A7BF-41F5-9A37-DF124FA2CEF3.jpeg
attachment
E9F4056B-CF11-4B9B-95D8-F329E6D78478.jpeg
attachment
15CC4F10-5438-4F0F-BB7A-79A22E3FBEF0.jpeg
attachment
49F91D63-8436-44C2-B745-1E680626DC13.jpeg
attachment
6325B22C-CED4-4F31-A9E4-CB527C53EA5B.jpeg
attachment
A39DB850-CA1D-4124-AA73-D146FA9817E0.jpeg
attachment
3CA065B3-7375-445C-BE29-0074D2F1B88A.jpeg
attachment
0A4BABDB-83B1-4A2D-8062-0643CD4AE671.jpeg
attachment
EB002FF3-E328-433C-B315-65B2E87C6445.jpeg
attachment
961BDE67-D7AE-4EDA-A569-387C1DB862F9.jpeg
attachment
14EB6E47-A2F2-48C0-81E3-474B88327C40.jpeg
attachment
299CA46D-C7EE-4B88-B4E8-6B6F277C83BE.jpeg
attachment
B04776A9-EEAC-4335-AB56-B7AC938BA377.jpeg
attachment
2FBF49FB-16DA-4F3D-A9E4-580516CC02DD.jpeg
attachment
7B9182C4-155B-4976-A0F6-13382C8F451D.jpeg
attachment
666D4DFC-F397-4191-9FF6-D66A7A5A085D.jpeg
attachment
8DE766D1-9682-4E22-854D-B23489EAC5C9.jpeg
attachment
64E089CB-0864-4BCF-A107-91B8DEEB6DD5.jpeg
attachment
C3E842BB-C0E8-4730-B270-44C64C84392A.jpeg
attachment
0F5C9874-AEFA-40E5-AFE4-A3FE8297E479.jpeg
attachment
D8EDD485-8127-4CD5-B4BB-A276FAAE4F41.jpeg
attachment
0F0270B7-7381-4423-AEE8-D9A2329FC060.jpeg
attachment
BC7835B9-7A4A-4BF0-9C84-A7EDCF47D9D3.jpeg
attachment
D744CE3A-D4F5-4FED-95FC-F79C5700D747.jpeg
attachment
7377ED17-05F6-406A-B0F4-1BEFFC23A927.jpeg
attachment
8B5642FF-56A5-44AE-8C47-71795272A420.jpeg
attachment
22AD9F2E-6550-4E65-9A85-CEA82393AFEF.jpeg
attachment
16FBBA00-D0E3-401C-8B76-5FE2FC016D9A.jpeg
attachment
111A058B-D034-4F4A-8B58-92596386C664.jpeg
attachment
BFB8FE7A-E137-4A15-8C72-9E01D92A23F1.jpeg
attachment
2D635EC9-BA51-44F1-A91C-C2844965469B.jpeg
attachment
D37941F4-D4BF-4BDB-B3E2-A5FC71FBCDA3.jpeg
attachment
D43483CE-1DEF-465D-8121-9E8920448953.jpeg
attachment
63CF721B-ABC4-41F5-BFF4-75B7035EB644.jpeg
attachment
470B3DF7-02E2-46A5-9413-FE3A3E1CEA3C.jpeg
attachment
A4B1B96F-7377-444D-9BAE-067CA0B8CEE6.jpeg
attachment
412F899E-F808-4196-B7A1-BBDFDD4F055B.jpeg
attachment
87E416BF-6AFF-4EC4-84AB-BB00D2C20DE1.jpeg
attachment
C36E1B2D-7E1D-4218-A472-64176B22EE7B.jpeg
attachment
A150ACFA-4FDB-456C-9305-B07238009396.jpeg
attachment
3D67AE60-CF73-4266-824C-B679635A3264.jpeg
attachment
640FD0FA-7509-43DB-8E2E-C798011F381C.jpeg
attachment
4B85DD27-522A-4B1C-9145-B2444D2ABEFB.jpeg
attachment
EAC8D9ED-167F-475B-9B07-0A50478B80D5.jpeg
attachment
D0DEC35B-E2B7-41BC-896E-BC271B3574A6.jpeg
attachment
EC7DD2F9-7492-4A65-B56B-30BFBDB215AE.jpeg
attachment
9DCCFF99-132B-4D26-BCD8-6895BFEE61B5.jpeg
attachment
B67FE07C-C2EE-4053-8ADD-2A17695BD2AB.jpeg
attachment
41A0B163-966C-4974-A69E-E0059D0A6E8A.jpeg
attachment
B293A31C-F9E4-478F-BBAC-8552879E32EC.jpeg
attachment
730FE564-AB31-4AF1-B308-B6F91E5F4528.jpeg
attachment
AA714703-9FFA-4EE6-A8A7-670A9B94068E.jpeg
attachment
2FFC1005-CB5D-4C66-A9EA-9D0372D8F348.jpeg
attachment
B35631B3-7B31-438E-A2F3-2C2681ED39CB.jpeg
attachment
6A1AB4C1-A518-4F75-8C5E-94CC75AD90E8.jpeg