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

Method of entry Research one of the methods of entry

  Method of entry Research one of the methods of entry in Chapter 4. Discuss in depth issues related to the considerations pertaining to this method of entry. Active exporting would be my prefered method. The requirements below must be met for your paper to be accepted and graded: ·

You can find out the Standard Deviation and beta for

You can find out the Standard Deviation and beta for any stock or mutual fund at various websites like www.cnbc.com, www.yahoofinance.com, www.cnnfn.com, or www.bloomberg.com, etc. Choose any stock or mutual fund and discuss the standard deviation and beta of this security. Do you think this security’s return is in line

Methods of Differential Reinforcement – 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.

Source and select a journal article that postulates or asserts

  Source and select a journal article that postulates or asserts a current or an emerging WMD threat to the Homeland. Cite the selected journal article and further: Identify the environmental setting the article describes; Discuss the related vulnerability it discusses; and Enumerate the specific threat it postulates along with

As you finish this capstone in your degree program, think

As you finish this capstone in your degree program, think about where you want to be as a health care professional in 1 year, 5 years, and 10 years. Lifelong learning will be essential to your professional growth and meeting your career goals. Research the professional organizations (requiring membership), that

Neuroscience

 Description Orexin/hypocretin peptides in the aetiology and treatment of narcolepsy. 4 out of the 15 articles will be given that need to be used. Conduct your own literature search and identify other relevant papers. You may use a mix of primary papers and review articles, with no more than 25%

Most ear, nose, and throat conditions that arise in non-critical

   Most ear, nose, and throat conditions that arise in non-critical care settings are minor in nature. However, subtle symptoms can sometimes escalate into life-threatening conditions that require prompt assessment and treatment. Nurses conducting assessments of the ears, nose, and throat must be able to identify the small differences between

Respond to this post with a positive response :Ask a probing question,

Respond to this post with a positive response : Ask a probing question, substantiated with additional background information, evidence or research. Share an insight from having read your colleagues’ postings, synthesizing the information to provide new perspectives. Offer and support an alternative perspective using readings from the classroom or from

Utilize the information below that is copied-and-pasted out of the

  Utilize the information below that is copied-and-pasted out of the SOAP Note Assignment instructions to assist you in formatting your post: Assessment (A): Diagnosis/Diagnoses: Start with the presenting chief complaint diagnosis first. Number each diagnosis. A statement of current condition and all other chronic illnesses that were addressed during

“What kinds of interpersonal skills and cultural awareness are

Question 1: What do you understand by ‘global citizenship’? And how might it help focus on shared concerns between national cultures, rather than on differences? Question 2: What do you understand by cultural heritage? And what role might it play in expectations of work and management? Question 3: “What kinds

PHC 311 SEU Different types of AIDS Questions Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for designing assignments and evaluating student performance, I strive to create comprehensive and meaningful assessment materials that align with the learning objectives of medical college students. Additionally, I aim to provide constructive feedback through examinations and assignments to aid in their

Assignment: How Algorithms Change Our World View An algorithm is

  Assignment: How Algorithms Change Our World View An algorithm is simply a pattern or protocol, referring to how things get done. If a Web page references your personal information and past viewing habits, the algorithm or protocol will be to serve up more of the same to capture your

Describe your personal worldview, including the religious, spiritual,

Being able to articulate your personal worldview can help you formulate a personal philosophy of practice and enhance your influence on patients and the industry. In this assignment, you will have an opportunity to reflect on your current and future practice(nursing Informatics), and the ways worldview and nursing theory influence

In preparation for our discussion on the Criminal (In)Justice System,

In preparation for our discussion on the Criminal (In)Justice System, Child Welfare System, and Criminalization of Youth: Listen to: https://www.irp.wisc.edu/resource/adrian-huerta-on-the-school-experiences-of-gang-associated-youth/ (Links to an external site.) Watch: https://www.youtube.com/watch?v=Pd9ePU2i9R8&t=3050s&ab_channel=InstituteforResearchonPoverty (Links to an external site.) Submit a reflective critique including but not limited to: The key takeaway from each of the links (what was the

The future of Healing Hands Hospital is looking bright thanks

The future of Healing Hands Hospital is looking bright thanks to the work of the task force. Mr. Magone is excited about the information you have presented about the changes in payment structures, competitors, and potential to merge; successful preparation for an accreditation visit; and emerging technologies. With these in

M3D2: Veterans, Mental Health and Substance Abuse.

 Module 3 The New York Times article ‘After the Battle, Fighting the Bottle at Home‘ and the video ‘War Torn’, show the deep relationship between mental health issues among veterans and substance abuse. As part of this activity, you will reflect deeply on these issues and discuss effective strategies to

Analysis Requirements: Based on your readings, analyze the court cases,

Analysis Requirements: Based on your readings, analyze the court cases, include the following in your discussion: Identify, discuss, and provide specific examples of the legal aspects of the fraud committed in each case. Identify, discuss, and provide specific examples of any legal aspects that a fraud examiner must consider in