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

Early Intervention of Developmental Disabilities

  Students will select a vignette about a family with a child who is eligible to receive early intervention services. Students will complete a blank IFSP form will all relevant information based on the case of Kim. You can add in any information that may not be addressed in the

Early Intervention of Developmental Disabilities

  Students will select a vignette about a family with a child who is eligible to receive early intervention services. Students will complete a blank IFSP form will all relevant information based on the case of Kim. You can add in any information that may not be addressed in the

brumsey

  Students will identify the cultures and societies (plural) of the United States. Students will evaluate the place of the United States within a larger global context.

neva

  1.  When it came to building empires in the Americas, the Europeans had  some advantages.  Explain what they were, and how they served as  advantages. 2. What was the Columbian exchange, and how was it global in nature? 3.  How did the Spanish transform the land once controlled by

neva

  1. How did the Russian Empire change the lives of its conquered peoples and the land itself? 2.  What were some of the distinct features of the empire established by the Qing Dynasty? 3. What were some of the distinct features of the Mughal Empire? 4.  What was the

des

Q1 topics.  Asia After World War II                The Korean War, A History.  With Bruce Cumings  Q2 Topics  American Expeditionary Forces in Siberia, Russia | 1918-1920 | US Army Documentary                1917: Lenin, Wilson, and the Birth of the New World Disorder                  

c mitchell

  . How did the Russian Empire change the lives of its conquered peoples and the land itself? 2.  What were some of the distinct features of the empire established by the Qing Dynasty? 3. What were some of the distinct features of the Mughal Empire? 4.  What was the

Plan Management

Draft Project Management Plan: Applying Contemporary Models to Develop a Change Embracing Culture Using your previous formative assessment titled “Paper: Applying Organizational Models to an Organizational Context” and insights from your recent Learning Activities, you will develop a Draft Project Management Plan. For this deliverable, you will continue with the

Discussion 4 AM

Assignment 4 – Differentiated Lesson (25 points) Due Week 8 After reviewing the SIOP and sample lesson plans for the grade levels of your choice, develop a differentiated lesson plan in any of the following content areas: mathematics, science, social studies, arts, language arts, health education or physical education. The

Education Assignment 3 AM

Assignment 3 – Additional language learning through apps (25 points) Due Week 7 An essential part of learning to work with English language learners is to understand some of the processes in learning a new language. Therefore, you will be learning a new language of your choice on at least

question assigment

Module 5: The Teacher as Part of the Learning Environment- Task (Select ONE from Choice A or B) · Collect ECERS-3 Data and record scores by clicking this link:  ECERS-3 REPORTING FORMLinks to an external site. · Create and submit a  PowerPoint Presentation (PPT) that summarizes the findings from your observations

research

research Locating educational research from scholarly sources allows you access to knowledge based on empirical data. After studying the course content in this module, you are equipped to identify educational research and locate scholarly sources. You can locate and read scholarly sources in your professional positions to answer questions and

article review

article review Choose one: Student Motivation  OR  Teacher Expectations Search for and summarize an article that explores the role of student motivation in student achievement  or  the role of teacher expectations in student learning.  When typing an Article Review, follow this format and include the bolded headings: 1. List the

ENV 4303

Please view attachment In these last units, we covered a number of important concepts related to environmental technology. For this assignment, you are asked to create a PowerPoint Presentation that presents an overview of these main concepts to present at a webinar for a fictitious not-for-profit organization. The organization promotes

OSH 4303

Please view attachment You have been tasked with identifying health hazards associated with a production line at a manufacturing facility. Employees at the beginning of the line use a solvent to clean the surface of medium-size auto parts, and then they place the parts on a moving line. As the

How Much Airsoft Guns Cost and What to Expect

  Let’s understand how much airsoft guns cost, and what to expect in terms of pricing is essential.  How Much Airsoft Guns Cost and What to Expect Airsoft is an exciting and thrilling sport that has gained immense popularity over the years. Whether you’re new to the world of airsoft

u edwards

please see attachment BUSI 701 Annotated Bibliography Assignment Instructions Overview submit your Annotated Bibliography Assignment on the topic that is being covered for the week (Marketing, Accounting, Finance, Management, Economic Data Analysis, International Business). Instructions An annotated bibliography is a list of sources (books, journals, Web sites, periodicals, etc.) one

u edwards

Please see attachment. do not forget to add bible verse at the bottom BUSI 701 Discussion Assignment Instructions Initial Thread The Journal of Accountancy has identified key areas of research in accounting. You can find a current list of those by visiting here ( Links to an external site.) Choose