This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: UF-ESI-6314DMOR-02-01.xmcdpage 1 of 502-01.Model the following problem and display the optimal solution you obtain from Solver. Youdo not need to turn in your Excel files.We are trying to measure airplane fuel consumption, f, as a function of distance traveled, d, andcruising altitude, a. We have eight data points given as follows:i1 8..:=Observationii:=Observation12345678=f11001420190018402000230026402850:=d1725293336475360:=a2222353430353941:=Part A:One engineer believes that we can write fuel consumption fas a linear function of distanceand altitude, i.e., if we plan a flight with distance dand cruising altitude a, for some values p1andp2 our fuel consumed should be:fp1dp2a+=Make initial guess values for the coefficients:p11:=p21:=Our problem is to determine the values of...
View Full Document
This note was uploaded on 02/02/2010 for the course ESI 6314 taught by Professor Vladimirlboginski during the Fall '09 term at University of Florida.
- Fall '09