Blog

In this post, you’ll learn how to calculate a weighted standard deviation in Excel. A weighted standard deviation calculates the spread in a data set where not all the observations have the same weight. Video: Weighted Standard Deviation in Excel Watch on YouTube | Subscribe to … Read more about Weighted Standard Deviation in Excel

In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineering notation differs from scientific notation, and how custom formats work in Excel Contents Video Watch on YouTube | Subscribe to EngineerExcel on YouTube Engineering Notation in Excel Numbers … Read more about Engineering Notation in Excel

In this post, you'll learn how to create custom Excel functions to store engineering constants by creating a user-defined function in VBA that can store the yield strength of steel and return it to the spreadsheet. You'll also learn how to save your custom functions in an Excel template so they … Read more about Custom Excel Functions for Engineering Constants

Excel's convert function works well to convert between simple units. However, in engineering, there's often compounds units where simple units are either multiplied together or divided by one another. One example is the units for torque, where we multiply a force times a distance (i.e. N*m). … Read more about Using the CONVERT Function for Compound Unit Conversions

Another way to document equations in Excel is the Equation Editor. This is the same editor that's used in both PowerPoint and Word. It may be helpful to create a location in your spreadsheets to display the main governing equations that you're using, whether it's one section of a spreadsheet or … Read more about Using Excel’s Equation Editor to Document Equations

Excel's Solver add-in can be used to find the best-fit line for nonlinear data. Worksheet 07f contains the flow and pressure data that was used in a previous example to illustrate fitting with LINEST. Delete the coefficients that are in the table from that example. For Solver to work, you'll need … Read more about Using Excel Solver for Nonlinear Regression

In this post, you'll learn how to perform constrained optimization in Excel through an example where we will maximize the flow rate in an open channel. The example will show that there is an optimal relationship between the channel dimensions that maximizes the flow rate for any required … Read more about Constrained Optimization in Excel – Maximize Open Channel Flow