Question

2. Exercise 4.2 Dismiss All Please Wait . . . Please Wait... The Pilot Pen Company...

2. Exercise 4.2

Dismiss All

Please Wait . . .

Please Wait...

The Pilot Pen Company has decided to use 15 test markets to examine the sensitivity of demand for its new product to various prices, as shown in the following table. Advertising effort was identical in each market. Each market had approximately the same level of business activity and population.

Complete the following worksheet and then estimate the demand function for Pilot's new pen using a linear regression model.

Test Market

Price Charged

Quantity Sold

(cents)

(Thousands of Pens)

ii xixi yiyi xixi yiyi xi2xi2 yi2yi2
1 50 20 1,000 2,500 400
2 50 21 1,050 2,500 441
3 55 19 1,045 3,025 361
4 55 19.5 1,072.5 3,025 380.25
5 60 20 1,200 3,600 400
6 60 19 1,140 3,600 361
7 65 16 1,040 4,225 256
8 65 15 975 4,225 225
9 70 14.5 1,015 4,900 210.25
10 70 15.5 1,085 4,900 240.25
11 80 13 1,040 6,400 169
12 80 14 1,120 6,400 196
13 90 11.5 1,035 8,100 132.25
14 90 11 990 8,100 121
15 40 17 680 1,600 289
Total 980 246 selector 1   
  • 15,487.5
  • 14,447.5
  • 14,472.5
67,100 selector 2   
  • 4,326
  • 4,515.75
  • 4,182

Points:

Regression Parameters

Estimations

Slope (ββ ) selector 1   
  • 0.418
  • 0.009
  • -0.190
Intercept (αα ) selector 2   
  • -10.909
  • 15.812
  • 28.825

Points:

Close Explanation

Explanation:

What is the standard error of the estimate (sese )?

105.103

1.407

1.674

Points:

Close Explanation

Explanation:

What is the estimate of the standard deviation of the estimated slope (sbsb )?

0.025

0.030

1.896

Points:

Close Explanation

Explanation:

Can you reject the hypothesis (at the 0.05 level of significance) that there is no relationship (i.e., β=0β=0 ) between the price and quantity variables? (Hint: t0.025,13=2.16t0.025,13=2.16 )

No

Yes

Points:

Close Explanation

Explanation:

Complete the following worksheet and then use it to calculate the coefficient of determination.

ii

xixi

yiyi

yˆy^

(yˆiy¯)2y^i−y¯2

(yiy¯)2yi−y¯2

1 50 20 19.325 8.556 12.960
2 50 21 19.325 8.556 21.160
3 55 19 18.375 3.901 6.760
4 55 19.5 18.375 3.901 9.610
5 60 20 17.425 1.051 12.960
6 60 19 17.425 1.051 6.760
7 65 16 16.475 0.006 0.160
8 65 15 16.475 0.006 1.960
9 70 14.5 15.525 0.766 3.610
10 70 15.5 15.525 0.766 0.810
11 80 13 13.625 7.701 11.560
12 80 14 13.625 7.701 5.760
13 90 11.5 11.725 21.856 24.010
14 90 11 11.725 21.856 29.160
15 40 17 21.225 23.281 0.360
Total selector 1   
  • 110.949
  • 111.721
  • 110.955
selector 2   
  • 168.760
  • 147.600
  • 126.440

Points:

The coefficient of determination (r2r2 ) is selector 1   
  • 0.657
  • 0.757
  • 0.752

Points:

Close Explanation

Explanation:

What is the price elasticity of demand at a price of 50 cents?

0.03

-0.02

-0.50

-0.46

Homework Answers

Answer #1

a. The regression model expresses the demand (quantity sold) for pens as a function of price:

Qi= [\alpha] + [\beta] P1+ [\varepsilon] i

We can estimate the model to get predictions: Q i = [\alpha] + [\beta] P i.

We get a = 28 . 915 and b =-0.191

Hence, we predict that a one-cent increase in the price of a pen will lead to a decrease in sales of 191 units, on average.

C, In the model the Price elasticity of demand is given by

ED= ( [\delta] QP) / ( [\delta] PQ) = [\beta] (P/Q)

Which can be estimated by ED= [\beta] (P/Q)

At P = 50 , Q = a + b (50) = 19 . 363 .

Thus we have ED= (-0.191) 50/ 19.363 [\approx] -0.493

