+ Reply to Thread
Results 1 to 6 of 6

quadratic equations help needed

Hybrid View

  1. 01-05-2014, 07:56 PM #1
    Joseph Little
    Joseph Little is offline
    Registered User
    Join Date
    01-01-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    3

    quadratic equations help needed

    Hi
    I'm trying to figure out how to input quadratic equations of this format in Excel: (x2.5/a2.5) + (y2.5/b2.5) = 1 (where '2.5' indicates the power of 2.5). Can anyone advise?
    Many thanks.

    Joseph
    Reply With QuoteRegister To Reply
  2. 01-05-2014, 08:04 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,188

    Re: quadratic equations help needed

    Formula: copy to clipboard 
    (x^2.5/a^2.5) + (y^2.5/b^2.5) = 1



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-05-2014, 08:28 PM #3
    Joseph Little
    Joseph Little is offline
    Registered User
    Join Date
    01-01-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: quadratic equations help needed

    Thanks TMS!
    I forgot to say I don't just want to write it, want to be able to solve it as a diagram: it should produce a rounded square called a 'super ellipse'.

    Regards,
    Joseph
    Reply With QuoteRegister To Reply
  4. 01-05-2014, 08:33 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,188

    Re: quadratic equations help needed

    I guess you'd need to express y in terms of x and then calculate the values of y for each x and chart the pairs.

    Never done that, sorry.

    Regards, TMS
    Reply With QuoteRegister To Reply
  5. 01-05-2014, 08:43 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: quadratic equations help needed

    A
    B
    C
    1
    a
    1
    2
    b
    2
    3
    4
    x
    y
    5
    0.00
    2.0000
    		 B5: =b * (1 - (x/a)^2.5) ^ (1/2.5)
    6
    0.05
    1.9996
    7
    0.10
    1.9975
    8
    0.15
    1.9930
    9
    0.20
    1.9856
    10
    0.25
    1.9748
    11
    0.30
    1.9600
    12
    0.35
    1.9407
    13
    0.40
    1.9164
    14
    0.45
    1.8865
    15
    0.50
    1.8503
    16
    0.55
    1.8068
    17
    0.60
    1.7548
    18
    0.65
    1.6931
    19
    0.70
    1.6195
    20
    0.75
    1.5312
    21
    0.80
    1.4237
    22
    0.85
    1.2896
    23
    0.90
    1.1140
    24
    0.95
    0.8575
    25
    1.00
    0.0000

    That's the first quadrant.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  6. 01-08-2014, 10:25 AM #6
    Joseph Little
    Joseph Little is offline
    Registered User
    Join Date
    01-01-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: quadratic equations help needed

    Wow,
    thanks you so much SHG!

    Regards,
    Joseph
    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. Quadratic Coefficients
    By Ian Adamson in forum Excel General
    Replies: 8
    Last Post: 05-07-2022, 10:06 AM
  2. Quadratic Regression - Help
    By kmr159 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-08-2013, 08:26 AM
  3. How do I enter a quadratic and cubit-fit equations?
    By DianeD in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-12-2006, 04:40 PM
  4. 2 variables in 2 quadratic equations in excel
    By fsshl@centurytel.net in forum Excel General
    Replies: 5
    Last Post: 02-06-2005, 08:10 PM
  5. Quadratic equation
    By Nes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2005, 10:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1