View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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.