【摘要】 基于Excel统计函数和数据分析工具库研究概率统计问题。通过Excel实例直观演示常见分布的概率计算、正态分布的引理、随机模拟、泊松定理、制作频率直方图、数据分析及处理等问题,更好地激发了学生的学习兴趣,提高了教学效果.更多还原

【Abstract】 Based on Excel statistical function and data analysis tool library, this paper studies the probability and statistics problems,and intuitively demonstrates the common distribution probability calculation, lemma of normal distribution, random simulation,Poisson’s theorem, frequency histogram production, data analysis and processing, etc., which can better stimulate students’ interest in learning and improve the teaching effect.更多还原