Excel in the Teaching of Mathematical Modeling-毕业论文翻译.docVIP

Excel in the Teaching of Mathematical Modeling [Abstract] the teaching of mathematical modeling courses to try, objective decision analysis for the mathematical modeling is widely used in analytic hierarchy process, change the traditional teaching model, the use of conventional, simple Excel statistical analysis software, to explore to solve this Kind of the problem of rapid, effective and direct method. [Keywords:] mathematical modeling; statistical analysis; AHP 1 Excel statistical analysis Among the many spreadsheet applications, the Microsoft Excel to an intuitive interface, powerful features, good maneuverability, has been recognized by many users. Microsoft’s Excel makes every upgrade their functions are better users with more convenient and simple. Excel is a comprehensive quick tabulation, data charts and data statistics and management of the tools package. Excel can handle large, complex data list, and the data for statistical analysis and processing, and finally to the way the chart or statistical graph is given visual display. Excel 2003 in the statistical analysis module, already covered the basic statistical analysis of the current common problems. 1.1 Statistical analysis analysis tools: Excel Software provides data analysis tools 15, known as the “Analysis ToolPak.” When the analysis only to provide the necessary data and parameters, the use of analytical tools will be able to get the appropriate data tables or data chart. Function of statistical analysis tools include: the statistical graphics, tab; Calculation of descriptive statistics; parameter estimation; hypothesis testing; analysis of variance; correlation, regression analysis; time series analysis; sampling; data transformation [1]. 1.2 Statistical analysis Statistical Functions: Excel 78 is provided in the statistical functions used for statistical analysis. The statistical analysis statistical functions include: the frequency distribution d