弦振动实验报告数据处理

Sheet1 N f 1 40.58 a -1.0533333333 2 81.28 b 41.4 3 123.38 r 0.9999523555Sheet2 L 1/L f 0.30 3.3333333333 120.58 0.35 2.8571428571 102.96 a -1.366155362 0.40 2.5 90.06 b 36.5542943621 0.45 2.2222222222 79.76 r 0.9999838201 0.50 2 71.66 0.55 1.8181818182 65.26Sheet3 T f T对数 f对数 1.96 59.76 0.6729444732 4.0903365408 3.92 85.53 1.3660916538 4.4488671916 5.88 104.56 1.7715567619 4.6497610693 a 3.7678923073 k 43.2887292774 7.84 119.56 2.0592388344 4.7838183374 bp 0.4927150949 密度 0.0005336424 -0.0145698101 9.8 133.96 2.2823823857 4.8975412479 r 0.9995744414 -0.0287788313 11.76 143.76 2.4647039425 4.9681452425Sheet4 p f lnp lnf 0.00947 32.32 -4.6596263718 3.4756862337 0.005791 40.58 -5.1514502907 3.7032753344 0.00349 51.78 -5.6578535428 3.9470039743 a 1.1184774411 3.0601913329 -1.0058851714 0.001911 71.66 -6.2601286137 4.2719327119 b -0.5029425857 0.000979 99.94 -6.9289789154 4.6045700059 r -0.9998130289 0.000549 133.96 -7.5074121165 4.8975412479Sheet5 L T p 50 1.96 0.00947 14.3864303071 0.0275602113 0.0326964325 1.96 0.005791 18.3971798159 0.0352436395 0.0418117723 3.92 0.00947 20.3454848544 0.0389760246 0.0462397383 1.96 0.00349 23.6981979173 0.0453988466 0.0538595407 0.0019157088 5.88 0.00947 24.9180282314 0.0477356863 0.0566318823 3.92 0.005791 26.017541205 0.049842033 0.0591307755 7.84 0.00947 28.7728606141 0.0551204226 0.065392865 5.88 0.005791 31.864850157 0.0610437742 0.072420114 0.00947 1.96 0.001911 32.025630761 0.0613517831 0.0727855245 0.005791 9.8 0.00947 32.1690361202 0.061626506 0.0731114457 0.00349 3.92 0.00349 33.5143128984 0.0642036646 0.076168893 0.001911 11.76 0.00947 35.2394134724 0.0675084549 0.0800895761 0.000979 7.84 0.005791 36.7943596317 0.070487279 0.0836235446 0.000549 5.88 0.00349 41.0464828406 0.0786331089 0.093287461 9.8 0.005791 41.1373446625 0.0788071737 0.0934939651 1.96 0.000979 44.744194047 0.0857168468 0.1016913501 11.76 0.005791 45.0637032551 0.0863289334 0.1024175074 3.92 0.001911 45.2910813658 0.0867645237 0.1029342758 7.84 0.00349 47.3963958346 0.0907976932 0.1077190814 9.8 0.00349 52.9907814873 0.1015149071 0.1204335943 5.88 0.001911 55.4700196225 0.1062644054 0.1260682264 11.76 0.00349 58.0484927209 0.111204009 0.1319283925 1.96 0.000549 59.7505439687 0.1144646436 0.1357966908 3.92 0.000979 63.2778460588 0.1212219273 0.1438132865 7.84 0.001911 64.051261522 0.1227035661 0.1455710489 9.8 0.001911 71.6114874039 0.1371867575 0.1627533805 5.88 0.000979 77.4992174332 0.1484659338 0.1761345851 11.76 0.001911 78.4464540553 0.1502805633 0.1782873956 3.92 0.000549 84.5000296397 0.1618774514 0.1920455219 7.84 0.000979 89.4883880941 0.1714336937 0.2033827002 9.8 0.000979 100.0510594876 0.1916686963 0.2273887716 5.88 0.000549 103.4909779336 0.1982585784 0.235206768 11.76 0.000979 109.6004443673 0.2099625371 0.249091919 7.84 0.000549 119.5010879374 0.2289292872 0.2715933817 9.8 0.000549 133.6062780066 0.2559507242 0.3036506318 11.76 0.000549 146.358344577 0.2803799705 0.3326326013 0 0 0 0 0 0Sheet6 f N L T p lnf lnN lnL lnT Lnp 133.96 1 0.5 9.8 0.000549 4.8975412479 0 -0.6931471806 65.26 1 0.55 9.8 0.001911 4.1783792912 0 -0.5978370008 59.76 1 0.5 1.96 0.000549 4.0903365408 0 -0.6931471806 71.66 1 0.5 9.8 0.001911 4.2719327119 0 -0.6931471806 123.38 3 0.5 9.8 0.005791 4.8152690238 1.0986122887 -0.6931471806