Statistics problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

I need to determine mean, median, mode, min, max and rank for a set of data
that exceeds a count of 255. Excel keeps locking up on me I think because
these functions are limited to arrays of 255 numbers or less.

Is there a way I can calculate these statistics on sets of data numbering in
the thousands?

.

Relevant Pages

  • RE: How do I call Excel functions with an array parameter?
    ... > the Excel Rank function, but I have been unsuccessful so far. ... remember that an Excel array is not the same as a VBA array of some ... Dim xlApp As Excel.Application ...
    (microsoft.public.access.modulesdaovba)
  • How do I call Excel functions with an array parameter?
    ... "HOW TO: Call Excel Functions from Within ... Microsoft Access 2000" gives examples of calling the Median, ChiInv, and ... the Rank function will rank ties with the same number. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Rank formula
    ... I am trying to find the percentile a specific row falls ... In Excel, I was ranking the items, then dividing the rank ... >> Is there a formula in Access equivalent to the RANK ...
    (microsoft.public.access.queries)
  • Re: Rank Formula
    ... I am trying to find the percentile a specific row falls ... In Excel, I was ranking the items, then dividing the rank ... >> Is there a formula in Access equivalent to the RANK ...
    (microsoft.public.access.queries)
  • Re: Ranking
    ... "Peo Sjoblom" wrote: ... "I am trying to use the RANK function but I keep getting the largest number ... Excel 95 - Excel 2007 ... Lord Healey ...
    (microsoft.public.excel.worksheet.functions)