+ Reply to Thread
Results 1 to 2 of 2

Median calculation

  1. #1
    Registered User
    Join Date
    05-30-2018
    Location
    india
    MS-Off Ver
    2003
    Posts
    1

    Median calculation

    Hi team i am new in this forum. I am trying to execute vba for VBA. I have a range of data in column A2:a15. I want to calculate median and want to add 10%,20,30% in increase and decrease order. Exp medin+10%,median+20% and so on and than medain-10%,20%,30% so on. I m doing in excel but want to run vba for this.
    Attached Images Attached Images

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Median calculation

    Welcome to the Forum!

    What do you need to do in VBA that you don't already have done in your worksheet? Your request is very straightforward to do with formulas.

    Also, using % of median is not the usual way to analyze data. You may find it more useful to use percentiles.

    An image attachment has very little value. Just attach the Excel file. It's easier than taking a photo your screen and then attaching that.

    The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Complex calculation using if, and, median
    By wwaller in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2016, 02:57 PM
  2. Replies: 8
    Last Post: 08-09-2016, 12:50 AM
  3. Median Absolute Deviation (MAD) Calculation
    By Arand in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2013, 04:07 PM
  4. Conditoinal median calculation for a series
    By mahershams in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2012, 10:10 AM
  5. Median calculation across two columns
    By captainjazz in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 10:02 AM
  6. Help with calculation of median
    By sssss in forum Excel General
    Replies: 8
    Last Post: 03-26-2010, 09:43 AM
  7. [SOLVED] How to automate the calculation of the median from a frq distribut
    By Alaska Hydro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 09:10 PM

Bookmarks

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