A marketing company based out of New York City is

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. https://www.mercer.com/    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.

https://mobilityexchange.mercer.com/Insights/ 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.

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

APA FORMAT at least 750 WORDS 3 pages Martha Ballard’s

APA FORMAT at least 750 WORDS 3 pages Martha Ballard’s diary provides an intriguing look into the lives of women in late eighteenth and early twentieth century Maine.  That it exists at all is rarity.  Martha Ballard’s life was both unique and ordinary and the pages of her diary reveal

1. Consider how training and development is influenced by, and

   1. Consider how training and development is influenced by, and in turn can influence, other human resource functions. In particular, give an example of how training and development can influence and is influenced by activities within each of the following human resource areas: recruitment, selection, HR planning, performance appraisals,

What steps would you take as a consultant hired to

  What steps would you take as a consultant hired to assess the feasibility and functions for selection and implementation of an electronic document and record management system at a large multi-specialty clinic?  Enterprise Content and Record Management Documents, records, and unstructured data of all types continue to proliferate, making it

You will be applying the concepts learned throughout this course

You will be applying the concepts learned throughout this course to an analysis of a merger or an acquisition. Much of the information you will need to complete this analysis can be found in the company’s annual report. You may choose any recent merger or acquisition (within the last 5

Completing this assignment will help you identify the skills and

 Completing this assignment will help you identify the skills and abilities that will move your career forward by developing a job application cover letter. If necessary, you may present yourself as a recent graduate if needed. Instructions Using the Internet, find a specific job opening posted online within the last

Stock – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

This is the discussion; Societal attitudes change over time on

This is the discussion;  Societal attitudes change over time on many issues. Respond to these two questions in this week’s discussion: If societal attitudes change over time, how might these changing attitudes affect a manager’s job over the next few years? What would be one thing you would do as

three persuasive speech ideas that you would like to deliver

three persuasive speech ideas that you would like to deliver to the class.  You need to write a paragraph for each idea explaining why you are interested in the idea, what exactly are you persuading the class to do? and why you feel this is important for the class to

500 words min each..2 references each 1. What is a

 500 words min each..2 references each 1.     What is a social stigma? Is there a stigma associated with being homosexual in today’s society? Is a stigma different or the same as a deviant behavior? Where do you see us moving in the future on this point as a

What is up with the world of pets? People have

What is up with the world of pets? People have some wild weird animals for pets. It seems people are willing to domesticate indoors anything smaller than they are. They prefer to domesticate the 500-pound and up animal on a farm (except for Ming, the Siberian Tiger, who spent time

Read the interview with Roberto Almanzan attached. 500 words. APA

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Health Care: Outbreak Investigation

As an epidemiologist investigating a Middle Eastern Respiratory Syndrome (MERS) outbreak, you have been tasked with developing an eight to ten-item questionnaire to investigate the situation. You will also write a brief report that explains the questionnaire. Your report should address the following: • An explanation of your questionnaire; o

Location Description of business

History of the business             Where did they come from? Mission Statement of the business (many small businesses may not have this) Two Objectives for 2018  External Environmental Factors:  Technological – what technological factors influence or could influence this business Political/Legal – what laws, regulations, etc. could impact this business?

First, read a news story from the newspaper or the

First, read a news story from the newspaper or the Internet.  Answer the following questions regarding your news story: 1) What is the main issue, who are the main actors being discussed;   Second, read all the articles and watch all the videos assigned in this module.  Answer the following

Non-smokers Smokers CAD No CAD CAD No CAD High coffee

      Non-smokers Smokers   CAD No CAD CAD No CAD   High coffee 40 90 High coffee 150 65   Low coffee 65 150 Low coffee 45 20   (a)  Calculate the crude odds ratio (for the association of coffee drinking and CAD) and the two stratum-specific odds ratios. Show

Group Dynamics

Description First select a healthcare organization, and then address the following in a paper: – Discuss why the study of group dynamics is important to today’s managers, and how it would be useful to your selected organization, in particular. – Explain how group cohesiveness either is or could be developed

Community Health Assessment

Write a 2–4-page report on the concepts, processes, and tools needed to conduct a community health assessment, how to find the data, and how to validate the data. Explain the factors that can affect the health of a community, along with how to obtain that information. Understanding community and state