Class07

# Class07 - Viscosity of Water versus Temperature 2.000 Class...

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

1 1 Class meeting #7 Wednesday, Sept 15 th Spreadsheet Problem Solving b general linear regression h Polynomial models h Multilinear models h Data Analysis Regression h Trendline b nonlinear regression h using Solver Homework #4 is posted, due next Wednesday GEEN 1300 Introduction to Engineering Computing 0.0 0 0.200 0.400 0.600 0.800 1.0 0 1.200 1.400 1.600 1.800 2.0 0 20 40 60 80 100 120 140 160 180 200 Viscosity (cP) Temperature (degF) Viscosity of Water versus Temperature Note: Section Test on Excel Monday, 9/27 7-9 p.m. HUMN 1B50/ RAMY C250 (we’ll organize by section #) 2 Clicker Question What will appear when the Ctrl-Shift-Enter key combination is pressed? A) B) C) D) E)

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

View Full Document
2 3 Example from last class Use Data Analysis toolpak 1320 1340 1360 1380 1400 1420 1440 1460 1480 1500 1520 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 CO 2 Emissions (MMT Carbon) Year CO 2 Emmissions for the US, 1989 - 2000 4 recall that, if Data Analysis does not appear on the Data ribbon, you will need to check Analysis Toolpak in the Add-ins dialog box [if it’s not there, you will have to go back to Microsoft Office/Excel set-up] Initial, empty Regression dialog box
3 5 Regression dialog box set up for our problem checking Residuals will give us also model predictions 6 Initial (poorly formatted) Regression output display [ on new worksheet ] Adjust some column widths and fix up display for appropriate significant figures

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

View Full Document
4 7 Final Display of Regression Output [ tons of info, most of which you will not understand for a couple years ] intercept and slope values used to judge goodness of fit used to judge whether terms “belong” in the model add to data graph for visual comparison with model 8 Judging Goodness of Fit correlation coefficient: if close to +1 or –1, indicates strong correlation between x and y [something we already know from the original graph!] coefficient of determination: %-age of the variability in y that’s accounted for by the model adjustment to R 2 that penalizes the value for using a model with too many terms gives an idea of how far off the model predictions will be Adjusted R 2 or Standard Error can be used to compare
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 17

Class07 - Viscosity of Water versus Temperature 2.000 Class...

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

View Full Document
Ask a homework question - tutors are online