Module #5
CHE 116
Spring 2009
Manipulating Data
Filtering Data to Reduce Data Noise
Fitting Data to Reduce Data Noise
Numerical Differentiation
Finite Difference
Calculating the Derivative
Advanced Technique for Calculating the Derivative
Numerical Integr
Module #3
CHE 116
Spring 2009
Excels GOAL SEEK utility
Excels SOLVER utility
Fit data using linear and non-linear models
Maximize linear/nonlinear functions subject to constraints
Solve systems of linear and nonlinear algebraic equations
Excels GOAL SEEK
Module #2A
CHE116
Spring 2010
Excels Analysis ToolPak(add-ins)
Linear regression & basic statistics
using the Analysis ToolPak
General XY data regression (using chart
trendline)
Accessing and Using Excels Analysis ToolPak (1)
Microsoft Excel provides a st
Module #2
CHE 116
Importing Text Files
Creating charts
Formatting and Modifying charts
Adding additional data to a chart
Spring 2009
Importing Text Files
Text files are a common way to move data from one program
to another.
Two types of text files:
Most l
Module #1
CHE 116
Spring 2010
Spreadsheet Overview
Creating, Opening, Saving, and Closing Excel Workbooks.
Entering & Deleting Data
Inserting & Removing Cells, Rows, and Columns
Cutting, copying, and pasting data
Cell formatting
Basics of Multiple Workshe
General Instructions for all homework problems
- place a descriptive title at the top of your worksheets
- name all worksheet tabs appropriately
- provide descriptive labels for all entries in your worksheet
- carefully organize your spreadsheet.
- use co
Class 2 Matlab
Colon
Brackets
Step size of 1, if not defined.
Mesh Grid. Given 2 vectors x and y. it will return a "mesh" a matrix
element by element multiplication. like a punnet square
surface command is a plot in matlab
How to build matrices
using colo
Matlab Day 1
(visual basic)
Create variables by stating
x=100 in command prompt
putting the semi colon supresses the output to the command windown
matlab assumes it is vectors already.
you can
command:
xlswrite:"doug"
to write an excel file
you can only
Module 8 Homework
First MatLab Homework Set
General Instructions:
All of your calculations are to be saved into a diary file. Your solutions to the problems
should be copied from the diary file (showing all the steps you performed to get there) and
paste
CHE116 Exam
First Session Spring 2010
Exam Information:
Exam is in class only.
The exam is open book and open notes.
This exam must be completed individually - no
collaboration!
This exam has 5 problems and 1 optional extracredit problem. The 5 required p
Module #11
CHE 116
Spring 2010
Survey of Numerical Techniques
Interpolation
Regression Analysis
Linear Regression
Linear Regression of Non-polynomial Terms
Polynomial Fitting
Using the Basic Fitting Tools
Numerical Differentiation and Smoothing
Numerical
Module #9
It is All about the Matrix
Creating a Matrix
Creating a Mesh
Combining Matrices
Indexing into an Array
Functions
Additional Data Arrays
Cell array
Structure array
CHE 116
Spring 2010
Creating a Matrix
Multiple methods exist for defining matrices
Module #8
CHE 116
What is MATLAB?
Starting MATLAB
The MATLAB interface
Defining Variables
Introduction to Matrices
Assignment Operator
Mathematical Operations
Formatting
Saving and Loading Variables
Spring 2010
What is MATLAB?
MATLAB is a sophisticated ma
Module #6
CHE 116
Spring 2009
Numerical Integration for Differential Equations
Eulers Method for 1st-order ODE
Runge-Kutta Method for 1st order ODE
First-Order Ordinary Differential Equation
A differential equation is an equation that involves one or
more
Module #4
Excel Functions
Using a function
Logicals
Data lookup
Array functions
Array constants
CHE 116
Spring 2009
Excel Functions - Introduction
In programming, a function is a piece of code
dedicated to a particular calculation.
Accepts inputs
Performs