Question

A certain company is a nationwide chain of retail stores that sell a wide assortment of​ merchandise, including domestics merchandise and home​ furnishings, as well as​ food, giftware, and health and beauty care items. The number of stores open at the end of the fiscal year from 1997 to 2012 is listed in the accompanying data table. Assign the coded value 0 to the first​ year, the coded value 1 to the second​ year, and so on. Complete parts​ (a) through​ (f) below.

Year   Stores_Open
1997   105
1998   141
1999   184
2000   232
2001   329
2002   402
2003   505
2004   610
2005   712
2006   790
2007   871
2008   958
2009   1035
2010   1089
2011   1137
2012   1182

d.) Compute an exponential trend forecasting equation and plot the results. Note that Xi represents the ith coded year and Yi represents the ith predicted value of the number of stores open.

Yi = [ ] ([ ])^Xi

**When answering can you please tell me/show the steps needed in order to get the answer (I make use of Excel and StatCrunch)

Answer 1

y = 128.97e0.1608x

First bring data in to excel sheet.

2. select birth year and Stores_open data and go to insert tab --> choose scatter plot diagram and populate the chart on the sheet

3. Select any data point in the chart and right click --> add trendline --> go to format trendline in the right side --> choose exponential as a trend --> select display an equation on chart option.

ψ1X-/ Chart 1 Format TrendlineX Stores Open Trendline Options Trendline Options Exponential y = 128·97e0-16 Eolynomial Order Moving Penod Average Automatic Expun Per İDcis periods Set Intercept Display Equation on chart Display R-squared valur on chart