COMPUTER PROBLEM-SOLVING IN - Oakland University
Computer Problem-Solving in EGR 141
Engineering and Computer Science Fall 2006
PROBLEM-SOLVING EXERCISE #3
ESTIMATING AND PREDICTING UNKNOWNS
IN THIS EXERCISE YOU WILL USE LEAST-SQUARES CURVE FITTING TO DEVELOP TWO EQUATIONS TO MODEL THE DATA GIVEN. USING THESE EQUATIONS, WE WILL PREDICT THE FUNCTION VALUES FOR TWO INPUTS AND EVALUATE THE PREDICTION MADE BY EACH OF THE CURVES AND LINEAR INTERPOLATION.
PART A
|X |5 |10 |15 |
X |LINEAR INTERPOLATION |LINEAR FIT |PARABOLIC FIT |LINEAR INTERPOLATION |LINEAR FIT |PARABOLIC FIT |ACTUAL |BEST VALUE |BEST METHOD | |20 | | | | | | |33 | | | |40 | | | | | | |42 | | | |
Which method(s) performed the best? Would you have expected the outcomes? How do these perform for these data points vs. the linear and parabolic curve’s squared errors? Discuss your answer.
PART E
IN PART B YOU USED MICROSOFT EXCEL TO SOLVE FOR THE COEFFICIENTS FOR PARABOLIC LEAST SQUARES REGRESSION (POLYNOMIAL OF DEGREE 2). USING VISUAL BASIC TO AUTOMATE MICROSOFT EXCEL, CREATE THIS EXCEL SPREADSHEET. YOU WILL LEARN ABOUT THIS DURING THE SECOND WEEK IN PROBLEM-SOLVING. TURN IN A PRINTOUT OF THIS PROGRAM.
PROBLEM SOLVING DELIVERABLES
YOU SHOULD WORK IN TEAMS OF EITHER TWO OR THREE. YOU MAY NOT WORK ALONE. TURN IN PARTS A, B, C (TWO GRAPHS USING GRAPH PAPER), D, AND E AT THE BEGINNING OF LECTURE, ON TUESDAY OCTOBER 24, 2006. ONE SET OF RESULTS SHOULD BE SUBMITTED PER TEAM.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- problem solving examples in life
- oakland university school calendar
- oakland university spring break 2020
- oakland university 2021 calendar
- oakland university calendar 2020
- oakland university 2019 2020 calendar
- problem solving skills in the workplace
- oakland university winter 2020 calendar
- oakland university calendar winter 2021
- oakland university schedule 2020
- oakland university academic calendar 2021
- oakland university fall 2020 schedule