Advertising Costs Revenues

March $$2,400$ $$60,000$

April $3,60084,000$

May $1,80066,000$

June $4,30078,000$

July $1,30059,000$

August $2,40075,000$

September $1,90054,000$

October $4,80095,000$

November $3,10068,000$

December $3,20072,000$

$*$ Create an X$-$Y scatter plot.

$*$ How much of the variability in revenues is driven by advertising expense? The R$-$squared.

$*$ You can type it as a decimal or percentage.

$*$ Scatter plot done in excel

$*$ Use the Hi$-$Lo method to calculate slope and the intercept; ie$.$ the equation