Please help with Excel formula: ((X-AVERAGE(A,B,C,D,E,F,G,H,I,X))*100)/J

M

Mathdude21

New member
Joined
Jul 19, 2023
Messages
3
Hello

Can someone please help me with this excel formula?

((X-AVERAGE(A,B,C,D,E,F,G,H,I,X))*100)/J

((X-AVERAGE(377.80,379.81,377.42,381.79,380.23,387.67,393.30,393.96,394.73,X))*100)/6.26

I need a formula that will tell me what X would have to be for the above formula to equal 50 (or in other case 40, etc)

Thanks

Aaron
 
Mathdude21 said:
Hello

Can someone please help me with this excel formula?

((X-AVERAGE(A,B,C,D,E,F,G,H,I,X))*100)/J

((X-AVERAGE(377.80,379.81,377.42,381.79,380.23,387.67,393.30,393.96,394.73,X))*100)/6.26

I need a formula that will tell me what X would have to be for the above formula to equal 50 (or in other case 40, etc)

Thanks

Aaron
Click to expand...
Since our goal is to help, not just give a complete answer without you having the think at all, we'd like to see either your attempt, or an explanation of what you know and what you don't:

Posting Guidelines (Summary)

Welcome to our tutoring boards! :) This page summarizes the main points from our posting guidelines. As our name implies, we provide math help (primarily to students with homework). We do not generally post immediate answers or step-by-step solutions. We don't do your homework. We prefer to...
www.freemathhelp.com

What you apparently want to do is to solve this equation for x: [math]\frac{x-\frac{A+B+C+D+E+F+G+H+I+x}{10}}{J}\cdot100=y[/math] where [imath]y=50[/imath] or whatever. Do you know enough algebra to attempt that?
 
Mathdude21 said:
Can someone please help me with this excel formula?
Click to expand...

Probably. But first we need to see where you're having the trouble. So please review the "Read Before Posting" message, and reply with the missing information.

Mathdude21 said:
((X-AVERAGE(A,B,C,D,E,F,G,H,I,X))*100)/J

((X-AVERAGE(377.80,379.81,377.42,381.79,380.23,387.67,393.30,393.96,394.73,X))*100)/6.26

I need a formula that will tell me what X would have to be for the above formula to equal 50 (or in other case 40, etc)
Click to expand...

You have the following formula:

[imath]\qquad \dfrac{\left(X - \dfrac{(A+B+C+\ldots+X)}{n}\right)(100)}{J}[/imath]

...[imath]n[/imath] is the number of values that you're averaging.

You need this expression to be equal to 50, so set it equal:

[imath]\qquad \dfrac{\left(X - \dfrac{(A+B+C+\ldots+X)}{n}\right)(100)}{J} = 50[/imath]

Where does this lead? Please be complete. Thank you!
 
Suggestion: Make your life a bit easier and jus add up the A + B + ... and call it Y. Then you need to solve
[imath]\dfrac{\left ( X - \dfrac{Y + X}{n} \right ) (100)}{J} = 50[/imath]

-Dan
 
Hmm, based off these answers, I believe I must have phrased the question incorrectly. I understand that all the answers are saying algebraically:

((X-AVERAGE(377.80,379.81,377.42,381.79,380.23,387.67,393.30,393.96,394.73,X))*100)/6.26 = 50

But how can I solve for X? I need to know what X is for the above to be true?
 
Mathdude21 said:
Hmm, based off these answers, I believe I must have phrased the question incorrectly. I understand that all the answers are saying algebraically:

((X-AVERAGE(377.80,379.81,377.42,381.79,380.23,387.67,393.30,393.96,394.73,X))*100)/6.26 = 50

But how can I solve for X? I need to know what X is for the above to be true?
Click to expand...
Dr.Peterson asked you in post #2 if you knew how to solve this. I take it that you are saying you do not?

You have an equation that says
[imath]\dfrac{ \left ( X - \dfrac{Y + X}{n} \right ) (100) }{J} = 50[/imath]

Rule of thumb #1: Get rid of as many fractions as you can.

So multiply both sides by J:
[imath]\left ( X - \dfrac{Y + X}{n} \right ) (100) = 50J[/imath]

Now multiply both sides by n:
[imath](nX - (Y + X) ) (100) = 50nJ[/imath]

Can you take it from here?

-Dan

Addendum: I just had a thought. Are you asking if Excel can solve this? The answer is no. You have to do the algebra.
 
Mathdude21 said:
Hmm, based off these answers, I believe I must have phrased the question incorrectly. I understand that all the answers are saying algebraically:

((X-AVERAGE(377.80,379.81,377.42,381.79,380.23,387.67,393.30,393.96,394.73,X))*100)/6.26 = 50

But how can I solve for X? I need to know what X is for the above to be true?
Click to expand...
I think you don't quite understand what "solve for X" means. It does not always mean "find the exact value of X". In general, it means rearranging the formula, so that instead of
something, X, something = 50
it looks like
X = something
In other words, we need to isolate X on one side of the equation.

For example, solve for X: 2X + B = 7
Solution:
Subtract B from both sides: 2X = 7 - B
Divide both sides by 2: X = (7 - B)/2
 
topsquark said:
Dr.Peterson asked you in post #2 if you knew how to solve this. I take it that you are saying you do not?

You have an equation that says
[imath]\dfrac{ \left ( X - \dfrac{Y + X}{n} \right ) (100) }{J} = 50[/imath]

Rule of thumb #1: Get rid of as many fractions as you can.

So multiply both sides by J:
[imath]\left ( X - \dfrac{Y + X}{n} \right ) (100) = 50J[/imath]

Now multiply both sides by n:
[imath](nX - (Y + X) ) (100) = 50nJ[/imath]

Can you take it from here?

-Dan

Addendum: I just had a thought. Are you asking if Excel can solve this? The answer is no. You have to do the algebra.
Click to expand...
Yes, I've figured it out here there. Thank you very much for the help. Much appreciated. Will never cease to be amazed how we can manipulate symbols in our minds to accurately describe reality.
 
You must log in or register to reply here.
Top