Ask Statistics and Probability Expert

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

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M91620237
  • Price:- $15

Priced at Now at $15, Verified Solution

Have any Question?


Related Questions in Statistics and Probability

Introduction to epidemiology assignment -assignment should

Introduction to Epidemiology Assignment - Assignment should be typed, with adequate space left between questions. Read the following paper, and answer the questions below: Sundquist K., Qvist J. Johansson SE., Sundquist ...

Question 1 many high school students take the ap tests in

Question 1. Many high school students take the AP tests in different subject areas. In 2007, of the 144,796 students who took the biology exam 84,199 of them were female. In that same year,of the 211,693 students who too ...

Basic statisticsactivity 1define the following terms1

BASIC STATISTICS Activity 1 Define the following terms: 1. Statistics 2. Descriptive Statistics 3. Inferential Statistics 4. Population 5. Sample 6. Quantitative Data 7. Discrete Variable 8. Continuous Variable 9. Qualit ...

Question 1below you are given the examination scores of 20

Question 1 Below you are given the examination scores of 20 students (data set also provided in accompanying MS Excel file). 52 99 92 86 84 63 72 76 95 88 92 58 65 79 80 90 75 74 56 99 a. Construct a frequency distributi ...

Question 1 assume you have noted the following prices for

Question: 1. Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. i. Compute the coefficient of determination ...

Question 1 a sample of 81 account balances of a credit

Question 1: A sample of 81 account balances of a credit company showed an average balance of $1,200 with a standard deviation of $126. 1. Formulate the hypotheses that can be used to determine whether the mean of all acc ...

5 of females smoke cigarettes what is the probability that

5% of females smoke cigarettes. What is the probability that the proportion of smokers in a sample of 865 females would be greater than 3%

Armstrong faber produces a standard number-two pencil

Armstrong Faber produces a standard number-two pencil called Ultra-Lite. The demand for Ultra-Lite has been fairly stable over the past ten years. On average, Armstrong Faber has sold 457,000 pencils each year. Furthermo ...

Sppose a and b are collectively exhaustive in addition pa

Suppose A and B are collectively exhaustive. In addition, P(A) = 0.2 and P(B) = 0.8. Suppose C and D are both mutually exclusive and collectively exhaustive. Further, P(C|A) = 0.7 and P(D|B) = 0.5. What are P(C) and P(D) ...

The time to complete 1 construction project for company a

The time to complete 1 construction project for company A is exponentially distributed with a mean of 1 year. Therefore: (a) What is the probability that a project will be finished in one and half years? (b) What is the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As