Year Average of Seasonally Adjusted Sales 1992 $150,781.17 a) Create a new column so that 1992 is year 1. Then create a scatterplot of the Total Adjusted Sales. Add 1993 $161,696.25 a title, axis labels, etc to create a readable scatterplot. Fit an exponential curve to the data. Display the 1994 $175,688.83 equation on the scatterplot. Make sure your scatterplot has an accurate title and the x,y axis are labelled. 1995 $185,437.25 b) Create a new column that shows the percent growth starting from 1993. As a reminder, percent 1996 $196,728.17 growth is determined by (new sales - prior sales)/ prior sales. Format your answer as a percentage with 1997 $206,334.08 one decimal. What is the average percent growth of the company since 1992? 1998 $215,657.67 1999 $233,872.00 c) Using your exponential model, predict Total Retail Sales revenue for 2025 and 2050. 2000 $248,748.25 d) Is the exponential model a good model for this data? Should it be used to model the growth of the 2001 $255,663.75 company in the long term? 4 2002 $261,272.42 5 2003 $272,232.50 19 67890222 2004 $288,987.50 2005 $307,826.08 18 2006 $323,823.08 2007 $334,008.00 2008 $328,780.33 21 2009 $303,288.92 2010 $323,964.17 23 2011 $349,7