Question

In: Statistics and Probability

Based on this information, in which city should you open a second office in and justify...

Based on this information, in which city should you open a second office in and justify your answer based upon the provided results of the Multiple Linear Regression. 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.

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/cities has the best potential? What city or cities fall above or below the median and/or the mean? What city or cities are in the upper 3rdquartile? Or the bottom quartile?

City Cost of Living Index Rent (in City Centre) Monthly Pubic Trans Pass Loaf of Bread Milk Bottle of Wine (mid-range) Coffee
Mumbai 31.74 $1,642.68 $7.66 $0.41 $2.93 $10.73 $1.63
Prague 50.95 $1,240.48 $25.01 $0.92 $3.14 $5.46 $2.17
Warsaw 45.45 $1,060.06 $30.09 $0.69 $2.68 $6.84 $1.98
Athens 63.06 $569.12 $35.31 $0.80 $5.35 $8.24 $2.88
Rome 78.19 $2,354.10 $41.20 $1.38 $6.82 $7.06 $1.51
Seoul 83.45 $2,370.81 $50.53 $2.44 $7.90 $17.57 $1.79
Brussels 82.2 $1,734.75 $57.68 $1.66 $4.17 $8.24 $1.51
Madrid 66.75 $1,795.10 $64.27 $1.04 $3.63 $5.89 $1.58
Vancouver 74.06 $2,937.27 $74.28 $2.28 $7.12 $14.38 $1.47
Paris 89.94 $2,701.61 $85.92 $1.56 $4.68 $8.24 $1.51
Tokyo 92.94 $2,197.03 $88.77 $1.77 $6.46 $17.75 $1.49
Berlin 71.65 $1,695.77 $95.34 $1.24 $3.52 $5.89 $1.71
Amsterdam 85.9 $2,823.28 $105.93 $1.33 $4.34 $7.06 $1.71
New York 100 $5,877.45 $121.00 $2.93 $3.98 $15.00 $0.84
Sydney 90.78 $3,777.72 $124.55 $1.94 $4.43 $14.01 $2.26
Dublin 87.93 $3,025.83 $144.78 $1.37 $4.31 $14.12 $2.06
London 88.33 $4,069.99 $173.81 $1.23 $4.63 $10.53 $1.90
mean 75.49 $2,463.12 $78.01 $1.47 $4.71 $10.41 $1.76
median 82.2 $2,354.10 $74.28 $1.37 $4.34 $8.24 $1.71
min 31.74 $569.12 $7.66 $0.41 $2.68 $5.46 $0.84
max 100 $5,877.45 $173.81 $2.93 $7.90 $17.75 $2.88
Q1 66.75 $1,695.77 $41.20 $1.04 $3.63 $7.06 $1.51
Q3 88.33 $2,937.27 $105.93 $1.77 $5.35 $14.12 $1.98
New York 100 $5,877.45 $121.00 $2.93 $3.98 $15.00 $0.84

Solutions

Expert Solution

Based on the given data, our objective here, is to choose a city to open a second office. Since, the Cost of living index is a single measure that can best characterize a city, we may test how the rest of the variables relate to it. Running a multiple regression model by regressing Cost of living index on possible predictors - Rent, Transport, Bread, Milk, Wine and Coffee we may identify the significant predictors and through them, the best city.

Using Excel,

From the p-values of the test for significance of predictors obtained from the output, we find that the only significant predictors are Monthly Public Trans Pass (p-value = 0.003<0.05) and Loaf of Bread (p-value = 0.033<0.05) along with the intercept at 5% level .

The regression equation can be expressed as:

Expected Cost of Living Index = 35.640 + 0.3 (Monthly Public Trans Pass) + 16.595 (Loaf of Bread)

The descriptive statistics for the response variable and the significant predictors are given by:

To find out what city or cities fall above or below the median and/or the mean, in the upper 3rdquartile or the bottom quartile, we may use the excel function "IF":

Similarly using the function for obtaining the cities that lie above or below the median, in the 1st or last quartile, we may arrive at the following conclusions:

Since, the slope of both predictors are positive, both are positively related to Cost of living. Cities which satisfies the required condition for both the variables is chosen.

- It is clear that cities namely Mumbai, Prague, Warsaw and Athens lie in the bottom quartile (For both the predictors) - Sydney lies above the 3rd quartile (In terms of both the predictors); Dublin, London, Seoul and Vancouver based on one of the predictor   

The cities marked in Green and Red lie above and below the median respectively (In terms of both significant predictors).

