用Excel做差分析.docVIP

用Excel做方差分析 1、打开EXCEl，录入好你的数据。然后点击“工具”，看你的有没有“数据分析”这一选项。如果有就OK。如果没有，那就加载。也点击“工具”下的加载宏，在“分析工具库”左边的方框里打上对勾。然后再点击“工具”，就会多了“数据分析”这一项。希望你office是完全安装的，否则这一步操作不了。 2、点击“数据分析”里面选择你想要的分析方法。你要的是单因素方差分析，就选第一项。然后选择你要分析的数据区域，再选择数据的分组方式，是按照行还是列。然后再选“输出选项”就OK啦。 P0.05显著，p0.01极显著 3、相关性分析 也在数据分析中选择“相关系数” 剩下的和方差分析一样选择数据区域和输出区域 然后的到结果： customer qualification preliminary examination of the material of the borrower for the loan person, determine whether you meet the loan conditions (standard specification for details of the conditions the fifth chapter 5.1 loans and borrower conditions). 3. agree loan person decides to accept, according to interviews ... First, the jurisdiction of the head office, branches and risk management, operational management should be strengthened on the Bank personal loan monitoring, inspection, management and guidance. Second, related personnel irregularities, according to qilu bank credits operational responsibility and accountability for implementation and the qilu bank employee violations of regulations dealing with regulations and other relevant rules of punishment and accountability. 9. According to file, and related system file 9.1 according to file a, and loan General II, and personal loan management provisional approach 9.2 related system file qilu Bank personal loan management approach 10. records table single records table single 1: personal loan customer talk record records table single 2: personal borrowing applications records table single 3: personal loan income proved records table single 4: personal loan survey declared table records table single 5: authorized Attorney (sample) records table single 6: Personal most high borrowing support with application approval table records table single 7: personal single pen cycle borrowing application approval table records table single 8: drawing applications records table single 9: qilu Bank personal most high borrowing support with single records table single 10: arrived (quality