Business Finance – Operations Management Can someone do my Week 2 assignment Data & Analytics?

 

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 Paper. 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. 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 paper,

  • Provide the URL and complete an APA reference for the URL. For assistance formatting your reference list, refer to APA: Formatting Your References ListLinks to an external site. 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, & AppendicesLinks to an external site. 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 paper

Are you struggling with your paper? Let us handle it - WE ARE EXPERTS!

Whatever paper you need - we will help you write it

Get started

Starts at $9 /page

How our paper writing service works

It's very simple!

  • Fill out the order form

    Complete the order form by providing as much information as possible, and then click the submit button.

  • Choose writer

    Select your preferred writer for the project, or let us assign the best writer for you.

  • Add funds

    Allocate funds to your wallet. You can release these funds to the writer incrementally, after each section is completed and meets your expected quality.

  • Ready

    Download the finished work. Review the paper and request free edits if needed. Optionally, rate the writer and leave a review.