@Wendy223 , if you want someone's attention, you have to put @ in front of their name and then choose it from a dropdown, as I have done with yours. Otherwise we don't know you are asking a question unless we happen to stumble upon the thread again. It's okay. It isn't a universal thing like all-caps yelling. It is peculiar to this forum and others like it.
Anyway, no, you've got it wrong, looks like, but understandable. Here's how it works: the guest gives stars in various categories, but the guest gives stars in the overall category, too. It is not an average of the other categories; it is a separate category called "overall". That one, "overall", is the one that generates system warnings, but also that one that counts for the stars shown in searches and for superhost, etc.
You don't want to fall down in cleanliness or communication, of course. But value and location are so incredibly arbitrary that they are nothing to worry about.
I have been annoyed about location stars, too. We all have, I think. But that's one thing that we can just see as funny, e.g., they LOVED (yelling here) how remote it was, but took off a star because there were no shops around.
Funny, right? : )