Identify seven cities and note cost of living index values

Assignment Help Operation Management

Reference no: EM133583706

Homework: Business Finance- Operations Management- Data & Analytics

In this homework, 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 City webpage and follow the directions below to get started:

A. Identify seven cities and note the "Cost of Living Index" and "Groceries Index" values.

B. In your Excel spreadsheet or tool of your choice, develop a table with three columns with the following titles:

a. City
b. Groceries Index (independent variable)
c. Cost of Living Index (dependent variable)

C. 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.

D. Now, insert or draw a scatterplot of the above data set.

E. 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."

F. 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.

Reference no: EM133583706

Questions Cloud

Prepare at least one equipment fault report : SITHCCC023 Use food preparation equipment, Campbell Institute - Outlined various fixed commercial equipment and prepare at least one equipment fault report

Discuss possible health and lifestyle real-life applications : consider the research your classmate has posted and compare/contrast with your own research. Additionally, discuss possible health and lifestyle real-life

Identifying an area for improvement : identifying an area for improvement, talk to your preceptor, educator or nurse manager. They may have ideas that are already under review or may be able

Why is it advisable to ambulate patients as soon as possible : Why is it advisable to ambulate (move) patients as soon as possible after a myocardial infarction? Keep in mind ambulation is NOT exercise, but it is movement.

Identify seven cities and note cost of living index values : Identify seven cities and note the Cost of Living Index and Groceries Index values. Now, insert or draw a scatterplot of the above data set.

Describe role of the apn as patient advocate at the patient : Describe the role of the APN as patient advocate at the patient, family, and systems level. What opportunities do you see in your workplace?

Describe careful consideration of each aspect of the dilemma : how you could solve this ethical dilemma " This child consistently comes to the daycare with bruises and seems unusually fearful. I suspect child abuse

What are the clinical manifestations of a uti : What are the clinical manifestations of a UTI? What are manifestations that an older adult may exhibit that are different from younger populations with a UTI

Define the functions of the clinical specialist according : Define the functions of the clinical specialist according to the AACN. Describe the essential competencies that the clinical specialist must possess according

User Account

All Pages