Re: (newbie) Find Max Number In An Array

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 ?

.

Relevant Pages

  • Re: hiding data points on a line graph
    ... Excel treats "" as text, with a numerical value of zero. ... When the related cells on the graph are blank though the ...
    (microsoft.public.excel.misc)
  • overcoming zero values in line graph
    ... I have a 12-month line graph where some of the earliest and most recent data ... Is there a way to have Excel not plot zero values - to avoid the big rises ...
    (microsoft.public.excel.charting)
  • Can blank cells be omitted from graph?
    ... I have created a graph in Excel 2007 that has 4 data series. ... the blank series are being plotted as zero values. ...
    (microsoft.public.excel.misc)
  • Re: Use RANDBETWEEN form & include certain #s in the range
    ... Microsoft Excel MVP ... as no algorithm parameter in KB 828795 is zero initially. ... I do not believe the current Excel 2003 RAND algorithm would result in ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Data/Values change when Query Analyzed in Excel
    ... Jerry Whittle, Microsoft Access MVP ... I have a quantity in a reocrd of zero, when I analyze the data with Excel, it ... Please post the SQL statement for the query. ...
    (microsoft.public.access.queries)