A Marketing Company

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.https://mobilityexchange.mercer.com/Insights/ cost-of-living-rankings#rankingsAssignment 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. What is an Executive Summary?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?

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Assignments ABC
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 10k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Microbiology
Thank you so much! I appreciate what you do and all of the great help you've given me!
Customer 452483, September 6th, 2021
English 101
Perfect! Thank you so much for all of your hard work and help! Appreciate it!!
Customer 452483, August 30th, 2021
Psychology
Thank you so much for all of your hard work & help! It’s perfect! Appreciate it!!
Customer 452483, September 11th, 2021
Introduction to Sociology
Amazing! Thank you so much for your hard work, appreciate it!!
Customer 452483, October 24th, 2021
English 101
Perfect! Very informative! Appreciate all of your hard work! Thank you very much.
Customer 452483, September 22nd, 2021
Nursing
Good job! Thank you.
Customer 452487, October 26th, 2021
English 101
I would like to thank you for the writing, it was a very busy week for me and had no time this week to do a writing. I would recommend you to others and would utilize you again.
Customer 452639, October 16th, 2022
Microbiology
Thank you so much for revising this paper for me. It looks great, truly appreciate it! You're awesome :)
Customer 452483, September 14th, 2021
Mathematics
Job WELL DONE! Thank You very much!!
Customer 452483, July 12th, 2021
Psychology
Thank you so much for all of your hard work, appreciate every bit of it!
Customer 452483, September 6th, 2021
Communications
Thank you for your hard work; I enjoyed reading the essay and appreciate your writing.
Customer 452483, July 18th, 2021
Sociology
Perfect! Appreciate all of your help! Thank you so much!
Customer 452483, November 14th, 2021
1159
Customer reviews in total
96%
Current satisfaction rate
2 pages
Average paper length
47%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon ABC15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat