Re: (newbie) Find Max Number In An Array

Marco van de Voort wrote:
On 2006-06-27, Nektarios - Greece <eizo5@xxxxxxxxxxxx> wrote:
Do i have to put each Y to an array [X,Y] and then find the minimum Y ?
No, because the minimum might not be a whole number. Probably you should
either calculate the derivative of the function, and equate that to zero, or try a numeric solving solution.
The final function is more complicated. The function i used above is just a sample example. The real function is Y(x1,x2,x3,x4,x5,x). :)
But for known x1,x3,x3,x4,x5 i want for one X to find Y value.
I used Excel but then i can SEE the minimum in the graph.

How? How do you know it is 2.1 and not 2.10004 ?



The X is integer.
The Y is real.
X > 0 and Y > 0.
I use '#.###' number format.
The cells in Excel goes like this

X Y
--------
25 0.571
26 0.555
27 0.534
28 0.530
29 0.535
30 0.541
etc


I already know that the values of Y CANNOT be the same, at different value of X. Also, the values of Y as you can see are CLEARLY different.

.

Relevant Pages

  • Re: Excel
    ... EQUATE STX TO CHAR ... Homer L. Hazel wrote: ... > Has anyone ever started Excel running on the same server as D3? ... I have an Excel Macro ...
    (comp.databases.pick)
  • Re: Excel
    ... > Hi Larry, ... > Excel stating that "This file contains macros.... ... >> It will also have macros, ... >>> EQUATE STX TO CHAR ...
    (comp.databases.pick)
  • Re: Excel
    ... Hi Larry, ... Excel stating that "This file contains macros.... ... >> EQUATE STX TO CHAR ... I have an Excel Macro ...
    (comp.databases.pick)
  • Re: Excel
    ... But, that starts Excel on the user's computer, not ... > EQUATE STX TO CHAR ... I have an Excel Macro ... >> Larry Hazel ...
    (comp.databases.pick)