Develop a trend equation for the net sales ($ million) for Home Depot. Consider both a linear trend and a nonlinear trend. Which one would you select and why? Given the trend equation you selected, forecast the net sales for 2019 and 2020.

Transcribed Image Text:

Associates Net Sales Mean Amount Year ($ million) Time (000) per Transaction CPI 1993 50.6 9,239 39.13 144.500 1994 67.3 12,477 41.29 148.200 1995 3 80.8 15,470 41.78 152.400 1996 4 98.1 19,535 42.09 156.900 1997 124.4 24,156 43.63 160.500 1998 156.7 30,219 45.05 163.000 1999 7 201.4 38,454 47.87 166.000 2000 8 227.3 45,738 48.65 172.200 2001 9 256.3 53,553 48.64 177.100 2002 10 280.9 58,247 49.43 179.900 2003 11 298.8 64,816 51.15 184.000 2004 12 323.1 73,094 54.89 188.900 2005 13 344.8 81,511 57.98 195.300 2006 14 364.4 79,022 58.90 201.600 2007 15 331.0 77,349 57.48 207.342 2008 16 322.0 71,288 55.61 215.303 2009 17 317.0 66,176 51.76 214.537 2010 18 321.0 67,997 51.93 218.056 2011 19 331.0 70,395 53.28 224.939 2012 20 340.0 74,754 54.89 229.594 2013 21 365.0 78,812 56.76 232.957 2014 22 371.0 83,176 57.87 236.736 2015 23 385.0 88,519 58.77 237.017 2016 24 406 94,595 60.35 240.007 2017 25 413 100,904 63.06 245.12 2018 26 413 108,203 65.74 251.107