Therefore, we predict that a 1% increase in price will lead to a 0.493% decrease in sales, on average, at an initial price of $ 0.50.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Approximate the mean for following frequency table. Data Frequency 60 - 64 13 65 - 69...
Approximate the mean for following frequency table. Data Frequency 60 - 64 13 65 - 69 22 70 - 74 13 75 - 79 7 80 - 84 5 85 - 89 4 90 - 94 2 95 - 99 1 100 - 104 1 mean = Report answer accurate to one decimal place. Approximate the mean for following GFDT. Data Frequency 50 - 54 1 55 - 59 4 60 - 64 5 65 - 69 14 70 -...
Compute each of the following probabilities. Label each problem clearly and show all your work. Use...
Compute each of the following probabilities. Label each problem clearly and show all your work. Use the numbers you computed in earlier parts of the project based on the class data set. Problem 1: Suppose all of the Skittles in the class data set are combined into one large bowl and you are going to randomly select one Skittle. (a) What is the probability that you select a green Skittle? (4 points) (b) What is the probability that you select...
USING C++ The purpose of this assignment is the use of 2-dimensional arrays, reading and writing...
USING C++ The purpose of this assignment is the use of 2-dimensional arrays, reading and writing text files, writing functions, and program planning and development. You will read a data file and store all of the input data in a two dimensional array. You will perform calculations on the data and store the results in the 2 dimensional array. You will sort the array and print the results in a report. Instructions You will read in the same input file...
The following data represents the exam scores of students in Econ 220 VV22, which is one...
The following data represents the exam scores of students in Econ 220 VV22, which is one of several sections of Econ 220 in a college. You can take this as a sample.                                                                 Student Score 1 82 2 70 3 50 4 60 5 75 6 65 7 55 8 80 9 85 10 90 11 95 12 94 13 35 14 40 15 65 16 95 17 91 18 55 19 65 20 76 21 86 22 96...
The data collection is conducted by randomly selecting 51 persons whose ages are between 25-30 and...
The data collection is conducted by randomly selecting 51 persons whose ages are between 25-30 and interviewing the average time they spend on Instagram in a day. What is the probability that people ages between 25-30 spend time using Instagram for more than one hour in a day? I need a PMF equation The collected data: Number of Person Time Number of Person Time Number of Person Time Number of Person Time 1 120 14 90 26 120 39 70...
This dataset contains consumer responses indicating the number of times they had to send their product...
This dataset contains consumer responses indicating the number of times they had to send their product for repair and their satisfaction with the repair process. Create a graph which can be used to visually demonstrate the relationship between the two columns of data. Ensure that the chart is professional with appropriate titles, axis labels, etc. Note any observations you see in your visualization (type these as sentences directly into an Excel cell(s)). Sample Satisfaction Rating Repair Requests 1 63% 13...
A survey was conducted to determine, on average, how long patients have to wait to see...
A survey was conducted to determine, on average, how long patients have to wait to see a doctor. The number of patients that ended up waiting up to 2 hours to see a doctor, recorded in 10-minutes intervals, is given in the table below. Calculate the standard deviation for this distribution. Explain what it means in the context of this problem. Waiting time(mins) 10 20 30 40 50 60 70 80 90 100 110 120 Frequency of Occ. 1 4...
1) Let's say that we use 16 mice in a study that seeks a relationship between...
1) Let's say that we use 16 mice in a study that seeks a relationship between the concentration (x) of a toxic substance and the mortality time of mice (y), and the findings given in the table below are obtained. Is there a relationship between concentration and death time? What is the direction and strength of the relationship? Find it with correlation analysis. Concentration (microgram) Death time (minutes) 20 20 25 18 30 18 35 16 40 17 45 16...
AM -vs- PM Test Scores: In my PM section of statistics there are 30 students. The...
AM -vs- PM Test Scores: In my PM section of statistics there are 30 students. The scores of Test 1 are given in the table below. The results are ordered lowest to highest to aid in answering the following questions. index 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 score 43 48 50 52 55 60 61 62 64 65 66 67 68 71 75 index 16 17 18 19 20 21 22...
Covert from a 15 minute UH to a 1hr UH Time (Minutes) Discharge (m3/s) 0 0...
Covert from a 15 minute UH to a 1hr UH Time (Minutes) Discharge (m3/s) 0 0 5 0.1611 10 0.525067 15 0.978533 20 1.11875 25 1.0024 30 0.76075 35 0.47435 40 0.31325 45 0.2148 50 0.1432 55 0.095467 60 0.06265 65 0.041767 70 0.02685 75 0.0179 80 0.011933 85 0.00895 90 0.005967 95 0.002983 100 0 Then construct Storm Hydro graph using the following rainfall excess Time (Hrs) Rainfall excess (mm) 1 0 2 0 3 0 4 0 5...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT