1、Sas 软件上机考试题1 用 excel 创建名称为 A 的数据集，变量为 x1x4,10 个观测。x1 x2 x3 x412 22 33 2334 15 54 3344 32 44 3465 63 35 3546 44 56 2356 56 55 3476 56 46 4575 77 47 4456 6 47 3367 75 57 542 打开 sas 软件，用 import data 将 excel 文件 A 导入成 sas 文件 work.a10 4 12 34 56 78 910I ntx112344465465676755667I ntx22215326344565677675I n
2、tx333544435565546474757I ntx4233334352334454433543 用 insight 或分析员应用或编程作频数统计和直方图x1Fr equency Count sVal ue12. 0000 34. 000044. 0000 46. 000056. 0000 65. 000067. 0000 75. 000076. 0000Count1 11 12 11 11Cel l Per cent10. 0 10. 010. 0 10. 020. 0 10. 010. 0 10. 010. 0Cum Per cent10. 0 20. 030. 0 40. 060.
3、0 70. 080. 0 90. 0100. 0x2Fr equency Count sVal ue6. 0000 15. 000022. 0000 32. 000044. 0000 56. 000063. 0000 75. 000077. 0000Count1 11 11 21 11Cel l Per cent10. 0 10. 010. 0 10. 010. 0 20. 010. 0 10. 010. 0Cum Per cent10. 0 20. 030. 0 40. 050. 0 70. 080. 0 90. 0100. 0x3Fr equency Count sVal ue33. 00
4、00 35. 000044. 0000 46. 000047. 0000 54. 000055. 0000 56. 000057. 0000Count1 11 12 11 11Cel l Per cent10. 0 10. 010. 0 10. 020. 0 10. 010. 0 10. 010. 0Cum Per cent10. 0 20. 030. 0 40. 060. 0 70. 080. 0 90. 0100. 0x4Fr equency Count sVal ue23. 0000 33. 000034. 0000 35. 000044. 0000 45. 000054. 0000Co
5、unt2 22 11 11Cel l Per cent20. 0 20. 020. 0 10. 010. 0 10. 010. 0Cum Per cent20. 0 40. 060. 0 70. 080. 0 90. 0100. 00 20 40 60 80x1024Frequency0 20 40 60 80x20123Frequency28 36 44 52 60x3024Frequency20 30 40 50 60x4024Frequency4 用 insight 或分析员应用或编程计算常用描述性统计量x120 40 60x1x10 20 40 60 80x100. 010. 02De
6、nsity0 50 100x100. 51CumulativeConf i dence Bands f or CDFCoef f i ci ent0. 9500 Lower Band Upper Band- 1 0 1N_x1_4204060x1Moment sN 10. 0000Mean 53. 1000St d Dev 19. 8408Skewness - 0. 8993USS 31739. 0000CV 37. 3649Sum Wgt s 10. 0000Sum 531. 0000Var i ance 393. 6556Kur t osi s 0. 6725CSS 3542. 9000S
7、t d Mean 6. 2742Quant i l es100% Max 76. 0000 75% Q3 67. 000050% Med 56. 0000 25% Q1 44. 0000 0% Mi n 12. 0000Range 64. 0000 Q3- Q1 23. 0000 Mode 56. 000099. 0% 76. 0000 97. 5% 76. 0000 95. 0% 76. 000090. 0% 75. 5000 10. 0% 23. 0000 5. 0% 12. 00002. 5% 12. 0000 1. 0% 12. 000095% Conf i dence I nt er
8、 val sPar amet erMean St d Dev Var i ance Est i mat e 53. 1000 19. 8408 393. 6556 LCL 38. 9068 13. 6472 186. 2452 UCL 67. 2932 36. 2215 1311. 9959Test s f or Locat i on: Mu0=0Num Obs ! = Mu0: 10Num Obs Mu0: 10TestSt udent s tSi gn Si gned Rank St at i st i c 8. 46 5. 00 27. 50 p- val ue . 1500. 2500
9、 . 25005 用 insight 或分析员应用或编程作均值检验x1Wei ght ed Moment sN 10. 0000Mean 60. 1547St d Dev 113. 3021Skewness - 0. 9588USS 1729427. 00CV 188. 3512Sum Wgt s 446. 0000Sum 26829. 0000Var i ance 12837. 3695Kur t osi s 0. 1059CSS 115536. 325St d Mean 5. 3650Wei ght ed Quant i l es100% Max 76. 0000 75% Q3 75. 0
10、00050% Med 65. 0000 25% Q1 46. 00000% Mi n 12. 0000 Range 64. 0000Q3- Q1 29. 0000 Mode 56. 000099. 0% 76. 0000 97. 5% 76. 000095. 0% 76. 0000 90. 0% 76. 000010. 0% 44. 0000 5. 0% 34. 00002. 5% 12. 0000 1. 0% 12. 000095% Wei ght ed Conf i dence I nt er val sPar amet erMean St d Dev Var i anceEst i ma
11、t e60. 1547 113. 302112837. 3695LCL48. 0182 77. 93326073. 5812UCL72. 2912 206. 845542785. 05946 用 insight 或分析员应用或编程制作散点图和计算相关系数20 40 60x2204060x135 40 45 50 55x3204060x130 40 50x4204060x1Uni vari ate Stati sti csVari abl ex1x1x2x3x4N10 1010 1010Mean53.1000 53.100044.6000 47.400035.8000Std Dev19.8408
12、 19.840824.9631 8.44859.6240Mi ni mum12.0000 12.00006.0000 33.000023.0000Maxi mum76.0000 76.000077.0000 57.000054.0000Parti al Std Dev. 018.7554 8.63776.6266Parti al Correl ati on Matri x x1x20x30x40x1 : x2 x3 x4 ( x1 ) 7 用 insight 或分析员或编程拟合简单线性回归x1 = x2 x3 x4Response Di stri buti on: NormalLi nk Fu
13、ncti on: Identi tyModel Equati onx1 = - 3.5458 + 0.2946 x2 + 0.1333 x3 + 1.0388 x4Summary of Fi tMean of Response 53.1000Root MSE 14.1685 R-Square 0.6600Adj R-Sq 0.4900Anal ysi s of Vari anceSourceModelErrorC TotalDF 36 9Sum of Squares 2338.42131204.4787 3542.9000Mean Square 779.4738200.7465F Stat 3
14、.88 Pr F 0.0741Type III TestsSourcex2x3x4DF 11 1Sum of Squares 282.390210.3774 488.1915Mean Square 282.390210.3774 488.1915F Stat 1.410.05 2.43Pr F 0.28040.8277 0.1699Parameter Esti matesVari abl eInterceptx2x3x4DF 11 11Esti mate -3.54580.2946 0.13331.0388Std Error 28.86560.2484 0.58610.6661t Stat -0.121.19 0.231.56Pr |t| 0.90620.2804 0.82770.1699Tol erance . 0.5801 0.90960.5427Var Infl ati on 01.7238 1.09931.842640 60 80P_x1-10010R_x1
