摘要
基于Excel统计函数和数据分析工具库研究概率统计问题。通过Excel实例直观演示常见分布的概率计算、正态分布的引理、随机模拟、泊松定理、制作频率直方图、数据分析及处理等问题,更好地激发了学生的学习兴趣,提高了教学效果.
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.
作者
吴正苗
魏万华
水清皎
王志全
WU Zheng-miao;WEI Wan-hua;SHUI Qing-jiao;WANG Zhi-quan(School of Bailie Mechanical Engineering,Lanzhou City University,Lanzhou Gansu 730070)
出处
《甘肃高师学报》
2020年第5期54-58,共5页
Journal of Gansu Normal Colleges
基金
甘肃省“十三五”教育科学规划项目“基于CDIO理念的应用型本科院校工科人才培养机制创新研究”(GS[2017]GHB1986).
