Question: The purpose of this exercise is to provide practice using LINGO or Excel Solver. Find the values of X and Y that minimize the function

The purpose of this exercise is to provide practice using LINGO or Excel Solver. Find the values of X and Y that minimize the function
Min X2 - 4X + Y2 + 8Y + 20
Do not assume non-negativity of the X and Y variables. Recall that by default LINGO assumes nonnegative variables. In order to allow the variables to take on negative values, you can add
@FREE(X); @FREE(Y);
Alternatively, if you want LINGO to allow for negative values by default, in the LINGO menu select Options and then click General Solver, and then uncheck the Variables assumed nonnegative tab?

Step by Step Solution

★★★★★

3.40 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Use EXCEL Solver to solve for the optimal solution report using the following st... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1137-M-S-Q-M(1827).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

The purpose of this exercise is to learn how to calculate stock returns for portfolio models using actual stock price data. First, it is necessary to obtain stock price data. One source (of many) is...

The purpose of this exercise is to compare the variability of 1 and 2 with the variability of (1 - 2). a. Suppose the first sample is selected from a population with mean = 150 and variance 21 =...

The purpose of this exercise is to compare the estimates and standard errors obtained by correctly using 2SLS with those obtained using inappropriate procedures. Use the data file WAGE2.RAW. (i) Use...

The purpose of this exercise is to provide practice using the LINGO or Excel solvers. Find the values of X and Y that minimize the function Min X 2 8 X + Y 2 + 10 Y + 41 Do not assume nonnegativity...

Problem 8-01 (Algorithmic) The purpose of this exercise is to provide practice using the LINGO or Excel solvers. Find the values of and Y that minimize the function Min x2 - 4x + y2 + 6y + 13 Do not...

Thepurpose of this exercise is to provide practice using Excel Solver or LINGO. Find the values of X and Y that minimize the function Min X 2 6 X + Y 2 + 8 Y + 1 5 and finat ( X , Y ) = The purpose...

Problem 8-01 (Algorithmic) The purpose of this exercise is to provide practice using the LINGO or Excel solvers. Find the values of X and Y that minimize the function Min x - 4x + y + 6Y + 13 Do not...

The purpose of this exercise is to provide practice using the LINGO or Excel solvers. Find the values of X and Y that minimize the function Min X2 6X + Y2 + 10Y + 34 Do not assume nonnegativity of...

Problem 8-01 (Algorithmic) The purpose of this exercise is to provide practice using the LINGO or Excel solvers. Find the values of X and Y that minimize the function Min X 2 10 X + Y 2 + 6 Y + 34 Do...

Problem 8-01 (Algorithmic) The purpose of this exercise is to provide practice using the LINGO or Excel solvers. Find the values of X and Y that minimize the function Min x2 - 2x + y2 + 6Y + 10 Do...

A survey of U.S. adults found that 51% think that high school students should be required to learn a foreign language. You randomly select 200 adults and ask them whether they think high school...

Norman Whiteside, insurance sales manager at Eastern Assurance, has been asked to project how many new policies he will sell in 20x4. The local economy has been growing, and the insurance industry...

Etackatone Energy is planning to houe hwo trpes of as - year, non - callable bonds to ralie a total of $ 8 milion. First, 3 , 0 0 0 boeds with a tos annual coupon entewill be sold at thelr $ 1 , 0 0...

Describe both the domestic and international channels through which monetary policy can affect real GDP.

A survey of 131 investment managers in Barrons Big Money poll revealed the following: 43% of managers classified themselves as bullish or very bullish on the stock market. The average expected return...

The Bureau of Transportation Statistics Omnibus Household Survey is conducted annually and serves as an information source for the U.S. Department of Transportation. In one part of the survey the...

The Hawaii Visitors Bureau collects data on visitors to Hawaii. The following questions were among 16 asked in a questionnaire handed out to passengers during incoming airline flights. This trip to...

Over time academics and practitioners have shown that CAPM does not fully describe the returns on stocks. They showed this by finding large persistent alphas on the returns. Specifically, if we let...

Bill deposits $100 at the end of each year for 13 years into fund A. Seth deposits $100 at the end of each year for 13 years into fund B. Fund A earns an annual effective rate of 15% for the first 5...

The Presley Corporation is about to go public. It currently has aftertax earnings of $7,700,000, and 2,300,000 shares are owned by the present stockholders (the Presley family). The new public issue...