Are these intervals more useful for planning your expansion

Assignment Help Basic Statistics
Reference no: EM13949392

You work for a company that has a number of take-out pizza stores located in Illinois. You want to produce a model that predicts sales at a location based on the total income of the surrounding neighborhood. This will be used for choosing new locations. The data set pizzasales.dta gives sales (in thousands of dollars) and local income (in millions of dollars) for 50 different stores. There is also a dummy variable equal to 1 if your main competitor chain also has a store in the neighborhood, and zero otherwise.

(a) Run a regression of sales against local income (only). Based on this regression, give an interval that you are 95% confident will contain your sales in a neighborhood with total income $200M. Do you think this regression is useful for planning your chain's expansion?

(b) Now use the data on your competitor's presence or absence to produce a better model. Your model should take into account the fact that what your competitor takes from you is market share. (i.e., the competitor doesn't just take away a fixed amount of business -- it competes with you for each additional dollar the neighborhood spends on pizza.) Based on your new regression, give intervals that you are 95% confident will contain your sales in a neighborhood with total income $200M, both with and without the presence of a competitor. Are these intervals more useful for planning your expansion?

(c) Suppose you are considering whether or not to start up a store in a particular neighborhood, where your competitor already has a store. The rental price for this location is quite high, so that the break-even figure for sales is $400,000. How high does local income have to be before you can expect to make a profit on average at this location? Use your model from part (b) to answer this question.

Income  Sales  Competitor
219.17653 708.97231 0
464.24351 1559.5697 0
285.72038 627.96458 1
361.87025 658.56853 1
338.86999 898.42678 1
199.51553 818.22042 0
426.34978 814.61226 1
227.75345 480.48037 1
421.56145 1575.6002 0
355.44418 621.0052 1
418.99875 977.30933 1
294.76422 1041.4825 0
147.13047 372.31767 1
209.49585 794.36815 0
301.38837 997.51438 0
472.72826 1642.8883 0
111.61568 241.0804 1
167.46639 438.00819 1
388.80013 1482.9168 0
134.73727 464.99457 1
495.1347 1072.2251 1
238.62761 467.07217 1
299.41772 952.33309 0
226.2798 679.95184 1
166.52278 560.42405 1
463.21752 1489.9119 0
135.13764 491.83926 0
270.46585 605.95229 1
412.19025 972.99139 1
129.77429 330.35447 1
305.34841 1147.9047 0
206.84525 688.86681 0
476.69868 1179.6488 1
419.81398 960.66892 1
281.17869 690.25882 1
401.31977 890.18406 1
302.55583 1155.52 0
117.35208 682.57403 0
367.71406 1308.5818 0
164.64894 437.73965 1
456.72928 1699.494 0
220.76865 700.17723 0
381.68252 1307.5377 0
117.0497 394.41721 1
231.37886 575.30526 1
294.51741 967.85099 0
122.10885 145.1625 1
336.38976 685.6216 1
306.30786 640.5577 1
398.17839 969.17607 1

Reference no: EM13949392

Questions Cloud

Annual interest rate r with continuous compounding : A City Tech student purchased a new 3D 4K HDTV on Cyber Monday that was selling for $3,500. He signed a financing deal to make a down-payment of $1,000 and then to make 24 monthly payments of $150, beginning one month from the time of purchase. Compu..
Example of trihybrid cross between two homizygous plants : Please give me an example of trihybrid cross between two homizygous plants
Exchange rate risk is an exposure that global company : Exchange Rate Risk is an exposure that global company management operating in a global economy has to manage and finds ways to reduce this risk. Discuss something the management can do to minimize this business risk.
Used as the annual sales figure when evaluating this project : Travel America Coaches currently sells 15,000 motor homes per year at $94,000 each, and 1,500 luxury motor coaches per year at $159,000 each. The company wants to introduce a low-range camper to fill out its product line; it hopes to sell 3,000 of th..
Are these intervals more useful for planning your expansion : Run a regression of sales against local income (only). Based on this regression, give an interval that you are 95% confident will contain your sales in a neighborhood with total income $200M. Do you think this regression is useful for planning you..
What is the amount of kristi realized gain : What is the amount of Kristi's realized gain and recognized gain and the basis in her new property?
What is the wacc it should use for the project : Lawler's is considering a new project. The company has a debt-equity ratio of 0.62. The company's cost of equity is 15.1 percent, and the aftertax cost of debt is 8.8 percent. The firm feels that the project is riskier than the company as a whole and..
Calculate the percentage error using the abc costs : Using the costs assigned in Requirement 1, calculate the percentage error using the ABC costs as a benchmark. Comment on the value and advantages of this ABC simplification.
How many pounds of plastic does aja need to purchase in 2016 : The Aja Co. expects to produce 2,000 baskets in 2016. Each basket requires 2 pounds of plastic. Aja has 225 pounds of plastic on hand at the end of 2015, and it wants to have 190 pounds on hand at the end of 2016. How many pounds of plastic does Aja ..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Confidence interval for automobiles traveling on interstate

From past information, it is known that the standard deviation of the population is 22 mph. The 96.6% confidence interval for m is?

  What is the incidence rate of waterborne diseases in africa

according to recent estimates only 45 of people in africa have access to safe drinking water this being the major

  Find how many big triple outcomes are possible

The Big Triple at the local racetrack consists of picking the correct order of finish of the first three horses in the ninth race. If there are 12 horses entered in today's ninth race, how many Big Triple outcomes are possible?

  We are aware that some states cities and counties have

examine the below topic and provide a hypothesis for which you would use the one-tailed and two-tailed t test to

  Find large-sampleconfidence interval for difference

Commercial A was selected by 45 out of 100 women and 80 out of 140 men. A large-sample 95% confidence interval for this difference is?

  Finite population correction factor

Using the finite population correction factor, compute the standard error for each of the three firms given a sample of size 50.

  Explain in detail expected monetary value decision rule

What is the probability of a bus picking up the passengers at a given bus stop in more than 15 minutes following their arrival at the bus stop

  The amount of gasoline sold daily at a service station is a

the amount of gasoline sold daily at a service station is a value of x of a random variable x that is approximately

  Probability for mutually exclusive-independent events

The probability of getting a big order currently under negotiation is 0.4. The probability of losing money this quarter is 0.5.

  Convert the following sat scores into a new distribution

convert the following sat scores into a new distribution with a mean of 50 and a standard deviation of 2.what new score

  During the global recession of 2008 and 2009 there were

ethical behavior of business students at rocky universityduring the global recession of 2008 and 2009 there were many

  Academic approach-statistics-probability

A City Survey states that 70 percent of all business owners favor increasing the parking fees. The city has commissioned a random sample of n = 100 business owners.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd