Using Excel to Solve Statistical Problems: A Practical Guide to the Book “Statistics for Chemical and Process Engineers”

Professor Yuri A. W. Shardt is currently the chair of the Department of Automation Engineering in the Faculty of Computer Science and Automation at the Technical University of Ilmenau, working in the fields of big data, including process identification and monitoring with an emphasis on the development and industrial implementation of soft sensors; holistic control, including the development of advanced control strategies for complex industrial process; and the smart world, including implementations such as smart factories, smart home, Industry 4.0, and smart grids. Previously, he worked at the University of Waterloo in the Department of Chemical Engineering and at the University of Duisburg-Essen in the Institute of Control and Complex Systems as an Alexander von Humboldt Fellow. He has written over 60 papers appearing in such journals as "Automatica", "Journal of Process Control", "IEEE Transactions on Industrial Electronics", and "Industrial and Engineering Chemistry Research" on topics ranging from system identification, soft sensor development, to process control. He has presented his research at numerous conferences and taught various courses in the intersection between statistics, chemical engineering, process control, Excel®, and MATLAB®. In addition to his academic work, he has spent considerable time in industry working on implementing various process control solutions.

 

Introduction to Excel.- Data Visualisation.- Theoretical Statistics Distributions Hypothesis Testing and Confidence Intervals.- Regression Analysis and Design of Experiments.