Spreadsheet: 39999d1238275390-cant-understand-trendline-equation-rough6
Sheet: Sheet1

 |  | Date | Close
 |  | 2009-03-02 00:00:00 | 722.51 | 901.8433333333336
 |  | 2009-02-02 00:00:00 | 632.2 | 932.5825000000001
 |  | 2009-01-02 00:00:00 | 654.18 | 968.5266666666668
 |  | 2008-12-01 00:00:00 | 683.9 | 1018.444166666667
 |  | 2008-11-03 00:00:00 | 671.78 | 1066.665833333333
 |  | 2008-10-01 00:00:00 | 768.77 | 1115.3325
 |  | 2008-09-02 00:00:00 | 907.54 | 1140.866666666667
 |  | 2008-08-01 00:00:00 | 1070.2 | 1148.485833333333
 |  | 2008-07-01 00:00:00 | 1043.17 | 1156.63
 |  | 2008-06-02 00:00:00 | 1074.42 | 1163.14
 |  | 2008-05-01 00:00:00 | 1175.91 | 1160.168333333333
 |  | 2008-04-01 00:00:00 | 1115.67 | 1158.705833333333
 |  | 2008-03-03 00:00:00 | 1024.38 | 1160.544166666667 |  | Year | Number of New US Students in Fall | 12 Month Moving Average | 12 Month to New Students Ratio
 |  | 2008-02-01 00:00:00 | 1001.07 | 1163.813333333333 |  | 2007-09-01 00:00:00 | 7915 | 1085 | 7.294930875576036
 |  | 2008-01-02 00:00:00 | 1085.51 | 1162.879166666666 |  | 2006-09-01 00:00:00 | 7840 | 966 | 8.115942028985508
 |  | 2007-12-03 00:00:00 | 1282.91 | 1143.704166666666 |  | 2005-09-01 00:00:00 | 7952 | 918 | 8.662309368191721
 |  | 2007-11-01 00:00:00 | 1250.44 | 1129.485 |  | 2004-09-01 00:00:00 | 9751 | 889 | 10.96850393700787
 |  | 2007-10-01 00:00:00 | 1352.77 | 1103.435 |  | 2003-09-01 00:00:00 | 11475 | 678 | 16.92477876106195
 |  | 2007-09-04 00:00:00 | 1213.95 | 1084.813333333333 |  | 2002-09-01 00:00:00 | 11943 | 807 | 14.79925650557621
 |  | 2007-08-01 00:00:00 | 1161.63 | 1066.749166666667 |  | 2001-09-01 00:00:00 | 14559 | 1280 | 11.37421875
 |  | 2007-07-02 00:00:00 | 1140.9 | 1045.975833333333 |  | 2000-09-01 00:00:00 | 18956 | 2184 | 8.679487179487179
 |  | 2007-06-01 00:00:00 | 1152.54 | 1026.411666666667 |  | 1999-09-01 00:00:00 | 15989 | 1206 | 13.25787728026534
 |  | 2007-05-01 00:00:00 | 1140.25 | 1007.115 |  | 1998-09-01 00:00:00 | 13936 | 734 | 18.98637602179836
 |  | 2007-04-02 00:00:00 | 1098.12 | 998.4633333333335 |  | 1997-09-02 00:00:00 | 13697 | 558 | 24.54659498207885
 |  | 2007-03-01 00:00:00 | 1046.44 | 994.9099999999999 |  | 1996-09-03 00:00:00 | 11377 | 397 | 28.65743073047859
 |  | 2007-02-01 00:00:00 | 1040.3 | 990.8183333333333 |  | 1995-09-01 00:00:00 | 9885 | 309 | 31.99029126213592
 |  | 2007-01-03 00:00:00 | 1074.3 | 987.2174999999999 |  | 1994-09-01 00:00:00 | 9041 | 280 | 32.28928571428571
 |  | 2006-12-01 00:00:00 | 1052.81 | 982.1333333333336
 |  | 2006-11-01 00:00:00 | 1079.81 | 976.2216666666668
 |  | 2006-10-02 00:00:00 | 1040.17 | 968.7800000000001
 |  | 2006-09-01 00:00:00 | 990.49 | 965.6891666666667
 |  | 2006-08-01 00:00:00 | 944.86 | 966.9916666666668
 |  | 2006-07-03 00:00:00 | 891.62 | 973.1441666666668
 |  | 2006-06-01 00:00:00 | 917.77 | 973.5791666666668
 |  | 2006-05-01 00:00:00 | 908.69 | 976.6858333333333
 |  | 2006-04-03 00:00:00 | 994.3 | 965.8058333333332
 |  | 2006-03-01 00:00:00 | 1003.8 | 956.5758333333333
 |  | 2006-02-01 00:00:00 | 991.2 | 951.1749999999998
 |  | 2006-01-03 00:00:00 | 1031.09 | 942.3633333333332
 |  | 2005-12-01 00:00:00 | 991.8 | 940.1541666666666
 |  | 2005-11-01 00:00:00 | 1008.87 | 934.045
 |  | 2005-10-03 00:00:00 | 950.87 | 928.0166666666668
 |  | 2005-09-01 00:00:00 | 953.4 | 917.5375
 |  | 2005-08-01 00:00:00 | 960.49 | 903.9716666666668
 |  | 2005-07-01 00:00:00 | 965.45 | 894.2325000000001
 |  | 2005-06-01 00:00:00 | 922.99 | 894.7599999999999
 |  | 2005-05-02 00:00:00 | 945.97 | 890.2483333333331
 |  | 2005-04-01 00:00:00 | 863.74 | 889.0091666666666
 |  | 2005-03-01 00:00:00 | 893.04 | 888.5374999999999
 |  | 2005-02-01 00:00:00 | 926.39 | 887.3366666666665
 |  | 2005-01-03 00:00:00 | 925.35 | 889.7433333333332
 |  | 2004-12-01 00:00:00 | 965.29 | 887.2108333333332
 |  | 2004-11-01 00:00:00 | 935.56 | 885.5208333333334
 |  | 2004-10-01 00:00:00 | 878.53 | 887.7008333333333
 |  | 2004-09-01 00:00:00 | 827.65 | 888.625
 |  | 2004-08-02 00:00:00 | 797.7 | 892.3233333333332
 |  | 2004-07-01 00:00:00 | 848.58 | 888.32
 |  | 2004-06-01 00:00:00 | 929.32 | 873.0425
 |  | 2004-05-03 00:00:00 | 891.83 | 859.7699999999999
 |  | 2004-04-01 00:00:00 | 848.87 | 845.3916666666668
 |  | 2004-03-01 00:00:00 | 887.38 | 822.7391666666666
 |  | 2004-02-02 00:00:00 | 911.98 | 798.9616666666666
 |  | 2004-01-02 00:00:00 | 954.23 | 770.2558333333333
 |  | 2003-12-01 00:00:00 | 934.9 | 744.2308333333332
 |  | 2003-11-03 00:00:00 | 915.28 | 728.2183333333334
 |  | 2003-10-01 00:00:00 | 904.69 | 704.6666666666669
 |  | 2003-09-02 00:00:00 | 838.74 | 678.0483333333333
 |  | 2003-08-01 00:00:00 | 842.08 | 659.0033333333333
 |  | 2003-07-01 00:00:00 | 800.54 | 644.0500000000001
 |  | 2003-06-02 00:00:00 | 745.99 | 638.7125
 |  | 2003-05-01 00:00:00 | 732.56 | 640.7624999999999
 |  | 2003-04-01 00:00:00 | 676.33 | 650.5958333333333
 |  | 2003-03-03 00:00:00 | 615.55 | 674.8375
 |  | 2003-02-03 00:00:00 | 626.65 | 693.8158333333334
 |  | 2003-01-02 00:00:00 | 609.76 | 726.695
 |  | 2002-12-02 00:00:00 | 622.6 | 756.5183333333333
 |  | 2002-11-01 00:00:00 | 723.13 | 777.735
 |  | 2002-10-01 00:00:00 | 622.07 | 794.3658333333333 |  | there appears to be a medium negative correlation between time and
 |  | 2002-09-03 00:00:00 | 519.32 | 807.3716666666664
 |  | 2002-08-01 00:00:00 | 613.54 | 827.0349999999999
 |  | 2002-07-01 00:00:00 | 621.1 | 859.3383333333333
 |  | 2002-06-03 00:00:00 | 681.94 | 892.8199999999998
 |  | 2002-05-01 00:00:00 | 757.16 | 916.1316666666667
 |  | 2002-04-01 00:00:00 | 794.33 | 938.3666666666667
 |  | 2002-03-01 00:00:00 | 906.45 | 936.8299999999999
 |  | 2002-02-04 00:00:00 | 854.39 | 955.2275
 |  | 2002-01-02 00:00:00 | 1004.31 | 994.5333333333333
 |  | 2001-12-03 00:00:00 | 980.48 | 1020.740833333333
 |  | 2001-11-01 00:00:00 | 977.73 | 1062.549166666666
 |  | 2001-10-01 00:00:00 | 821.64 | 1159.646666666667
 |  | 2001-09-04 00:00:00 | 675.39 | 1280.321666666666
 |  | 2001-08-01 00:00:00 | 849.5 | 1420.3625
 |  | 2001-07-02 00:00:00 | 1008.74 | 1523.2875
 |  | 2001-06-01 00:00:00 | 1083.72 | 1628.308333333333
 |  | 2001-05-01 00:00:00 | 1036.9 | 1706.54
 |  | 2001-04-02 00:00:00 | 1061.15 | 1805.935833333334
 |  | 2001-03-01 00:00:00 | 888.01 | 1957.040833333333
 |  | 2001-02-01 00:00:00 | 1075.16 | 2089.696666666667
 |  | 2001-01-02 00:00:00 | 1475.98 | 2151.070833333333
 |  | 2000-12-01 00:00:00 | 1294.97 | 2236.94
 |  | 2000-11-01 00:00:00 | 1479.43 | 2266.490833333333
 |  | 2000-10-02 00:00:00 | 1986.81 | 2235.4
 |  | 2000-09-01 00:00:00 | 2123.49 | 2183.758333333334
 |  | 2000-08-01 00:00:00 | 2529.99 | 2097.474166666667
 |  | 2000-07-03 00:00:00 | 2243.84 | 2024.2475 |  | y = 2E-19x6 - 5E-14x5 + 4E-09x4 - 0.0002x3 + 5.9498x2 - 86834x + 5E+08
 |  | 2000-06-01 00:00:00 | 2343.97 | 1944.445
 |  | 2000-05-01 00:00:00 | 1975.68 | 1882.714999999999
 |  | 2000-04-03 00:00:00 | 2253.9 | 1803.125833333334
 |  | 2000-03-01 00:00:00 | 2701.27 | 1686.770833333333
 |  | 2000-02-01 00:00:00 | 2667.03 | 1563.999166666666
 |  | 2000-01-03 00:00:00 | 2212.47 | 1493.943333333333
 |  | 1999-12-01 00:00:00 | 2325.4 | 1394.675833333333
 |  | 1999-11-01 00:00:00 | 1834.04 | 1323.544166666667
 |  | 1999-10-01 00:00:00 | 1613.72 | 1260.5475
 |  | 1999-09-01 00:00:00 | 1503.79 | 1206.355833333333
 |  | 1999-08-02 00:00:00 | 1494.58 | 1141.290833333333
 |  | 1999-07-01 00:00:00 | 1365.12 | 1099.076666666667
 |  | 1999-06-01 00:00:00 | 1386.34 | 1054.304166666667 |  |  |  |  |  |  |  | 2008-09-01 00:00:00 | 1900-01-01 00:00:00
 |  | 1999-05-03 00:00:00 | 1234.92 | 1013.300833333333
 |  | 1999-04-01 00:00:00 | 1298.83 | 971.5558333333332
 |  | 1999-03-01 00:00:00 | 1305.01 | 927.2208333333332
 |  | 1999-02-01 00:00:00 | 1193.77 | 891.1816666666665
 |  | 1999-01-04 00:00:00 | 1371.8 | 833.1725
 |  | 1998-12-01 00:00:00 | 1134.19 | 790.2116666666667
 |  | 1998-11-02 00:00:00 | 980.46 | 763.9191666666667
 |  | 1998-10-01 00:00:00 | 857.76 | 746.8508333333334
 |  | 1998-09-01 00:00:00 | 853.49 | 734.3041666666667
 |  | 1998-08-03 00:00:00 | 713.8 | 732.1166666666667
 |  | 1998-07-01 00:00:00 | 858.55 | 718.6908333333332
 |  | 1998-06-01 00:00:00 | 849.07 | 697.3933333333334
 |  | 1998-05-01 00:00:00 | 742.88 | 685.0491666666667
 |  | 1998-04-01 00:00:00 | 797.89 | 663.5458333333335
 |  | 1998-03-02 00:00:00 | 772.99 | 639.7700000000001 |  | EXTENDING THE GRAPH
 |  | 1998-02-02 00:00:00 | 761.3 | 619.8758333333334
 |  | 1998-01-02 00:00:00 | 675.69 | 612.1408333333333
 |  | 1997-12-01 00:00:00 | 618.66 | 603.8183333333333
 |  | 1997-11-03 00:00:00 | 664.95 | 592.0825
 |  | 1997-10-01 00:00:00 | 652.94 | 577.3291666666665
 |  | 1997-09-02 00:00:00 | 702.93 | 557.7391666666666
 |  | 1997-08-01 00:00:00 | 687.55 | 534.86
 |  | 1997-07-01 00:00:00 | 697.44 | 509.75
 |  | 1997-06-02 00:00:00 | 593.5 | 496.2258333333334
 |  | 1997-05-01 00:00:00 | 594.75 | 484.3491666666667
 |  | 1997-04-01 00:00:00 | 539.85 | 475.2866666666667
 |  | 1997-03-03 00:00:00 | 487.68 | 466.3066666666667
 |  | 1997-02-03 00:00:00 | 522.57 | 455.2733333333334
 |  | 1997-01-02 00:00:00 | 582.87 | 437.1908333333333
 |  | 1996-12-02 00:00:00 | 518.79 | 424.4691666666667
 |  | 1996-11-01 00:00:00 | 524.12 | 412.6833333333333
 |  | 1996-10-01 00:00:00 | 475.9 | 405.5366666666667
 |  | 1996-09-03 00:00:00 | 467.85 | 397.2766666666666
 |  | 1996-08-01 00:00:00 | 413 | 392.9333333333333
 |  | 1996-07-01 00:00:00 | 396.12 | 389.9191666666666
 |  | 1996-06-03 00:00:00 | 431.21 | 382.7950000000001
 |  | 1996-05-01 00:00:00 | 452.23 | 371.7933333333334
 |  | 1996-04-01 00:00:00 | 431.1 | 361.9175
 |  | 1996-03-01 00:00:00 | 379.92 | 355.48
 |  | 1996-02-01 00:00:00 | 390.17 | 347.4633333333334
 |  | 1996-01-02 00:00:00 | 365.88 | 340.2816666666667
 |  | 1995-12-01 00:00:00 | 366.13 | 332.9791666666667 |  |  | WHEN PROJECTing with polynomial trendline the graph goes up
 |  | 1995-11-01 00:00:00 | 382.69 | 324.2466666666667 |  |  | the polynomial isn't appropriate, is papropriate when you're not projecting, but logarithmic is better
 |  | 1995-10-02 00:00:00 | 390.14 | 315.7316666666667 |  |  | what DOES R^2 mean ? Why does it change as I change the different types of regression analysis?
 |  | 1995-09-01 00:00:00 | 368.73 | 308.5933333333333
 |  | 1995-08-01 00:00:00 | 360.88 | 302.15
 |  | 1995-07-01 00:00:00 | 359.95 | 294.4433333333334
 |  | 1995-06-01 00:00:00 | 345.72 | 287.4225000000001
 |  | 1995-05-01 00:00:00 | 320.21 | 283.4291666666667
 |  | 1995-04-03 00:00:00 | 312.59 | 280.0291666666667
 |  | 1995-03-01 00:00:00 | 302.67 | 277.7533333333334
 |  | 1995-02-01 00:00:00 | 293.97 | 277.7158333333334
 |  | 1995-01-03 00:00:00 | 279.7 | 279.1133333333333
 |  | 1994-12-01 00:00:00 | 278.5 | 279.8799999999999
 |  | 1994-11-01 00:00:00 | 277.9 | 280.005
 |  | 1994-10-03 00:00:00 | 287.96 | 280.0591666666667
 |  | 1994-09-01 00:00:00 | 283.07 | 280.0125
 |  | 1994-08-01 00:00:00 | 283.56
 |  | 1994-07-01 00:00:00 | 267.47
 |  | 1994-06-01 00:00:00 | 261.47
 |  | 1994-05-02 00:00:00 | 272.29
 |  | 1994-04-04 00:00:00 | 271.79
 |  | 1994-03-01 00:00:00 | 275.36
 |  | 1994-02-01 00:00:00 | 293.52
 |  | 1994-01-03 00:00:00 | 296.47
 |  | 1993-12-01 00:00:00 | 287.7
 |  | 1993-11-01 00:00:00 | 279.4
 |  | 1993-10-01 00:00:00 | 288.61
 |  | 1993-09-01 00:00:00 | 282.51
 |  |  |  |  |  |  |  |  |  |  |  |  | y = 1E+06e-0.0003x