The lower range for a "D" is in F5, so the upper range for "F" (calculated by the formula in G4) would be one less than than that.
What formulas have you tried? What (if anything) is wrong with the results that they return?
This is a discussion on Adding missing values (HELP!!) within the Excel Questions forums, part of the Question Forums category; I am trying to do an assignment and am having a really hard time figuring it out. The other steps ...
I am trying to do an assignment and am having a really hard time figuring it out. The other steps I have figured out.
This is the step:
In the test score worksheet the range F4:G8 will contain the lower and upper ranges for each letter grade. Add the missing upper range values in the range G4:G7 by inserting formulas in each of those cells that calculates the upper range for each letter grade as being one point lower than the lower range of the next letter grade. any changes to the numeric values in F5:F8 should result in changes to the calculated values in G4:G7.
Grading Curve Lower Range Upper Range Grade Count Percentage Optimal Difference 0 F 5.0% 20 D 10.0% 40 C 35.0% 60 B 35.0% 80 100 A 15.0% Total 100.0%
PLEASE HELP!!!
The lower range for a "D" is in F5, so the upper range for "F" (calculated by the formula in G4) would be one less than than that.
What formulas have you tried? What (if anything) is wrong with the results that they return?
I've tried using the sum, if, >= to, and tried subtracting by 1, but it throws back an error like ?name, ?value. The book doesn't show an example of this so that's why I'm having an issue.
A basic formula like =A1-2 should work in this situation.
let me try real quick to see if it works
The formula that I gave isn't the one you want. (I've been trying like mad to avoid doing that).
If your text doesn't give basic examples like this, you might consult Excel's built-in Help feature.
Ok I got it but now something else doesn't want to work. It says that if there's perfect correspondence that L9 would be zero. Well it is showing 56.36%. =COUNTIF($D$4:$D$223,H4) for the Count, =I4/220 percentage, =abs(j4-k4) difference,
Grading Curve Lower Range Upper Range Grade Count Percentage Optimal Difference 0 59 F 54 24.5% 5.0% 19.5% 60 69 D 41 18.6% 10.0% 8.6% 70 79 C 60 27.3% 35.0% 7.7% 80 89 B 34 15.5% 35.0% 19.5% 90 100 A 31 14.1% 15.0% 0.9% Total 220 100.0% 100.0% 56.36% 56.36% 4 TRUE 100 100
Hey lenakjm
what formula did you use to find the upper range?
Nevermind I got it. I feel dumb now how easy that was.
Last edited by BlueCore; Nov 16th, 2011 at 03:52 PM.
I felt like a complete idiot especially since it was something that easy.
I still don't get it how do you find the upper range value ? If I do =F-1
upper rage will be 19 ? not 59 ? how did you get 59 ? and why did you change all the lower range value ?
Like this thread? Share it with others