Elements of Numerical Mathematical Economics with Excel

Exercises

• 1. Enumerate in Excel the following univariate functions and study the concavity, convexity. Find the critical points and assess whether they are maxima or minima. Find then the exact minima or maxima of the function using the Solver. Using the numerical second derivative also find the inflexion points. Plot each function together with its first and second derivatives.
• y = ( x 2 − 5 x + 6 ) ( x − 1 ) 2

  
• y = x 3 + 0.13 x 2 − 0.0005 x − 0.0009

  
• y = x 3
• 2. ...