Wednesday, February 6, 2013

Inverse Sine Functions in Excel


The process of inverse sine functions functions represents the processing of the trigonometric functions with inverse calculations in the excel. The students normally does not involve in the inverse functions in excel but when we intend to calculate the angles we calculate it in the excel. In this article we are going to discuss about the inverse sine functions in the excel which shows clear image for understanding the concept fully.

I like to share this Integrals of Inverse Trig Functions with you all through my article.

Examples for Inverse Sine Excel

Review on the inverse sine excel functions in excel for the functions sin^(-1) x

Solution:

The values present in the excel showing the column are represented or mentioned as A2, A3, A4, A5, A6 and A7.

Excel help in inverse sine functions

We want to provide the inverse sine functions in the cells where we need.

The functions exist are  sin^(-1) x   for that the excel format is ASIN(x)

On the corresponding cells,

B2 = asin(A2) and C2 =Degrees(asin(A2)).

B3 =asin(A3) and C3 =Degrees(asin(A3)).

B4 = asin(A4) and C4 =Degrees(asin(A4)).

B5 = asin(A5) and C5 =Degrees(asin(A5)).

B6 = asin(A6) and C6 =Degrees(asin(A6)) .

B7 = asin(A7) and C7 =Degrees(asin(A7)) .


Excel help in inverse sine functions

This formula is applied in all the cells that we needed by dragging the cell in single or in group.

Excel help in inverse sine functions

The  results of the inverse sine functions

sin^-1(0.1) = 0.10016 in radians,   sin^-1(0.1) = 5.73917 in degrees

sin^-1(0.2) = 0.20135 in radians,   sin^-1(0.2) = 11.5369 in degrees

sin^-1(0.3) = 0.30469 in radians,  sin^-1(0.3) = 17.45760 in degrees

sin^-1(0.4) = 0.41151 in radians,    sin^-1(0.4) = 23.5781 in degrees

sin^-1(0.5) = 0.52359 in radians,   sin^-1(0.5) = 30 in degrees

sin^-1(0.6) = 0.64350 in radians,   sin^-1(0.6) =36.8698 in degrees

We can do any inverse trigonometric functions in this way with the excel format.

My forthcoming post is on word problems 5th grade math and syllabus of iit jee 2013 will give you more understanding about Algebra.

Problems for Inverse Sine Excel

Review on the inverse sine excel functions in excel for the functions  sin^(-1) x  + logx in radians

Solution:

We want to provide the inverse sine functions in the cells where we need.

The functions exist are  sin^(-1) x   for that the excel format is ASIN(x)

The functions exist are  log x   for that the excel format is LOG(x)

On the corresponding cells,

B2 = asin(A2) and C2 =LOG(A2) + asin(A2).

B3 =asin(A3) and C3 =LOG(A3) + asin(A3).

B4 = asin(A4) and C4 =LOG(A4) + asin(A4).

B5 = asin(A5) and C5 =LOG(A5) + asin(A5).

B6 = asin(A6) and C6 =LOG(A6) + asin(A6) .

B7 = asin(A7) and C7 =LOG(A7) + asin(A7) .

Excel help in inverse sine functions

No comments:

Post a Comment