Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help reversing a formula...
Ok, I'll admit it right now.
I don't have as many brain cells as I used to and I need help. I have the following formula in Excel and I'm trying to reverse it.... Answer =NORMSINV(1-X/2)*Y/SQRT(Z) At the Microsoft support site it says this returns the same value as Answer =CONFIDENCE(X,Y,Z) and indeed it does. I have the value for Answer, and the values of X and Y. What formula do I need to get the value of Z? Thanks in advance. I'm going to take some aspirin now... Larry W. Las Vegas, NV |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help reversing a formula...
have you tried:
(NORMSINV(1-X/2)*Y/Answer)^2 ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help reversing a formula...
Jarek Kujawa wrote:
have you tried: (NORMSINV(1-X/2)*Y/Answer)^2 ? Doh! Don't know why I couldn't figure that one out. Not enough sleep I guess. Lol. Thanks! Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reversing Data | Excel Discussion (Misc queries) | |||
Reversing a column. How? | Excel Discussion (Misc queries) | |||
Formula for Reversing Score items | Excel Discussion (Misc queries) | |||
Reversing POWER Formula | Excel Worksheet Functions | |||
Reversing First & Last Name | Excel Worksheet Functions |