math/excel - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: math/excel (/showthread.php?tid=71949)
math/excel by Supersonicdarky on 02-20-2007 at 03:51 AM
can someone check if the second thingy in there is right?
you enter x and y coordinates of two points and it gives you the slope (y=mx+b)
i'm not entirely sure i got b (y intercept) formula correct, can someone check?
ignore the other stuffs
also can .xls be allowed?
RE: math/excel by markee on 02-20-2007 at 04:03 AM
G16 should actually be "=G6-G15" or else you get the negative of it. You could have checked this by actually making a graph and plotting the points to see that the y intercept had to be positive
EDIT: The third thing seems to be an interest formula except I don't think you did it right, you should add the last value, not the initial value and the interest should be fixed (or just write it in the form of a geometric progression....).
RE: math/excel by Supersonicdarky on 02-20-2007 at 04:07 AM
i forgot i had a graphic calc
o well, thnx =]
edit:
this is a partner activity, and i did the first 2 parts and someone else did the 3rd. thnx for noticing, now i get to scold them tomorrow
also, how do i do the geometric thingy? i rarely use excel and hardly know how to do anything
RE: math/excel by markee on 02-20-2007 at 04:25 AM
For excel you should write "=$N3*1.01^R" but you will need to change the R for each (increase by one each time) and I even made it so you can put it into one and drag it across with ease too
EDIT: I should explain it to.... $N3 is you initial value, 1.01 is the interest rate and keeping the principle amount and you times that by the time interval as this is the same as just putting another *1.01 on the end to get the next interval. If you do them individually and then substitute each equation in to the next then you would see exactly what I'm talking about.
|