Analyze the following Dataset and find: scatterplot with r², r, slope, intercept interpreted, Ho and Ha, and make a prediction for the sales in 2014 (EXCEL PLEASE)

A w N 5 6 * ***** A B C D E F G H 1 Time Month Month Num Year NumBDay AvsalesPD Total.Sales Total.Fastner Total.Nonfastner 2 85 January 1 2011 21 8712530.2 182963134.8 82962643.52 100000491.3 3 86 February 2 2011 20 8827946.2 176558924.1 80281314.9 96277609.15 4 87 March 3 2011 23 9453848 217438503.3 97954498.77 119484004.5 5 88 April 4 2011 21 9521306.6 199947437.9 92411582.23 107535855.6 6 89 May 5 2011 21 9924828.4 208421397.4 95327635.82 113093761.5 7 90 June 6 2011 22 10067031 221474687.1 99890077.88 121584609.2 8 91 July 7 2011 20 9944623.8 198892475.7 89323141.27 109569334.4 9 92 August 8 2011 23 10168681 233879669.9 102539456.4 131340213.5 10 93 Septembe 9 2011 21 10493136 220355850 96598120.3 123757729.7 11 94 October 10 2011 21 10589095 222370996.9 96448576.81 125922420.1 12 95 Novembe 11 2011 21 9932563.1 208583825.8 91804774.84 116779051 13 96 December 12 2011 21 9353312.2 196419555.2 84208415.87 112211139.3 14 97 January 1 2012 21 10550169 221553547.6 96370711.29 125182836.3 15 98 February 2 2012 21 10569029 221949613.1 96850324.92 125099288.2 16 99 March 3 2012 22 11205743 246526337 105592564.2 140933772.8 17 100 April 4 2012 21 11182098 234824049.7 101439732.8 133384316.9 18 101 May 5 2012 22 11215198 246734359.2 105521984.2 141212375 19 102 June 6 2012 21 11529042 242109876.1 102699572 139410304 20 103 July 7 2012 21 11224377 235711910.2 99203972.54 136507937.6 21 104 August 2012 23 11439918 263118104.8 108948794.6 154169310.2 22 105 Septembe 2012 19 11772554 223678521.5 92927765.53 130750755.9 23 106 October 10 2012 23 11293523 259751031.2 107140859.6 152610171.6 24 107 Novembe 11 2012 21 10706447 224835379.9 92371891.61 132463488.3 25 108 December 12 2012 19 10275178 195228373.9 80046088.49 115182285.4 26 109 January 1 2013 22 11182299 246010575.5 102417297.2 143593278.2 27 110 February 2 2013 20 11432735 228654700.1 93869485.97 134785214.1 28 111 March 3 2013 21 11838292 248604129.7 100840020.2 147764109.6 29 112 April 4 2013 22 11623365 255714040.1 106147631.1 149566409 30 113 May 5 2013 22 11745805 258407711.6 106623641 151784070.6 31 114 June 6 2013 20 12148877 242977536.5 98248923.81 144728612.6 32 115 July 7 2013 22 11445549 251802073.9 101752573.5 150049500.3 33 116 August 8 2013 22 12200638 268414035.4 106473768 161940267.4 34 117 Septembe 9 2013 20 12400430 248008598.8 97489722.94 150518875.9 35 118 October 10 2013 23 12112485 278587164.1 109679692.7 168907471.5 36 119 Novembe 11 2013 20 11538835 230776707.1 89462451.39 141314255.7 37 120 December 12 2013 20 10827375 216547505.2 82200164.47 134347340.8 009 *** 00 A w N 5 6 * ***** A B C D E F G H 1 Time Month Month Num Year NumBDay AvsalesPD Total.Sales Total.Fastner Total.Nonfastner 2 85 January 1 2011 21 8712530.2 182963134.8 82962643.52 100000491.3 3 86 February 2 2011 20 8827946.2 176558924.1 80281314.9 96277609.15 4 87 March 3 2011 23 9453848 217438503.3 97954498.77 119484004.5 5 88 April 4 2011 21 9521306.6 199947437.9 92411582.23 107535855.6 6 89 May 5 2011 21 9924828.4 208421397.4 95327635.82 113093761.5 7 90 June 6 2011 22 10067031 221474687.1 99890077.88 121584609.2 8 91 July 7 2011 20 9944623.8 198892475.7 89323141.27 109569334.4 9 92 August 8 2011 23 10168681 233879669.9 102539456.4 131340213.5 10 93 Septembe 9 2011 21 10493136 220355850 96598120.3 123757729.7 11 94 October 10 2011 21 10589095 222370996.9 96448576.81 125922420.1 12 95 Novembe 11 2011 21 9932563.1 208583825.8 91804774.84 116779051 13 96 December 12 2011 21 9353312.2 196419555.2 84208415.87 112211139.3 14 97 January 1 2012 21 10550169 221553547.6 96370711.29 125182836.3 15 98 February 2 2012 21 10569029 221949613.1 96850324.92 125099288.2 16 99 March 3 2012 22 11205743 246526337 105592564.2 140933772.8 17 100 April 4 2012 21 11182098 234824049.7 101439732.8 133384316.9 18 101 May 5 2012 22 11215198 246734359.2 105521984.2 141212375 19 102 June 6 2012 21 11529042 242109876.1 102699572 139410304 20 103 July 7 2012 21 11224377 235711910.2 99203972.54 136507937.6 21 104 August 2012 23 11439918 263118104.8 108948794.6 154169310.2 22 105 Septembe 2012 19 11772554 223678521.5 92927765.53 130750755.9 23 106 October 10 2012 23 11293523 259751031.2 107140859.6 152610171.6 24 107 Novembe 11 2012 21 10706447 224835379.9 92371891.61 132463488.3 25 108 December 12 2012 19 10275178 195228373.9 80046088.49 115182285.4 26 109 January 1 2013 22 11182299 246010575.5 102417297.2 143593278.2 27 110 February 2 2013 20 11432735 228654700.1 93869485.97 134785214.1 28 111 March 3 2013 21 11838292 248604129.7 100840020.2 147764109.6 29 112 April 4 2013 22 11623365 255714040.1 106147631.1 149566409 30 113 May 5 2013 22 11745805 258407711.6 106623641 151784070.6 31 114 June 6 2013 20 12148877 242977536.5 98248923.81 144728612.6 32 115 July 7 2013 22 11445549 251802073.9 101752573.5 150049500.3 33 116 August 8 2013 22 12200638 268414035.4 106473768 161940267.4 34 117 Septembe 9 2013 20 12400430 248008598.8 97489722.94 150518875.9 35 118 October 10 2013 23 12112485 278587164.1 109679692.7 168907471.5 36 119 Novembe 11 2013 20 11538835 230776707.1 89462451.39 141314255.7 37 120 December 12 2013 20 10827375 216547505.2 82200164.47 134347340.8 009 *** 00