| Author |
Message |
Tim N (Timn88)
Intermediate Member
Username: Timn88
Post Number: 2135
Registered: 6-2001
| | Posted on Wednesday, January 29, 2003 - 10:15 am: | |
they arent hard to type in. you do know that excel can calculate eveerything for you and also that you onnly need to enter a forumla once and then use auto fill tofill inthe rest of the boxes, just make sure the cell adressing is correct (ie. that absoute cell adressing is used where its needed). theres a icon "f(x)" i think, or it muht just be "f" onthe tool bar that has all the notations for stuff you will need. |
DES (Sickspeed)
Intermediate Member
Username: Sickspeed
Post Number: 1661
Registered: 8-2002
| | Posted on Tuesday, January 28, 2003 - 11:54 pm: | |
i use Excel all the time, at work... Anyone know of an easy way of learning the formulas that can be created...? |
Chris D (Prohydro)
New member
Username: Prohydro
Post Number: 39
Registered: 11-2001
| | Posted on Tuesday, January 28, 2003 - 11:13 pm: | |
Dude, drop out of calc and then you can use a calculator whenever you want. Although, that might not be too good for your engineering degree... |
Tim N (Timn88)
Intermediate Member
Username: Timn88
Post Number: 2131
Registered: 6-2001
| | Posted on Tuesday, January 28, 2003 - 3:27 pm: | |
what happened was i thought excel was giving me BS calculations.
i edited the post as to not look like any more of an ass. |
Tim N (Timn88)
Intermediate Member
Username: Timn88
Post Number: 2130
Registered: 6-2001
| | Posted on Tuesday, January 28, 2003 - 3:24 pm: | |
well if someone could tell me the average sum of the slopes and the standard deviation for them that would be great too....
this just goes to show how dependent we are on calculators and stuff. i dont think i know how to find the standard deviation without one, and for this i have to show my work. in my calc class, calculators arent even allowed. on the bright side, i am learning how to do all types of stuff that i never thought was possible without one.
anyway, what i am trying to say is try to imagine a world without computers. |
Rob Lay (Rob328gts)
Board Administrator
Username: Rob328gts
Post Number: 3373
Registered: 12-2000
| | Posted on Tuesday, January 28, 2003 - 3:01 pm: | |
Ohh cool, "guess the part contests" and also "help Tim with homework contests". This is fun. Give us some more. |
Tim N (Timn88)
Intermediate Member
Username: Timn88
Post Number: 2129
Registered: 6-2001
| | Posted on Tuesday, January 28, 2003 - 2:13 pm: | |
i know. i know excel does give bad answers for some stuff. it was my fault this time though. i think i corrected the cell adressing it and didnt realize it.
what a headache i caused myself. |
Becker Cu�llar (Becker)
Junior Member
Username: Becker
Post Number: 61
Registered: 2-2001
| | Posted on Tuesday, January 28, 2003 - 2:12 pm: | |
Tim
I'm not Excel expert nor I like MS stuff but ln(0.1)=-2.30 which is what you requested when u said LN(A23) ... probably you meant ln(B23) to get LN(.98)
|
Mfennell70 (Mfennell70)
Junior Member
Username: Mfennell70
Post Number: 87
Registered: 7-2001
| | Posted on Tuesday, January 28, 2003 - 2:09 pm: | |
Am I missing something? Your first picture shows you taking the natural log of column A and ln(0.1) is -2.3. Don't you want column B? |
Tim N (Timn88)
Intermediate Member
Username: Timn88
Post Number: 2126
Registered: 6-2001
| | Posted on Tuesday, January 28, 2003 - 1:34 pm: | |
never mind, i am an idiot.
the world really is getting stupider. |