Compiling all the three results, we find that Sydney marks its place in the criterion - Greater than median and third quartile and hence is the next best city to open an office after New York. Cities Tokyo & Paris also lies above the median, hence might be the next choice in rank.

The above conclusions are also supported by the Cost of living index for the three cities.


Related Solutions

Based on this information, in which city should you open a second office in?   Based on...
Based on this information, in which city should you open a second office in?   Based on the MLR output, what variable(s) is/are significant? Based on the descriptive statistics, for the significant predictors, what city/cities has the best potential? What city or cities fall above or below the median and/or the mean? What city or cities are in the upper 3rd quartile? Or the bottom quartile? These are some things to consider not necessarily questions you need to answer in your...
1. Company Amliba.Inc is considering building a second headquarter in a new city. The new office...
1. Company Amliba.Inc is considering building a second headquarter in a new city. The new office will create 5000 new jobs for the city. So the government is incentivized to support the project. The company plans to issue $100 million bond with coupon rate of 8%. Coupon will be paid annually and the bond matures in 5 year. As a form of support, local government guarantee the bond, so the YTM of the bond at issuance is 5%. Another bond...
According to the attached information, based on total risk and return, which of the investments should...
According to the attached information, based on total risk and return, which of the investments should a risk-averse investor prefer? Assume that only one investment can be purchased. Return on Investment: Economic Condition Probability A B C Boon 0.5 25.0% 40.0% 5.0% Normal 0.4 15.0 20.0 10.0 Recession 0.1 -5.0 -40.0 15.0 Expected Return 18.0% 24.0% ? Standard Deviation 9.0% 23.3% 3.3% A. The investments should all be rejected because they are all too risky. B. The investments are equally...
Do you believe that persons owning property in the city in which you live should purchase...
Do you believe that persons owning property in the city in which you live should purchase the Earthquake Assumption Endorsement to their homeowners Policies? Why or why not? Also, please respond to another student's post.
For the data below graph and determine the fit you should use based on the information...
For the data below graph and determine the fit you should use based on the information available. Also try to think about any natural system that might use this type of fit (use SciDavis). Let the horizontal axis represent time in seconds. Choose a physical quantity for y data. Paste graph below and list the values of fitting parameters, along with their uncertainties. Watch significant figures and don’t forget the units for each parameter. X Y 1 1.82 2 2.36...
The second weekly assignment for the course is an open forum. In this assignment you task...
The second weekly assignment for the course is an open forum. In this assignment you task is to find an economic news topic and summarize the article in your post. The purpose of this assignment is to give you a free hand in the subject you wish to discover. The news article can come from any widely known news site such as BBC, Bloomberg, CNBC, Fox Business, MarketWatch, Wall Street Journal, etc. If this does not offer you enough options,...
You want to open Louie’s place, a restaurant in Quebec City. You plan to run the...
You want to open Louie’s place, a restaurant in Quebec City. You plan to run the restaurant for two years and then retire. Start-up costs (kitchen equipment and supplies, renovations, furniture, fixtures, and the point-of-sales system), to be incurred immediately, are $500,000. Assume that all of the assets are in Class 8 and depreciated at 20%. The assets can be sold for $360,000 after two years. The restaurant will be open for 300 nights per year and you expect 100...
You want to open Louie’s place, a restaurant in Quebec City.   You plan to run the...
You want to open Louie’s place, a restaurant in Quebec City.   You plan to run the restaurant for two years and then retire. Start-up costs (kitchen equipment and supplies, renovations, furniture, fixtures, and the point-of-sales system), to be incurred immediately, are $500,000. Assume that all of the assets are in Class 8 and depreciated at 20%. The assets can be sold for $360,000 after two years. The restaurant will be open for 300 nights per year and you expect 100...
1. You are trying to make decisions on which mutual fund you should invest in based...
1. You are trying to make decisions on which mutual fund you should invest in based on the past performance of two fund managers. Manger A averaged a 17% return with a portfolio beta of 1.5, and manager B averaged a 15% return with a portfolio beta of 1.2. If the T-bill rate was 5% and the market return during the period was 13%, which fund manager was the better stock picker? A.         Advisor A was better because he generated a...
As a business investment, you are planning to open several donut shops throughout the city of...
As a business investment, you are planning to open several donut shops throughout the city of Riyadh, with potential futu.re expansion plans in other city areas in Saudi Arabia including Jeddah, Dammam, Khobar and Al Hofuf. Your initial plan will offer a wide variety of donuts and assorted beverages (coffee, tea, juices, etc.) Currently, the only competitors you will face in the above mentioned locations are two global organizations, with no local competitors in the market for those locations. Realizing...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT