Correlation, Partial Correlation, and Regression Excel Templates

These Excel templates are designed for a statistical analysis in Excel. Main screen:

corr1.gif (15930 bytes)

If we want to calculate a correlation matrix and partial correlation matrix, click the template 'corr1'.

corr2.gif (13153 bytes)

We enter our data in A, B, C ... and then pres the 'Correlation' button. And VBA code shows the following sheet:

corr3.gif (7899 bytes)

If we want to calculate a partial correlation coefficient between two variables when the third one is held then we open 'corr partial' sheet:

corr5.gif (20002 bytes)

If we want to calculate the regression coefficients, then we open the 'linest' sheet:

corr6.gif (8054 bytes)

corr7.gif (20553 bytes)

Linear, polynomial and exponential regression analysis is also enabled.

This workbook also contains several sheets for forecasting using a regression analysis.

The download also contains the Securities Excel templates for a financial analysis.

System Requirements

Platform:

Windows XP / 2000 / 2003 or later. Or NT4 Server,  Windows 9x, Me, NT or Mac.

Requires Excel 2000 or later.

 Order for Correlation &Regression Excel Templates

30 day money back guarantee!

order.gif (1362 bytes) Buy Online Correlation & Regression Excel Templates $67.00

The download contains correlation and regression Excel templates.

This download contains also our bonus!

Our bonus:

sec.xls - contains 26 securities Excel templates: templates for coupons (6 templates), teplates for price calculation (6 templates), templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duratinn for a security. Full instructions.

Please note that we included this bonus just temporarily. You can also order the following more power product.

Order for FinExcelSoft Financial Excel Templates

This product contains 56 financial Excel Templates

1. npv.xls - NPV & IRR for periodic cash flows templates
2. npvirrdate.xls - NPV & IRR for any cash flows templates
3. mirr.xls - MIRR template
4. sec.xls - 26 securities templates
5. amort.xls - 5 amortization templates
6. datetime.xls - 4 date templates
7. finexcelsoft.xls - additional 16 financial templates

Excel templates for almost all financial calculations: NPV, IRR, MIRR, amortization templates, securities templates, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule, and more. finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in 7 workbooks. Use of some complex financial functions are simplified by VBA procedures. Our workbooks contain also full instructions.

This download also contains our bonus - correlation and regression Excel templates descrived above.

30 day money back guarantee!

order.gif (1362 bytes) Buy Online 56 Excel Financial Templates and correlation&regression Excel Templates for just $94.95

More FinExcelSoft Excel Templates

For more NPV & IRR and other financial Excel Templates please visit:

Busysoftorder.com Excel Templates

IovSoft Financial Excel Templates

Copyright © FinExcelSoft 2007 All Rights Reserved