Seeing With C - Useful spreadsheets


Copyright: Hardeep Singh, 2007. All rights reserved on all sheets.
No commercial use/distribution/modification permitted.
No warranty, this is free stuff use at your own risk.

Spreadsheets

NPV

net present value calculator.

Linear Statistic relation

to find, with different probabilities, if a set of X values is statistically related to a set of Y values linearly and if so, find the relation.

Cubic Approximation

for finding the three degree curve that fits a set of points.

Biquadratic Approximation

for finding the four degree curve that fits a set of points.

Quintic Approximation

for finding the five degree curve that fits a set of points.

Exponential Approximation

for finding the exponential curve that fits a set of points.

Numeric truth

if you feed a set of values, this sheet can tell you whether or not the values are "cooked" based on Benford's law. For example entering all the numbers in an income tax return into the sheet can indicate if the return is actual or created just to decieve the authorities.
MD5: 4423DF67B6F7E886 73118F5575DD8DED
SHA256: E28D9AD8 1897285B 15CF7ACE 0E219886 C1B04ECB 4FCBD6C0 11EC59A8 ADFA9638
Version 1

DCC Index

the Digital Camera Capability Index.

Quadratic approximation is not available here because it can be more easily performed using HSB Grapher. It can also create graphs for quadratic approximation, the functions generated out of these higher degree approximation sheets and much more.

You can use OpenOffice to open and view all these sheets. I recommend Open Office Portable, which can be installed on USB drives and can be taken along anywhere - it does not need to be installed to host computers.

To save these spreadsheets, please do NOT right-click to save target. Instead, click on the hyperlink, and the save dialog should open.