These Excel templates are designed for a statistical analysis in Excel. Main screen:
If we want to calculate a correlation matrix and partial correlation matrix, click the template 'corr1'.
We enter our data in A, B, C ... and then pres the 'Correlation' button. And VBA code shows the following sheet:
If we want to calculate a partial correlation coefficient between two variables when the third one is held then we open 'corr partial' sheet:
If we want to calculate the regression coefficients, then we open the 'linest' sheet:
This workbook also contains several sheets for forecasting using a regression analysis.
The download also contains the Securities Excel templates for a financial analysis.
Platform:
Windows XP / 2000 / 2003 or later. Or NT4 Server, Windows 9x, Me, NT or Mac.
Requires Excel 2000 or later.
30 day money back guarantee!
Buy Online Correlation and Regression Excel Templates $15.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.
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 linear, polynomial and exponential regression Excel templates descrived above.
30 day money back guarantee!
Buy Online 56 Excel Financial Templates and correlation®ression Excel Templates for just $15.00
More FinExcelSoft Excel Templates
Copyright © FinExcelSoft 2014 All Rights Reserved