Use the variables average ticket sale and number of associates to forecast net sales. Are these two independent variables reasonable predictors of net sales?

You will need the help of a software package such as Excel and perhaps a companion package such as MegaStat. For the years 1993 through 2020, the data include a coded time variable (1 through 26), the number of associates in thousands, net sales in millions of dollars, the average ticket sale, and the Consumer Price Index (CPI) for each year.

Transcribed Image Text:

Year 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Time 1235 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ZEHEEE8 22 23 24 25 26 27 28 Associates 50.6 67.3 80.8 98.1 124.4 156.7 201.4 227.3 256.3 280.9 298.8 323.1 344.8 364.4 331 322 317 321 331 340 365 371 385 406 413 413 415 504 Net Sales ($Millions) 9239 12477 15470 19535 24156 30219 38454 45738 53553 58247 64816 73094 81511 79022 77349 71288 66176 67997 70395 74754 78812 83176 88519 94595 100904 108203 110225 132110 Average Ticket Sale 39.13 41.29 41.78 42.09 43.63 45.05 47.87 48.65 48.64 49.43 51.15 54.89 57.98 58.9 57.48 55.61 51.76 51.93 53.28 54.89 56.76 57.87 58.77 60.35 63.06 65.74 67.30 74.32 CPI 144.5 148.2 152.4 156.9 160.5 163 166 172.2 177.1 179.9 184 188.9 195.3 201.6 207.342 215.303 214.537 218.056 224.939 229.594 232.957 236.736 237.017 240.007 245.12 251.107 255.657 258.811