Navigation

Quick Links

Lifelong Learning

Astronomy

Classical & Medieval

Linguistics

Mathematics

Philosophy & Logic

Mixology

MIS

Data Analytics

History

Computational Sciences

Return

Return to Homepage

Computational and Data-Enabled Science and Engineering

Coding Tutorials and Examples

Excel

One might argue Excel is not really a coding language (and I do tend to agree), but it has some similarities, especially if you are doing a lot of mathematical analysis.  The materials here are quite basic, and relate primarily to data analysis, but there are a couple of Excel tutorials for subjects like differential equations (numerical methods), or linear algebra, etc. 

Differential Equations

Lab #3 Key -- Code -- Euler's method (I also used a version of this for Calculus II)
Lab #11 Key -- Code -- Modified Euler's, Runge-Kutta

Calculus I - III

Lab Alternate -- Code -- single variable Reimann sums
Alt/Make-up -- Code -- multivariable Reimann sums

Statistics and Data Analysis

Basic Linear Regression in Excel 2016 (video)

Two-Way Tables in Excel 2016 -- Basics (video)
Two Way Tables in Excel 2016 -- Multiple Questions (video)

Percentiles in Excel 2016 (video)

Line Graphs in Excel 2016 (video)

Linear Programming in Two Variables, Solve with Solver in Excel 2016 (video)

Monte Carlo Simulation to Estimate Pi (pdf) Excel

YouTube Playlists:

Statistics, Spreadsheet Applications, Basics for Quantitative Reasoning

Coding Tutorials and Examples

Personal

Interests

Recipes

Cards

Quotes