Demand Estimation for the Urgent Healthcare Clinic

Consider the hypothetical example of the Urgent Healthcare Clinic (UHC), a chain of urgent care facilities in 35 regional areas across the U.S.Management of the Urgent Healthcare Clinics has initiated an empirical estimation of customer traffic at their 35 regional locations to help the clinics formulate updates to patient pricing and possible expansion plans for the coming year.Annual operating data for 35 regions appear in the attached spreadsheet (Table 1).Regression results also in the spreadsheet (Results/Table 2).

The following regression equation was fit to these data:

Q_i = b₀ + b₁P_i + b₂P_xi + b₃Ad_i + b₄I_i + u_it.

Where: Q is the number of annual patients serviced,

P is the average price charged per patient visit (patient amount, in dollars),

P_x is the average price per patient charged by competing facilities (in $)

Ad is the local advertising budget for facilities in each region (in $),

I is the average income per household in each region's service area,

u_i is a residual (or disturbance) term.

The subscript indicates each of the 35 regional markets (i = 1,..., 35) from which the observation was taken.Least squares estimation of the regression equation on the basis of the 35 data cross-sectional observations resulted in the estimated regression coefficients and other statistics as shown in the results and in Table 2.

A.Describe the economic meaning for the individual independent variables included in the Urgent Healthcare Clinic demand equation.Interpret each estimated coefficient and its impact on the dependent variable (number of patients serviced)?

B.Using the estimates from the regression analysis, compute the expected (average) unit sales and average sales revenue for a typical region? (Assume that all independent variables are statistically significant in your computations).

C.From the regression estimates develop a demand equation for Urgent Healthcare Clinic.Use each coefficient average (at the bottom on Table 1) for the non-price variables to develop the demand equation. (Again, assume that all independent variables are statistically significant in your demand equation computation and the variables P_x, Ad and I are held constant in the development of the demand curve). Q = f(P | P_x, Ad, I)

D.Develop the null and alternative hypothesis for the b₁ coefficient (average price per patient - one-tail test), the b₂ coefficient (average price charged by competition - one tail test) and the b₃ coefficient (advertising variable - two tail test). Briefly describe when it is appropriate to use a one-tail test relative compared to a two-tailed t-test?Use a t-test to determine the level statistical significance for each individual independent variables at the 95 and 99 percent confidence levels.

E.Briefly explain the terminology of the coefficient of determination (R²).If one of the independent variables was found to not be statistically significant, what changes might you perform to the original regression equation?

F.Develop the null and alternative hypothesis and conduct an F-test for the complete set of coefficients in the equation to determine the significance at the 95 and 99 percent levels.

l'w'll-lCSULWeek 05_Urgent Healtl'icare Clinic Results Fall 201:3 [II-:r'npatilailit - '-: Arninata Sew E Insert Page Lay-nut Formulas ' ' ' View Help F :it F'DF _..':' Tell rnewl1at y'c-u want t:- d:- . ( , ED 38C\" Anal E E E It)\" 2'! WrapTatt General . 1 } ('LU \"K :H EMMW ' '9? p elecapy . __ ' nr .Fillv _ eeee We 3 e 2e 2 : : \"me We ens es :geggggeieegreeeeg: We Deiee W we. eggs: Clipboard '1 Font '1 Alignment F: Number E Styles Cells Editing A (:35 - E fx v AAiBlCID E F G|Hi IJIKILerNIOIPIQIr; LSUMMARYOUTPUT 2 3 Regression Statistics 4_Mu|tipleR 0948226547 5_RSquare 0899133584 iAdjustedRSqu: 0885684728 L Standard Error 839.1882756 8 Observations 35 9 1? ANOVA 11 d7 SS MS F Signicance F gRegression 4 1883292157 470823039 668557694 1.64884E14 QResidual 30 2112710885 704236.962 14 Total 34 2094563246 15 16 Coefcients Standard Error tStat P-vaiue LowerQ'B Upper95'36 Lower95.0% Upper95.0% ilntercept 1118881987 3812381291 293486381 000634506 3402.8985681897474118 3402.89861897474118 EXVariahle 41113833013 108664516 -3,96986355 000041479 6533058494 -209460753 -65,330585 -209460753 EXVariahle2 6851398997 849494-4815 08065266 042628708 71049759282 2420039081 710497593 2420039081 ZiXVariahle3 0022803572 0006907087 330147451 000248972 0008697418 0036909726 00086974 0036909726 21 XVarIahle4 0106554043 0051012565 208878036 00453132 0002372487 0210735599 00023725 0210735599 22 2; 24 21 26 f v 03 :13 Conditional Formatas Cell Insert Delete Format '0 ' Sorte FIndSL - "at BMW Formathng' Table' Styl' - - - ~ 63' Fllter' Seled' Clipboard Vi Font Vi Alignment F11 Number F11 Styles Cells Ed1ting A 137 - E fx v .5151010151r15111111.1|1