|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-introduction-excel-for-science-and-engineering/
课程评论：没有评论
课程名称：科学与工程的基础Excel 课程概述：本课程旨在教授现代计算物理的基本概念，整个过程无需使用任何编程或编码。我们将利用几乎每个人电脑上都已安装的工具：电子表格软件（如Excel、WPS、Libreoffice等）。课程强调通过添加公式和在工作表中进行迭代计算，实现显著成果的能力。课程分为两个部分，涵盖科学和工程学生最常用的计算应用。 第一部分：微分方程 我们将使用现代技术，特别是有限差分法的变体，以数值方式寻找微分方程的解，无需高昂或复杂的专业软件。具体内容包括： - 欧拉法 - 泰勒级数 - 龙格-库塔法 - 高阶方程 - 刚性方程 - 预测-校正方法 虽然对于流体动力学等高级应用，需要进一步扩展这些主题，但以上内容为所有现代方法奠定了良好的基础。 第二部分：实验统计 对实验数据的解读可能复杂，并且容易产生错误，进而破坏整个实验的有效性。我们将探讨常用电子表格软件中的工具，进行分布拟合、提取统计细节和假设检验。具体内容包括： - 正态分布 - 均值和标准差 - 威布尔分布 - 失效分析 - 学生t检验 免责声明：本课程并不替代应用数学学位或专业咨询。购买本课程即表示您同意课程讲师对因课程内容或讲师与学生之间的任何支持通信而引起的争议、索赔、损失、伤害或任何形式的损害不承担责任。
This course is designed to teach you the broad outlines of modern computational physics using no programming or coding whatsoever. To do this, we'll use the sort of tool almost everyone has installed on their machines: spreadsheet software. Excel, WPS, Libreoffice, any will do. We're going to see that just the capacity to add in formulas and iteratively calculate across your worksheet is enough to achieve spectacular things.This course is split into two sections, representing the most common uses of computing for students of the sciences and engineering:Differential EquationsWe're going to use modern techniques, especially variants of the finite difference method, to find solutions to differential equations numerically without any expensive or complicated specialist software.Euler's MethodTaylor SeriesRunge-KuttaHigher Order EquationsStiff EquationsPredictor-Corrector MethodsWhile for advanced applications like fluid dynamics this must be extended, these topics provide a good grounding of the fundamentals for all modern methods. Experimental StatisticsIf you have experimental data, interpreting its meaning can be complicated and prone to mistakes that can destroy the validity of your whole experiment! We're going to look at the tools common spreadsheet software has available to us to fit distributions, extract statistical details and test hypotheses.Normal distributionsThe Mean and Standard DeviationThe Weibull DistributionFailure analysisStudent's T-TestDisclaimer:This course is not a substitute for a degree in applied mathematics or specialist consultancy, by purchasing this course you agree that the course instructor is in no way liable for any disputes, claims, losses, injuries, or damage of any kind that might arise out of or relate to the content of this course or any supporting communications between instructor and student.
