Create predictions for each of the potential sites using your regression results and the attributes for each potential hotel site using the SUMPRODUCT formula You will need to decide whether to have an indoor pool or not and code that information as 1 or 0 based on your decision You can easily compare the predicted operating margin of each potential site with and without a pool by changing the values back and forth from 1 to 0 Rank the potential hotel sites from highest to lowest in terms of predicted operating margin Site Indoor pool Competitor rooms Distance to competitor Office space Median income Distance to downtown Estimated Margin 1 2802 1 476 51 8 8 2 3656 2 1 344 54 6 7 3 2875 0 1 392 61 5 13 6 4 2504 1 1 487 55 5 3 6 5 3152 2 4 508 57 8 1 Coefficients Standard Error t Stat P value Lower 95 Upper 95 Lower 95 0 Upper 95 0 Intercept 0 593008412 0 04087196 14 50893004 1 76492E 24 0 511715727 0 674301097 0 511715727 0 674301097 Competitor rooms 6 8411E 05 6 70675E 06 10 20032311 2 63203E 16 8 17504E 05 5 50715E 05 8 17504E 05 5 50715E 05 Distance to competitor 0 018781105 0 003639779 5 159956933 1 65639E 06 0 02602048 0 01154173 0 02602048 0 01154173 Office space 0 000185051 1 94716E 05 9 503594323 6 42312E 15 0 000146322 0 000223779 0 000146322 0 000223779 Median income 0 000175253 0 000444207 0 394529757 0 694201909 0 001058764 0 000708258 0 001058764 0 000708258 Distance to downtown 0 001886448 0 001006759 1 87378249 0 064479451 0 000115956 0 003888852 0 000115956 0 003888852 Indoor pool D 0 022840354 0 006788638 3 364497101 0 001162775 0 009338026 0 036342683 0 009338026 0 036342683

Question: Create predictions for each of the potential sites using your regression results and the attributes for each potential hotel site using the SUMPRODUCT formula.

 Create predictions for each of the potential sites using your regression results and the attributes for each potential hotel site using the SUMPRODUCT formula.
 You will need to decide whether to have an indoor pool or not and code that information as 1 or 0 based on your decision. You can easily compare the predicted operating margin of each potential site with and without a pool by changing the values back and forth from 1 to 0.
 Rank the potential hotel sites from highest to lowest in terms of predicted operating margin.

Site	Indoor pool	Competitor rooms	Distance to competitor	Office space	Median income	Distance to downtown	Estimated Margin
1		2802	1	476	51	8.8
2		3656	2.1	344	54	6.7
3		2875	0.1	392	61.5	13.6
4		2504	1.1	487	55.5	3.6
5		3152	2.4	508	57	8.1


	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	0.593008412	0.04087196	14.50893004	1.76492E-24	0.511715727	0.674301097	0.511715727	0.674301097
Competitor rooms	-6.8411E-05	6.70675E-06	-10.20032311	2.63203E-16	-8.17504E-05	-5.50715E-05	-8.17504E-05	-5.50715E-05
Distance to competitor	-0.018781105	0.003639779	-5.159956933	1.65639E-06	-0.02602048	-0.01154173	-0.02602048	-0.01154173
Office space	0.000185051	1.94716E-05	9.503594323	6.42312E-15	0.000146322	0.000223779	0.000146322	0.000223779
Median income	-0.000175253	0.000444207	-0.394529757	0.694201909	-0.001058764	0.000708258	-0.001058764	0.000708258
Distance to downtown	0.001886448	0.001006759	1.87378249	0.064479451	-0.000115956	0.003888852	-0.000115956	0.003888852
Indoor pool D	0.022840354	0.006788638	3.364497101	0.001162775	0.009338026	0.036342683	0.009338026	0.036342683

Step by Step Solution

★★★★★

3.54 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Predicting operating margin for each potential hotel site To predict the operating margin for each potential hotel site we can use the SUMPRODUCT form... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

