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

Help with RTI Tier 1-3 Graphic Organizer

EDSP 622 EDSP 622 RTI Tier 1-3 Graphic Organizer Assignment instructions Overview As special educators, it is necessary to assess and interpret data when making decisions about the needs of students. Through the reading and materials in the course, you will understand the role of the three tiers of Response

lawson

 Any use of AI will result in an automatic 0 Respond  to a professional article, discussing the two  major types of research methodologies, worth 100 points. The article is  attached.  You  will be asked to respond to several questions about the article and the  author’s point of view. Discuss the

assitant needed kk ac

please see attachment AOS 492- Financial Literacy for Leaders Applied Financial Decision Project PURPOSE: To integrate the learning from all the course units within the AOS492 course, this assignment is an opportunity to incorporate the important aspects learned in the course, research, and other readings to be able to apply

edu 535 week 9 discussion

  Read the blog post, Careers and Learning: Real-Time, All the Time,Links to an external site. from Deloitte Insights. Then, in your discussion, please address the following: Discuss how the changing cultures in society and the workplace are affecting career choices in learning and development as well as training. Explain

assitant needed S Kenniqua

please see the attachment K. Grate 2 Leveling the Playing Field: Why Female Athletes Deserve Equal Pay Should professional female athletes be paid the same as male athletes in the same sport? Thesis: Women professional athletes are supposed to earn as much as their counterparts in the same sport due

question

Journal Entry 1 · What is the difference between facilitating learning and teaching information​? Journal Entry 2 · Imagine that the parents in your class are not pleased with the authentic measures for assessment being used. They want to know if their children are doing as well as others. Based

question

Video 2 Kristen A- I liked the idea of doing formative assessments, where teachers are doing small check-ins with students. This means students can gain feedback and make immediate changes. One of the people in the video brought up how we often write feedback on a student’s paper, but then

assitant needed SL Kenniqua

please see attachment Using the short story, “The Lottery,” please provide an example of each of the following concepts.  Include the page number in your answer.   1.      What is a social fact from the story? Why should it be considered a social fact?   2.      From our discussion on Culture, give

assitant needed kk ac

please see attachment Question 4 (5 points)   What categories of activities are reported on the statement of cash flows? Does it matter in what order these sections are presented? Question 5 (10 points)   What function does the statement of cash flows serve, as one of the four basic financial statements? Question

assitant needed kk ac

please see attachment Many organizations have difficulties controlling their inventory.  Reflecting on your present or past jobs, think about practices that could cause problems controlling the organization’s inventory.  Then explain one of these practices, why it was or could be considered a problem with controlling inventory, and what could be

health education

To this point in the course the bulk of our discussion has been on the role of the health educator as an organizational manager and how that relates to different areas of the organization. With this information in mind, I would like you to explain the concept of a health

question

620 Baseline Survey Directions: Answer and submit your answers to this survey BEFORE completing any of the course readings. 1. What do students need in order to learn effectively? 2. Describe how your students’ physical, social, and emotional development will impact your lesson planning and instruction. 3. How do students’ family,

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   

edwards

Please respond to the posts 2 Recommendations for Prevention and Diversion Programs for Juveniles Juvenile delinquency prevention and diversion programs are crucial to  both rehabilitation efforts and public safety. Instead of focusing  primarily on formal adjudication and incarceration, these programs aim  to address the root causes of delinquent behavior, with

Education edu 535 week 8 assignment

refer to the attached document Overview Educational experts develop strategies and techniques to provide the best instructional strategies for learning. These strategies are grounded in the research of learning theorists and various methods of acquiring knowledge. In this assignment, you will identify activities for your training program that align with

edu 535 week 8 discussion

  A training program that you designed to help your organization or institution improve communication from the boardroom to the mailroom has been in place for the past three months. You notice that there are still communication issues across multiple departments and lines of business. Your chief financial officer is

assitant needed H Kenniqua

please see attachment US HISTORY II THE GREAT DEPRESSION Film “Stormy Weather” The Century: America’s Time 1, What was the “Bonus March?” What does this event tell you about the feelings of Americans during this period? 2. What were Hoover’s responses to the Depression? 3. What were some common means

edwards

  Recommendations For Prevention/Diversion Programs For Juveniles You  will include in your assessment the assumptions you think are related  to these programs, if these assumptions are justified, and your  rationale as to why the public doesn’t support diversion programs. The  purpose of this assignment will give you the opportunity to