A company reckons that sales are exponentially related to advertising expenditure.

Use the data advertex and sales to test this hypothesis by fitting the model:

sales =

Note that in Excel the exponential function is written as = exp(cell ref)

This can be re-expressed as ln(sales) = β0 + β1 advertex R2 =

Model =

Standard errors of coefficients =