Application of Excel in Probability Statistics
Zhentong Gao, Jiajin Xu · 2024
Excel is a well-known software in Microsoft Office, but it does not mean that everyone will be proficient in using it in probability statistics, especially in the use of various functions. There is also a drawing problem in Excel that many people may not be able to use without specialized learning. In fact, for some simple probability or statistical problems, using Excel is quite convenient. For those who are studying “fatigue statistics”, it is necessary to master a certain knowledge of Excel using functions and drawing, at least without the need for some special function tables. Therefore, unlike other statistical books, this book does not have various function tables attached. People note that Excel, a general-purpose software, can perform many tasks from tabulation to statistics and analysis and can draw various charts; the software seems omnipotent. However, itʼs actually impossible. No matter how good a general-purpose software is, it is impossible to achieve everything. This is also why Python is still needed.