Category: XLSmath

Download this Excel file for a full demo for setting up and maintaining a Statistical Process Control “Run Chart”. The trick is determining your process control variability limits. There are formal rules for determining these limits, and the demo shows how to do it.

Number Generator 2022:  Use this macro-enabled (xlsm) Excel file to generate your choice of:  a normally-distributed data set for a mean and standard deviation;  a uniformly-distributed (random) data set between two limits; a linear trend set of data; or a periodic trend set of data.

This is a macro-enabled (xlsm) Excel file which performs a basic statistical analysis on any data set (can be a few dozen data points, or a few thousand).  The summary report provides the expected statistics:  average, standard deviation, median, minimum, maximum.  A histogram of the data is compared to a comparable “normal distribution”.  The VALUE of this tool is that it quantifies if your data set is “normally distributed” or “non-normal”.  The selection of subsequent statistical analyses (like ANOVA) depend on normally distributed data.

This macro-free (xlsx) Excel file demonstrates five examples, of increasing complexity, of solving an ordinary differential equation (dx/dt = f(x,t) ) using the classic 4th Order Runge-Kutta method.  If you have a differential equation to solve, in other words you need to simulate a process that can be described analytically, then try RK4 simulation first and see what happens.  You may save yourself a lot of hand wringing and research.

This file provides six example problems illustrating how Excel can be used to craft a custom-looking bar graph to summarize your engineering data.  Don’t just provide supervisors, managers, and co-workers with a “table of your data”, also provide a nice graphical summary that makes clear any trends that can be concluded from your hard-earned data.

Use this Excel file to learn more about using selected basic functions.  The file is designed as 16 separate “example problems”.  You are given a basic assignment and have the opportunity to implement an Excel solution on your own.  Click each “Solution” button to see how I’ve solved the problem.

Excel file (xlsx) worked-out examples.  Created for thermodynamics students who need to learn how to interpolate between tabulated values in steam tables (and other tables) QUICKLY.  This file illustrates the basics behind single linear interpolation, and also depicts “why” it works.

Also, the more difficult situation of double-interpolation (a combination of two single interpolation steps) is implemented.

This file illustrates the idea behind the built-in Excel “Goal Seek” tool.  Four examples are presented.  It will give you confidence in using the Goal Seek tool for your own application.