1
$\begingroup$

I have a LSD that has been produced from the transformation of percentage data. I want, if possible, to transform this number back in a % that can be plotted onto the graph with the percentages on it.

I have used the below formula in excel as recommended by the below website. However, it is not giving me a sensible answer. 

=SIN(E2/180*PI())^2*100.

http://archive.bio.ed.ac.uk/jdeacon/statistics/tress4.html

any advice you could give me would be great.

Improve this question
$\endgroup$
1
  • 1
    $\begingroup$ What is LSD? What is E2? $\endgroup$
    – user31264
    Commented Sep 25, 2014 at 21:55

1 Answer 1

Reset to default
3
$\begingroup$

If $y = \arcsin(\sqrt{p})$ then $p=(\sin(y))^2$.

To convert a proportion to a percentage, multiply by 100.

Note that your original percentages have to be transformed to proportions before taking the arcsin-square-root.

Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.