廣東金融學院實驗報告課程名稱：數據分析與SAS實驗一、實驗目的及要求1、使用系統計算數據的一些基本描述性統計量；2、利用樣本對總體進行統計推斷，主要是參數估計問題和假設檢驗問題.二、實驗環境及相關情況（包含使用軟件、實驗設備、主要儀器及材料等）1、裝有版本為8.1以上的SAS系統的個人電腦2、股票行情軟件和Word、Excel等辦公軟件三、實驗內容及步驟（包含簡要的實驗步驟流程）實驗內容:1、分別畫七個指標的平均值在九個月中的走勢圖2、對各個指標的統計量進行說明，然后進行區間估計及假設檢驗。實驗步驟：（此為簡步略驟，詳細程序與分析見附錄）1、用程序導入全部數據2、分別算出每天七個指標的平均值并合并在一個文件中3、畫出七個指標的平均值在九個月中的走勢圖4、分別對七個指標的統計量進行說明，然后進行區間估計及假設檢驗第1頁共6頁1、實驗結果（包括程序或圖表、結論陳述、數據記錄及分析等，可附頁）一、幾個指標的平均值在九個月中的走勢:zf3sp191817161514210-1-2-3-4-5-60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890timetime收盤價漲幅zje1.80E+08cjl1300000012000000110000001000000090000008000000700000060000005000000400000030000001.70E+081.60E+081.50E+081.40E+081.30E+081.20E+081.10E+081.00E+089.00E+078.00E+077.00E+076.00E+075.00E+074.00E+073.00E+072.00E+071.00E+070.00E+000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890timetime成交量成交金額hslK90432180706050403020100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890timetime換手率K值D90807060504030201000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111111111111111222222222222222333333333333333333333334444444444444444444555555555555555555555666666666666666666666777777777777777777777888888888888888888888889999999999999999999990000111111112222230011111112222220000000111111122222223300001111111222222220000011111111222222330000001111112222222230000001111111222222220000000111111112222223300000001111122222222345670123478945678119014567812345812347890145678123458901167812345890125678934569012367890345670112378903456701234789014567812345890125678912345890125678923456901125678934569012367890timeD值第2頁共6頁二、七個指標的描述性統計量、正態性檢驗結果、直方圖、QQ圖:1、漲幅表1正態性檢驗檢驗----統計量----0.978078-------P值-------Shapiro-WilkWPr<WPr>D0.0058Kolmogorov-SmirnovD0.0613390.0923Cramer-vonMisesW-Sq0.127871A-Sq0.80656Pr>W-Sq0.0475Anderson-DarlingPr>A-Sq0.0380漲幅的直方圖漲幅的QQ圖30252015105420Percentzf-2-4-60-5-4-3-2-1zf01230.1151025507590959999.9NormalPercentiles、A-Sq的P值中是小于0.05的,變量zf是不服從正態分結果分析:表1中統計量W-Sq布的,從直方圖可以看出數據是不對稱的,而且QQ圖的尾部不是直線.2、收盤價表2正態性檢驗檢驗----統計量----0.967255-------P值-------Shapiro-WilkWPr<WPr>D0.0003Kolmogorov-SmirnovD0.087789<0.0100Cramer-vonMisesAnderson-DarlingW-Sq0.266872A-Sq1.759529Pr>W-Sq<0.0050Pr>A-Sq<0.0050收盤價的直方圖收盤價的QQ圖19181722.520.017.515.0Per12.5cspen10.0t1615147.55.02.5014.2514.7515.2515.7516.2516.7517.2517.7518.2518.75sp0.1151025507590959999.9NormalPercentiles結果分析:表2中所有的P值都是小于0.05的,而且直方圖明顯不對稱,QQ圖成曲線,這些都顯示了變量sp是不服從正態分布的.3、成交量第3頁共6頁表3正態性檢驗檢驗----統計量-----------P值-------Shapiro-WilkW0.9702010.08656Pr<WPr>D0.0006Kolmogorov-SmirnovD<0.0100Cramer-vonMisesAnderson-DarlingW-Sq0.21851A-Sq1.367486Pr>W-Sq<0.0050Pr>A-Sq<0.0050成交量的直方圖成交量的QQ圖20.017.515.0140000001200000010000000P12.5erccent10.07.55.02.50j8000000l60000004000000200000035000004500000550000065000007500000850000095000001050000011500000125000000.1151025507590959999.9cjlNormalPercentiles結果分析:表3中所有的P值都是小于0.05的,而且直方圖明顯右偏,QQ圖成曲線,這些都顯示了變量cjl是不服從正態分布的.4、成交金額表4正態性檢驗檢驗----統計量-----------P值-------Shapiro-WilkW0.9755980.083849Pr<WPr>D0.0028Kolmogorov-SmirnovD<0.0100Cramer-vonMisesAnderson-DarlingW-Sq0.297566Pr>W-Sq<0.0050A-Sq1.646507Pr>A-Sq<0.0050成交金額的直方圖成交金額的QQ圖252015175000000150000000125000000Percen100000000zje75000000t10500000002500000005010000000300000005000000070000000900000001100000001300000001500000001700000000.1151025507590959999.9zje結果分析:所有的P值都是小于0.05的,而且直方圖明顯右偏,QQ圖成曲線,這些都顯NormalPercentiles第4頁共6頁示了變量zje是不服從正態分布的.5、換手率表5正態性檢驗----統計量-------P值-------檢驗----Shapiro-WilkW0.9811310.068564Pr<WPr>D0.0145Kolmogorov-SmirnovD0.0360Cramer-vonMisesAnderson-DarlingW-Sq0.171707A-Sq1.080578Pr>W-Sq0.0129Pr>A-Sq0.0080換手率的直方圖換手率的QQ圖20.017.515.012.53.53.02.5Perhslc10.0ent2.01.51.07.55.02.501.1251.3751.6251.8752.1252.3752.6252.8753.125hsl0.1151025507590959999.9NormalPercentiles結果分析:所有的P值都是小于0.05的,而且QQ圖成曲線,說明變量hsl是不服從正態分布的.6、K值表6正態性檢驗----統計量-------P值-------檢驗----Shapiro-WilkW0.9734540.065865Pr<WPr>D0.0015Kolmogorov-SmirnovD0.0519Cramer-vonMisesAnderson-DarlingW-Sq0.107885A-S