Identifying relationships between variable | Management homework help

 

n 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:

  1. Utilities (Monthly)
    • Basic utilities (electricity, heating, cooling, water, garbage) for 915 square foot apartment
  2. Sports and Leisure
    • Fitness club, monthly fee for one adult
  3. Childcare
    • Preschool (or kindergarten), full-day daycare, private, monthly for one child
  4. Rent Per Month
    • Apartment (1 bedroom) in city centre
  5. 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

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Academic Solvers has put together a group of highly qualified writers with a wide range of expertise in the online writing community. Our goal is to become your one-stop shop for all academic and online writing needs. Take a look at our fantastic service below!

Editing

Research Paper Editing

At Academic SolversEditing your research paper could prove to be difficult especially amidst the tight schedules that students have. At academicsolvers.net, we offer research paper editing services. The services include proofreading and use of online platforms such as Grammarly and Turnitin to address any concerns that may arise within the paper. Get our services and you will have satisfactory results.

Research Paper

Custom Research Paper

Writing a research paper could be quite hectic especially if it is your first time. Identifying the research topic, finding the references and interpreting information could pose significant challenges. However, this should not be issues of concern anymore. At academicsolvers.net, we offer solutions to research papers. We deliver plagiarism free and quality research papers that are customized to suit your needs.

Editing

Online Proofreading

Despite writing expertise and skills, you are never guaranteed of error free papers. Academic solvers’ online proofreading services leaves no mistake unaddressed. We go through your paper using a variety of online tools that help to ensure that we edit your paper and make it error free. We have collected a group of experts hence can guarantee quality proofreading services.

Coursework

Cheap Research Papers

Do you have difficulties writing your research paper? Are you afraid of the cost of hiring a professional to write your research papers? Worry no more. At academicsolvers.net we address both of your problems. We are equipped with a large number of professional writers. Second, we offer our research paper writing services at cheap prices that are largely affordable. Don’t miss this chance. Order our cheap research papers today.

Coursework

College Assignment

College assignment could be one of the biggest challenges to students especially working with tight schedules. Academicsolvers.net acts to bridge this gap existing between getting satisfactory grades and meeting deadlines. Our college assignment professionals provide students with quality, plagiarism free and confidential assignment help that helps them to achieve desired grades and outcomes.

Coursework

Essay Help

Essays are some of the most critical elements in the academic life of a student. At academic solvers we prioritize providing quality essays. As such, our professional ensure that they address issues of grammar, structure and plagiarism to provide essays that meet the need of the client. Here, we focus on developing content that aims at addressing the subject in question through the expertise of our professional and experienced writers. Try our services and we guarantee succes.