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

States

Please read: Start by reviewing the 50-State Comparison (opens in a new tab) which outlines the various school funding formulas that the states utilize. You can also view the state profiles(opens in a new tab) on this page to get a comprehensive overview of just one state. Even within the

Issues in special education

Task 2- National and State Identification and Evaluation Critical Issues  The following resources illustrate THREE critical issues and trends in Special Education for the 2023-2024 academic year national and state-wide.  Provide a two- page summary for each. Issue 1: National Raise the Bar Policy Brief: | U.S. Department of EducationLinks

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      

Mana

Demonstrate your understanding of the module information by relating the information to the case study. Be explicit. Use apa format and site correctly. TEXT BOOK LOGIN usename: [email protected] password: Kirtavious1$ a.com%2F&data=05%7C02%7CNPARKS%40augusta.edu%7Cca99494d66b04685fede0 8ddd8eb5839%7C8783ac6bd05b4292b483e65f1fdfee91%7C0%7C0%7C638905227498 101192%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuM DAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C& sdata=TOgwJX4Gt5l9zd3xVXC2cKlpTTabI0TJDMDLNtAyaKo%3D&reserved=0 Answer the following: What are the positive aspects of the teacher’s management? What problems are

Design A Classroom

The classroom environment provides a powerful context for learning.  Environments communicate messages to children about what kind of learning is valued and what their role is in the process.  An intellectually engaging learning environment provides various contexts for teaching and learning to occur, such as small groups, individual interactions, whole-group

Module 5 Discussion

Textbook for Question 1 & 2: Approaches to Early Childhood Textbook for Question 3 & 4:  Effective Practices in Early Childhood Education   Question 1 – How is imaginative play used in the Pyramid curriculum, and how does it serve the 3 H’s (Heart, Head, and Hands) or three bits of

The Odyssey and Storytelling)

The Odyssey and Storytelling) Directions Whether they come to us as poems, like The Odyssey, or through plays, novels, or film, stories serve many purposes. In “The Story of Storytelling,” Ferris Jabr writes of how, in particular, ancient myths functioned. “Not only are ancient myths and folktales almost universally concerned with

lason

please see attachment InSideOut Coaching template Title page – use the template found in Canvas…this should be on a single page before the abstract Abstract – this should be roughly 200 words which summarizes what will be found in the body of the paper. This should be on its own

a evans

  Any use of AI will receive automatic 0 Project  management is about planning, organizing, directing, and controlling of  company resources. The assignment for this week involves using project  management with the help of Six Sigma to create a chart showing each of  the steps you will take, and then

angela

 Topic:  From Coping in Silence to Wellness Units: Police Mental Health Reform in NC 1970–2000   How and why did North Carolina police departments shift from discipline-first, stigma-heavy approaches to structured wellness and peer-support models between 1970 and 2000?  This assignment requires the submission of a preliminary annotated bibliography of works

cdassign2

 students will collect documentation to put together a potential family newsletter.   Will upload more information on how to do assignment soon

need 1-4 parts

Required Readings & Resources Swanson, J. L., & Fouad, N. A. (2020). Career theory and practice: Learning through case studies (4th ed.). · Chapter 15: “The Intersection of Career and Noncareer Issues” · Chapter 16: “Summary and Integration” PART A-A client comes into your office lost and says, “I don’t

Education Homework

Hello. is there anyone that can assist me with my homework.  I will have thing in in the upload below. Chapter 9 : Lesson 2 Destruction of the Amazon Rainforest Info Graph Assignment: Create an eye-catching, info graph about the deforestation of the Amazon Rain Forest on a sheet paper.

Education Assignment 3AM

Methodology and Strategies for teaching English Language Learners (20 points) The purpose of this assignment is to become familiar with a variety of methodologies, strategies, best practices, and instructional techniques used to teach English as a second language. For this assignment, you will view  5 videos of teachers instructing English language

Edwards

Any use of AI will result in automatic 0 topic:  The Effectiveness of Restorative Justice Programs in Reducing Juvenile Recidivism 

edwards DQ

 In  this discussion, you will apply this module’s Learn materials in a  meaningful way to clarify your understanding of stress and law  enforcement.  What are early stress management techniques?  What are  some stress management techniques being used today for law enforcement  officers?  

D posts

Discussion Forum – Online teaching/e-learning day activities –Brainstorm, research, discuss, and reflect on 2-3 online teaching strategies or platforms for implementation with online teaching and/or distance learning. This is two differpost group discussion posts. One and half paragraphs for each are good. Please stay away from AI and plagiarism. Discussion

Rational and problem statement

I need someone to help me  2 Addressing Public Health Challenges: Mental Health Disparities, Chronic Diseases, and Environmental Health Risks Quannessa Beasley The University of Phoenix MPH/570 Ms. Rose 0908/2025 Addressing Public Health Challenges: Mental Health Disparities, Chronic Diseases, and Environmental Health Risks Part 1: Brainstormed Topics Public health issues