ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   back transforming log10 standard error (https://www.excelbanter.com/excel-worksheet-functions/232626-back-transforming-log10-standard-error.html)

fluff

back transforming log10 standard error
 
Hi everyone,

I'm trying to find the back transformed values of my log10 transformed
standard error values.

The mean is 4.5857. I did 10^4.587 which gave me the back transformed
value of 38521.

The standard error is 0.11893. I have realised you cannot back
transform it in the same way as you can with the mean. Does anyone
know the calculation I can put into excel to do this for me?

Many thanks.

joeu2004

back transforming log10 standard error
 
See the thread for same subject in m.p.e.misc. It is not a good idea to
post the same inquiry in multiple related newsgroups (m.p.excel*)


----- original message -----

"fluff" wrote in message
...
Hi everyone,

I'm trying to find the back transformed values of my log10 transformed
standard error values.

The mean is 4.5857. I did 10^4.587 which gave me the back transformed
value of 38521.

The standard error is 0.11893. I have realised you cannot back
transform it in the same way as you can with the mean. Does anyone
know the calculation I can put into excel to do this for me?

Many thanks.




All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com