Spreadsheets Pathway

Author

DOFPro group

Spreadsheets

Introduction

From Mole to Megawatt: The Full Journey Through Chemical and Thermal Engineering
Intro to DOFPro CTP
Video, Info Page, Visuals

How to Have a Quickie with Your Data Part 1
\(\bar{x}\), \(S_{\bar{x}}\), Linear Least Squares
Video, Info Page, Visuals

How to Have a Quickie with Your Data Part 2
Nonlinear least squares
Video, Info Page, Visuals

Solving Nonlinear Equations with Spreadsheets
See Title
Video, Info Page, Visuals

How Deviant and Mean Are Your Data? Intro and Basics Part 1, Just the Facts
Mean (\(\mu,\ \bar{x}\)) and Standard Deviation (\(\sigma,\ S\))
Video, Info Page, Visuals

How Deviant and Mean Are Your Data? Intro and Basics Part 1, The Full Story
Mean (\(\mu,\ \bar{x}\)) and Standard Deviation (\(\sigma,\ S\))
Video, Info Page, Visuals

How Deviant and Mean Are Your Data? Part 2
Standard Error (\(S_{\bar{x}}\)) and Confidence Interval (\(2\lambda\))
Video, Info Page, Visuals

Basic Statistics on a Spreadsheet
\(\bar{x}\), \(S\), \(S_{\bar{x}}\), \(\lambda\) with a spreadsheet
Video, Info Page, Visuals

Linear Regression
Derivation of the equations for linear regression
Video, Info Page, Visuals

Linear Regression Spreadsheet
Performing linear regression with a spreadsheet
Video, Info Page, Visuals

Error Propagation
Propagating errors or uncertainties through equations and calculations
Video, Info Page, Visuals

Integrals and Derivatives Part 1
Propagating errors or uncertainties through numerical integrals and derivatives
Video, Info Page, Visuals

Integrals and Derivatives Part 2
More propagating errors or uncertainties through numerical integrals and derivatives
Video, Info Page, Visuals

Nonlinear Regression
Derivation/explanation of nonlinear regression
Video, Info Page, Visuals

Using DWSIM to Create Binary Phase Diagrams
DWSIM, Binary Phase Diagrams
Video, Info Page, Visuals

Modeling the Rankine Cycle in DWSIM
Modeling the Rankine Cycle in DWSIM
Video, Info Page, Visuals

Modeling the Vapor Compression Cycle in DWSIM
Modeling the Vapor Compression Cycle in DWSIM
Video, Info Page, Visuals