Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter...

Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter grade

Nested loop		Student ID	Grade	Letter Grade
		1	5
If score is	Then return	2	55
Greater than 89	A	3	86
From 80 to 89	B	5	64
From 70 to 79	C	6	25
from 60 to 69	D	7	56
less than 60	F	8	58
		9	99
		10	90
		11	28

Expert Solution

	A	B	C	D	E
	If score is	Then return	Student ID	Grade	Letter Grade	Formula
1	Greater than 89	A	1	5	F	IF(D1<60,"F",(IF(D1<69,"D",(IF(D1<79,"C",IF(D1<89,"B","A"))))))
2	From 80 to 89	B	2	55	F	IF(D2<60,"F",(IF(D2<69,"D",(IF(D2<79,"C",IF(D2<89,"B","A"))))))
3	From 70 to 79	C	3	86	B	IF(D3<60,"F",(IF(D3<69,"D",(IF(D3<79,"C",IF(D3<89,"B","A"))))))
4	from 60 to 69	D	5	64	D	IF(D4<60,"F",(IF(D4<69,"D",(IF(D4<79,"C",IF(D4<89,"B","A"))))))
5	less than 60	F	6	25	F	IF(D5<60,"F",(IF(D5<69,"D",(IF(D5<79,"C",IF(D5<89,"B","A"))))))
6			7	56	F	IF(D6<60,"F",(IF(D6<69,"D",(IF(D6<79,"C",IF(D6<89,"B","A"))))))
7			8	58	F	IF(D7<60,"F",(IF(D7<69,"D",(IF(D7<79,"C",IF(D7<89,"B","A"))))))
8			9	99	A	IF(D8<60,"F",(IF(D8<69,"D",(IF(D8<79,"C",IF(D8<89,"B","A"))))))
9			10	90	A	IF(D9<60,"F",(IF(D9<69,"D",(IF(D9<79,"C",IF(D9<89,"B","A"))))))
10			11	28	F	IF(D10<60,"F",(IF(D10<69,"D",(IF(D10<79,"C",IF(D10<89,"B","A"))))))

ekkarill92 answered 1 year ago

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line. X-Bar 2 4 5 6 Y-Bar 7 11 13 20

Please use Microsoft excel to solve the following questions. 1a) You borrowed a 15-year loan of...

Please use Microsoft excel to solve the following questions. 1a) You borrowed a 15-year loan of $1,000,000 from a bank. Interest is compounded monthly and the annual interest rate is 2.5%. Find the monthly repayment amount. 1b) You borrowed a 10-year loan of $1,200,000 from a bank. Interest is compounded monthly and the annual interest rate is 2%. What is the total interest expense of the loan? 1c) You borrowed $50,000 from a bank 2 years ago at an unknown...

1. Use Microsoft Excel to solve the question . The initial cost of an asset is...

1. Use Microsoft Excel to solve the question . The initial cost of an asset is BD100000. It has useful life of 9 years. The estimated salvage value of the asset at the end of useful life is zero. Calculate the annual depreciation and book value using double-declining balance method and find out the year in which the switching is done from double-declining balance method to straight-line method. Theory related to switching : Switching between different depreciation methods:- Switching from...

Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You...

Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You want to retire on the day you have $1,000,000 is your savings account. You expect to earn 4 percent compounded monthly, on your money during your retirement. Your plan is to withdraw $4500 a month as retirement income from this account. How many years can you be retired until you run out of money? . Question 02: you are able to pay mortgage payments...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...

PLEASE SHOW HOW TO SOLVE IN EXCEL NOT HANDWRITTEN 5) The letter grades on the midterm...

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 5) The letter grades on the midterm exam given in a large managerial statistics class are normally distributed with mean 75 and standard deviation 9. The instructor of this class wants to assign an A grade to the top 10% of the scores, a B grade to the next 10% of the scores, a C grade to the next 10% of the scores, a D grade to the next 10% of...

must use python Write a nested for loop that displays the following output using the same...

must use python Write a nested for loop that displays the following output using the same integer from part a: 1 1 2 1 1 2 4 2 1 1 2 4 8 4 2 1 1 2 4 8 16 8 4 2 1 1 2 4 8 16 32 16 8 4 2 1 1 2 4 8 16 32 64 32 16 8 4 2 1 1 2 4 ...

Using Matlab Write a program that print the following matrix. (hint: use nested for-loop and if-statement)...

Using Matlab Write a program that print the following matrix. (hint: use nested for-loop and if-statement) mat = [2 -1 0 0 0 -1 2 -1 0 0 0 0 -1 2 -1 0 0 0 -1 2];

Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and...

Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and will be turned in on Thursday, September 20th in class. You are to follow the steps we used in class on 9-13-2018 to construct the histogram for the data consisting of the ages of the 50 most powerful women in the world from 2012 (Source: Page 39 of textbook via Forbes Magazine). Your work should have columns for: 1. the raw data; 2. the...

*SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED**** A company is considering...

*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000. In addition, the machine must be installed and tested. The costs of installation and testing will amount to $10,000. The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it) The equipment will...

Question