Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started