Gasoline Prices - Average U.S. Prices for Regular Gasoline \begin{tabular}{|c|c|} \hline Date & Price \\ \cline { 1 - 2 } Jan 03, 2000 & $1.26 \\ Jan 10, 2000 & $1.25 \\ Jan 17, 2000 & $1.27 \\ Jan 24, 2000 & $1.31 \\ Jan 31, 2000 & $1.31 \\ Feb 07, 2000 & $1.32 \\ Feb 14, 2000 & $1.35 \\ Feb 21, 2000 & $1.40 \\ Feb 28, 2000 & $1.41 \\ Mar 06, 2000 & $1.49 \\ Mar 13, 2000 & $1.51 \\ Mar 20,2000 & $1.51 \\ Mar 27, 2000 & $1.48 \\ Apr 03,2000 & $1.48 \\ Apr 10, 2000 & $1.45 \\ Apr 17, 2000 & $1.42 \\ Apr 24, 2000 & $1.41 \\ May 01,2000 & $1.39 \\ May 08, 2000 & $1.43 \\ May 15, 2000 & $1.47 \\ May 22, 2000 & $1.49 \\ May 29, 2000 & $1.51 \\ Jun 05, 2000 & $1.54 \\ Jun 12, 2000 & $1.61 \\ Jun 19, 2000 & $1.66 \\ Jun 26, 2000 & $1.64 \\ Jul 03, 2000 & $1.61 \\ Jul 10, 2000 & $1.57 \\ Jul 17, 2000 & $1.52 \\ Jul 24, 2000 & $1.50 \\ Jul 31, 2000 & $1.45 \\ Aug 07, 2000 & $1.44 \\ Aug 14, 2000 & $1.42 \\ Aug 21, 2000 & $1.44 \\ \hline \end{tabular} Gasoline Prices - Average U.S. Prices for Regular Gasoline \begin{tabular}{|c|c|} \hline Date & Price \\ \cline { 1 - 2 } Jan 03, 2000 & $1.26 \\ Jan 10, 2000 & $1.25 \\ Jan 17, 2000 & $1.27 \\ Jan 24, 2000 & $1.31 \\ Jan 31, 2000 & $1.31 \\ Feb 07, 2000 & $1.32 \\ Feb 14, 2000 & $1.35 \\ Feb 21, 2000 & $1.40 \\ Feb 28, 2000 & $1.41 \\ Mar 06, 2000 & $1.49 \\ Mar 13, 2000 & $1.51 \\ Mar 20,2000 & $1.51 \\ Mar 27, 2000 & $1.48 \\ Apr 03,2000 & $1.48 \\ Apr 10, 2000 & $1.45 \\ Apr 17, 2000 & $1.42 \\ Apr 24, 2000 & $1.41 \\ May 01,2000 & $1.39 \\ May 08, 2000 & $1.43 \\ May 15, 2000 & $1.47 \\ May 22, 2000 & $1.49 \\ May 29, 2000 & $1.51 \\ Jun 05, 2000 & $1.54 \\ Jun 12, 2000 & $1.61 \\ Jun 19, 2000 & $1.66 \\ Jun 26, 2000 & $1.64 \\ Jul 03, 2000 & $1.61 \\ Jul 10, 2000 & $1.57 \\ Jul 17, 2000 & $1.52 \\ Jul 24, 2000 & $1.50 \\ Jul 31, 2000 & $1.45 \\ Aug 07, 2000 & $1.44 \\ Aug 14, 2000 & $1.42 \\ Aug 21, 2000 & $1.44 \\ \hline \end{tabular} Aug 21, 2000$1.44 Aug 28, 2000$1.46 Sep 04, 2000$1.50 Sep 11, 2000$1.54 Sep 18, 2000$1.54 Sep 25, 2000$1.53 Oct 02,2000$1.50 Oct 09,2000$1.47 Oct 16,2000$1.52 Oct 23,2000$1.53 Oct 30,2000$1.52 Nov 06, 2000$1.50 Nov 13, 2000$1.50 Nov 20,2000$1.49 Nov 27,2000$1.49 Dec 04, 2000$1.46 Dec 11,2000$1.43 Dec 18,2000$1.40 Dec 25,2000$1.39 Jan 01,2001$1.38 Jan 08,2001$1.40 Jan 15,2001$1.46 Jan 22,2001$1.46 Jan 29,2001$1.45 Feb 05, 2001$1.43 Feb 12, 2001$1.46 Feb 19,2001 $1.43 Feb 26, 2001$1.41 Mar 05,2001 $1.39 Mar 12, 2001$1.39 Mar 19,2001 $1.38 Mar 26, 2001$1.38 Apr 02, 2001$1.41 Apr 09, 2001$1.47 Apr 16,2001 \$1.54 Apr 23, 2001$1.59 Apr 30,2001$1.59 45 Sep 16,2002 $1.37 46 Sep 23, 2002$1.36 47 Sep 30,2002 \$1.39 48 Oct 07,2002 $1.42 49 Oct 14,2002$1.42 50 Oct 21,2002$1.44 51 Oct 28,2002 $1.43 52 Nov 04, 2002$1.43 63 Nov 11, 2002$1.41 54 Nov 18,2002 $1.37 55 Nov 25, 2002$1.34 56 Dec 02,2002$1.32 57 Dec 09,2002 \$1.32 58 Dec 16,2002$1.32 59 Dec 23,2002$1.37 60 Dec 30,2002$1.42 Jan 06,2003$1.41 Jan 13,2003$1.42 Jan 20,2003$1.42 Jan 27,2003$1.44 Feb 03,2003 \$1.50 Feb 10, 2003$1.58 Feb 17,2003 $1.63 Feb 24, 2003$1.62 69 Mar 03,2003 \$1.64 70 Mar 10,2003 \$1.66 71 Mar 17,2003 \$1.67 72 Mar 24,2003 $1.63 73 Mar 31, 2003$1.58 74 Apr 07, 2003$1.56 75 Apr 14, 2003$1.52 76 Apr 21, 2003$1.50 77 Apr 28,2003 \$1.49 78 May 05, 2003$1.44 79 May 12, 2003$1.43 80 May 19, 2003$1.44 81 May 26, 2003$1.44 May 26, 2003$1.44 Jun 02,2003$1.43 Jun 09,2003$1.46 Jun 16,2003$1.48 Jun 23, 2003$1.45 Jun 30,2003$1.44 Jul 07, 2003$1.45 Jul 14, 2003$1.49 Jul 21,2003$1.50 Jul 28,2003$1.49 Aug 04, 2003$1.52 Aug 11, 2003$1.55 Aug 18, 2003$1.59 Aug 25,2003$1.69 35 Sep 01,2003 \$1.69 36 Sep 08,2003 \$1.65 97 Sep 15,2003 \$1.64 38 Sep 22, 2003$1.58 99 Sep 29,2003 \$1.52 00 Oct 06, 2003$1.51 11 Oct 13, 2003$1.52 02 Oct 20,2003 $1.53 03 Oct 27,2003$1.50 94 Nov 03, 2003$1.49 55 Nov 10,2003$1.46 36 Nov 17, 2003$1.46 7 Nov 24, 2003$1.48 Dec 01, 2003$1.45 Dec 08,2003 \$1.44 0 Dec 15, 2003$1.43 11 Dec 22, 2003$1.46 12 Dec 29,2003$1.45 13 Jan 05,2004 $1.49 4 Jan 12,2004$1.54 15 Jan 19,2004$1.58 16 Jan 26, 2004$1.60 17 Feb 02, 2004$1.59 or the data in the Excel file asoline Prices, do the following: a. Develop a spreadsheet for forecasting prices using simple exponential smoothing with smoothing constants from 0.1 to 0.9 in increments of 0.1. b. Using MAD, MSE, and MAPE as guidance, find the best smoothing constant. Gasoline Prices - Average U.S. Prices for Regular Gasoline \begin{tabular}{|c|c|} \hline Date & Price \\ \cline { 1 - 2 } Jan 03, 2000 & $1.26 \\ Jan 10, 2000 & $1.25 \\ Jan 17, 2000 & $1.27 \\ Jan 24, 2000 & $1.31 \\ Jan 31, 2000 & $1.31 \\ Feb 07, 2000 & $1.32 \\ Feb 14, 2000 & $1.35 \\ Feb 21, 2000 & $1.40 \\ Feb 28, 2000 & $1.41 \\ Mar 06, 2000 & $1.49 \\ Mar 13, 2000 & $1.51 \\ Mar 20,2000 & $1.51 \\ Mar 27, 2000 & $1.48 \\ Apr 03,2000 & $1.48 \\ Apr 10, 2000 & $1.45 \\ Apr 17, 2000 & $1.42 \\ Apr 24, 2000 & $1.41 \\ May 01,2000 & $1.39 \\ May 08, 2000 & $1.43 \\ May 15, 2000 & $1.47 \\ May 22, 2000 & $1.49 \\ May 29, 2000 & $1.51 \\ Jun 05, 2000 & $1.54 \\ Jun 12, 2000 & $1.61 \\ Jun 19, 2000 & $1.66 \\ Jun 26, 2000 & $1.64 \\ Jul 03, 2000 & $1.61 \\ Jul 10, 2000 & $1.57 \\ Jul 17, 2000 & $1.52 \\ Jul 24, 2000 & $1.50 \\ Jul 31, 2000 & $1.45 \\ Aug 07, 2000 & $1.44 \\ Aug 14, 2000 & $1.42 \\ Aug 21, 2000 & $1.44 \\ \hline \end{tabular} Gasoline Prices - Average U.S. Prices for Regular Gasoline \begin{tabular}{|c|c|} \hline Date & Price \\ \cline { 1 - 2 } Jan 03, 2000 & $1.26 \\ Jan 10, 2000 & $1.25 \\ Jan 17, 2000 & $1.27 \\ Jan 24, 2000 & $1.31 \\ Jan 31, 2000 & $1.31 \\ Feb 07, 2000 & $1.32 \\ Feb 14, 2000 & $1.35 \\ Feb 21, 2000 & $1.40 \\ Feb 28, 2000 & $1.41 \\ Mar 06, 2000 & $1.49 \\ Mar 13, 2000 & $1.51 \\ Mar 20,2000 & $1.51 \\ Mar 27, 2000 & $1.48 \\ Apr 03,2000 & $1.48 \\ Apr 10, 2000 & $1.45 \\ Apr 17, 2000 & $1.42 \\ Apr 24, 2000 & $1.41 \\ May 01,2000 & $1.39 \\ May 08, 2000 & $1.43 \\ May 15, 2000 & $1.47 \\ May 22, 2000 & $1.49 \\ May 29, 2000 & $1.51 \\ Jun 05, 2000 & $1.54 \\ Jun 12, 2000 & $1.61 \\ Jun 19, 2000 & $1.66 \\ Jun 26, 2000 & $1.64 \\ Jul 03, 2000 & $1.61 \\ Jul 10, 2000 & $1.57 \\ Jul 17, 2000 & $1.52 \\ Jul 24, 2000 & $1.50 \\ Jul 31, 2000 & $1.45 \\ Aug 07, 2000 & $1.44 \\ Aug 14, 2000 & $1.42 \\ Aug 21, 2000 & $1.44 \\ \hline \end{tabular} Aug 21, 2000$1.44 Aug 28, 2000$1.46 Sep 04, 2000$1.50 Sep 11, 2000$1.54 Sep 18, 2000$1.54 Sep 25, 2000$1.53 Oct 02,2000$1.50 Oct 09,2000$1.47 Oct 16,2000$1.52 Oct 23,2000$1.53 Oct 30,2000$1.52 Nov 06, 2000$1.50 Nov 13, 2000$1.50 Nov 20,2000$1.49 Nov 27,2000$1.49 Dec 04, 2000$1.46 Dec 11,2000$1.43 Dec 18,2000$1.40 Dec 25,2000$1.39 Jan 01,2001$1.38 Jan 08,2001$1.40 Jan 15,2001$1.46 Jan 22,2001$1.46 Jan 29,2001$1.45 Feb 05, 2001$1.43 Feb 12, 2001$1.46 Feb 19,2001 $1.43 Feb 26, 2001$1.41 Mar 05,2001 $1.39 Mar 12, 2001$1.39 Mar 19,2001 $1.38 Mar 26, 2001$1.38 Apr 02, 2001$1.41 Apr 09, 2001$1.47 Apr 16,2001 \$1.54 Apr 23, 2001$1.59 Apr 30,2001$1.59 45 Sep 16,2002 $1.37 46 Sep 23, 2002$1.36 47 Sep 30,2002 \$1.39 48 Oct 07,2002 $1.42 49 Oct 14,2002$1.42 50 Oct 21,2002$1.44 51 Oct 28,2002 $1.43 52 Nov 04, 2002$1.43 63 Nov 11, 2002$1.41 54 Nov 18,2002 $1.37 55 Nov 25, 2002$1.34 56 Dec 02,2002$1.32 57 Dec 09,2002 \$1.32 58 Dec 16,2002$1.32 59 Dec 23,2002$1.37 60 Dec 30,2002$1.42 Jan 06,2003$1.41 Jan 13,2003$1.42 Jan 20,2003$1.42 Jan 27,2003$1.44 Feb 03,2003 \$1.50 Feb 10, 2003$1.58 Feb 17,2003 $1.63 Feb 24, 2003$1.62 69 Mar 03,2003 \$1.64 70 Mar 10,2003 \$1.66 71 Mar 17,2003 \$1.67 72 Mar 24,2003 $1.63 73 Mar 31, 2003$1.58 74 Apr 07, 2003$1.56 75 Apr 14, 2003$1.52 76 Apr 21, 2003$1.50 77 Apr 28,2003 \$1.49 78 May 05, 2003$1.44 79 May 12, 2003$1.43 80 May 19, 2003$1.44 81 May 26, 2003$1.44 May 26, 2003$1.44 Jun 02,2003$1.43 Jun 09,2003$1.46 Jun 16,2003$1.48 Jun 23, 2003$1.45 Jun 30,2003$1.44 Jul 07, 2003$1.45 Jul 14, 2003$1.49 Jul 21,2003$1.50 Jul 28,2003$1.49 Aug 04, 2003$1.52 Aug 11, 2003$1.55 Aug 18, 2003$1.59 Aug 25,2003$1.69 35 Sep 01,2003 \$1.69 36 Sep 08,2003 \$1.65 97 Sep 15,2003 \$1.64 38 Sep 22, 2003$1.58 99 Sep 29,2003 \$1.52 00 Oct 06, 2003$1.51 11 Oct 13, 2003$1.52 02 Oct 20,2003 $1.53 03 Oct 27,2003$1.50 94 Nov 03, 2003$1.49 55 Nov 10,2003$1.46 36 Nov 17, 2003$1.46 7 Nov 24, 2003$1.48 Dec 01, 2003$1.45 Dec 08,2003 \$1.44 0 Dec 15, 2003$1.43 11 Dec 22, 2003$1.46 12 Dec 29,2003$1.45 13 Jan 05,2004 $1.49 4 Jan 12,2004$1.54 15 Jan 19,2004$1.58 16 Jan 26, 2004$1.60 17 Feb 02, 2004$1.59 or the data in the Excel file asoline Prices, do the following: a. Develop a spreadsheet for forecasting prices using simple exponential smoothing with smoothing constants from 0.1 to 0.9 in increments of 0.1. b. Using MAD, MSE, and MAPE as guidance, find the best smoothing constant