Results 1 to 5 of 5

Thread: relationship among four variables
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default relationship among four variables

    How can i get the relationship among this 4 variables

    a = no of days = 30
    b = rates/number of holes/ma = 315.81
    c = expected monthly target (number of holes) = 240
    d = expected production amount = 75,795.36 (Naira)

    regards

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,194
    Post Thanks / Like
    Mentioned
    67 Post(s)
    Tagged
    14 Thread(s)

    Default Re: relationship among four variables

    What relationship are you looking for?
    Maybe compare against data in the cells?

    You can put examples of what you have and what you expect of result.
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,101
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: relationship among four variables

    315.81 * 240 = 75,794.40 which is roughly 1.00 less than 75,795.36

    (???)
    Last edited by sheetspread; Jul 17th, 2019 at 11:46 AM.

  4. #4
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: relationship among four variables

    My target is how the variable b was defined because the variable
    I know that the number of days is a constant as well as variable c

  5. #5
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,101
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: relationship among four variables

    Ok so:

    Excel 2010
    C
    1315.814

    Sheet5



    Worksheet Formulas
    CellFormula
    C1=75795.36/240


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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