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