Maths In Excel - Help Needed!
 

Here is what Im trying to do:

Use the above equations (Sinh,Cosh,Tan) to create a 4-column table labelled
x, sinh(x), cosh(x) and tanh(x) and calculate the values of each function for
40 points (i.e. a step value of �/20 or 0.157) along x between 0 and 2�
radians.

Im not overly clued up on excel, so any help would be much appreciated -
Also, if anyone really enjoys doing things like the above - Id be happy to
send them a paper to do for me!

Thanks for you time
Keir

Maths In Excel - Help Needed!
 

Enter your headers in columns A, B, C, D - first row.

In A2, type 0 and press Enter.
In A3, type =A2+(PI()/20) and press Enter
Copy A3 (Ctrl+C), select cells A4:A41 and Paste (Ctrl+V)
In cell B2, type in =SINH($A2) and press Enter
In cell C2, type in =COSH($A2) and press Enter
In cell D2, type in =TANH($A2) and press Enter
Select cells B2:D2 and press Copy (Ctrl+C)
Select cells B3:D41 and press Paste (Ctrl+V)

Hope that helps.


On Dec 5, 4:00 pm, Keir FM <Keir
wrote:
Here is what Im trying to do:

Use the above equations (Sinh,Cosh,Tan) to create a 4-column table labelled
x, sinh(x), cosh(x) and tanh(x) and calculate the values of each function for
40 points (i.e. a step value of Ĉ/20 or 0.157) along x between 0 and 2Ĉ
radians.

Im not overly clued up on excel, so any help would be much appreciated -
Also, if anyone really enjoys doing things like the above - Id be happy to
send them a paper to do for me!

Thanks for you time
Keir

Maths In Excel - Help Needed!
 

thanks so much! really appreciate it!


"iliace" wrote:

Enter your headers in columns A, B, C, D - first row.

In A2, type 0 and press Enter.
In A3, type =A2+(PI()/20) and press Enter
Copy A3 (Ctrl+C), select cells A4:A41 and Paste (Ctrl+V)
In cell B2, type in =SINH($A2) and press Enter
In cell C2, type in =COSH($A2) and press Enter
In cell D2, type in =TANH($A2) and press Enter
Select cells B2:D2 and press Copy (Ctrl+C)
Select cells B3:D41 and press Paste (Ctrl+V)

Hope that helps.


On Dec 5, 4:00 pm, Keir FM <Keir
wrote:
Here is what Im trying to do:

Use the above equations (Sinh,Cosh,Tan) to create a 4-column table labelled
x, sinh(x), cosh(x) and tanh(x) and calculate the values of each function for
40 points (i.e. a step value of �/20 or 0.157) along x between 0 and 2�
radians.

Im not overly clued up on excel, so any help would be much appreciated -
Also, if anyone really enjoys doing things like the above - Id be happy to
send them a paper to do for me!

Thanks for you time
Keir