+ Reply to Thread
Results 1 to 5 of 5

Formula to output +/-1 at specified probability

  1. 05-04-2017, 04:43 PM #1
    chilledmalt
    chilledmalt is offline
    Registered User
    Join Date
    08-20-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    18

    Formula to output +/-1 at specified probability

    Hi,

    I want a column A to output +1 at the probability of 83% and -1 at the probability of 17%
    I want a column B to output +1 at the probability of 62% and -1 at the probability of 38%

    How can I do this with formulas?
    Reply With QuoteRegister To Reply
  2. 05-04-2017, 04:59 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula to output +/-1 at specified probability

    What output do you want between those percentages? Could you list some examples of probabilities and desired output?
    Dave
    Reply With QuoteRegister To Reply
  3. 05-04-2017, 05:03 PM #3
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Formula to output +/-1 at specified probability

    I would probably do something like =IF(RAND()>0.17,1,-1) [similar for output B].
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  4. 05-04-2017, 05:32 PM #4
    chilledmalt
    chilledmalt is offline
    Registered User
    Join Date
    08-20-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    18

    Re: Formula to output +/-1 at specified probability

    Thanks MrShorty, you nailed it. Thanks FlameRetired for your interest. Much appreciated!
    Reply With QuoteRegister To Reply
  5. 05-04-2017, 05:47 PM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula to output +/-1 at specified probability

    Thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Array to embed formula and if number of output is met output Blank
    By ywang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-29-2015, 02:34 AM
  2. Formula/formatting to calculate probability
    By kjrmitch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2015, 10:19 PM
  3. average of data by date to probability formula steps help
    By jamie2v in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2014, 05:17 PM
  4. Formula to calculate the probability of the next value, considering previous pattern
    By vicentiu in forum Excel General
    Replies: 4
    Last Post: 11-26-2011, 02:33 PM
  5. Probability/Formula Help
    By jamesryan in forum Excel General
    Replies: 1
    Last Post: 08-10-2007, 06:36 PM
  6. Probability Question:probability outcomes
    By Myles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2006, 06:45 AM
  7. [SOLVED] [SOLVED] Creating a merged probability table from a granular probability table
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 09-08-2005, 10:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1