+ Reply to Thread
Results 1 to 2 of 2

Working with ranges

  1. #1
    Registered User
    Join Date

    Working with ranges

    I want make special statistical tests using Excel.
    Without using ranges it is very difficult to make certain calculations.
    The tests will be about statistical distributions that are not included in Excel Analysis Toolpaks.
    I want to learn about using ranges in Excel.
    I have read about using ranges in formulas.

    For example;
    the sample may consist of two variables each having different number of records; weight (30 rows), height (43 rows).

    I want to create a variable length range, but I don't know how.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Hello Okaderli,

    Here is a code example that assigns either the weight range or the height range to a range variable named "Rng". The weight range is "A1:A30" and the height range is "B1:B43". Both ranges are located on worksheet "Sheet1".

    Please Login or Register  to view this content.
    These next examples assume there are header labels in row 1 and "A1" is labeled "Weight" and "B1" is labeled "Height". Both Names have been entered with their defined ranges of "A1:A30" and "B1:B43".

    Examples with named ranges:
    Please Login or Register  to view this content.
    Example of finding a Range's length:
    Please Login or Register  to view this content.
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1