Arcsin equation - getting results?

  • Context: Graduate 
  • Thread starter Thread starter Sparky_
  • Start date Start date
Click For Summary
SUMMARY

The discussion centers on the application of the complex variable approach to the arcsine function, specifically using the equation w = -i*ln(iz +/- SQRT(1-z^2)) to derive angles from given sine values. Users report successful outputs for z = 0.5 and z = 0.707, yielding angles of approximately 0.5236 radians (30 degrees) and 0.7854 radians (45 degrees) respectively, when calculated correctly. However, challenges arise when attempting to implement this in Excel, with users struggling to reconcile the complex terms and achieve matching results with the built-in Arcsin() function.

PREREQUISITES
  • Understanding of complex numbers and their operations
  • Familiarity with the arcsine function and its properties
  • Proficiency in using Excel for mathematical computations
  • Knowledge of logarithmic functions and their applications in complex analysis
NEXT STEPS
  • Explore the derivation of the arcsine function using complex analysis techniques
  • Learn how to implement complex number calculations in Excel
  • Study the properties of logarithmic functions in the context of complex variables
  • Investigate manual methods for calculating arcsine values using complex variables
USEFUL FOR

Mathematicians, students of complex analysis, data analysts using Excel for mathematical modeling, and anyone interested in the intersections of trigonometry and complex numbers.

Sparky_
Messages
227
Reaction score
5
Regarding the arcsine function and the complex variables approach:

z = sin(w)

w = -i*ln(iz +/- SQRT(1-z^2))

I'm trying to plug in numbers for z and "turn the crank" and get back the angle.

Meaning, if z = 0.5, the equation should yield 0.5236 (30 degrees) and if z = 0.707, I should get 0.7854 (45 degrees).

I've tried to do this in Excel. - no luck

I was assuming the "i" terms shifted things ?perhaps by PI/2? - no combination has worked.

How does this equation yield arcsine values? How do I turn the crank and handle the "i" terms.

Thanks
Sparky_
 
Physics news on Phys.org
Sparky_ said:
Regarding the arcsine function and the complex variables approach:

z = sin(w)

w = -i*ln(iz +/- SQRT(1-z^2))

I'm trying to plug in numbers for z and "turn the crank" and get back the angle.

Meaning, if z = 0.5, the equation should yield 0.5236 (30 degrees) and if z = 0.707, I should get 0.7854 (45 degrees).
? My TI-83 gives 0.523598... for z= 0.5 and 0.785398... for z= sqrt(2)/2 using your formula.

I've tried to do this in Excel. - no luck

I was assuming the "i" terms shifted things ?perhaps by PI/2? - no combination has worked.

How does this equation yield arcsine values? How do I turn the crank and handle the "i" terms.

Thanks
Sparky_
 
I'm curious how I can implement this equation manually. (pencil and paper of sorts)

I set this up in Excel (I know this is not pencil and paper)

I have a column for radians, I have a column that takes the sin() of that coumn, than I use Excel's Arcsin() function and take the arcsin of the sin() and then I have a column using the complex variables formula w = -i*ln(iz +/- SQRT(1-z^2)).

My hope is to have the 2 columns match - the column using the actual arcsin() function and the complex var. equation.

The complex variables formula uses simple operations that could be performed manually. I'm trying to understand how to do it manually and how to deal with the "i" terms since my attempts have failed. I thought the "i" terms would simply shift things by pi/2 or something like that.


Thanks
Sparky_
 

Similar threads

  • · Replies 9 ·
Replies
9
Views
4K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 4 ·
Replies
4
Views
5K
  • · Replies 16 ·
Replies
16
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 7 ·
Replies
7
Views
1K
  • · Replies 12 ·
Replies
12
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 1 ·
Replies
1
Views
2K