Could someone please help me. How do you plot a least square regression line on
ID: 1825315 • Letter: C
Question
Could someone please help me. How do you plot a least square regression line on scatter plots in excel. i have the scatter plots and the tread line but I'm confused on where to go from here. here is my data for one of my scatter plots, it includes: Day, Date, Steamflow, and Gage Height. Day Daytime Streamflow Gage Height 1 10/1/2009 13 2.749167 2 10/2/2009 13.96875 2.776979 3 10/3/2009 19.229167 2.891146 4 10/4/2009 47.717391 3.305326 5 10/5/2009 56.291667 3.412917 6 10/6/2009 47.78125 3.321458 7 10/7/2009 39.96875 3.225833 8 10/8/2009 37.354167 3.192604 9 10/9/2009 36.166667 3.1775 10 10/10/2009 35.34375 3.163542 11 10/11/2009 38.78125 3.214687 12 10/12/2009 42.322917 3.255417 13 10/13/2009 40.541667 3.232917 14 10/14/2009 36 3.175 15 10/15/2009 32.489583 3.12125 16 10/16/2009 29.354167 3.076667 17 10/17/2009 30.03125 3.084687 18 10/18/2009 39.458333 3.219896 19 10/19/2009 44.3125 3.281667 20 10/20/2009 40.351064 3.231277 21 10/21/2009 36.739583 3.186562 22 10/22/2009 35.59375 3.168958 23 10/23/2009 36.34375 3.179896 24 10/24/2009 169.84375 3.954792 25 10/25/2009 411.177083 4.9625 26 10/26/2009 154.989583 3.204444 27 10/27/2009 36.96875 3.187708 28 10/28/2009 31.416667 3.105625 29 10/29/2009 63.177083 3.117604 30 10/30/2009 28.854167 3.06875 31 10/31/2009 26.833333 3.033437 1 11/1/2009 25.14 3.007 2 11/2/2009 24.28125 2.989583 3 11/3/2009 23.71875 2.978125 4 11/4/2009 23.197917 2.968437 5 11/5/2009 22.729167 2.957292 6 11/6/2009 20.791667 2.928542 7 11/7/2009 19.989583 2.903958 8 11/8/2009 25.041667 2.887222 9 11/9/2009 24.927083 3.368125 10 11/10/2009 23.177083 3.349688 11 11/11/2009 21.114583 3.30625 12 11/12/2009 22.375 3.318333 13 11/13/2009 22.135417 3.271771 14 11/14/2009 21.947917 3.276354 15 11/15/2009 21.604167 3.320208 16 11/16/2009 20.6875 3.3025 17 11/17/2009 20.71875 3.250521 18 11/18/2009 20 3.221563 19 11/19/2009 18.3125 3.168021 20 11/20/2009 18.416667 3.257292 21 11/21/2009 23.625 3.735729 22 11/22/2009 24.479167 4.117812 23 11/23/2009 22.84375 4.04125 24 11/24/2009 20.40625 4.062083 25 11/25/2009 21.135417 3.916979 26 11/26/2009 21.291667 3.755104 27 11/27/2009 19.46875 3.617188 28 11/28/2009 20.520833 3.66625 29 11/29/2009 21.427083 3.557917 30 11/30/2009 20.614583 3.487083 1 12/1/2009 14.654167 3.364167 2 12/2/2009 20.46875 3.2925 3 12/3/2009 20.135417 3.254583 4 12/4/2009 18.666667 3.224022 5 12/5/2009 19.15625 3.220938 6 12/6/2009 19.458333 3.306042 7 12/7/2009 18.229167 3.340625 8 12/8/2009 18.958333 3.3075 9 12/9/2009 18.375 3.374479 10 12/10/2009 18.947917 3.448542 11 12/11/2009 18.833333 3.397396 12 12/12/2009 18.4375 3.387917 13 12/13/2009 15.979167 3.405625 14 12/14/2009 16.395833 3.392188 15 12/15/2009 16.239583 3.641146 16 12/16/2009 16.645833 3.358229 17 12/17/2009 16.322917 3.457083 18 12/18/2009 17.385417 3.779348 19 12/19/2009 18.229167 4.644062 20 12/20/2009 16.145833 5.210625 21 12/21/2009 14.635417 5.225104 22 12/22/2009 17.833333 4.639688 23 12/23/2009 13.885417 4.187083 24 12/24/2009 13.6875 3.866562 25 12/25/2009 14.395833 4.083229 26 12/26/2009 16.145833 3.747174 27 12/27/2009 16.09375 3.536304 28 12/28/2009 15.197917 3.451146 29 12/29/2009 15 3.681354 30 12/30/2009 16.395833 4.268229 31 12/31/2009 17.8125 4.197917 1 1/1/2010 16.729167 3.954583 2 1/2/2010 16.4375 3.874167 3 1/3/2010 15.5625 3.799792 4 1/4/2010 16.21875 3.592396 5 1/5/2010 15.895833 3.525312 6 1/6/2010 17.760417 3.484375 7 1/7/2010 16.260417 3.454062 8 1/8/2010 16.75 3.376667 9 1/9/2010 13.395833 3.316458 10 1/10/2010 15.739583 3.295521 11 1/11/2010 15.479167 3.276667 12 1/12/2010 15.270833 3.248542 13 1/13/2010 14.227083 3.210313 14 1/14/2010 14.795833 3.177609 15 1/15/2010 14.065625 3.171042 16 1/16/2010 17.083333 3.205217 17 1/17/2010 12.85 3.26125 18 1/18/2010 12 3.336979 19 1/19/2010 12.447917 3.331979 20 1/20/2010 14.304348 3.3025 21 1/21/2010 22.385417 3.29875 22 1/22/2010 23.916667 3.331771 23 1/23/2010 44.041667 3.337604 24 1/24/2010 50.916667 3.297188 25 1/25/2010 65.208333 3.280208 26 1/26/2010 69.46875 3.280625 27 1/27/2010 57.677083 3.300312 28 1/28/2010 44.71875 3.305938 29 1/29/2010 33.90625 3.321458 30 1/30/2010 28.916667 3.3175 31 1/31/2010 26.916667 3.318125 1 2/1/2010 24.75 3.31125 2 2/2/2010 25.385417 3.405104 3 2/3/2010 24.114583 3.306042 4 2/4/2010 23.510417 3.214583 5 2/5/2010 22.479167 3.212917 6 2/6/2010 22.5625 3.220208 7 2/7/2010 71.094118 3.245729 8 2/8/2010 71.326316 3.262187 9 2/9/2010 50.811111 3.301042 10 2/10/2010 29.239583 3.354375 11 2/11/2010 33.684783 3.300625 12 2/12/2010 18.1875 3.227708 13 2/13/2010 19.489583 3.23 14 2/14/2010 19.552083 3.219063 15 2/15/2010 20.15625 3.207917 16 2/16/2010 20.375 3.347917 17 2/17/2010 24.447917 3.705312 18 2/18/2010 21.5625 3.848333 19 2/19/2010 18.90625 4.163438 20 2/20/2010 18.53125 4.324167 21 2/21/2010 19.03125 3.936667 22 2/22/2010 18.291667 3.656354 23 2/23/2010 19.479167 3.505417 24 2/24/2010 21.041667 3.348021 25 2/25/2010 21.864583 3.748854 26 2/26/2010 23.145833 4.507188 27 2/27/2010 20.40625 4.196667 28 2/28/2010 21.03125 3.87087 1 3/1/2010 55.416667 3.612917 2 3/2/2010 42.385417 3.487604 3 3/3/2010 26.25 3.475521 4 3/4/2010 28.458333 3.387708 5 3/5/2010 36.989583 3.282188 6 3/6/2010 27.864583 3.243229 7 3/7/2010 30.197917 3.310625 8 3/8/2010 28.489583 3.298478 9 3/9/2010 29.28125 3.283958 10 3/10/2010 30.6875 3.300938 11 3/11/2010 30.293478 3.307917 12 3/12/2010 28.145833 3.318958 13 3/13/2010 28.15625 3.307283 14 3/14/2010 25.59375 3.282604 15 3/15/2010 27.84375 3.322604 16 3/16/2010 29.885417 3.523646 17 3/17/2010 53.854167 3.475312 18 3/18/2010 126.260417 3.394375 19 3/19/2010 144.947917 3.556979 20 3/20/2010 114.4375 3.538229 21 3/21/2010 79.572917 3.836354 22 3/22/2010 58.541667 3.78125 23 3/23/2010 46.354167 3.609783 24 3/24/2010 48.020833 3.823958 25 3/25/2010 41.8125 3.93375 26 3/26/2010 40.072917 3.928021 27 3/27/2010 34.822917 3.758646 28 3/28/2010 35.177083 3.523804 29 3/29/2010 35.604167 3.495417 30 3/30/2010 46.447917 3.5425 31 3/31/2010 67.583333 3.645313 1 4/1/2010 63.395833 3.876667 2 4/2/2010 56.739583 4.102917 3 4/3/2010 55.520833 4.058542 4 4/4/2010 65.9375 4.052917 5 4/5/2010 59.395833 4.214583 6 4/6/2010 55.479167 4.274062 7 4/7/2010 51.364583 4.166771 8 4/8/2010 53.53125 3.938229 9 4/9/2010 60.729167 3.815521 10 4/10/2010 66.3125 3.719375 11 4/11/2010 61.572917 3.715833 12 4/12/2010 53.864583 3.740104 13 4/13/2010 58.854167 3.750521 14 4/14/2010 60.520833 3.677292 15 4/15/2010 21.604167 3.530833 16 4/16/2010 77.4375 3.608958 17 4/17/2010 95.864583 3.755313 18 4/18/2010 111.03125 3.86375 19 4/19/2010 122.822917 3.939687 20 4/20/2010 141.416667 4.052292 21 4/21/2010 113.010417 3.876667 22 4/22/2010 93.020833 3.735312 23 4/23/2010 85.552083 3.678438 24 4/24/2010 96.104167 3.755521 25 4/25/2010 135.6875 4.013542 26 4/26/2010 180.802083 4.248125 27 4/27/2010 204.197917 4.355417 28 4/28/2010 157.322917 4.138854 29 4/29/2010 124.833333 3.953125 30 4/30/2010 107.291667 3.83875 1 5/1/2010 106.875 3.833229 2 5/2/2010 134.229167 4.009583 3 5/3/2010 176.427083 4.215521 4 5/4/2010 264.677083 4.584687 5 5/5/2010 295.166667 4.695625 6 5/6/2010 290.104167 4.678021 7 5/7/2010 304.447917 4.724792 8 5/8/2010 324.322917 4.788333 9 5/9/2010 291.760417 4.683125 10 5/10/2010 216.927083 4.41 11 5/11/2010 177.229167 4.237917 12 5/12/2010 166.21875 4.182813 13 5/13/2010 184.21875 4.269896 14 5/14/2010 208.489583 4.372292 15 5/15/2010 283.96875 4.64625 16 5/16/2010 381.736842 4.952211 17 5/17/2010 378.4 4.945789 18 5/18/2010 298.010417 4.704479 19 5/19/2010 351.9375 4.865937 20 5/20/2010 466.34375 5.175729 21 5/21/2010 445.739583 5.125625 22 5/22/2010 308.583333 4.738958 23 5/23/2010 238.864583 4.496458 24 5/24/2010 193.802083 4.312812 25 5/25/2010 181.34375 4.256667 26 5/26/2010 189.8125 4.294687 27 5/27/2010 187 4.282292 28 5/28/2010 173.072917 4.218646 29 5/29/2010 175.4375 4.222396 30 5/30/2010 248.822917 4.520104 31 5/31/2010 359.614583 4.885208 1 6/1/2010 466.989583 5.177604 2 6/2/2010 583.197917 5.432396 3 6/3/2010 740.5625 5.749583 4 6/4/2010 977.778947 6.135895 5 6/5/2010 1212.0625 6.460104 6 6/6/2010 1336.5625 6.623542 7 6/7/2010 1402.395833 6.707292 8 6/8/2010 1211.916667 6.468958 9 6/9/2010 1113.442105 6.337684 10 6/10/2010 941.166667 6.084687 11 6/11/2010 666.706522 5.613043 12 6/12/2010 462.760417 5.172708 13 6/13/2010 452.5 5.145521 14 6/14/2010 544.479167 5.357812 15 6/15/2010 737.760417 5.746875 16 6/16/2010 716.583333 5.706875 17 6/17/2010 580 5.440729 18 6/18/2010 585.489583 5.452292 19 6/19/2010 555.895833 5.388958 20 6/20/2010 567.239583 5.413646 21 6/21/2010 595.28125 5.473229 22 6/22/2010 574.166667 5.426562 23 6/23/2010 656.416667 5.596667 24 6/24/2010 642.614583 5.567812 25 6/25/2010 675.447917 5.631667 26 6/26/2010 709.083333 5.695833 27 6/27/2010 777.010417 5.818229 28 6/28/2010 812.126316 5.878947 29 6/29/2010 784.802083 5.831354 30 6/30/2010 744.5 5.759896 1 7/1/2010 627.041667 5.534375 2 7/2/2010 516.260417 5.299583 3 7/3/2010 488.75 5.236042 4 7/4/2010 454.145833 5.151563 5 7/5/2010 437.3125 5.109167 6 7/6/2010 455.760417 5.155729 7 7/7/2010 453.666667 5.150521 8 7/8/2010 432.770833 5.097083 9 7/9/2010 426.458333 5.080833 10 7/10/2010 416.510417 5.054271 11 7/11/2010 404.791667 5.023021 12 7/12/2010 401.75 5.015104 13 7/13/2010 447.770833 5.135938 14 7/14/2010 418.625 5.057083 15 7/15/2010 362.333333 4.904167 16 7/16/2010 406.541667 5.026562 17 7/17/2010 446.197917 5.129479 18 7/18/2010 391.71875 4.987604 19 7/19/2010 351.135417 4.870208 20 7/20/2010 294.625 4.694063 21 7/21/2010 267.302083 4.599583 22 7/22/2010 221.5 4.428125 23 7/23/2010 206.208333 4.364479 24 7/24/2010 197.520833 4.328854 25 7/25/2010 195.125 4.318438 26 7/26/2010 195.1875 4.318125 27 7/27/2010 172.020833 4.210521 28 7/28/2010 140.21875 4.044479 29 7/29/2010 134.239583 4.01125 30 7/30/2010 152.510417 4.114688 31 7/31/2010 149.510417 4.096146 1 8/1/2010 122.635417 3.939167 2 8/2/2010 106.03125 3.830208 3 8/3/2010 96.90625 3.763125 4 8/4/2010 87.458333 3.693021 5 8/5/2010 83.28125 3.660104 6 8/6/2010 79.739583 3.63125 7 8/7/2010 74.302083 3.586667 8 8/8/2010 77.583333 3.613125 9 8/9/2010 75.28125 3.594063 10 8/10/2010 64.979167 3.499792 11 8/11/2010 61.875 3.46875 12 8/12/2010 57.104167 3.421042 13 8/13/2010 54.677083 3.396771 14 8/14/2010 57.291667 3.422917 15 8/15/2010 59.666667 3.446667 16 8/16/2010 55.489583 3.404896 17 8/17/2010 52.041667 3.368437 18 8/18/2010 48.5 3.329583 19 8/19/2010 48.833333 3.332083 20 8/20/2010 49.78125 3.343854 21 8/21/2010 45.375 3.291667 22 8/22/2010 39.833333 3.224896 23 8/23/2010 39.364583 3.219792 24 8/24/2010 36.479167 3.180312 25 8/25/2010 34.166667 3.147917 26 8/26/2010 37.270833 3.190625 27 8/27/2010 46.736264 3.309121 28 8/28/2010 44.65625 3.283542 29 8/29/2010 35.739583 3.169687 30 8/30/2010 30.71875 3.096875 31 8/31/2010 26.552083 3.028646 1 9/1/2010 24.083333 2.984167 2 9/2/2010 22.8125 2.962604 3 9/3/2010 23.385417 2.971771 4 9/4/2010 24.822917 2.998438 5 9/5/2010 24.875 3.001458 6 9/6/2010 23.729167 2.979063 7 9/7/2010 23.083333 2.966667 8 9/8/2010 22.979167 2.965833 9 9/9/2010 22.114583 2.949271 10 9/10/2010 19.677083 2.904583 11 9/11/2010 18.260417 2.866875 12 9/12/2010 16.791667 2.842604 13 9/13/2010 16.489583 2.835625 14 9/14/2010 16.135417 2.828021 15 9/15/2010 15.864583 2.822813 16 9/16/2010 15.541667 2.813958 17 9/17/2010 15.260417 2.805625 18 9/18/2010 14.989583 2.8 19 9/19/2010 14.760417 2.792813 20 9/20/2010 14.604167 2.788229 21 9/21/2010 14.125 2.777396 22 9/22/2010 13.885417 2.77125 23 9/23/2010 14.34375 2.780208 24 9/24/2010 13.552083 2.764063 25 9/25/2010 12.927083 2.749896 26 9/26/2010 12.739583 2.741667 27 9/27/2010 12.520833 2.736875 28 9/28/2010 12.385417 2.730938 29 9/29/2010 12.395833 2.730625 30 9/30/2010 12.729167 2.738333 1 10/1/2010 13 2.749167 2 10/2/2010 13.96875 2.776979 3 10/3/2010 19.229167 2.891146 4 10/4/2010 47.717391 3.305326 5 10/5/2010 56.291667 3.412917 6 10/6/2010 47.78125 3.321458 7 10/7/2010 39.96875 3.225833 8 10/8/2010 37.354167 3.192604 9 10/9/2010 36.166667 3.1775 10 10/10/2010 35.34375 3.163542 11 10/11/2010 38.78125 3.214687 12 10/12/2010 42.322917 3.255417 13 10/13/2010 40.541667 3.232917 14 10/14/2010 36 3.175 15 10/15/2010 32.489583 3.12125 16 10/16/2010 29.354167 3.076667 17 10/17/2010 30.03125 3.084687 18 10/18/2010 39.458333 3.219896 19 10/19/2010 44.3125 3.281667 20 10/20/2010 40.351064 3.231277 21 10/21/2010 36.739583 3.186562 22 10/22/2010 35.59375 3.168958 23 10/23/2010 36.34375 3.179896 24 10/24/2010 169.84375 3.954792 25 10/25/2010 411.177083 4.9625 26 10/26/2010 154.989583 4.120208 27 10/27/2010 103.385417 3.810208 28 10/28/2010 80.354167 3.634896 29 10/29/2010 63.177083 3.481771 30 10/30/2010 57.34375 3.423438 31 10/31/2010 51.260417 3.362604 1 11/1/2010 47.364583 3.315312 2 11/2/2010 45.739583 3.297396 3 11/3/2010 47.65625 3.316562 4 11/4/2010 49.010417 3.339062 5 11/5/2010 48.729167 3.333125 6 11/6/2010 46.1875 3.301875 7 11/7/2010 24.5 3.3055 8 11/8/2010 25.041667 3.396146 9 11/9/2010 24.927083 3.368125 10 11/10/2010 23.177083 3.349688 11 11/11/2010 21.114583 3.30625 12 11/12/2010 22.375 3.318333 13 11/13/2010 22.135417 3.271771 14 11/14/2010 21.947917 3.276354 15 11/15/2010 21.604167 3.320208 16 11/16/2010 20.6875 3.3025 17 11/17/2010 20.71875 3.250521 18 11/18/2010 20 3.221563 19 11/19/2010 18.3125 3.168021 20 11/20/2010 18.416667 3.257292 21 11/21/2010 23.625 3.735729 22 11/22/2010 24.479167 4.117812 23 11/23/2010 22.84375 4.04125 24 11/24/2010 20.40625 4.062083 25 11/25/2010 21.135417 3.916979 26 11/26/2010 21.291667 3.755104 27 11/27/2010 19.46875 3.617188 28 11/28/2010 20.520833 3.66625 29 11/29/2010 21.427083 3.557917 30 11/30/2010 20.614583 3.487083 1 12/1/2010 14.654167 3.364167 2 12/2/2010 20.46875 3.2925 3 12/3/2010 20.135417 3.254583 4 12/4/2010 18.666667 3.224022 5 12/5/2010 19.15625 3.220938 6 12/6/2010 19.458333 3.306042 7 12/7/2010 18.229167 3.340625 8 12/8/2010 18.958333 3.3075 9 12/9/2010 18.375 3.374479 10 12/10/2010 18.947917 3.448542 11 12/11/2010 18.833333 3.397396 12 12/12/2010 18.4375 3.387917 13 12/13/2010 15.979167 3.405625 14 12/14/2010 16.395833 3.392188 15 12/15/2010 16.239583 3.641146 16 12/16/2010 16.645833 3.358229 17 12/17/2010 16.322917 3.457083 18 12/18/2010 17.385417 3.779348 19 12/19/2010 18.229167 4.644062 20 12/20/2010 16.145833 5.210625 21 12/21/2010 14.635417 5.225104 22 12/22/2010 17.833333 4.639688 23 12/23/2010 13.885417 4.187083 24 12/24/2010 13.6875 3.866562 25 12/25/2010 14.395833 4.083229 26 12/26/2010 16.145833 3.747174 27 12/27/2010 16.09375 3.536304 28 12/28/2010 15.197917 3.451146 29 12/29/2010 15 3.681354 30 12/30/2010 16.395833 4.268229 31 12/31/2010 17.8125 4.197917 1 1/1/2011 16.729167 3.954583 2 1/2/2011 16.4375 3.874167 3 1/3/2011 15.5625 3.799792 4 1/4/2011 16.21875 3.592396 5 1/5/2011 15.895833 3.525312 6 1/6/2011 17.760417 3.484375 7 1/7/2011 16.260417 3.454062 8 1/8/2011 16.75 3.376667 9 1/9/2011 13.395833 3.316458 10 1/10/2011 15.739583 3.295521 11 1/11/2011 15.479167 3.276667 12 1/12/2011 15.270833 3.248542 13 1/13/2011 14.227083 3.210313 14 1/14/2011 14.795833 3.177609 15 1/15/2011 14.065625 3.171042 16 1/16/2011 17.083333 3.205217 17 1/17/2011 12.85 3.26125 18 1/18/2011 12 3.336979 19 1/19/2011 12.447917 3.331979 20 1/20/2011 14.304348 3.3025 21 1/21/2011 22.385417 3.29875 22 1/22/2011 23.916667 3.331771 23 1/23/2011 44.041667 3.337604 24 1/24/2011 50.916667 3.297188 25 1/25/2011 65.208333 3.280208 26 1/26/2011 69.46875 3.280625 27 1/27/2011 57.677083 3.300312 28 1/28/2011 44.71875 3.305938 29 1/29/2011 33.90625 3.321458 30 1/30/2011 28.916667 3.3175 31 1/31/2011 26.916667 3.318125 1 2/1/2011 24.75 3.31125 2 2/2/2011 25.385417 3.405104 3 2/3/2011 24.114583 3.306042 4 2/4/2011 23.510417 3.214583 5 2/5/2011 22.479167 3.212917 6 2/6/2011 22.5625 3.220208 7 2/7/2011 71.094118 3.245729 8 2/8/2011 71.326316 3.262187 9 2/9/2011 50.811111 3.301042 10 2/10/2011 29.239583 3.354375 11 2/11/2011 33.684783 3.300625 12 2/12/2011 18.1875 3.227708 13 2/13/2011 19.489583 3.23 14 2/14/2011 19.552083 3.219063 15 2/15/2011 20.15625 3.207917 16 2/16/2011 20.375 3.347917 17 2/17/2011 24.447917 3.705312 18 2/18/2011 21.5625 3.848333 19 2/19/2011 18.90625 4.163438 20 2/20/2011 18.53125 4.324167 21 2/21/2011 19.03125 3.936667 22 2/22/2011 18.291667 3.656354 23 2/23/2011 19.479167 3.505417 24 2/24/2011 21.041667 3.348021 25 2/25/2011 21.864583 3.748854 26 2/26/2011 23.145833 4.507188 27 2/27/2011 20.40625 4.196667 28 2/28/2011 21.03125 3.87087 1 3/1/2011 55.416667 3.612917 2 3/2/2011 42.385417 3.487604 3 3/3/2011 26.25 3.475521 4 3/4/2011 28.458333 3.387708 5 3/5/2011 36.989583 3.282188 6 3/6/2011 27.864583 3.243229 7 3/7/2011 30.197917 3.310625 8 3/8/2011 28.489583 3.298478 9 3/9/2011 29.28125 3.283958 10 3/10/2011 30.6875 3.300938 11 3/11/2011 30.293478 3.307917 12 3/12/2011 28.145833 3.318958 13 3/13/2011 28.15625 3.307283 14 3/14/2011 25.59375 3.282604 15 3/15/2011 27.84375 3.322604 16 3/16/2011 29.885417 3.523646 17 3/17/2011 53.854167 3.475312 18 3/18/2011 126.260417 3.394375 19 3/19/2011 144.947917 3.556979 20 3/20/2011 114.4375 3.538229 21 3/21/2011 79.572917 3.836354 22 3/22/2011 58.541667 3.78125 23 3/23/2011 46.354167 3.609783 24 3/24/2011 48.020833 3.823958 25 3/25/2011 41.8125 3.93375 26 3/26/2011 40.072917 3.928021 27 3/27/2011 34.822917 3.758646 28 3/28/2011 35.177083 3.523804 29 3/29/2011 35.604167 3.495417 30 3/30/2011 46.447917 3.5425 31 3/31/2011 67.583333 3.645313 1 4/1/2011 63.395833 3.876667 2 4/2/2011 56.739583 4.102917 3 4/3/2011 55.520833 4.058542 4 4/4/2011 65.9375 4.052917 5 4/5/2011 59.395833 4.214583 6 4/6/2011 55.479167 4.274062 7 4/7/2011 51.364583 4.166771 8 4/8/2011 53.53125 3.938229 9 4/9/2011 60.729167 3.815521 10 4/10/2011 66.3125 3.719375 11 4/11/2011 61.572917 3.715833 12 4/12/2011 53.864583 3.740104 13 4/13/2011 58.854167 3.750521 14 4/14/2011 60.520833 3.677292 15 4/15/2011 55.416667 3.705313 16 4/16/2011 135.239583 4.006458 17 4/17/2011 204.84375 4.355417 18 4/18/2011 252.1875 4.546563 19 4/19/2011 243.302083 4.513021 20 4/20/2011 235.322917 4.481146 21 4/21/2011 178.708333 4.243958 22 4/22/2011 147.760417 4.088333 23 4/23/2011 131.947917 3.997604 24 4/24/2011 119.052083 3.916667 25 4/25/2011 113.8125 3.883021 26 4/26/2011 125.583333 3.956979 27 4/27/2011 150.770833 4.097812 28 4/28/2011 193.020833 4.308646 29 4/29/2011 190.739583 4.298542 30 4/30/2011 174.625 4.226146 1 5/1/2011 163.548387 4.172258 2 5/2/2011 185.520833 4.272188 3 5/3/2011 248.147727 4.524545 4 5/4/2011 319.666667 4.769167 5 5/5/2011 414 5.036458 6 5/6/2011 505.885417 5.269792 7 5/7/2011 491.479167 5.239583 8 5/8/2011 442.979167 5.119271 9 5/9/2011 301.645833 4.716562 10 5/10/2011 233.583333 4.47625 11 5/11/2011 224.34375 4.436146 12 5/12/2011 314.652174 4.748043 13 5/13/2011 441.71875 5.108021 14 5/14/2011 487.416667 5.230833 15 5/15/2011 396.875 4.999688 16 5/16/2011 290.885417 4.682187 17 5/17/2011 235.927083 4.485521 18 5/18/2011 204.875 4.360313 19 5/19/2011 176.885417 4.237396 20 5/20/2011 183.416667 4.262292 21 5/21/2011 247.479167 4.525521 22 5/22/2011 304.979167 4.72875 23 5/23/2011 323.291667 4.7875 24 5/24/2011 335.166667 4.822708 25 5/25/2011 355.6875 4.885729 26 5/26/2011 342.947917 4.846458 27 5/27/2011 415.135417 5.040208 28 5/28/2011 462.09375 5.169063 29 5/29/2011 348.25 4.861771 30 5/30/2011 271.635417 4.617188 31 5/31/2011 252.09375 4.546146 1 6/1/2011 251.9375 4.546458 2 6/2/2011 228.104167 4.455313 3 6/3/2011 226.15625 4.447708 4 6/4/2011 220.947917 4.426979 5 6/5/2011 291.979167 4.680104 6 6/6/2011 319.614583 4.775833 7 6/7/2011 330.125 4.805313 8 6/8/2011 434.916667 5.086563 9 6/9/2011 557.489583 5.385208 10 6/10/2011 646.145833 5.567396 11 6/11/2011 700.510417 5.679063 12 6/12/2011 723.927083 5.715313 13 6/13/2011 857.614583 5.948438 14 6/14/2011 952.145833 6.102292 15 6/15/2011 1027.229167 6.2125 16 6/16/2011 1090.708333 6.306875 17 6/17/2011 941.729167 6.086146 18 6/18/2011 871.322917 5.976354 19 6/19/2011 953.885417 6.106146 20 6/20/2011 927.46875 6.065 21 6/21/2011 978.635417 6.141563 22 6/22/2011 1058.3125 6.260625 23 6/23/2011 1186.53125 6.43375 24 6/24/2011 1101.625 6.31875 25 6/25/2011 895.947917 6.01625 26 6/26/2011 792.78125 5.845729 27 6/27/2011 784.510417 5.83 28 6/28/2011 883.416667 5.996875 29 6/29/2011 1184.15625 6.430833 30 6/30/2011 743.78125 5.753542 1 7/1/2011 662.354167 5.604688 2 7/2/2011 748.625 5.763958 3 7/3/2011 853.489583 5.947604 4 7/4/2011 871.145833 5.97375 5 7/5/2011 928.958333 6.06875 6 7/6/2011 833.4375 5.916458 7 7/7/2011 833.421053 5.916421 8 7/8/2011 792.260417 5.845417 9 7/9/2011 749.21875 5.769792 10 7/10/2011 680.697917 5.640833 11 7/11/2011 571.697917 5.422187 12 7/12/2011 525.625 5.320937 13 7/13/2011 496.791667 5.255104 14 7/14/2011 465.104167 5.179167 15 7/15/2011 454.6875 5.153333 16 7/16/2011 436.697917 5.107604 17 7/17/2011 404.166667 5.022292 18 7/18/2011 386 4.972604 19 7/19/2011 380.9375 4.958437 20 7/20/2011 363.239583 4.907917 21 7/21/2011 363.395833 4.908125 22 7/22/2011 353.1875 4.87875 23 7/23/2011 375.791667 4.943958 24 7/24/2011 394.229167 4.995104 25 7/25/2011 373.145833 4.935208 26 7/26/2011 333.59375 4.819062 27 7/27/2011 311.354167 4.75 28 7/28/2011 310.0625 4.745625 29 7/29/2011 326.635417 4.798125 30 7/30/2011 372.322917 4.933438 31 7/31/2011 402.989583 5.019271 1 8/1/2011 351.510417 4.871979 2 8/2/2011 300.84375 4.715 3 8/3/2011 264.40625 4.591042 4 8/4/2011 239.260417 4.497813 5 8/5/2011 218.052083 4.414583 6 8/6/2011 198.4375 4.333229 7 8/7/2011 188.479167 4.288958 8 8/8/2011 179.260417 4.247396 9 8/9/2011 172.854167 4.217187 10 8/10/2011 168.46875 4.19625 11 8/11/2011 158.604167 4.146667 12 8/12/2011 156.552083 4.136146 13 8/13/2011 152.145833 4.112708 14 8/14/2011 150.135417 4.102292 15 8/15/2011 155.604167 4.131042 16 8/16/2011 142.645833 4.058646 17 8/17/2011 125.666667 3.958854 18 8/18/2011 115.270833 3.891563 19 8/19/2011 121.572917 3.932396 20 8/20/2011 127.947917 3.972292 21 8/21/2011 119.3125 3.918229 22 8/22/2011 107.46875 3.840104 23 8/23/2011 101.725275 3.799011 24 8/24/2011 109.947917 3.857708 25 8/25/2011 123.021053 3.941895 26 8/26/2011 123.574468 3.945213 27 8/27/2011 123.260417 3.942708 28 8/28/2011 147.802083 4.089167 29 8/29/2011 135.421053 4.016211 30 8/30/2011 113.197917 3.877292 31 8/31/2011 91.5625 3.72375 1 9/1/2011 81.020833 3.643125 2 9/2/2011 73.677083 3.580104 3 9/3/2011 73.34375 3.578021 4 9/4/2011 71.284211 3.559579 5 9/5/2011 70.393617 3.551383 6 9/6/2011 63.1875 3.480625 7 9/7/2011 59.302083 3.443021 8 9/8/2011 60.552083 3.455521 9 9/9/2011 62.84375 3.478438 10 9/10/2011 70.239583 3.547604 11 9/11/2011 66.5625 3.513125 12 9/12/2011 70.84375 3.555 13 9/13/2011 82.145833 3.649792 14 9/14/2011 74.0625 3.583333 15 9/15/2011 73.15625 3.574792 16 9/16/2011 66.979167 3.517917 17 9/17/2011 60.291667 3.452917 18 9/18/2011 52.510417 3.375104 19 9/19/2011 49.479167 3.3425 20 9/20/2011 52.416667 3.373958 21 9/21/2011 49.65625 3.342813 22 9/22/2011 46.9375 3.309479 23 9/23/2011 43.020833 3.266354 24 9/24/2011 42.75 3.26125 25 9/25/2011 41.166667 3.241771 26 9/26/2011 40.384615 3.232418 27 9/27/2011 39.010417 3.215938 28 9/28/2011 38.4375 3.206771 29 9/29/2011 37.536842 3.195474 30 9/30/2011 37.34375 3.194167 1 10/1/2011 36.385417 3.180729 2 10/2/2011 37.208333 3.192292 3 10/3/2011 40.166667 3.228229 4 10/4/2011 38.260417 3.205208 5 10/5/2011 50.520833 3.348229 6 10/6/2011 50.489583 3.3525 7 10/7/2011 48.71875 3.3325 8 10/8/2011 48.177083 3.326042 9 10/9/2011 51.020833 3.355625 10 10/10/2011 50.416667 3.349167 11 10/11/2011 59.135417 3.441354 12 10/12/2011 59.479167 3.444792 13 10/13/2011 60.979167 3.459792 14 10/14/2011 57.916667 3.429167 15 10/15/2011 49.09375 3.334479 16 10/16/2011 45.604167 3.296042 17 10/17/2011 40.75 3.237812 18 10/18/2011 36.666667 3.183542 19 10/19/2011 34.40625 3.150417 20 10/20/2011 31.78125 3.112396 21 10/21/2011 33.322917 3.135625 22 10/22/2011 29.59375 3.078542 23 10/23/2011 26.494737 3.027053 24 10/24/2011 25.12766 3.007021 25 10/25/2011 25.543478 3.011087 26 10/26/2011 24.489583 2.994687 27 10/27/2011 23.395833 2.973854 28 10/28/2011 22.84375 2.960208 29 10/29/2011 22 2.946562 30 10/30/2011 21.583333 2.935833 31 10/31/2011 20.239583 2.922396 1 11/1/2011 20 2.916042 2 11/2/2011 19.541667 2.895729 3 11/3/2011 19.447917 2.894062 4 11/4/2011 20.46875 2.918854 5 11/5/2011 23.802083 2.978542 6 11/6/2011 22.79 2.9635 7 11/7/2011 24.5 2.990833 8 11/8/2011 25.041667 2.998542 9 11/9/2011 24.927083 2.999375 10 11/10/2011 23.177083 2.968438 11 11/11/2011 21.114583 2.931875 12 11/12/2011 22.375 2.951771 13 11/13/2011 22.135417 2.949375 14 11/14/2011 21.947917 2.941042 15 11/15/2011 21.604167 2.939062 16 11/16/2011 20.6875 2.928125 17 11/17/2011 20.71875 2.92625 18 11/18/2011 20 2.911875 19 11/19/2011 18.3125 2.872292 20 11/20/2011 18.416667 2.87375 21 11/21/2011 23.625 2.976146 22 11/22/2011 24.479167 2.992812 23 11/23/2011 22.84375 2.964062 24 11/24/2011 20.40625 2.91875 25 11/25/2011 21.135417 2.930625 26 11/26/2011 21.291667 2.932292 27 11/27/2011 19.46875 2.894271 28 11/28/2011 20.520833 2.915208 29 11/29/2011 21.427083 2.932708 30 11/30/2011 20.614583 2.916771 1 12/1/2011 14.654167 2.790312 2 12/2/2011 20.46875 2.915 3 12/3/2011 20.135417 2.910937 4 12/4/2011 18.666667 2.878438 5 12/5/2011 19.15625 2.891667 6 12/6/2011 19.458333 2.895833 7 12/7/2011 18.229167 2.870521 8 12/8/2011 18.958333 2.885625 9 12/9/2011 18.375 2.874271 10 12/10/2011 18.947917 2.886146 11 12/11/2011 18.833333 2.882604 12 12/12/2011 18.4375 2.873437 13 12/13/2011 15.979167 2.823229 14 12/14/2011 16.395833 2.832917 15 12/15/2011 16.239583 2.828333 16 12/16/2011 16.645833 2.836354 17 12/17/2011 16.322917 2.828542 18 12/18/2011 17.385417 2.850625 19 12/19/2011 18.229167 2.868854 20 12/20/2011 16.145833 2.824063 21 12/21/2011 14.635417 2.789688 22 12/22/2011 17.833333 2.855625 23 12/23/2011 13.885417 2.773854 24 12/24/2011 13.6875 2.769167 25 12/25/2011 14.395833 2.781979 26 12/26/2011 16.145833 2.823333 27 12/27/2011 16.09375 2.820937 28 12/28/2011 15.197917 2.802812 29 12/29/2011 15 2.793854 30 12/30/2011 16.395833 2.829688 31 12/31/2011 17.8125 2.860208 1 1/1/2012 16.729167 2.837292 2 1/2/2012 16.4375 2.82875 3 1/3/2012 15.5625 2.808229 4 1/4/2012 16.21875 2.823646 5 1/5/2012 15.895833 2.816042 6 1/6/2012 17.760417 2.855417 7 1/7/2012 16.260417 2.824896 8 1/8/2012 16.75 2.835208 9 1/9/2012 13.395833 2.764375 10 1/10/2012 15.739583 2.814896 11 1/11/2012 15.479167 2.808542 12 1/12/2012 15.270833 2.802604 13 1/13/2012 14.227083 2.777604 14 1/14/2012 14.795833 2.793646 15 1/15/2012 14.065625 2.774167 16 1/16/2012 17.083333 2.837917 17 1/17/2012 12.85 2.744792 18 1/18/2012 12 2.726458 19 1/19/2012 12.447917 2.739167 20 1/20/2012 14.304348 2.779891 21 1/21/2012 22.385417 2.954687 22 1/22/2012 23.916667 2.983229 23 1/23/2012 44.041667 3.263021 24 1/24/2012 50.916667 3.359063 25 1/25/2012 65.208333 3.483437 26 1/26/2012 69.46875 3.542604 27 1/27/2012 57.677083 3.426771 28 1/28/2012 44.71875 3.278854 29 1/29/2012 33.90625 3.140938 30 1/30/2012 28.916667 3.069167 31 1/31/2012 26.916667 3.033229 1 2/1/2012 24.75 2.998021 2 2/2/2012 25.385417 3.0075 3 2/3/2012 24.114583 2.982708 4 2/4/2012 23.510417 2.972396 5 2/5/2012 22.479167 2.955833 6 2/6/2012 22.5625 2.955521 7 2/7/2012 71.094118 3.450235 8 2/8/2012 71.326316 3.495684 9 2/9/2012 50.811111 3.303333 10 2/10/2012 29.239583 3.057396 11 2/11/2012 33.684783 3.089783 12 2/12/2012 18.1875 2.870625 13 2/13/2012 19.489583 2.896042 14 2/14/2012 19.552083 2.896354 15 2/15/2012 20.15625 2.910208 16 2/16/2012 20.375 2.917083 17 2/17/2012 24.447917 2.976458 18 2/18/2012 21.5625 2.933438 19 2/19/2012 18.90625 2.883646 20 2/20/2012 18.53125 2.875 21 2/21/2012 19.03125 2.885521 22 2/22/2012 18.291667 2.869271 23 2/23/2012 19.479167 2.895312 24 2/24/2012 21.041667 2.926458 25 2/25/2012 21.864583 2.948229 26 2/26/2012 23.145833 2.965625 27 2/27/2012 20.40625 2.915208 28 2/28/2012 21.03125 2.927917 29 2/29/2012 24.90625 2.994687 1 3/1/2012 55.416667 3.392187 2 3/2/2012 42.385417 3.239375 3 3/3/2012 26.25 3.022292 4 3/4/2012 28.458333 3.060833 5 3/5/2012 36.989583 3.161042 6 3/6/2012 27.864583 3.050729 7 3/7/2012 30.197917 3.086354 8 3/8/2012 28.489583 3.055625 9 3/9/2012 29.28125 3.066771 10 3/10/2012 30.6875 3.095208 11 3/11/2012 30.293478 3.090435 12 3/12/2012 28.145833 3.055729 13 3/13/2012 28.15625 3.055833 14 3/14/2012 25.59375 3.015937 15 3/15/2012 27.84375 3.049688 16 3/16/2012 29.885417 3.082292 17 3/17/2012 53.854167 3.366562 18 3/18/2012 126.260417 3.955417 19 3/19/2012 144.947917 4.070208 20 3/20/2012 114.4375 3.879063 21 3/21/2012 79.572917 3.621667 22 3/22/2012 58.541667 3.435417 23 3/23/2012 46.354167 3.304583 24 3/24/2012 48.020833 3.323125 25 3/25/2012 41.8125 3.251771 26 3/26/2012 40.072917 3.228333 27 3/27/2012 34.822917 3.158438 28 3/28/2012 35.177083 3.160729 29 3/29/2012 35.604167 3.168229 30 3/30/2012 46.447917 3.296458 31 3/31/2012 67.583333 3.525833 1 4/1/2012 63.395833 3.483333 2 4/2/2012 56.739583 3.416875 3 4/3/2012 55.520833 3.405208 4 4/4/2012 65.9375 3.509375 5 4/5/2012 59.395833 3.443958 6 4/6/2012 55.479167 3.40125 7 4/7/2012 51.364583 3.358542 8 4/8/2012 53.53125 3.383333 9 4/9/2012 60.729167 3.455833 10 4/10/2012 66.3125 3.512812 11 4/11/2012 61.572917 3.465729 12 4/12/2012 53.864583 3.388646 13 4/13/2012 58.854167 3.438542 14 4/14/2012 60.520833 3.455208 15 4/15/2012 55.416667 3.404167 16 4/16/2012 62.052083 3.468646 17 4/17/2012 84.84375 3.664688 18 4/18/2012 113.40625 3.876875 19 4/19/2012 148.010417 4.075729 20 4/20/2012 222.40625 4.421562 21 4/21/2012 286.708333 4.658542 22 4/22/2012 347.666667 4.849792 23 4/23/2012 401.135417 5.006771 24 4/24/2012 423.104167 5.068229 25 4/25/2012 393.354167 4.988333 26 4/26/2012 462.395833 5.172396 27 4/27/2012 336.114583 4.825625 28 4/28/2012 291.34375 4.682813 29 4/29/2012 303.958333 4.722396 30 4/30/2012 323.5625 4.785208 1 5/1/2012 368.59375 4.920729 2 5/2/2012 371.364583 4.930104 3 5/3/2012 352.072917 4.874792 4 5/4/2012 297.791667 4.704687 5 5/5/2012 253.645833 4.552188 6 5/6/2012 228.927083 4.458646 7 5/7/2012 218.65625 4.417083 8 5/8/2012 221 4.424896 9 5/9/2012 266.125 4.5925 10 5/10/2012 325.958333 4.793646 11 5/11/2012 347.666667 4.861458 12 5/12/2012 346.791667 4.857396 13 5/13/2012 360.489583 4.898542 14 5/14/2012 386.270833 4.971667 15 5/15/2012 346.354167 4.856458 16 5/16/2012 336.645833 4.826979 17 5/17/2012 354.833333 4.882188 18 5/18/2012 296.40625 4.700417 19 5/19/2012 270.645833 4.611667 20 5/20/2012 304.802083 4.727188 21 5/21/2012 325.197917 4.792396 22 5/22/2012 325.833333 4.794271 23 5/23/2012 313.520833 4.755312 24 5/24/2012 265.677083 4.594375 25 5/25/2012 216.354167 4.406875 26 5/26/2012 157 4.135729 27 5/27/2012 122.458333 3.937292 28 5/28/2012 108.09375 3.844583 29 5/29/2012 109.135417 3.850938 30 5/30/2012 137.625 4.030208 31 5/31/2012 166.052083 4.183125 1 6/1/2012 199.84375 4.338333 2 6/2/2012 217.104167 4.410208 3 6/3/2012 210.739583 4.383958 4 6/4/2012 218.145833 4.413854 5 6/5/2012 188.427083 4.284792 6 6/6/2012 139.072917 4.038125 7 6/7/2012 121.510417 3.931979 8 6/8/2012 123.71875 3.946979 9 6/9/2012 126.270833 3.961875 10 6/10/2012 113.697917 3.881563 11 6/11/2012 104.5625 3.819583 12 6/12/2012 102.791667 3.807187 13 6/13/2012 101.84375 3.800417 14 6/14/2012 104.53125 3.819792 15 6/15/2012 112.447917 3.873021 16 6/16/2012 106.510417 3.833438 17 6/17/2012 107.614583 3.84125 18 6/18/2012 107.385417 3.838438 19 6/19/2012 100.864583 3.793229 20 6/20/2012 94.15625 3.743229 21 6/21/2012 90.28125 3.714375 22 6/22/2012 90.270833 3.714687 23 6/23/2012 75.052083 3.590937 24 6/24/2012 61.608696 3.466087 25 6/25/2012 54.48913 3.394891 26 6/26/2012 50.6875 3.355729 27 6/27/2012 48.208333 3.327292 28 6/28/2012 48.336957 3.327065 29 6/29/2012 49.114583 3.337083 30 6/30/2012 50.666667 3.355729 1 7/1/2012 57.25 3.4225 2 7/2/2012 61.375 3.463542 3 7/3/2012 66.520833 3.515 4 7/4/2012 66.895833 3.518958 5 7/5/2012 63.177083 3.481771 6 7/6/2012 62.875 3.47875 7 7/7/2012 58.645833 3.436458 8 7/8/2012 63.614583 3.486146 9 7/9/2012 64.8125 3.497813 10 7/10/2012 68.28125 3.530104 11 7/11/2012 73.1875 3.574271 12 7/12/2012 72.822917 3.571562 13 7/13/2012 70.864583 3.553646 14 7/14/2012 71.572917 3.560729 15 7/15/2012 61.364583 3.463021 16 7/16/2012 53.03125 3.379271 17 7/17/2012 49.541667 3.339583 18 7/18/2012 45.833333 3.298437 19 7/19/2012 43.416667 3.26875 20 7/20/2012 36.729167 3.184271 21 7/21/2012 36.333333 3.178854 22 7/22/2012 41.8125 3.248854 23 7/23/2012 46.75 3.307708 24 7/24/2012 49.072917 3.335104 25 7/25/2012 46.145833 3.30125 26 7/26/2012 41.625 3.248229 27 7/27/2012 35.585106 3.165 28 7/28/2012 32.25 3.118437 29 7/29/2012 30.760417 3.095208 30 7/30/2012 28.708333 3.064063 31 7/31/2012 28.885417 3.068958 1 8/1/2012 32.385417 3.121458 2 8/2/2012 34.270833 3.149062 3 8/3/2012 34.1875 3.147292 4 8/4/2012 33.8125 3.141771 5 8/5/2012 34.6875 3.156146 6 8/6/2012 32.822917 3.125833 7 8/7/2012 31.239583 3.103125 8 8/8/2012 32.354167 3.120833 9 8/9/2012 35.1875 3.163229 10 8/10/2012 37.395833 3.193333 11 8/11/2012 38.802083 3.218854 12 8/12/2012 43.427083 3.278333 13 8/13/2012 56.5625 3.424062 14 8/14/2012 56.03125 3.420313 15 8/15/2012 65.520833 3.514896 16 8/16/2012 54.166667 3.401146 17 8/17/2012 45.239583 3.299062 18 8/18/2012 40.1875 3.239792 19 8/19/2012 49.697917 3.353958 20 8/20/2012 47.552083 3.329375 21 8/21/2012 42.520833 3.270521 22 8/22/2012 41.59375 3.256875 23 8/23/2012 41.708333 3.259479 24 8/24/2012 38.041667 3.211458 25 8/25/2012 33.583333 3.147292 26 8/26/2012 33.09375 3.141042 27 8/27/2012 28.21875 3.067917 28 8/28/2012 24.447917 3.005208 29 8/29/2012 21.375 2.944375 30 8/30/2012 19.854167 2.915313 31 8/31/2012 19.677083 2.912604 1 9/1/2012 19.427083 2.909688 2 9/2/2012 19.28125 2.905 3 9/3/2012 18.947917 2.898333 4 9/4/2012 19.145833 2.905 5 9/5/2012 17.34375 2.875 6 9/6/2012 16.177083 2.849167 7 9/7/2012 16.875 2.870937 8 9/8/2012 19.302083 2.916875 9 9/9/2012 21.520833 2.957187 10 9/10/2012 20.447917 2.936562 11 9/11/2012 24.71875 3.015625 12 9/12/2012 21.385417 2.954792 13 9/13/2012 19.364583 2.918437 14 9/14/2012 16.145833 2.848125 15 9/15/2012 15.291667 2.833125 16 9/16/2012 13.572917 2.793542 17 9/17/2012 13.333333 2.789063 18 9/18/2012 11.875 2.751875 19 9/19/2012 10.388542 2.711354 20 9/20/2012 9.876042 2.701875 21 9/21/2012 9.71875 2.694375 22 9/22/2012 9.684375 2.692812 23 9/23/2012 9.64375 2.691458 24 9/24/2012 9.229167 2.678854 25 9/25/2012 9.0625 2.674062 26 9/26/2012 9.101042 2.674688 27 9/27/2012 8.786458 2.666042 28 9/28/2012 8.503125 2.656771 29 9/29/2012 8.3 2.65 30 9/30/2012 8.3 8.075Explanation / Answer
This "should" work. Click on the scatterplot to select it. Click on the Chart menu and choose Add Trendline. Choose Linear for Trend/Regression Type, then click on the Options tab at the top of the dialog box. Select Automatic under Trendline name . Check the boxes for Display equation on chart and Display R-Squared value on chart if desired. Click OK
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.