Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE CREATE AN EXCEL SPREAD SHEET WITH INSTRUCTIONS OF WHAT EQUATION YOU USED TO SOLVE THE PROBLEM. 1. Create an Excel Spreadsheet. Each problem should

PLEASE CREATE AN EXCEL SPREAD SHEET WITH INSTRUCTIONS OF WHAT EQUATION YOU USED TO SOLVE THE PROBLEM.

image text in transcribed

image text in transcribed

1. Create an Excel Spreadsheet. Each problem should be worked in a separately labeled worksheet and all should be saved in one Excel file. Submit the file on Carwas for grade. a. Find the root of the following equations using Excel. Check for (b-4ac) >=0. Display "Requires Complex Number" if the test is false and "Real roats" if the test is true 5x - 6x + 8 = 0 -6x + 5x + 8 = 0 Use EO 12x - x= 10 (see slide #12) Root 2 If the equation has real roots then find those two root. For Example, a b C Test for real root Root 1 2 requires complex numbers -6 3 real roots -3.436 0.436 b. You have a series of grades and you need to calculate the total grade. Each of the exams is worth 20% of the total grade and the final exam is worth 4096. You can drop the lowest (KIN) exam grade, but not the final exam Create an Excel sheet which calculates the total score. Use RANDBETWEEN to generate random numbers for all Exam grades. Enter grades for at least 5 students Use I) and a Assign te Letter Grade using E.Letter grades will be based on formula to calculate Grade 90 is an A 80

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

More Books

Students also viewed these Databases questions