LAB01(1705)

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

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

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-

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This lab report was uploaded on 04/08/2008 for the course ENG 1705 taught by Professor Koffke during the Spring '08 term at Villanova.

### Page1 / 3

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

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

View Full Document
Ask a homework question - tutors are online