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

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

View Full Document Right Arrow Icon
Lecture 16 Excel Part II 1 Lecture 16 Excel Part II Linear regression Example from Lecture 14 Root finding Macros
Background image of page 1

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

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

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

View Full DocumentRight Arrow Icon
Lecture 16 Excel Part II 4 After a few editing changes (see Lecture 15)
Background image of page 4
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
Background image of page 5

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

View Full DocumentRight Arrow Icon
Lecture 16 Excel Part II 6 On Options Tab Check : Display equation on chart Display R-squared value on chart Display equation
Background image of page 6
Lecture 16 Excel Part II 7 Done!
Background image of page 7

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

View Full DocumentRight Arrow Icon
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
Background image of page 8
Lecture 16 Excel Part II 9 1 2 5 . 0 18 . 0 ) ( 2 3 + - - = x x
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
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 Right Arrow Icon
Ask a homework question - tutors are online