A large retailer has noted that its revenue from sales is correlated with its advertising expenditure. The data are
Revenue (in Millions) 46 18 20 22 27 34 14 37 30
Advertising expenditure (in Millions) 9 3 4 4 5 7 3 8 5
a) Use excel and obtain a regression equation for the revenue data (as a function of advertising expenditure). b) What's the estimated average revenue when advertising expenditure is 6 million?