Math

ProbabilityQ&A LibraryI have collected real data on the sale of a microwavable cup of soup across 20 different cities for the same time period (a month). The variables in the dataset are: Quantity sold in the city for that month: Measured in thousands of units Price: measured in dollars Average Income in the city: Measured in thousands of dollars Ads: Average number of ads run in stores for that city during that month. Price of a substitute product: measured in dollars Population of the city: measured in thousands of people The dataset is on Canvas and, using Excel or any other statistical software, please answer the following questions: 1. Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well. 2. Take the logs of the variables, and estimate the demand function. a. Interpret the R-square. b. Interpret the coefficients for logP and logPsub c. Interpret the p-values associated with each independent variable 3. Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining? 4. How sensitive are our consumers to changes in the rival good’s price? Explain in detail. 5. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Explain. 6. Suppose we are charging a price of $2 and our currentmarginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?Start your trial now! First week only $4.99!*arrow_forward*

Question

I have collected real data on the sale of a microwavable cup of soup across 20 different cities for the same time period (a month). The variables in the dataset are:

Quantity sold in the city for that month: Measured in thousands of units

Price: measured in dollars

Average Income in the city: Measured in thousands of dollars

Ads: Average number of ads run in stores for that city during that month.

Price of a substitute product: measured in dollars

Population of the city: measured in thousands of people

The dataset is on Canvas and, using Excel or any other statistical software, please answer the following questions:

1. Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well.

2. Take the logs of the variables, and estimate the demand function.

a. Interpret the R-square.

b. Interpret the coefficients for logP and logPsub

c. Interpret the p-values associated with each independent variable

3. Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining?

4. How sensitive are our consumers to changes in the rival good’s price? Explain in detail.

5. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Explain.

6. Suppose we are charging a price of $2 and our currentmarginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?

2 Ratings

Tagged in

Math

Probability

Find answers to questions asked by students like you.

Q: In a study of work patterns in one population, the mean weekly family time devoted to child care is ...

A: Click to see the answer

Q: Question 1. The apparatuses of a “6-component system” are to be randomly chosen from a box of 20 u...

A: We have given, The apparatuses of a “6-component system” are to be randomly chosen from a box of 20 ...

Q: screen shot

A: Given data, 2,25,30,45,50,56,62,75,83,90,92 Sample mean=?

Q: Probability Distribution Function of X discrete random variable is given below FX(x)={ 0 x<0...

A: Click to see the answer

Q: hi

A: (a) The semesters average GPA is

Q: Two dice are tossed. Find the probability and the odds that the sum is as specified.(a) 11 (b) 8 (c)...

A: Click to see the answer

Q: True or False. Write True of the statement is correct and False if it is not. 1. Hypothesis testing ...

A: 1) True In hypothesis testing, we use the sample data to verify the claims about population paramete...

Q: (5.00 PUINS) 2-A machine produces a 1.3 cm battery. A sample of 5 batteries was chosen to determine ...

A: We have given that Sample size n =5 , sample mean xbar=1.32 ,mu=1.3 And standard deviation (s)=0.01

Q: q19

A: We have to find value of k.