The spreadsheet below contains the direct marketing firms data for the number of pieces of mail sent (both current and lagged) and the number of credit card applications received. Perform a regression analysis to analyze the impact of the number of pieces of mail sent in the current and preceding weeks on the number of applications received. Be sure to include labels, residuals, and residual plots in your analysis.

1 Week ending Applications Received during Specified Week Pieces of Mail Sent during Specified Week Pieces of Mail Sent the Preceding Week 2 12/11/15 2,139 85,220 93,460 3 12/18/15 1,829 99,860 85,220 4 12/25/15 1,432 59,720 99,860 5 1/1/16 1,615 73,220 59,720 6 1/8/16 2,343 85,240 73,220 7 1/15/16 1,336 49,100 85,240 8 1/22/16 1,855 63,280 49,100 9 1/29/16 2,359 119,920 63,280 10 2/5/16 2,856 111,080 119,920 11 2/12/16 2,108 109,880 111,080 12 2/19/16 2,076 86,520 109,880 13 2/26/16 1,506 58,620 86,520 14 3/4/16 2,343 107,020 58,620 15 3/11/16 1,757 72,500 107,020 16 3/19/16 1,808 70,560 72,500 17 3/26/16 1,714 81,480 70,560 18 4/2/16 1,715 64,120 81,480 19 4/9/16 2,113 108,720 64,120 20 4/16/16 1,768 84,980 108,720 21 4/23/16 2,243 97,420 84,980 22 4/30/16 2,580 136,820 97,420 23 5/7/16 2,157 140,060 136,820 24 5/14/16 2,050 20,980 140,060 25 5/21/16 1,956 95,820 20,980 26 5/28/16 2,302 118,620 95,820 27 6/4/16 1,646 63,760 118,620 28 6/11/16 2,250 85,800 63,760 29 6/18/16 2,982 144,100 85,800 30 6/25/16 2,355 115,920 144,100 31 7/2/16 1,309 43500 115920 32 33 34 35 26 1