You will need to understand solved problem S4 before answering this question. In an island population, the following data were obtained for the numbers of people with each of the four blood types:...

You will need to understand solved problem S4 before answering this question. A muscle - specific gene was cloned and then subjected to promoter bashin. As shown here, six regions, labeled A - F,...

You will need to understand solved problem S4 before answering this question .A gene that is normally expressed in pancreatic cell was cloned and then subjected to promoter bashing. As shown here,...

Twenty-four observations were used to estimate y = 0 + 1x + . A portion of the Excel results is as follows: a. What is the point estimate for 1? Interpret this value. b. What is the sample regression...

For each of the plane stress states listed below, draw a Mohrs circle diagram properly labeled, find the principal normal and shear stresses, and determine the angle from the x axis to 1. Draw stress...

An experiment is conducted to measure the electrical resistivity of Nichrome in the form of wires with different lengths and cross-sectional areas. For one set of measurements, a student uses...

A sample of two printed circuit boards is selected without replacement from a batch. Describe the (ordered) sample space for each of the following batches: (a) The batch contains 90 boards that are...

The accelerating seek described in Exercise 14.3 is typical of hard-disk drives. By contrast, floppy disks (and many hard disks manufactured before the mid-1980s) typically seek at a fixed rate....

Consider a heat engine and heat pump connected as shown in figure P.7.38. Assume TH1 = TH2 > Tamb and determine for each of the three cases if the setup satisfy the first law and/or violates the 2nd...

Write structural formulas for each of the following compounds: (a) Pyrogallol (1, 2, 3-benzenetriol) (c) 3-Nitro-1-naphthol (b) o-Benzylphenol (d) 4-Chlororesorcinol

A 1995 Pepsico promotion offered merchandise in exchange for points earned by buying Pepsi-Cola. The television ad showed a teenager modeling some of the available merchandise. A Pepsi T-shirt was...

A direct cost has been defined as 'a cost that that can be easily and economically identified with a particular department, section product or unit'. Critically examine this definition from a...

# 4 . Evaluate a x 2 - b x d x where a , b i n R # 5 . Given that the series n = 0 ( 2 n + 1 3 n - 1 5 n ) converges, find the sum.

Perform a quantitative elemental analysis of the XPS data below, and fill in the last column. Make sure that you use sensitivity factors properly. Peak areas refer to properly fitted peaks for the...

Using the data below and referring to your notes from our discussion in class and the handout "E. Data Interpretation XPS", perform a qualitative elemental analysis of the XPS data below, and fill in...

AL DELTA Investment company is operating business in a dynamic and competitive market of the Far East. To cope with the dynamic variables of the demand and supply markets, the management of the...

Answer the following questions. Please type using a word processing program and bring a printed copy to class. Write as much or as little as you feel necessary to answer each question to the best of...

the questions . Emmaus (Lk 24:13-35) . Jerusalem (Lk 24:36-43) . Sea of Tiberius (Jn 21:1-14) 1. What do the three stories have in common? 2. What are the differences among the stories? 3. How are...

Create Predictions for Potential Sites Create predictions for each of the potential sites using your regression results and the attributes for each potential hotel site using the SUMPRODUCT formula....

What attributes should the company focus on while designing the communication plan? For the exclusive use of J. Barry, 2020. A00183 March 31, 2014 Revised 18 June 2019 Cerenity Sanitiser: Marketing...

5-407-753 MARK JEFFERY Air France Internet Marketing: Optimizing Google, Yahoo!, MSN, and Kayak Sponsored Search Rob Griffin, senior vice president and U.S. director of search for Media Contacts, a...

I'm in desperate for help. It's due on next Tuesday midnight. Attached files contain all the requirements of this individual project. I also added some hint on word file and ppt file to mark the...

Can anyone help me with this or already have the solution this whole Finance Workbook for Madura Personal Finance, Third Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK INDEX Chapter...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...