I have the excel General maths text book and all the answers I am getting for trigonometry are wrong (according to the book) although I am using the same method as the book..first I thought it was my calculator but then I tried another one and got the same anwer...Is it possible the text book answers are wrong cause I'm going crazy over simple trig...when i use the new century text book my method works but with this one and general math in a month the answers are weird...PLZ HELP SUM1
-
Looking for HSC notes and resources? Check out our Notes & Resources page
excel answers wrong!!!!!! (1 Viewer)
- Thread starter nanoose
- Start date
Dreamerish*~
Love Addict - Nakashima
- Joined
- Jan 16, 2005
- Messages
- 3,705
- Gender
- Female
- HSC
- 2005
Post up a couple of questions, and I'll tell you what I get.
switchblade87
Member
Perhaps your calculator is in the wrong mode, say in Radians (R) instead of Degrees (D). That will change your answer. Post some up and we'll see.shoo_nanoose said:
P
pLuvia
Guest
It depends on the edition the textbook is in, 1st edition usually has lots of mistakes and the mistakes reduce as more editions are published
Another thing to look out for in the Excel book...
Quite a few of the Financial Maths questions on annuities have payments made at the beginning of each period. In the General Maths course, annuities always have payments made at the END of each period. The formulas given on the formula sheet only work for payments made at the end of each period.
So ... don't get too freaked out by these questions if you can't seem to figure out the answer at the back of the book!
Quite a few of the Financial Maths questions on annuities have payments made at the beginning of each period. In the General Maths course, annuities always have payments made at the END of each period. The formulas given on the formula sheet only work for payments made at the end of each period.
So ... don't get too freaked out by these questions if you can't seem to figure out the answer at the back of the book!
If you have a loan (i.e. making repayments) then you'll always use the PV formula, and the amount of the loan (the amount borrowed) is the PV. Use the formula to work out M, monthly payments.
If you're investing money, then it's a little more complicated:
1. If you're just putting a single sum of money away to start with, then it's Compound interest.
2. If you're making a series of regular payments, then it's an annuity so you use FV formula.
But ... if you're thinking about making regular payments and you want to look at the option of a single payment which will grow to the same amount, then you use PV.
See ... complicated.
If you're investing money, then it's a little more complicated:
1. If you're just putting a single sum of money away to start with, then it's Compound interest.
2. If you're making a series of regular payments, then it's an annuity so you use FV formula.
But ... if you're thinking about making regular payments and you want to look at the option of a single payment which will grow to the same amount, then you use PV.
See ... complicated.