# Lec16 - Lecture 16 Excel Part II Linear regression Example...

This preview shows pages 1–10. Sign up to view the full content.

Lecture 16 Excel Part II 1 Lecture 16 Excel Part II Linear regression Example from Lecture 14 Root finding Macros

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Lecture 16 Excel Part II 2 Linear Regression Start – Programs –(MS Office) – Excel Enter the xi and yi data as shown here:
Lecture 16 Excel Part II 3 Create graph of y vs x Insert – Chart – XY(Scatter) or hit the chart button

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Lecture 16 Excel Part II 4 After a few editing changes (see Lecture 15)
Lecture 16 Excel Part II 5 1. Hold pointer over a point on the graph 2. Right-click 3. Select “Add Tr endline…” (not shown) 4. Default is Type Linear Adding a Trendline

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Lecture 16 Excel Part II 6 On Options Tab Check : Display equation on chart Display R-squared value on chart Display equation
Lecture 16 Excel Part II 7 Done!

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Lecture 16 Excel Part II 8 Root finding Excel has a tool called goal seek Located under Tools in main menu. Let’s try it with our polynomial function of Lecture 10 1 2 5 . 0 18 . 0 ) ( 2 3 + - - = x x x x f
Lecture 16 Excel Part II 9 1 2 5 . 0 18 . 0 ) ( 2 3 + - - = x x

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/26/2008 for the course ENGR 1 taught by Professor X during the Spring '07 term at Lehigh University .

### Page1 / 15

Lec16 - Lecture 16 Excel Part II Linear regression Example...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online