数据分析实验报告分析解析

实验课程：数据分析专业：信息与计算科学班级：学号：姓名：中北大学理学院..SAS【实验目的】了解SAS系统，熟练掌握SAS数据集的建立及一些必要的SAS语句。精品文档放心下载【实验内容】1.将SCORE数据集的内容复制到一个临时数据集test。感谢阅读SCORE数据集NameSexMathChineseEnglish

Alicef908591

Tomm958784

Jennyf939083

Mikem808580

Fredm848589

Katef978382

Alexm929091

Cookm757876

Bennief827984

Hellenf857484

Winceletf908287

Buttm778179

Geogem868582

Todm898484

Chrisf898487

Janetf866587

2．将SCORE数据集中的记录按照math的高低拆分到3个不同的数据集：math精品文档放心下载大于等于90的到good数据集，math在80到89之间的到normal数据集，math感谢阅读在80以下的到bad数据集。3．将3题中得到的good，normal，bad数据集合并。谢谢阅读【实验所使用的仪器设备与软件平台】SAS【实验方法与步骤】1：$$感谢阅读2fmfmmfmmfffmmmff;Run;2：SELECT;when(math>=90)感谢阅读when(math>=8090)精品文档放心下载when(math<80)end;Run;DATADATADATA3DATARun;3【实验结果】结果一：结果二：4结果三：5【实验目的】通过使用SAS感谢阅读数据分析方法，培养学生分析处理实际数据的综合能力。【实验内容】表2是一组上市公司在2001eps(scale)精品文档放心下载的规模以及2001年最后一个交易日的收盘价(price).精品文档放心下载表2某上市公司的数据表代码流通盘每股收益股票价格00009685000.05913.2700009960000.02814.200015012600-0.0037.12000151105000.02610.0800015325000.05622.7500015513000-0.0096.8500015636000.03314.95000157100000.0612.65000158100000.0188.3800015970000.00812.15000301153650.047.3100048877000.10113.2600072560000.04412.3300083513380.0722.58000869000877000885000890000892000897000900000901000902000903000905000906000908000909000910000911000912000913000915000916000917000918320078006000169341200014166214234800650060009500665089886000800072801500084504599340001180060000.194-0.084-0.0730.0310.0310.0020.0580.005-0.0310.1090.0460.0070.0060.0020.0360.0670.1120.0620.0010.0380.086-0.04518.2912.5512.489.127.886.918.5927.9510.9211.799.2914.478.289.998.99.018.0611.8614.45.1516.2310.1261、对股票价格1）计算均值、方差、标准差、变异系数、偏度、峰度；2）计算中位数，上、下四分位数，四分位极差，三均值；精品文档放心下载3）作出直方图；4）作出茎叶图；5）进行正态性检验（正态W6）计算协方差矩阵，Pearson相关矩阵；7）计算Spearman相关矩阵；8）分析各指标间的相关性。21）对股票价格，拟合流通盘和每股收益的线性回归模型，求出回归参数估计精品文档放心下载值及残差；2）给定显著性水平α=0.05，检验回归关系的显著性，检验各自变量对因变谢谢阅读量的影响的显著性；3）拟合残差关于拟合值Y,X,XXX的残差图及残差的正态QQ图。分析精品文档放心下载1212这些残差，并予以评述。【实验所使用的仪器设备与软件平台】SAS【实验方法与步骤】谢谢阅读cards;85000.05960000.02825000.05636000.0330.0612.6570000.0080.047.3177000.10160000.04413380.0722.5832000.19477800-0.0846000-0.07348000.0056500-0.03160000.10995000.04666500.00789880.00660000.00280000.03672800.06784500.06245990.0016000-0.045run;DATArun;data;感谢阅读outrun;datanormal;精品文档放心下载outrun;datanoprint;谢谢阅读price/normal;run;datanosimple;感谢阅读run;dataeps/selectionpr;精品文档放心下载p感谢阅读data8【实验结果】91011对于问题二结果：12131450【实验目的】通过使用SAS感谢阅读数据分析方法，培养学生分析处理实际数据的综合能力。【实验内容】表3给出的是美国50个州每100000个人中七种犯罪的比率数谢谢阅读MurderRapeRobberyAssault感谢阅读BurglaryLarcenyAuto精品文档放心下载表3美国50个州七种犯罪的比率数据StateMurderRapeRobberyAssaultBurglaryLarcenyAuto精品文档放心下载Alabama14.225.296.8278.31135.51881.9280.7精品文档放心下载Alaska10.851.696.8284.01331.73369.8753.3谢谢阅读Arizona9.534.2138.2312.32346.14467.4439.5谢谢阅读Arkansas8.827.683.2203.4972.61862.1183.4精品文档放心下载California11.549.4287.0358.02139.43499.8663.5感谢阅读Colorado6.342.0170.7292.91935.23903.2477.1精品文档放心下载Connecticut4.216.8129.5131.81346.02620.7593.2感谢阅读Delaware6.024.9157.0194.21682.63678.4467.0谢谢阅读Florida10.239.6187.9449.11859.93840.5351.4感谢阅读Georgia11.731.1140.5256.51351.12170.2297.9感谢阅读Hawaii7.225.5128.064.11911.53920.4489.4精品文档放心下载Idaho5.519.439.6172.51050.82599.6237.6谢谢阅读Illinois9.921.8211.3209.01085.02828.5528.6谢谢阅读Indiana7.426.5123.2153.51086.22498.7377.4谢谢阅读Iowa2.310.641.289.8812.52685.1219.9谢谢阅读Kansas6.622.0100.7180.51270.42739.3244.3精品文档放心下载Kentucky10.119.181.1123.3872.21662.1245.4感谢阅读Louisiana15.530.9142.9335.51165.52469.9337.7感谢阅读Maine2.413.538.7170.01253.12350.7246.9谢谢阅读Maryland8.034.8292.1358.91400.03177.7428.5精品文档放心下载Massachusetts3.120.8169.1231.61532.22311.31140.1感谢阅读Michigan9.338.9261.9274.61522.73159.0545.5谢谢阅读Minnesota2.719.585.985.81134.72559.3343.1精品文档放心下载Mississippi14.319.665.7189.1915.61239.9144.4精品文档放心下载Missouri9.628.3189.0233.51318.32424.2378.4谢谢阅读Montana5.416.739.2156.8804.92773.2309.2感谢阅读NebraskaNevada3.915.818.149.164.7323.1112.7355.0760.02453.12316.14212.6249.1559.2NewHampshire3.210.723.276.01041.72343.9293.4精品文档放心下载NewJersey5.621.0180.4185.11435.82774.5511.5感谢阅读NewMexico8.839.1109.6343.41418.73008.6259.5谢谢阅读NewYorkNorthCarolina10.710.629.417.0472.661.3319.1318.31728.01154.12782.02037.8745.8192.115Ohio7.827.3190.5181.11216.02696.8400.4感谢阅读NorthDakota0.99.013.343.8446.11843.0144.7谢谢阅读Oklahoma8.629.273.8205.01288.22228.1326.8精品文档放心下载Oregon4.939.9124.1286.91636.435061388.9感谢阅读Pennsylvania5.619.0130.3128.0877.51624.1333.2精品文档放心下载RhodeIsland3.610.586.5201.01489.52844.1791.4感谢阅读SouthCarolina11.933.0105.9485.31613.62342.4245.1感谢阅读SouthDakota2.013.517.9155.7570.51704.4147.5感谢阅读Tennessee10.129.7145.8203.91259.71776.5314.0感谢阅读Texas13.333.8152.4208.21603.12988.7397.6精品文档放心下载Utah3.520.368.8147.31171.63004.6334.5精品文档放心下载Vermont1.415.930.8101.21348.22201.0265.2精品文档放心下载Virginia9.023.392.1165.7986.22521.2226.7精品文档放心下载Washington4.339.6106.2224.81605.63386.9360.3谢谢阅读WestVirginia6.013.242.290.9597.41341.7163.3谢谢阅读Wisconsin2.812.952.263.7846.92614.2220.7感谢阅读Wyoming5.421.939.7173.9811.62772.2282.0感谢阅读1、1谢谢阅读异？2精品文档放心下载出合理的解释。3）计算从样本相关矩阵出发计算的第一样本主成分的得分并予以排序.感谢阅读2、从样本相关矩阵出发，做因子分析。【实验所使用的仪器设备与软件平台】SAS【实验方法与步骤】首先将上述数据复制到excel,再通过SAS导入数据至数据集crime。感谢阅读样本协方差矩阵做主成分分析：covariance;精品文档放心下载run;感谢阅读out谢谢阅读run;run;16datarun;2、程序：score;谢谢阅读run;【实验结果】1718192021【实验目的】通过使用SAS精品文档放心下载据分析方法，培养学生分析处理实际数据的综合能力。【实验内容】1991年全国各省、区、市城镇居民月平均收入情况见下表，变感谢阅读量含义如下：X1-人均生活费收入（元/X2-人均全民所有制职工工资（元/感谢阅读X3-/X4-人均集体所有制工资（元/谢谢阅读X5-/人X6-/人X7-谢谢阅读人均各种津贴（元/X8-/X9-感谢阅读个体劳动者收入（元/省(区\市)名类型x1x2x3x4x5x6x7x8x9北京1170.03110.259.768.384.4926.816.4411.90.41感谢阅读天津1141.5582.5850.9813.49.3321.312.369.211.05感谢阅读河北1119.483.3353.39117.5217.311.79120.7精品文档放心下载上海1194.53107.860.2415.68.883121.0111.80.16精品文档放心下载山东1130.4686.2152.315.910.520.6112.149.610.47精品文档放心下载湖北1119.2985.4153.0213.18.4413.8716.478.380.51谢谢阅读广西1134.4698.6148.188.94.3421.4926.1213.64.56精品文档放心下载海南1143.7999.9745.66.31.5618.6729.4911.83.82精品文档放心下载四川1128.0574.9650.1313.99.6216.1410.1814.51021精品文档放心下载云南1127.4193.5450.5710.55.8719.4121.212.60.9精品文档放心下载新疆1122.96101.469.76.33.8611.318.965.624.62感谢阅读山西2102.4971.7247.729.426.9613.127.96.660.61感谢阅读内蒙古2106.1476.2746.199.656.279.65520.16.970.96谢谢阅读吉林2104.9372.9944.613.79.019.43520.616.651.68谢谢阅读黑龙江2103.3462.9942.9511.17.418.34210.196.452.68感谢阅读江西298.08969.4543.0411.47.9510.5916.57.691.08感谢阅读河南2104.1272.2347.319.486.4313.1410.438.31.11精品文档放心下载贵州2108.4980.7947.526.063.4213.6916.538.372.85精品文档放心下载陕西2113.9975.650.885.213.8612.949.4926.771.27谢谢阅读甘肃2114.0684.3152.787.815.4410.8216.433.791.19谢谢阅读青海2108.880.4150.457.274.078.37118.985.950.83精品文档放心下载宁夏2115.9688.2151.858.815.6313.9522.654.750.97感谢阅读辽宁江苏33128.46135.2468.9173.1843.4144.5422.423.915.315.213.8822.3812.429.6619.0113.91.411.19浙江3162.5380.1145.9924.313.929.5410.9133.47谢谢阅读22安徽3111.7771.0743.6419.412.516.689.6987.020.63感谢阅读福建3139.0979.0944.1918.510.520.2316.477.673.08谢谢阅读湖南312484.6644.0513.57.4719.1120.4910.31.76感谢阅读广东待判211.311441.4433.211.248.7230.7714.911.1西藏待判175.93163.857.894.223.3717.8182.3215.7011）判定广东、西藏两省区属于哪种收入类型，并用回代法及交叉确认法对误精品文档放心下载判率作出估计。2）进行Bayes判别，并用回代法与交叉确认法验证判别结果。精品文档放心下载2、1）用最短距离法、最长距离法与类平均法聚类，画出谱系图，并写出分3感谢阅读类的结果；2）快速聚类法聚类，并写出分3类的结果。【实验所使用的仪器设备与软件平台】SAS【实验方法与步骤】1:发现数据四川省X9数据存在异常,通过查阅课本170页表5.3可得此处数据应谢谢阅读为1.21.首先将上述数据建立excelSAS直接导入到名为shuj