question:

this is the data:

Create an Excel file containing the prices for Google stock for 07/01/2019 - 11/25/2019 (inclusively). Use Yahoo Finance or similar websites to obtain historical data. Ignore dividends. a) Assuming a linear relationship between the closing price and the business day (07/01/2019 - business day 1, 07/02/2019 - business day 2, etc), use the least-squares method to compute the regression coefficients. You can use Data Analysis Toolpack for this. State the obtained model with the found estimated parameters. b) State the extrapolated price for the Google stock for 11/26/2019 (since the date is out of the range, this predicted value for the stock for 11/26/2019 will be an extrapolation). c) Perform the residual analysis. Based on the results, evaluate whether the assumptions of the linear regression are seriously violated. d) Find the Durbin-Watson statistic. Do this with Excel but don't use Data Analysis or any additional Excel Toolpacks for this. At level of significance a 0.01, is there evidence of positive autocorrelation among the errors? Be careful with the formulation of your hypothesis here. = e) Based on your observations in (c)-(d), is there a reason to question the validity of the linear model? Explain your solutions in complete sentences. Date Nov 22, 2019 Nov 21, 2019 Nov 20, 2019 Nov 19, 2019 Nov 18, 2019 Nov 15, 2019 Nov 14, 2019 Nov 13, 2019 Nov 12, 2019 Nov 11, 2019 Nov 08, 2019 Nov 07, 2019 Nov 06, 2019 Nov 05, 2019 Nov 04, 2019 Nov 01, 2019 Oct 31, 2019 Oct 30, 2019 Oct 29, 2019 Oct 28, 2019 Oct 25, 2019 Oct 24, 2019 Oct 23, 2019 Oct 22, 2019 Oct 21, 2019 Oct 18, 2019 Oct 17, 2019 Oct 16, 2019 Oct 15, 2019 Open High 1,305.62 1,308.73 1,301.48 1,291.41 1,295.34 1,293.00 1,301.35 1,291.15 1,303.05 1,312.80 1,315.46 1,332.22 1,335.53 1,317.50 1,320.70 1,311.74 1,315.00 1,327.70 1,327.70 1,297.50 1,294.07 1,312.59 1,300.00 1,318.94 1,334.88 1,317.00 1,304.30 1,293.51 1,310.00 1,295.77 1,303.18 1,306.43 1,297.41 1,305.28 1,318.00 1,294.28 1,323.74 1,289.46 1,293.73 1,282.50 1,291.80 1,292.89 1,298.93 1,291.23 1,292.03 1,276.45 1,294.13 Low 1,251.03 1,260.90 1,265.00 1,274.62 1,260.50 1,250.93 1,263.32 1,261.28 1,267.67 1,252.97 1,269.36 1,252.00 1,276.23 1,281.59 1,275.45 1,241.17 1,254.74 1,314.28 1,334.87 1,295.65 1,311.46 1,220.40 1,247.33 Close* Adj Close** 1,295.34 1,304.36 1,311.37 1,294.24 1,308.86 1,276.35 1,291.37 1,250.84 1,257.21 1,238.45 1,273.74 1,301.35 1,241.38 1,242.80 1,303.05 1,487,400 1,334.87 1,782,600 1,311.46 1,193,500 1,298.00 1,298.00 826,700 1,298.80 1,298.80 1,085,900 1,299.19 1,299.19 1,011,900 1,315.46 1,243.64 1,320.70 1,311.37 1,299.31 1,272.54 1,290.00 1,269.60 1,250.01 1,265.13 1,264.00 1,253.71 1,260.99 1,242.36 1,259.89 1,242.36 1,259.13 1,259.13 1,247.85 1,250.60 1,252.26 1,254.63 1,240.60 1,246.15 1,253.46 1,258.89 1,241.08 1,245.49 1,249.94 1,253.07 1,308.86 1,291.80 1,292.03 1,291.37 1,260.11 1,290.00 1,265.13 Volume 1,260.99 1,385,700 995,500 1,260.11 1,455,700 1,261.29 1,261.29 1,408,900 1,262.62 1,262.62 1,886,400 1,242.80 1,308,600 1,273.74 1,670,100 1,269,200 1,220.40 1,243.01 1,243.01 1,251,400 2,030,000 1,153,000 1,282,700 1,501,000 2,613,200 1,213,100 1,028,100 1,023,800 1,246.15 1,027,200 1,245.49 1,352,800 1,253.07 911,500 952,400 1,243.64 1,094,600 1,381,700 Oct 14, 2019 Oct 11, 2019 Oct 10, 2019 Oct 09, 2019 Oct 08, 2019 Oct 07, 2019 Oct 04, 2019 Oct 03, 2019 Oct 02, 2019 Oct 01, 2019 Sep 30, 2019 Sep 27, 2019 Sep 26, 2019 Sep 25, 2019 Sep 24, 2019 Sep 23, 2019 Sep 20, 2019 Sep 19, 2019 Sep 18, 2019 Sep 17, 2019 Sep 16, 2019 Sep 13, 2019 Sep 12, 2019 Sep 11, 2019 Sep 10, 2019 Sep 09, 2019 Sep 06, 2019 Sep 05, 2019 Sep 04, 2019 Sep 03, 2019 1,212.34 1,226.33 1,211.76 1,217.14 1,222.21 1,228.39 1,213.74 1,215.45 1,198.58 1,215.00 1,197.34 1,208.67 1,199.35 1,208.35 1,197.63 1,202.31 1,197.59 1,206.08 1,204.40 1,218.20 1,203.75 1,207.68 1,191.89 1,211.44 1,189.17 1,209.00 1,180.00 1,189.06 1,162.43 1,187.83 1,196.98 1,196.98 1,171.29 1,176.63 1,231.23 1,203.58 1,219.00 1,220.97 1,243.01 1,241.96 1,232.06 1,227.51 1,230.40 1,226.00 1,212.30 1,189.01 1,189.13 1,244.02 1,245.00 1,219.00 1,219.00 1,404,100 1,214.45 1,225.09 1,225.09 1,353,900 1,232.27 1,241.39 1,241.39 1,538,000 1,215.82 1,248.30 1,210.09 1,246.52 1,240.00 1,246.74 1,210.68 1,218.76 1,583,200 1,226.00 1,239.09 1,224.17 1,062,400 1,233.12 1,243.32 1,223.08 1,229.93 1,229.93 2,270,000 1,244.44 1,232.02 1,238.71 1,235.61 1,176.71 1,216.53 1,205.10 1,229.52 1,239.56 1,225.61 1,234.03 1,235.00 1,223.69 1,229.15 1,231.30 1.183.48 1,232.41 1,195.15 1,210.00 1,194.58 1,206.00 1,204.00 1,220.00 1,192.62 1,208.13 1,212.02 1,202.52 1,204.93 1,191.53 1,213.04 1,191.53 1,211.38 1,217.14 1,215.45 1,272,700 1,208.67 846,600 867,700 1,189.13 1,039,300 1,207.68 842,900 1,209.00 1,162,400 1,187.83 1,202.31 1,177.03 1,186.89 1,163.20 1,168.39 1,176.63 1,615,100 1,205.10 1,273,500 1,246.52 1,218.76 1,234.03 1,238.71 1,053,300 1,231.35 1,240.88 1,227.01 1,239.56 1,239.56 1,301,400 1,224.30 1,241.86 1,223.02 1,234.25 1,203.41 1,222.60 1,202.20 1,220.17 867,500 1,231.30 1,621,200 1,232.41 1,135,100 1,234.25 1,229.15 955,100 1,220.17 1,206.00 1,453,000 1,204.93 996,000 1,211.38 1,725,900 1,204.41 1,204.41 1,471,900 1,307,000 1,260,100 1,408,100 1,171.00 1,181.41 1,181.41 1,068,900 1,168.39 1,479,900 1,072,100 Aug 30, 2019 Aug 29, 2019 Aug 28, 2019 Aug 27, 2019 Aug 26, 2019 Aug 23, 2019 Aug 22, 2019 Aug 21, 2019 Aug 20, 2019 Aug 19, 2019 Aug 16, 2019 Aug 15, 2019 Aug 14, 2019 Aug 13, 2019 Aug 12, 2019 Aug 09, 2019 Aug 08, 2019 Aug 07, 2019 Aug 06, 2019 Aug 05, 2019 Aug 02, 2019 Aug 01, 2019 Jul 31, 2019 Jul 30, 2019 Jul 29, 2019 Jul 26, 2019 Jul 25, 2019 Jul 24, 2019 Jul 23, 2019 Jul 22, 2019 1,198.50 1,198.50 1,183.80 1,188.10 1,188.10 1,129,800 1,181.12 1,196.06 1,192.85 1,161.71 1,176.42 1,157.30 1,171.02 1,180.53 1,182.40 1,157.26 1,181.99 1,194.07 1,193.15 1,179.21 1,176.31 1,182.30 1,197.99 1,156.00 1,163.31 1,182.83 1,205.01 1,214.03 1,199.00 1,223.00 1,088,400 802,000 1,167.84 1,077,200 1,169.47 1,152.96 1,168.89 1,168.89 1,226,100 1,194.08 1,147.75 1,151.29 1,198.01 1,178.58 1,189.53 1,195.25 1,196.06 1,182.11 1,182.69 1,182.69 915,500 1,190.09 1,206.99 1,190.09 1,198.45 1,179.55 1,182.72 1,171.81 1,177.60 1,163.50 1,175.84 1,162.11 1,167.26 1,164.29 1,171.46 1,204.78 1,171.46 1,197.27 1,167.67 1,174.71 1,203.88 1,183.60 1,188.01 1,225.41 1,184.96 1,137.82 1,178.44 1,179.96 1,234.00 1,234.87 1,241.05 1,247.37 1,175.24 1,181.12 1,234.11 1,224.04 1,265.55 1,161.45 1,192.85 1,187.43 1,191.25 1,160.54 1,173.02 1,204.80 1,149.62 1,173.99 1,160.00 1,140.14 1,169.95 1,228.23 1,239.41 1,224.00 1,250.41 1,141.70 1,120.92 1,132.12 1,171.02 1,170.04 1,152.32 2,597,500 1,200.74 1,206.90 1,188.94 1,193.99 1,193.99 1,645,100 1,205.72 1,209.01 1,209.01 1,698,500 1,207.76 1,216.68 1,216.68 1,725,500 1,223.30 1,225.14 1,225.14 1,453,300 1,239.41 2,223,700 4,805,800 2,209,800 1,131.90 1,144.00 1,126.99 1,137.81 1,167.84 1,146.21 1,151.29 1,687,000 1,189.53 947,500 1,191.25 740,700 1,198.45 1,231,600 1,177.60 1,313,300 1,167.26 1,218,700 1,164.29 1,578,700 1,197.27 1,294,400 1,174.71 1,003,000 1,188.01 1,065,700 1,468,000 1,204.80 1,173.99 1,169.95 1,152.32 1,250.41 1,132.12 1,137.81 1,144.00 1,146.90 1,131.80 1,133.45 1,139.25 1,124.24 1,138.07 1,138.07 1,146.21 1,444,300 1,709,400 1,589,800 1,093,700 1,301,500 Aug 30, 2019 Aug 29, 2019 Aug 28, 2019 Aug 27, 2019 Aug 26, 2019 Aug 23, 2019 Aug 22, 2019 Aug 21, 2019 Aug 20, 2019 Aug 19, 2019 Aug 16, 2019 Aug 15, 2019 Aug 14, 2019 Aug 13, 2019 Aug 12, 2019 Aug 09, 2019 Aug 08, 2019 Aug 07, 2019 Aug 06, 2019 Aug 05, 2019 Aug 02, 2019 Aug 01, 2019 Jul 31, 2019 Jul 30, 2019 Jul 29, 2019 Jul 26, 2019 Jul 25, 2019 Jul 24, 2019 Jul 23, 2019 Jul 22, 2019 1,198.50 1,198.50 1,183.80 1,188.10 1,188.10 1,129,800 1,181.12 1,196.06 1,192.85 1,161.71 1,176.42 1,157.30 1,171.02 1,180.53 1,182.40 1,157.26 1,181.99 1,194.07 1,193.15 1,179.21 1,176.31 1,182.30 1,197.99 1,156.00 1,163.31 1,182.83 1,205.01 1,214.03 1,199.00 1,223.00 1,088,400 802,000 1,167.84 1,077,200 1,169.47 1,152.96 1,168.89 1,168.89 1,226,100 1,194.08 1,147.75 1,151.29 1,198.01 1,178.58 1,189.53 1,195.25 1,196.06 1,182.11 1,182.69 1,182.69 915,500 1,190.09 1,206.99 1,190.09 1,198.45 1,179.55 1,182.72 1,171.81 1,177.60 1,163.50 1,175.84 1,162.11 1,167.26 1,164.29 1,171.46 1,204.78 1,171.46 1,197.27 1,167.67 1,174.71 1,203.88 1,183.60 1,188.01 1,225.41 1,184.96 1,137.82 1,178.44 1,179.96 1,234.00 1,234.87 1,241.05 1,247.37 1,175.24 1,181.12 1,234.11 1,224.04 1,265.55 1,161.45 1,192.85 1,187.43 1,191.25 1,160.54 1,173.02 1,204.80 1,149.62 1,173.99 1,160.00 1,140.14 1,169.95 1,228.23 1,239.41 1,224.00 1,250.41 1,141.70 1,120.92 1,132.12 1,171.02 1,170.04 1,152.32 2,597,500 1,200.74 1,206.90 1,188.94 1,193.99 1,193.99 1,645,100 1,205.72 1,209.01 1,209.01 1,698,500 1,207.76 1,216.68 1,216.68 1,725,500 1,223.30 1,225.14 1,225.14 1,453,300 1,239.41 2,223,700 4,805,800 2,209,800 1,131.90 1,144.00 1,126.99 1,137.81 1,167.84 1,146.21 1,151.29 1,687,000 1,189.53 947,500 1,191.25 740,700 1,198.45 1,231,600 1,177.60 1,313,300 1,167.26 1,218,700 1,164.29 1,578,700 1,197.27 1,294,400 1,174.71 1,003,000 1,188.01 1,065,700 1,468,000 1,204.80 1,173.99 1,169.95 1,152.32 1,250.41 1,132.12 1,137.81 1,144.00 1,146.90 1,131.80 1,133.45 1,139.25 1,124.24 1,138.07 1,138.07 1,146.21 1,444,300 1,709,400 1,589,800 1,093,700 1,301,500 Aug 09, 2019 Aug 08, 2019 Aug 07, 2019 Aug 06, 2019 Aug 05, 2019 Aug 02, 2019 Aug 01, 2019 Jul 31, 2019 Jul 30, 2019 Jul 29, 2019 Jul 26, 2019 Jul 25, 2019 Jul 24, 2019 Jul 23, 2019 Jul 22, 2019 Jul 19, 2019 Jul 18, 2019 Jul 17, 2019 Jul 16, 2019 Jul 15, 2019 Jul 12, 2019 Jul 11, 2019 Jul 10, 2019 Jul 09, 2019 Jul 08, 2019 Jul 05, 2019 Jul 03, 2019 Jul 02, 2019 Jul 01, 2019 1,197.99 1,203.88 1,183.60 1,188.01 1,188.01 1,065,700 1,182.83 1,205.01 1,173.02 1,204.80 1,156.00 1,178.44 1,149.62 1,173.99 1,163.31 1,179.96 1,160.00 1,169.95 1,170.04 1,175.24 1,140.14 1,152.32 1,152.32 2,597,500 1,200.74 1,206.90 1,188.94 1,193.99 1,645,100 1,214.03 1,223.00 1,234.00 1,137.82 1,141.70 1,131.90 1,144.00 1,234.11 1,225.41 1,234.87 1,223.30 1,241.05 1,247.37 1,228.23 1,239.41 1,239.41 2,223,700 1,224.04 1,265.55 1,224.00 1,250.41 1,250.41 4,805,800 1,132.12 1,132.12 2,209,800 1,144.00 1,146.90 1,131.80 1,148.19 1,151.14 1,141.74 1,133.45 1,139.25 1,124.24 1,146.00 1,158.58 1,131.22 1,120.92 1,117.41 1,126.99 1,102.24 1,205.72 1,209.01 1,209.01 1,698,500 1,207.76 1,216.68 1,216.68 1,725,500 1,129.62 1,147.60 1,132.73 1,146.33 1,150.97 1,158.36 1,145.77 1,146.35 1,146.86 1,150.82 1,139.40 1,111.77 1,301,500 1,647,200 1,290,700 1,170,000 1,145.00 1,153.58 1,153.58 1,238,800 1,150.34 1,150.34 903,800 1,143.99 1,147.34 1,138.78 1,144.90 1,144.90 864,000 1,143.25 1,153.07 1,139.58 1,144.21 1,130.97 1,142.05 1,111.80 1,128.03 1,107.17 1,124.83 1,124.83 1,330,400 1,125.17 1,125.98 1,111.21 1,116.35 1,116.35 1,236,400 1,117.80 1,132.88 1,116.14 1,131.59 1,131.59 1,264,300 1,126.76 1,113.86 1,121.58 767,000 991,600 1,097.95 1,436,300 1,225.14 1,098.17 1,137.81 1,098.00 1,107.58 1,093.70 1,146.21 1,138.07 1,130.10 1,204.80 1,468,000 1,173.99 1,140.48 1,111.25 1,169.95 1,709,400 1,193.99 1,097.95 1,225.14 1,453,300 1,137.81 1,589,800 1,146.21 1,093,700 1,138.07 1,130.10 1,444,300 1,146.33 1,146.35 1,144.21 1,121.58 1,140.48 1,209,500 1,111.25 1,195,500 Create an Excel file containing the prices for Google stock for 07/01/2019 - 11/25/2019 (inclusively). Use Yahoo Finance or similar websites to obtain historical data. Ignore dividends. a) Assuming a linear relationship between the closing price and the business day (07/01/2019 - business day 1, 07/02/2019 - business day 2, etc), use the least-squares method to compute the regression coefficients. You can use Data Analysis Toolpack for this. State the obtained model with the found estimated parameters. b) State the extrapolated price for the Google stock for 11/26/2019 (since the date is out of the range, this predicted value for the stock for 11/26/2019 will be an extrapolation). c) Perform the residual analysis. Based on the results, evaluate whether the assumptions of the linear regression are seriously violated. d) Find the Durbin-Watson statistic. Do this with Excel but don't use Data Analysis or any additional Excel Toolpacks for this. At level of significance a 0.01, is there evidence of positive autocorrelation among the errors? Be careful with the formulation of your hypothesis here. = e) Based on your observations in (c)-(d), is there a reason to question the validity of the linear model? Explain your solutions in complete sentences. Date Nov 22, 2019 Nov 21, 2019 Nov 20, 2019 Nov 19, 2019 Nov 18, 2019 Nov 15, 2019 Nov 14, 2019 Nov 13, 2019 Nov 12, 2019 Nov 11, 2019 Nov 08, 2019 Nov 07, 2019 Nov 06, 2019 Nov 05, 2019 Nov 04, 2019 Nov 01, 2019 Oct 31, 2019 Oct 30, 2019 Oct 29, 2019 Oct 28, 2019 Oct 25, 2019 Oct 24, 2019 Oct 23, 2019 Oct 22, 2019 Oct 21, 2019 Oct 18, 2019 Oct 17, 2019 Oct 16, 2019 Oct 15, 2019 Open High 1,305.62 1,308.73 1,301.48 1,291.41 1,295.34 1,293.00 1,301.35 1,291.15 1,303.05 1,312.80 1,315.46 1,332.22 1,335.53 1,317.50 1,320.70 1,311.74 1,315.00 1,327.70 1,327.70 1,297.50 1,294.07 1,312.59 1,300.00 1,318.94 1,334.88 1,317.00 1,304.30 1,293.51 1,310.00 1,295.77 1,303.18 1,306.43 1,297.41 1,305.28 1,318.00 1,294.28 1,323.74 1,289.46 1,293.73 1,282.50 1,291.80 1,292.89 1,298.93 1,291.23 1,292.03 1,276.45 1,294.13 Low 1,251.03 1,260.90 1,265.00 1,274.62 1,260.50 1,250.93 1,263.32 1,261.28 1,267.67 1,252.97 1,269.36 1,252.00 1,276.23 1,281.59 1,275.45 1,241.17 1,254.74 1,314.28 1,334.87 1,295.65 1,311.46 1,220.40 1,247.33 Close* Adj Close** 1,295.34 1,304.36 1,311.37 1,294.24 1,308.86 1,276.35 1,291.37 1,250.84 1,257.21 1,238.45 1,273.74 1,301.35 1,241.38 1,242.80 1,303.05 1,487,400 1,334.87 1,782,600 1,311.46 1,193,500 1,298.00 1,298.00 826,700 1,298.80 1,298.80 1,085,900 1,299.19 1,299.19 1,011,900 1,315.46 1,243.64 1,320.70 1,311.37 1,299.31 1,272.54 1,290.00 1,269.60 1,250.01 1,265.13 1,264.00 1,253.71 1,260.99 1,242.36 1,259.89 1,242.36 1,259.13 1,259.13 1,247.85 1,250.60 1,252.26 1,254.63 1,240.60 1,246.15 1,253.46 1,258.89 1,241.08 1,245.49 1,249.94 1,253.07 1,308.86 1,291.80 1,292.03 1,291.37 1,260.11 1,290.00 1,265.13 Volume 1,260.99 1,385,700 995,500 1,260.11 1,455,700 1,261.29 1,261.29 1,408,900 1,262.62 1,262.62 1,886,400 1,242.80 1,308,600 1,273.74 1,670,100 1,269,200 1,220.40 1,243.01 1,243.01 1,251,400 2,030,000 1,153,000 1,282,700 1,501,000 2,613,200 1,213,100 1,028,100 1,023,800 1,246.15 1,027,200 1,245.49 1,352,800 1,253.07 911,500 952,400 1,243.64 1,094,600 1,381,700 Oct 14, 2019 Oct 11, 2019 Oct 10, 2019 Oct 09, 2019 Oct 08, 2019 Oct 07, 2019 Oct 04, 2019 Oct 03, 2019 Oct 02, 2019 Oct 01, 2019 Sep 30, 2019 Sep 27, 2019 Sep 26, 2019 Sep 25, 2019 Sep 24, 2019 Sep 23, 2019 Sep 20, 2019 Sep 19, 2019 Sep 18, 2019 Sep 17, 2019 Sep 16, 2019 Sep 13, 2019 Sep 12, 2019 Sep 11, 2019 Sep 10, 2019 Sep 09, 2019 Sep 06, 2019 Sep 05, 2019 Sep 04, 2019 Sep 03, 2019 1,212.34 1,226.33 1,211.76 1,217.14 1,222.21 1,228.39 1,213.74 1,215.45 1,198.58 1,215.00 1,197.34 1,208.67 1,199.35 1,208.35 1,197.63 1,202.31 1,197.59 1,206.08 1,204.40 1,218.20 1,203.75 1,207.68 1,191.89 1,211.44 1,189.17 1,209.00 1,180.00 1,189.06 1,162.43 1,187.83 1,196.98 1,196.98 1,171.29 1,176.63 1,231.23 1,203.58 1,219.00 1,220.97 1,243.01 1,241.96 1,232.06 1,227.51 1,230.40 1,226.00 1,212.30 1,189.01 1,189.13 1,244.02 1,245.00 1,219.00 1,219.00 1,404,100 1,214.45 1,225.09 1,225.09 1,353,900 1,232.27 1,241.39 1,241.39 1,538,000 1,215.82 1,248.30 1,210.09 1,246.52 1,240.00 1,246.74 1,210.68 1,218.76 1,583,200 1,226.00 1,239.09 1,224.17 1,062,400 1,233.12 1,243.32 1,223.08 1,229.93 1,229.93 2,270,000 1,244.44 1,232.02 1,238.71 1,235.61 1,176.71 1,216.53 1,205.10 1,229.52 1,239.56 1,225.61 1,234.03 1,235.00 1,223.69 1,229.15 1,231.30 1.183.48 1,232.41 1,195.15 1,210.00 1,194.58 1,206.00 1,204.00 1,220.00 1,192.62 1,208.13 1,212.02 1,202.52 1,204.93 1,191.53 1,213.04 1,191.53 1,211.38 1,217.14 1,215.45 1,272,700 1,208.67 846,600 867,700 1,189.13 1,039,300 1,207.68 842,900 1,209.00 1,162,400 1,187.83 1,202.31 1,177.03 1,186.89 1,163.20 1,168.39 1,176.63 1,615,100 1,205.10 1,273,500 1,246.52 1,218.76 1,234.03 1,238.71 1,053,300 1,231.35 1,240.88 1,227.01 1,239.56 1,239.56 1,301,400 1,224.30 1,241.86 1,223.02 1,234.25 1,203.41 1,222.60 1,202.20 1,220.17 867,500 1,231.30 1,621,200 1,232.41 1,135,100 1,234.25 1,229.15 955,100 1,220.17 1,206.00 1,453,000 1,204.93 996,000 1,211.38 1,725,900 1,204.41 1,204.41 1,471,900 1,307,000 1,260,100 1,408,100 1,171.00 1,181.41 1,181.41 1,068,900 1,168.39 1,479,900 1,072,100 Aug 30, 2019 Aug 29, 2019 Aug 28, 2019 Aug 27, 2019 Aug 26, 2019 Aug 23, 2019 Aug 22, 2019 Aug 21, 2019 Aug 20, 2019 Aug 19, 2019 Aug 16, 2019 Aug 15, 2019 Aug 14, 2019 Aug 13, 2019 Aug 12, 2019 Aug 09, 2019 Aug 08, 2019 Aug 07, 2019 Aug 06, 2019 Aug 05, 2019 Aug 02, 2019 Aug 01, 2019 Jul 31, 2019 Jul 30, 2019 Jul 29, 2019 Jul 26, 2019 Jul 25, 2019 Jul 24, 2019 Jul 23, 2019 Jul 22, 2019 1,198.50 1,198.50 1,183.80 1,188.10 1,188.10 1,129,800 1,181.12 1,196.06 1,192.85 1,161.71 1,176.42 1,157.30 1,171.02 1,180.53 1,182.40 1,157.26 1,181.99 1,194.07 1,193.15 1,179.21 1,176.31 1,182.30 1,197.99 1,156.00 1,163.31 1,182.83 1,205.01 1,214.03 1,199.00 1,223.00 1,088,400 802,000 1,167.84 1,077,200 1,169.47 1,152.96 1,168.89 1,168.89 1,226,100 1,194.08 1,147.75 1,151.29 1,198.01 1,178.58 1,189.53 1,195.25 1,196.06 1,182.11 1,182.69 1,182.69 915,500 1,190.09 1,206.99 1,190.09 1,198.45 1,179.55 1,182.72 1,171.81 1,177.60 1,163.50 1,175.84 1,162.11 1,167.26 1,164.29 1,171.46 1,204.78 1,171.46 1,197.27 1,167.67 1,174.71 1,203.88 1,183.60 1,188.01 1,225.41 1,184.96 1,137.82 1,178.44 1,179.96 1,234.00 1,234.87 1,241.05 1,247.37 1,175.24 1,181.12 1,234.11 1,224.04 1,265.55 1,161.45 1,192.85 1,187.43 1,191.25 1,160.54 1,173.02 1,204.80 1,149.62 1,173.99 1,160.00 1,140.14 1,169.95 1,228.23 1,239.41 1,224.00 1,250.41 1,141.70 1,120.92 1,132.12 1,171.02 1,170.04 1,152.32 2,597,500 1,200.74 1,206.90 1,188.94 1,193.99 1,193.99 1,645,100 1,205.72 1,209.01 1,209.01 1,698,500 1,207.76 1,216.68 1,216.68 1,725,500 1,223.30 1,225.14 1,225.14 1,453,300 1,239.41 2,223,700 4,805,800 2,209,800 1,131.90 1,144.00 1,126.99 1,137.81 1,167.84 1,146.21 1,151.29 1,687,000 1,189.53 947,500 1,191.25 740,700 1,198.45 1,231,600 1,177.60 1,313,300 1,167.26 1,218,700 1,164.29 1,578,700 1,197.27 1,294,400 1,174.71 1,003,000 1,188.01 1,065,700 1,468,000 1,204.80 1,173.99 1,169.95 1,152.32 1,250.41 1,132.12 1,137.81 1,144.00 1,146.90 1,131.80 1,133.45 1,139.25 1,124.24 1,138.07 1,138.07 1,146.21 1,444,300 1,709,400 1,589,800 1,093,700 1,301,500 Aug 30, 2019 Aug 29, 2019 Aug 28, 2019 Aug 27, 2019 Aug 26, 2019 Aug 23, 2019 Aug 22, 2019 Aug 21, 2019 Aug 20, 2019 Aug 19, 2019 Aug 16, 2019 Aug 15, 2019 Aug 14, 2019 Aug 13, 2019 Aug 12, 2019 Aug 09, 2019 Aug 08, 2019 Aug 07, 2019 Aug 06, 2019 Aug 05, 2019 Aug 02, 2019 Aug 01, 2019 Jul 31, 2019 Jul 30, 2019 Jul 29, 2019 Jul 26, 2019 Jul 25, 2019 Jul 24, 2019 Jul 23, 2019 Jul 22, 2019 1,198.50 1,198.50 1,183.80 1,188.10 1,188.10 1,129,800 1,181.12 1,196.06 1,192.85 1,161.71 1,176.42 1,157.30 1,171.02 1,180.53 1,182.40 1,157.26 1,181.99 1,194.07 1,193.15 1,179.21 1,176.31 1,182.30 1,197.99 1,156.00 1,163.31 1,182.83 1,205.01 1,214.03 1,199.00 1,223.00 1,088,400 802,000 1,167.84 1,077,200 1,169.47 1,152.96 1,168.89 1,168.89 1,226,100 1,194.08 1,147.75 1,151.29 1,198.01 1,178.58 1,189.53 1,195.25 1,196.06 1,182.11 1,182.69 1,182.69 915,500 1,190.09 1,206.99 1,190.09 1,198.45 1,179.55 1,182.72 1,171.81 1,177.60 1,163.50 1,175.84 1,162.11 1,167.26 1,164.29 1,171.46 1,204.78 1,171.46 1,197.27 1,167.67 1,174.71 1,203.88 1,183.60 1,188.01 1,225.41 1,184.96 1,137.82 1,178.44 1,179.96 1,234.00 1,234.87 1,241.05 1,247.37 1,175.24 1,181.12 1,234.11 1,224.04 1,265.55 1,161.45 1,192.85 1,187.43 1,191.25 1,160.54 1,173.02 1,204.80 1,149.62 1,173.99 1,160.00 1,140.14 1,169.95 1,228.23 1,239.41 1,224.00 1,250.41 1,141.70 1,120.92 1,132.12 1,171.02 1,170.04 1,152.32 2,597,500 1,200.74 1,206.90 1,188.94 1,193.99 1,193.99 1,645,100 1,205.72 1,209.01 1,209.01 1,698,500 1,207.76 1,216.68 1,216.68 1,725,500 1,223.30 1,225.14 1,225.14 1,453,300 1,239.41 2,223,700 4,805,800 2,209,800 1,131.90 1,144.00 1,126.99 1,137.81 1,167.84 1,146.21 1,151.29 1,687,000 1,189.53 947,500 1,191.25 740,700 1,198.45 1,231,600 1,177.60 1,313,300 1,167.26 1,218,700 1,164.29 1,578,700 1,197.27 1,294,400 1,174.71 1,003,000 1,188.01 1,065,700 1,468,000 1,204.80 1,173.99 1,169.95 1,152.32 1,250.41 1,132.12 1,137.81 1,144.00 1,146.90 1,131.80 1,133.45 1,139.25 1,124.24 1,138.07 1,138.07 1,146.21 1,444,300 1,709,400 1,589,800 1,093,700 1,301,500 Aug 09, 2019 Aug 08, 2019 Aug 07, 2019 Aug 06, 2019 Aug 05, 2019 Aug 02, 2019 Aug 01, 2019 Jul 31, 2019 Jul 30, 2019 Jul 29, 2019 Jul 26, 2019 Jul 25, 2019 Jul 24, 2019 Jul 23, 2019 Jul 22, 2019 Jul 19, 2019 Jul 18, 2019 Jul 17, 2019 Jul 16, 2019 Jul 15, 2019 Jul 12, 2019 Jul 11, 2019 Jul 10, 2019 Jul 09, 2019 Jul 08, 2019 Jul 05, 2019 Jul 03, 2019 Jul 02, 2019 Jul 01, 2019 1,197.99 1,203.88 1,183.60 1,188.01 1,188.01 1,065,700 1,182.83 1,205.01 1,173.02 1,204.80 1,156.00 1,178.44 1,149.62 1,173.99 1,163.31 1,179.96 1,160.00 1,169.95 1,170.04 1,175.24 1,140.14 1,152.32 1,152.32 2,597,500 1,200.74 1,206.90 1,188.94 1,193.99 1,645,100 1,214.03 1,223.00 1,234.00 1,137.82 1,141.70 1,131.90 1,144.00 1,234.11 1,225.41 1,234.87 1,223.30 1,241.05 1,247.37 1,228.23 1,239.41 1,239.41 2,223,700 1,224.04 1,265.55 1,224.00 1,250.41 1,250.41 4,805,800 1,132.12 1,132.12 2,209,800 1,144.00 1,146.90 1,131.80 1,148.19 1,151.14 1,141.74 1,133.45 1,139.25 1,124.24 1,146.00 1,158.58 1,131.22 1,120.92 1,117.41 1,126.99 1,102.24 1,205.72 1,209.01 1,209.01 1,698,500 1,207.76 1,216.68 1,216.68 1,725,500 1,129.62 1,147.60 1,132.73 1,146.33 1,150.97 1,158.36 1,145.77 1,146.35 1,146.86 1,150.82 1,139.40 1,111.77 1,301,500 1,647,200 1,290,700 1,170,000 1,145.00 1,153.58 1,153.58 1,238,800 1,150.34 1,150.34 903,800 1,143.99 1,147.34 1,138.78 1,144.90 1,144.90 864,000 1,143.25 1,153.07 1,139.58 1,144.21 1,130.97 1,142.05 1,111.80 1,128.03 1,107.17 1,124.83 1,124.83 1,330,400 1,125.17 1,125.98 1,111.21 1,116.35 1,116.35 1,236,400 1,117.80 1,132.88 1,116.14 1,131.59 1,131.59 1,264,300 1,126.76 1,113.86 1,121.58 767,000 991,600 1,097.95 1,436,300 1,225.14 1,098.17 1,137.81 1,098.00 1,107.58 1,093.70 1,146.21 1,138.07 1,130.10 1,204.80 1,468,000 1,173.99 1,140.48 1,111.25 1,169.95 1,709,400 1,193.99 1,097.95 1,225.14 1,453,300 1,137.81 1,589,800 1,146.21 1,093,700 1,138.07 1,130.10 1,444,300 1,146.33 1,146.35 1,144.21 1,121.58 1,140.48 1,209,500 1,111.25 1,195,500