Nona016
Level 1 (8 points)
iWork

Q: Is there any linear programming function in numbers version 3.6.2?

i know there was no linear programming function in numbers till 2011 (read all old posts). I want to know is there any now or Apple is still complacent enough to do anything about it. In my class I have to submit spreadsheets and I choose to submit it in numbers instead of excel, now I can't change my choice If I have to then I have to take excel classes and change all my previous spreadsheets which is equivalent to failed in class and subject repeat. I am the only one facing this problem because I am the misfortunate one, who made a mistake of loving Mac. And in case it makes Apple feel better hear this "I manually solve linear programming models (just had to learn it,no other way) and then plot it, whereas windows users use the inbuilt function they have". Thanks Apple

MacBook Pro (Retina, 13-inch,Early 2015), OS X El Capitan (10.11.5), null

Posted on Jul 17, 2016 12:31 AM

by Nona016,Solvedanswer
Nona016 Nona016
Level 1 (8 points)
iWork
A:

I consulted genius bar they provided me a custom made function. Works good, if they made it wow! if they did not still wow!. Thanks Apple and you all.

Posted on Jul 18, 2016 10:08 AM

Close
Nona016

Q: Is there any linear programming function in numbers version 3.6.2?

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Jul 17, 2016 7:56 AM in response to Nona016
    Level 6 (18,977 points)
    iWork
    Jul 17, 2016 7:56 AM in response to Nona016

    If you are trying to get the parameters for a best fit line I suggest using the function linest():

     

    Screen Shot 2016-07-17 at 9.45.35 AM.png

     

    linest() is a the linear estimate function.  I suggest you spend some time getting familiar with the functions Numbers offers by typing the equal sign in any cell, then browsing the function list on the right.

     

    To use the line eat function do something like show above, enter the X and Y data in columns as shown.  To get the slope (m in my example) select cell E2 and enter the formula:

    INDEX(LINEST(B2:B11,A2:A11,nonzero-y-intercept,FALSE), 0)

     

    shorthand for this is:

    E2=INDEX(LINEST(B2:B11,A2:A11,nonzero-y-intercept,TRUE), 0)

     

    to get the y intercept:

    E3INDEX(LINEST(B2:B11,A2:A11,nonzero-y-intercept,FALSE), 1)

     

    there are additional stats in the array that linest() returns.  read about that in the built-in help

     

    I hope this helps

  • by SGIII,

    SGIII SGIII Jul 17, 2016 4:32 PM in response to Nona016
    Level 6 (10,622 points)
    Mac OS X
    Jul 17, 2016 4:32 PM in response to Nona016

    When you say linear programming "function" in Excel are you referring to Solver?

     

    It is possible to use scripts to introduce Solver-like capability into Numbers.

     

    But more specifics on what kinds of linear programming problems you are solving (equations, constraints, etc.) would be necessary before attempting this.

     

    SG

  • by Nona016,

    Nona016 Nona016 Jul 18, 2016 12:55 AM in response to SGIII
    Level 1 (8 points)
    iWork
    Jul 18, 2016 12:55 AM in response to SGIII

    Yeah I meant solver in excel for optimisation under constraints.

  • by Nona016,

    Nona016 Nona016 Jul 18, 2016 12:56 AM in response to Wayne Contello
    Level 1 (8 points)
    iWork
    Jul 18, 2016 12:56 AM in response to Wayne Contello

    Thanks man but this is regression not linear programming.

  • by Nona016,Solvedanswer

    Nona016 Nona016 Jul 18, 2016 10:08 AM in response to SGIII
    Level 1 (8 points)
    iWork
    Jul 18, 2016 10:08 AM in response to SGIII

    I consulted genius bar they provided me a custom made function. Works good, if they made it wow! if they did not still wow!. Thanks Apple and you all.

  • by SGIII,

    SGIII SGIII Jul 18, 2016 10:28 AM in response to Nona016
    Level 6 (10,622 points)
    Mac OS X
    Jul 18, 2016 10:28 AM in response to Nona016

    Care to share?

     

    SG

  • by Nona016,

    Nona016 Nona016 Jul 19, 2016 2:16 AM in response to SGIII
    Level 1 (8 points)
    iWork
    Jul 19, 2016 2:16 AM in response to SGIII

    Okay how do I share it?. They just took my laptop and just entered something in numbers and I don't know it appears when I write =customo(objective,constraint,1,1).

  • by SGIII,

    SGIII SGIII Jul 19, 2016 5:54 AM in response to Nona016
    Level 6 (10,622 points)
    Mac OS X
    Jul 19, 2016 5:54 AM in response to Nona016

    You could post a screenshot. Wayne explains how in this user tip.

     

    SG