Scribd
Upload
23 views4 pages

Advanced Math Functions

The document outlines various mathematical calculations including averages, standard deviations, and logarithms for different columns of data. It also includes computations for sine values, exponential functions, NPV, and IRR based on provided cash flows. Additionally, it presents results for these calculations, including numerical outputs for each operation.

Uploaded by

Amarjit suklabaidya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
23 views4 pages

Advanced Math Functions

The document outlines various mathematical calculations including averages, standard deviations, and logarithms for different columns of data. It also includes computations for sine values, exponential functions, NPV, and IRR based on provided cash flows. Additionally, it presents results for these calculations, including numerical outputs for each operation.

Uploaded by

Amarjit suklabaidya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Task Column B Column C Column D

Calculate the average of numbers in Column B 12 5 0


Find the standard deviation of numbers in Column C 15 10 0.5
Compute the sine of angles (in radians) in Column D 18 15 1
Compute the logarithm (base 10) of numbers in Column E 20 20 1.5
Calculate the exponential of numbers in Column F 22 25 2
Multiply the matrices given in two separate sheets 25 30 2.5
Find the Net Present Value (NPV) for cash flows in Column G 30 35 3
Calculate the Internal Rate of Return (IRR) for values in Column H 35 40 3.5

19 22.125 12.247449 0
-2 0.4794255
0.841471
0.997495
0.9092974
0.5984721
0.14112
-0.350783
Column E Column F Column G Column H
1 0.1 -1000 -500
10 0.2 200 100
100 0.3 300 150
1000 0.4 400 200
10000 0.5 500 250
100000 0.6 600 300
1000000 0.7 700 350
10000000 0.8 800 400

0 1.1051709 ₹ 1,136.36 34%


1 1.2214028
2 1.3498588
3 1.4918247
4 1.6487213
5 1.8221188
6 2.0137527
7 2.2255409
1 2
3 4
5 6
7 8

You might also like