Scribd Logo
Upload

Welcome to Scribd!

  • 164 views

    How To Solve A Quadratic Equation in Excel

    Uploaded by

    Er S Thirumarai Nathan
    This document provides instructions on how to solve quadratic equations in Excel using three main methods: 1) It shows how to input the coefficients of a quadratic equation (a, b, c) and solve for x using the quadratic formula. 2) It demonstrates using an Excel table to input the coefficients and a formula to automatically calculate the solutions. 3) It describes how to use Excel's Goal Seek tool to find the value of x that satisfies a given quadratic equation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    How To Solve A Quadratic Equation in Excel

    Uploaded by

    Er S Thirumarai Nathan
    164 views5 pages
    This document provides instructions on how to solve quadratic equations in Excel using three main methods: 1) It shows how to input the coefficients of a quadratic equation (a, b, c) and solve for x using the quadratic formula. 2) It demonstrates using an Excel table to input the coefficients and a formula to automatically calculate the solutions. 3) It describes how to use Excel's Goal Seek tool to find the value of x that satisfies a given quadratic equation.

    Original Title

    How to Solve a Quadratic Equation in Excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions on how to solve quadratic equations in Excel using three main methods: 1) It shows how to input the coefficients of a quadratic equation (a, b, c) and solve for x using the quadratic formula. 2) It demonstrates using an Excel table to input the coefficients and a formula to automatically calculate the solutions. 3) It describes how to use Excel's Goal Seek tool to find the value of x that satisfies a given quadratic equation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    164 views5 pages

    How To Solve A Quadratic Equation in Excel

    Uploaded by

    Er S Thirumarai Nathan
    This document provides instructions on how to solve quadratic equations in Excel using three main methods: 1) It shows how to input the coefficients of a quadratic equation (a, b, c) and solve for x using the quadratic formula. 2) It demonstrates using an Excel table to input the coefficients and a formula to automatically calculate the solutions. 3) It describes how to use Excel's Goal Seek tool to find the value of x that satisfies a given quadratic equation.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    How to solve a quadratic equation in Excel

    Standard reference

    Quadratic Equation
    a b c (ax²+bx+c) x1
    3 4 0 3x²+4x 0
    -2 5 3 -2x²+5x+3 -0.5
    1 4 -3 x²+4x-3 0.645751311065
    1 1 0 x²+x 0
    5 1 3 5x²+x+3 Err:502
    -2 -1 1 -2x²-1x+1 -1

    Excel Table

    Quadratic Equation
    a b c (ax²+bx+c) x1
    2 -4 2 2x²-4x+2 1
    -2 5 3 -2x²+5x+3 -0.5
    1 4 -3 x²+4x-3 0.645751311065
    1 1 0 x²+x 0
    5 1 3 5x²+x+3 Err:502
    -2 -1 1 -2x²-1x+1 -1
    x2
    -1.33333333333 x1 =(-C7+SQRT(C7^2-4*B7*D7))/(2*B7)
    3 x2 =(-C7-SQRT(C7^2-4*B7*D7))/(2*B7)
    -4.64575131106
    -1
    Err:502
    0.5

    x2
    1 x1 =(-Table1[[#This Row],[b]]+SQRT(Table1[[#This Row],[b]]^2-4*Table1[[#This Row],[
    3 x2 =(-Table1[[#This Row],[b]]-SQRT(Table1[[#This Row],[b]]^2-4*Table1[[#This Row],[a
    -4.64575131106
    -1
    Err:502
    0.5
    b]]^2-4*Table1[[#This Row],[a]]*Table1[[#This Row],[c]]))/(2*Table1[[#This Row],[a]])
    ]]^2-4*Table1[[#This Row],[a]]*Table1[[#This Row],[c]]))/(2*Table1[[#This Row],[a]])
    How to solve a quadratic equation in Excel

    Goal Seek

    Quadratic Equation
    a b c (ax²+bx+c) x
    2 -4 2 2x²-4x+2 0
    -2 5 3 -2x²+5x+3 3
    1 4 -3 x²+4x-3 2
    1 1 0 x²+x 0
    5 1 3 5x²+x+3 1
    -2 -1 1 -2x²-1x+1 2

    -2 -1 1 -2x²-1x+1 0.500010843413
    y
    2 =B7*POWER(F7,2)+C7*F7+D7
    0 =B8*POWER(F8,2)+C8*F8+D8
    9 =B9*POWER(F9,2)+C9*F9+D9
    0 =B10*POWER(F10,2)+C10*F10+D10
    9 =B11*POWER(F11,2)+C11*F11+D11
    -9 =B12*POWER(F12,2)+C12*F12+D12

    -3.25304733E-05

    You might also like