Microsoft Excel Question.
I'm having trouble using the vlookup function, I have calculated a final numerical grade for a hypothetical course, and and trying to use a set of numerical grades with their corresponding letter grades to get a vlookup function to return the letter grade from the numerical grade.
However the function for some reason only returns the lowest value out of the set grades, not the closest match.
For the getting the closest match (approximate match =TRUE), the lookup data needs to be sorted in the ascending order.
The following is the sheet
Get this result
this is assuming that 89-90 you want to award B+
89.901 is in between 89-90.
Of course you can always round 89.901 to the closest integer in the vlookup
=VLOOKUP(round(C29,0),J3:K23,2,TRUE)
to get A-
Microsoft Excel Question. I'm having trouble using the vlookup function, I have calculated a final numerical...
C++: Create a grade book program that includes a class of up to 20 students each with 5 test grades (4 tests plus a Final). The sample gradebook input file (CSCI1306.txt) is attached. The students’ grades should be kept in an array. Once all students and their test scores are read in, calculate each student’s average (4 tests plus Final counts double) and letter grade for the class. The output of this program is a tabular grade report that is...
The Computer Science Instructor has just completed compiling all the grades for the C++ Programming class. The grades were downloaded into a file titled ‘studentGrades.txt’ (attached). Write a C++ Program that reads this file and calculates the following as described : The final semester numeric and letter grade (using 10 point scale) Calculated as follows: Labs 1-6 (worth 50% of final grade) Lab 7 is extra credit (worth 2 % of final grade OR replaces lowest lab grade – Select...
1. For each set below, using Excel, construct a. a frequency distribution, b. a relative frequency distribution, and c. a cumulative relative frequency distribution. Consider whether or not you should group your data. Describe how you determined your bin width, if you grouped the data in intervals. Set 1 75 95 103 100 93 91 90 92 89 105 86 85 81 96 103 99 94 95 91 97 92 107...
Midterm1 = (83.33, 98.33, 75, 91.67, 96.67, 95, 86.67, 65, 100, 100, 80, 88.33, 96.67, 96.67, 90, 96.67, 86.67, 93.33, 80, 91.67, 98.33, 86.67, 85, 86.67, 95, 83.33, 96.67, 81.67, 98.33, 100, 95, 93.33, 91.67, 88.33, 98.33, 93.33, 98.33, 93.33, 85, 88.33, 100, 98.33, 96.67, 90, 86.67, 100, 96.67, 98.33, 90, 96.67, 86.67, 95, 78.33, 86.67, 100, 81.67, 96.67, 91.67, 96.67, 96.67, 95, 96.67, 73.33, 100, 93.33, 96.67, 88.33, 70, 96.67, 96.67, 100, 88.33, 96.67, 100, 88.33, 100, 78.33, 93.33,...
Student stress at final exam time comes partly from the uncertainty of grades and the consequences of those grades. Can knowledge of a midterm grade be used to predict a final exam grade? A random sample of 200 BCOM students from recent years was taken and their percentage grades on assignments, midterm exam, and final exam were recorded. Let’s examine the ability of midterm and assignment grades to predict final exam grades. The data are shown here: Assignment Midterm FinalExam...
CIS 120 Final Project Case Study Grades Analysis 1. 4. Overview Please use the Excel data file to analyze the grades for students in their class. You are required to use either a formula or function to receive points for the steps. Typing in the answer is worth 0 (zero) points. Steps to complete are as following: Separate the student first name and last name into two columns. (5 points) 2. Get the Average, Minimum, and Maximum of Test 1....
ofessor believes that the final examination scores in statistics distributed. A sample of 40 final s sample of 40 final scores has been taken. You are given the sample below. The mean of the scores is 83.1, and the standar the scores is 83.1, and the standard deviation is 10.43. 56 63 65 68 72 72 73 75 77 78 78 79 80 80 80 80 80 80 81 81 82 84 84 86 86 87 88 90 90 92...
Question 9-15 are based on the random sample below which is obtained to test the following hypothesis about the population mean. Test the hypothesis that the mean is less than 80. 80 100 81 93 80 57 98 90 71 56 58 78 59 55 55 77 72 78 56 94 98 59 93 86 89 62 60 66 59 71 96 97 94 69 64 77 87 77 64 90 90 95 98 99 56 69 72 81 95...
Please write in MATLAB code: 1. Write a function called myMin4 that will take in four numbers and returns the minimum value. You may NOT use the built-in min() function. Run the function for the following: myMin4(4, 8, 12, 15) myMin4(18, 9, 1, 6) myMin4(8, -2, 2, 10) 2. Write a function called classAverage that takes in an array of numbers and returns the letter grade of the class average. The grade ranges are as follow: Average >90 = A...
Please help me with this program.You are to write a C++ program that will read in up to 15 students with student information and grades. Your program will compute an average and print out certain reports. Format: The information for each student is on separate lines of input. The first data will be the student�s ID number, next line is the students name, next the students classification, and the last line are the 10 grades where the last grade is...