资源描述：
《统计学上机实验报告.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、-颜航统计图表一、上机项目名称：EXCEL、SPSS绘制统计图表二、上机时间、地点：2010年9月16日，上午10：20—12：10基础楼综合实验室三、上机目的、内容、步骤及结果目的：掌握EXCEL、SPSS统计图表的基本操作内容：教材29页4题EXCEL；30页6题SPSS步骤及结果：29页4题EXCEL1．复制各个名称→在F1插入函数→选择统计中的frequency→在F2插入函数COUNTI→分别填$A$2:$A$51和D2→拖拽复制公式至E51→在G1输入函数relativef→输入公式：=F2/50→拖拽复制公式至F51→抽取D2：E51中的所有不同数据→复制到
2、I2：K5，得出如下表格由大到小TVshowfrequencyrelativef1Millionaire240.482Frasier150.33ChicagoHope70.144Charmed40.08total5012.在工具栏选择插入菜单图表→柱形图→选择柱形图格式→下一步→选择相应的区域→按下一步→设置图表的名称、横轴和竖轴的名称→选中完成，得出如下图表：在平时的测量工作中，他积极做好传、帮、带工作，热心地把自己学到和掌握好的操作技艺毫无保留地传授给徒弟andactualcasewhethermatch;byislocatedlandrightnature;prop
3、ertystatus,whetherhasdamageorqualityproblem;propertyusingsituation,rentaloruse;referencearoundsimilarpropertyprice,judgeassessmentvalueofrationality;whetherexistspropertydisputes,andseized,andfreeze,andmortgage,anddemolition,andtransformation,limitsituation.2.tolandrightmortgageof,surveyp
4、eopleshouldverifiedfollowinginformation:landrightcardbycontainsMinginformation(rightpeople,andlocation,andnature,andterm,andarea,)andactualcasewhethermatch;landnature;landflatsituation;groundbuildingssituation;referencearoundsimilarlandprice,judgeassessmentvalueofrationality;mortgagerealw
5、hetherhasothermortgagerightornoticeregistrationestablishedprior;whetherexistspropertydisputes,andseized,andfreeze,andmortgage,limitsituation.3.otherchattels,ownership,thevalueofthemortgageshouldbeimplemented,andwhetherfactorssuchaseasyhandling.(C)pledgeofcollateralinvestigationprocedures,
6、investigatorsshouldenforcecollateralvalue,conveniencecustodyanddisposition,pledgerightseffectiveidentification,registration,etc.(D)guaranteeinvestigationtoensurethattheprocedures,theinvestigationshall,inaccordancewiththeborrower'sstandardstoinvestigatetheguarantorevaluationassurance.15thi
7、nformationauditsurveypeopledealwithborrowersandqualificationprovidedbytheguarantor,financialstatus,proofofidentity,theauthenticityofthedatacarefullyreviewed,verified,rationalityandeffectiveness.Include:(a)theborrowerdataauditing1.corporateclientsshouldfocusonassessi
