LAB01(1705)

LAB01(1705) - To: Prof. William C Koffke P.E. From:, S-05...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
To: Prof. William C Koffke P.E. From:, S-05 Date: 01-16-2008 Subject: Report for Lab 01 1.0 Objective The purpose of this lab is to solve for the roots, the x values that return zero values for the function, of second-order polynomials, in the form Y = A∙X² + B∙X + C. 2.0 Problem Description GIVEN : the Quadratic equation Create an Excel solver to find the roots of the following Quadratic functions: Your Equations from side 1 Go Here 3.0 Excel Formulas DISC =B4^2-4*B3*B5 Real Root1 =(-B4+SQRT(B4^2- 4*B3*B5))/(2*B3) Real Root2 =(-B4-SQRT(B4^2- 4*B3*B5))/(2*B3) Complex Real Part Complex Part i Root1 =(-B4/ (2*B3)) =+SQRT(-(B4^2- (4*B3*B5))/(2*B3)) Root2 =(-B4/ (2*B3)) =-SQRT(-(B4^2- (4*B3*B5))/(2*B3)) 4.0 Excel Output For Excel, you will include the formatted cells with values displayed. Copy and Paste these cells into this Word document. All Worksheets should be labeled and formatted for readability . ALTENATIVE staple a printout of the Excel to the end of you report and refer to it in this section as ATTACHED . Quadratic Solu-
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

LAB01(1705) - To: Prof. William C Koffke P.E. From:, S-05...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online