What the heck is Sin-1

  • Thread starter Thread starter mcmcom
  • Start date Start date
M

mcmcom

I am in need of math help!

I no NOTHING about Sine and Cosine except for what i've read in a boo
in the past day. Now, I need to use SIN-1 (which I can see on m
Calculator) but I don't know the formula in Excel. How do I writ
this Sin-1 expression?

Is it ASIN?

Also, is there any website anyone knows about that has information o
advanced excel formulas, with examples. Perhaps where i can see sin-
or cos-1 examples? Thanks

thank
 
...
...
I no NOTHING
Click to expand...

Perhaps you know nothing either.
about Sine and Cosine except for what i've read in a book
in the past day. Now, I need to use SIN-1 (which I can see on my
Calculator) but I don't know the formula in Excel. How do I write
this Sin-1 expression?

Is it ASIN?
Click to expand...

Yes.

With respect to real words examples of Excel functions, best source is the
Google Groups archives for the Excel newsgroups. If there are no previous
articles for some built-in functions in the archives, it's a fair bet they're
never needed in real world formulas. That said, ASIN has appeared in the
archives before, as have the Bessel functions. As far as I can tell, only the
complex arithemetic functions get hardly any airing in the newsgroups. Well,
then again it's not like REPT or REPLACE are going to top the charts any time
soon either.
 
SIN-1 is another way of expressing arcsine. This
calculation is represented by ASIN in excel, with the
output in radians from -pi/2 to pi/2. To try and give
you a quick trigonometry lesson, the sine of an angle is
a number that represents a ratio between the two sides
that make up an angle (the adjacent side and the
hypotenuse). The sine is a number between -pi/2 and
pi/2. If you have the sine of an angle (pi/6 or -0.5,
etc) and want to know what the size of the angle is with
that sine, use the arcsine function. To convert the ASIN
output in excel (which is in radians) to a degree output,
multiply the excel output by 180/pi(). There should be
info in the Excel help file. I will paste the output
here from my help file.


ASIN
Returns the arcsine of a number. The arcsine is the angle
whose sine is number. The returned angle is given in
radians in the range -pi/2 to pi/2.

Syntax

ASIN(number)

Number is the sine of the angle you want and must be
from -1 to 1.

Remark

To express the arcsine in degrees, multiply the result by
180/PI( ).

Examples

ASIN(-0.5) equals -0.5236 (-pi/6 radians)

ASIN(-0.5)*180/PI() equals -30 (degrees)
 
gee,

thanks i think. I don't know if your insulting me or trying to help.

Let me re-phrase. Is ASIN the same as Sin-1 is on a scientifi
calculator?

Thanks for making me feel like crap for trying to learn some math.
hope it bloats your ego sufficiently
 
thanks i think. I don't know if your insulting me or trying to help.

Let me re-phrase. Is ASIN the same as Sin-1 is on a scientific
calculator?
Click to expand...

Yes- Harlan did actually answer that. Try in Cell A1 number 0.11 , in B1
formula =SIN(A1) and in C1 formula =ASIN(B1). It should result in the same
as A1, up to A1 values pi/2.

HTH. Best wishes Harald
 
...
...
Let me re-phrase. Is ASIN the same as Sin-1 is on a scientific
calculator?
Yes.

Thanks for making me feel like crap for trying to learn some math. I
hope it bloats your ego sufficiently.
Click to expand...

It's not your stated ignorance of math, it's your unwillingness to spell. I hate
txting, so I flame it whenever the mood is right.
 
well.............at least something useful was discovered.

................................
 
THANK YOU ANONYMOUS

Your ASIN Help and the fact that I have to MULTIPLY the answer b
(180/pi()) was JUST WHAT I NEEDED!!!!

THANK YOU THANK YOU THANK YOU

This is the formula I used (in case anyone cares)

=ASIN(F10*SIN(E10/(180/PI()))/H10)*(180/PI())

It works great. Thanks again!

You too Harlan. Me be gracious veritably to u 2, amigo.

;
 
Just to add to your Excel library, this might be another way. (I may have it
slightly off...)

=DEGREES(ASIN((F10/H10)*SIN(RADIANS(E10))))

The idea being that the following also returns 30.

=DEGREES(ASIN(0.5))

(It would just be personal preference.)
 
Back
Top