Regression Analysis and Forecasting 3.0

The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity.

Product Details

Publishers Description

The Multiple Regression Analysis and Forecasting template enables the confident identification of value drivers and forecasting business plan or scientific data. The multiple regression process utilizes commonly employed statistical measures to test the validity of the analysis and results are summarized in text form to be easily understood. When predictive relationships have been identified by the regression analysis, forecasting can be quickly accomplished based on a range of available methodologies and accompanying statistical strength. An intuitive stepwise work flow enables to develop strong forecasts for projects in a timely manner. The Multiple Regression Analysis and Forecasting model provides simple and flexible input with integrated help icons to facilitate utilization. Results and statistics are explained in a user friendly manner to be understood by users of all levels of statistical expertize. The Multiple regression analysis and forecasting template provides much more functionality than the Excel Analysis Toolpak such as individual regression of all independent variables, the actual level of confidence for the results, and tests of for autocorrelation and multicollinearity. The forecasting process provides options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables as well as the option to override independent variable forecast data with external analysis. The Multiple Regression Analysis and Forecasting template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform regression and forecasting solution.

Requirements: Requires Microsoft Excel 97 or higher
Languages: English
Release Info: Major Update on Sep 19, 2013
Release Notes: No limit to the number of independent variables. Automatic and configurable feature selection. Faster data processing. Support for categorical and logistic/binary variables. Save as XLSM feature for recent versions of Excel and enhanced exporting functions.
Related Tags: Excel forecasting multiple regression template

Other products submitted by this publisher

Bond Yield Calculator

The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.

Investment and Business Valuation

The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.

Invoice Template for Excel

The invoice template for Excel is a complete customer invoicing system with ability to store created invoices, products and customer details, manage inventory and perform advanced order sales reporting.

Portfolio Optimization

The Portfolio Optimization template optimizes capital weightings for portfolios of financial investments that maximizes return and minimizes risk. Technical analysis constant parameters are optimized to maximize back tested returns on signal trading.

Portfolio Performance Monitoring

The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.

Product Specifications

Download Purchase
User Rating:
5 out of 5 (based on 1 ratings)
FileCart Rating
Submitted by:
Homepage Visit Homepage
License Shareware
Expires 30 Days
Price $19.00
Downloads 420
OS Support Windows Install and Uninstall
File Name excel_regfor.zip
File Size 0.16 MB ( 167 KB )
Published Aug 11, 2003 (13 years ago)
Updated Dec 15, 2013 (3 years ago)

Featured Listings

Featured Products
VBAcodePrint
Print Microsoft VBA source code in color of your applications across the entire Microsoft...
iMetaSearch
Search engines can't group results based on meaning, but iMetaSearch can.
Servers Alive
Get 24/7 foolproof server monitoring and reporting.Try free Servers Alive.