Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

thelma final

 

please see attachments

Final Project Assignment Instructions

Scenario Background:

A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.

You work for Mercer Human Resources. The
Mercer Human Resource Consulting website lists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.

More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.

cost-of-living-rankings#rankings

Assignment Guidance:

In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.

You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data).

Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well.

Deliverable Requirements:

This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression.

The format of this assignment will be an Executive Summary. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment. If you are unsure of an Executive Summary, this resource can help with an overview.
How to Write an Executive Summary That Gets the Job Done 2023.pdf

Things to Consider:

To help you make this decision here are some things to consider:

· Based on the MLR output, what variable(s) is/are significant?

· From the significant predictors, review the mean, median, min, max, Q1 and Q3 values?

· It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.

· Based on the descriptive statistics, for the significant predictors, what city has the best potential?

· What city or cities fall are below the median?

· What city or cities are in the upper 3rd quartile?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

student teach

I need to answer those questions in 5-7 sentences each. I am applying for a student teaching field experience at a school. This is a special education ABS major. Please tell us about a time when you were part of a diverse team. 7. Please tell us how you feel

questions

 Please answer each question in complete paragraph. Do not repeat the questions. All answers should be followed by a reference   Any use of AI will result in automatic 0      

sam

Please complete one or the other do not complete both. Any use of AI will result in automatic 0  Over  the last few weeks, you have been conducting research on a solution to a  problem in the market. It is time to decide to either move forward or  not.  In

rob

please see attachment. Any use of AI will receive an automatic 0 I am currently a high school football coach at Northeastern High School in elizaeth City NC

Thomas week 3

any use of AI will result in automatuc 0   Many students will struggle to read or write at some point in  their lives. Consider your current school or district Response to  Intervention (RtI) plan for helping these students by addressing these  questions in an original response: How can educators

Education Thomas assignment week 3

  Educators typically follow a process for identifying students  who struggle and implement a series of steps for providing  individualized instruction. While the Response to Intervention (RtI)  process is presented within the regulatory notes of the 2004  reauthorization of the Individuals with Disabilities Act (IDEA), it  pertains to all students,

Education EDU 755 Reading Assignment/Discussion 1

  Unit 1: Reading Assignment Chapters 1 and 2 (Terrell & Lindsey text) Chapter 10 (Payne text)   Unit 1: Discussion Question 1 Discussion Questions: Post your initial response to the discussion forum by Wednesday 11:59 p.m. and respond to the discussion of others by Saturday 11:59 p.m. Discussion Question

EDU 755 Discussion 2

  Unit 1: Discussion Question 2 Discussion Questions: Post your initial response to the discussion forum by Wednesday 11:59 p.m. and respond to the discussion of others by Saturday 11:59 p.m. Discussion Question (10 points) According to the Payne text, how does the information on intersectionality apply to your students?

Education Quality Improvement Action Plan Assignment

Quality Improvement Action Plan Assume that you have recently been hired as the special assistant to the chief executive officer (CEO) of your health care organization. Your duty is to head up the new quality improvement department. Over the past year, the hospital has experienced substantial growth but is also

Education I need help with homework

I need help with homework National Council for the Social Studies Required Explore the National Council for the Social Studies website. Taxonomy of Educational Objectives – The Cognitive Domain Required Read “Taxonomy of Educational Objectives – The Cognitive Domain,” by Kretchmar, from  Salem Press Encyclopedia (2021) … Read More Appendix A: Higher-Order

replyy

5-6 sentences at least At least 5-6 sentences each posts Monrcian post – If I were trying to build trust with families, I would start by simply leading with strength and clarity. I share a quick “here’s what your child does well” snapshot and a plain-language IEP-at-a-glance. I discuss what

Issues

Please read: · Read Chapter 9 of American Public School Finance to better understand demographics and the impact on school funding. · A new report finds predominantly white school districts get $23 billion more in funding than nonwhite ones | CNN · Read Chapter 12 in American Public School Finance

Quality Improvement Action Plan

Quality Improvement Action Plan Assume that you have recently been hired as the special assistant to the chief executive officer (CEO) of your health care organization. Your duty is to head up the new quality improvement department. Over the past year, the hospital has experienced substantial growth but is also

Education Homework

Hello.  Is there anyone that can assist me with my homework.  I will have everything that is needed to complete this assignment in the upload.

MTE/510: Professional Knowledge, Skills, And Dispositions

  Wk3 Summative Assessment instructions Teacher dispositions are the values, attitudes, commitments, and professional ethics that influence a teacher’s behaviors toward students, colleagues, families, and communities. Teacher dispositions may be less visible than knowledge and skills; however, they can be considered the most influential quality of highly effective educators. In

sam 2

Please see attachment In our lesson, we discussed the final three areas of the Financial Feasibility Canvas (FFC) and the ninth block of the Business Model Canvas (BMC). Let’s combine what we have learned regarding FFC and BMC. 1. Step 5 of the FFC is Financial Returns – this step