Create an Excel spreadsheet that will determine the roots of a quadratic equation in terms of the coefficients a, b, and
Posted: Sun Jul 03, 2022 11:22 am
Create an Excel spreadsheet that will determine the roots of a quadratic equation in terms of the coefficients a, b, and c. In the case of complex roots, use the TEXT library function to convert the imaginary number to a string (i.e., a label), and then combine the resulting string with the letter i using the string operator (&). Enter the following sets of coefficients in your worksheet, and determine the roots corresponding to each set: (a) a= 2, b=4, c = 1 (b) a=4, b=2, c = 3