Reported below are the amounts spent on advertising ($ millions) by a large firm
ID: 2924877 • Letter: R
Question
Reported below are the amounts spent on advertising ($ millions) by a large firm from 2004 to 2014. Year Amount Year Amount 2004 88.9 2010 132.7 2005 94.6 2011 141.6 2006 102.2 2012 150.7 2007 109.6 2013 157.5 2008 118.4 2014 162.7 2009 125.6 a. Determine the logarithmic trend equation. (Round your answers to 4 decimal places.) Log Picture = + t b. Estimate the advertising expenses for 2015. (Round your answer to 2 decimal places.) The antilog of Picture (2015) = $ c. By what percent per year did advertising expense increase during the period? (Round your answer to 2 decimal places.) percent.
Explanation / Answer
(a) Plotting the given data points in excel in fitting a logarithmic trend between it gives the equation
where y = amounts spend on advertising ; x= year
(b) putting x = 2015 in the above equation gives us y = 174.35
(c) From 2004-2014, we will calcualte CAGR = {(162.7/88.9)^1/10}-1 = -0.82% (It decreased by 82%)
y=15422ln(x)-117162