Mark Price, the newproductions manager for Speakers and Company, needs to find outwhich variable most affects the demand for their line of stereospeakers. He is uncertain whether the unit price of the product orthe effects of increased marketing are the main drivers in salesand wants to use regression analysis to figure out which factordrives more demand for its particular market. Pertinent informationwas collected by an extensive marketing project that lasted overthe past 12 years and was reduced to the data that follow:
YEARUNITSALES
(THOUSANDS)PRICE$/UNITADVERTISING
($000)1396280619269622382438962191,10941,3012161,40251,1382231,20761,1921971,301789622789581,1092061,1099971229697101,2322198951189523269712808251697
a.Perform a regression analysis based on these data using Excel.(Negative values should be indicated by
PayPal Gateway not configured
PayPal Gateway not configured