|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/precipitation-threshold-analysis-using-microsoft-excel-only/
课程评论：没有评论
Coursera课程《仅使用Excel预测滑坡的降雨阈值》课程内容总结： 本课程将**逐步**指导学员完成降雨阈值的开发与验证。您将学习如何**有效构建、应用和验证**最强大的降雨阈值模型，并掌握以下关键知识点： * **经验分享**：关注诱发滑坡的具体阈值。 * **数据准备**：为阈值分析做好数据准备。 * **误差与不确定性**：理解和处理分析过程中的误差和不确定性。 * **站点记录相关性**：分析站点数据之间的相关性。 * **事件与站点空间模式分析**： * 计算距离矩阵（重命名源站点为文本，目标站点为ID）。 * 进行最近邻分析（共享最近邻聚类，数值越高表示分组越少）。 * 通过删除不需要的数据和异常值来选择点。 * **相关性分析**。 * **诱发滑坡的降雨阈值分析**： * ID, IE。 * E-Date, I-Date。 * 前期降雨及其他因素。 * **可靠性指数**。 * **处理步骤**：遵循“先来后到”的原则进行处理。 * **时间序列分析**。 **工具**：课程主要使用Microsoft Excel，并提及开源GIS软件QGIS作为辅助工具。 **数据来源**：教程中使用的数据受《滑坡》（国际滑坡联盟期刊）的版权保护。学员需引用以下文章：Althuwaynee O F., Asikoglu O. & Eris E. (2018) "Threshold contour production of rainfall intensity that induces landslides in susceptible regions of northern Turkey " *Landslides*. DOI: 10.1007/s10346-018-0968-2。 **注意**：课程提供Excel表格和文章供练习使用。
In this course, we go through the development and validation of precipitation rainfall threshold step-by-step.You will learn how to effectively build, apply and validate the most powerful Precipitation thresholds, and much more: [Excel sheet and Articles are available for the exercise application purposes]What is all about with experience sharing: focus on that thresholds that Induces LandslidesHow to prepare the data for threshold analysisErrors and UncertaintiesCorrelation between station recordsSpatial pattern analysis for incidents and stationsa. Compute the Distance Matrix [distance matrix, rename the source stations as text and target as ID]b. Compute Nearest Neighbor Analysis [shared nearest neighbor clustering, high no.= less groups]c. Select points by delete unwanted and outliers 6. Correlation analysis 7. Precipitation Threshold Analysis that Induces Landslides types a. ID, IE, b. E-Date, I-Date, c. Antecedents and others 8.Reliability index 9.Processing steps: first comes first 10.Temporal analysisTools: Microsoft excel and open source GIS software QGIS.Data used in the tutorial, is strictly protected under copyright law of Landslides (Journal of the International Consortium on Landslides). Please cite the article below: Althuwaynee O F., Asikoglu O. & Eris E. (2018) "Threshold contour production of rainfall intensity that induces landslides in susceptible regions of northern Turkey " Landslides. DOI : 10.1007/s10346- 018-0968-2
