Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Convert TI-83 equation to Excel formula...  (Read 2509 times)

0 Members and 1 Guest are viewing this topic.

arthurz11

  • Guest
Convert TI-83 equation to Excel formula...
« on: May 14, 2009, 04:15:04 PM »
Hello!,

I used my TI-83 to find an angle.  This is what I enter to my TI-83:

sin(-)(((10)(521^(-9) / (.53^(-5)))

and the correct answer is 79.42 degrees.  The calculator mode is set in degrees.

Now when I enter it on Excel 2003, it gives me the wrong answer.  How do I write the formula so I can get 79.42 degrees???

Please help...


Sincerely,
Arthur Hernandez
« Last Edit: May 14, 2009, 05:20:41 PM by CBMatt »

CBMatt

  • Mod & Malware Specialist


  • Prodigy

  • Sad and lonely...and loving every minute of it.
  • Thanked: 167
    • Yes
  • Experience: Experienced
  • OS: Windows 7
Re: Convert TI-83 equation to Excel formula...
« Reply #1 on: May 14, 2009, 05:56:03 PM »
First of all, I removed your e-mail address to avoid spamming.  I'm sure you'd hate for your inbox to be flooded with messages from Prince Ndugu asking for money.

Now...I've never used Excel 2003 (only 2007), so I don't know for sure what kind of features it has.  And I'm no math major, but I don't see how you are getting 79.42 degrees on your calculator.  When I entered the number into a TI-83 (after correcting the formula, which has an incorrect number of parentheses and an improper sine declaration), the answer was nowhere near what you got.  Admittedly, I haven't worked with geometry in several years, so I'm a bit rusty, but I certainly know how to enter numbers into a calculator.

I could be wrong, but this should be the proper way to write your formula in Excel:
=sin(-1)*(((10)*(521^(-9)))/(.53^(-5)))


By default, Excel is normally set to Degrees.  If it is set to Radian, you can write the following:
=degrees(sin(-1)*(((10)*(521^(-9)))/(.53^(-5))))

But that shouldn't be necessary.  If you are getting the incorrect answer, the only thing I can suggest is to check your formula again.  And for future record, I don't normally respond to PM's requesting help.  I've actually been away from the forums for nearly a month or two and yet I still receive a lot of messages from people asking me for help.  And in many cases, they want help with things I know nothing about.  In your case, I have some knowledge, but I am very very rusty, so I don't know how much help I can actually provide here.

Out of curiosity, what answer are you getting from Excel?
If you use a different calculator, what answer do you get?  You can search for online graphing calculators on Google.
Quote
An undefined problem has an infinite number of solutions.
—Robert A. Humphrey