I really need help with the regression analysis part in question 1. If you can, could you help me with a step by step instruction on how to get to the appropriate regression analysis please.

COST STRCTURE and PRICING: Sting Ray PoolVac, Inc. manufactures

and sells a single product called the "Sting Ray," which is a

patent-protected automatic cleaning device for swimming pools. PoolVac's Sting

Ray faces its closest competitor, Howard Industries, also selling a competing

pool cleaner. Using the last 30 quarters of production and cost data, PoolVac

wishes to estimate its average variable costs using the following quadratic

specification:

AVC = a + bQ + cQ^2 .

The quarterly data on average variable cost (AVC), and the

quantity of Sting Rays produced and sold each quarter (Q) are presented in the

data file. PoolVac also wishes to use its sales data for the last 30 quarters

to estimate demand for its Sting Ray. Demand for Sting Rays is specified to be

a linear function as the following:

Qd= d + eP + fM +gPh,

in which its price (P), average income for households in

the U.S. that have swimming pools (M), and the price of the competing pool

cleaner sold by Howard Industries (PH ).

QUESTIONS:

1. Run the appropriate regression to estimate the average

variable cost function (AVC) for Sting Rays. Evaluate the statistical

significance of the three estimated parameters using a significance level of 5

percent. Be sure to comment on the algebraic signs of the three parameter

estimates. (30%)

2. Given your answer in 1, show the estimated total variable

cost, average variable cost, and marginal cost functions (TVC, AVC, and MC) for

PoolVac. (15%)

\f