# Multiple Linear Regression

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#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. 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.
Mathematics
Thank you, great work!
Customer 452483, July 19th, 2021
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
Nursing
Excellent!!! Thank you.
Customer 452487, September 13th, 2021
Communications
Thank you! It was great :)
Customer 452483, July 26th, 2021
Communications
came in earlier than I thought and has all the sources listed and cited in APA format, overall all perfect!
Customer 452461, May 24th, 2021
Nursing
Good job! Thank you
Customer 452487, October 17th, 2021
English 101
Perfect! Thank you so much for all of your hard work and help! Appreciate it!!
Customer 452483, August 30th, 2021
Nursing
Excellent! Thank you.
Customer 452487, October 16th, 2021
Healthcare Writing & Communications
Perfect! Thank you so much for all of your help!
Customer 452483, October 31st, 2021
Nursing
Excellent job! super recommended.
Customer 452487, August 24th, 2021
English 101
Amazing thank you!
Customer 452615, August 1st, 2022
Other
I appreciate the help.
Customer 452567, March 18th, 2022
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
Get in Touch with Our Live Chat Agents via WhatsApp on +1(346) 416-0954. Get Unlimited Access to Answers on Any Queries With Your Paper.