A new, fourth version of the distribution fitting application EasyFit is planned to be released later this month (November 2007). We’re currently busy with extensively testing the product and updating the documentation.
The new version will in particular be of great interest to Excel users as, in addition to a stand-alone desktop application, EasyFit will also work as a MS Excel add-in, making it a flexible yet powerful solution for complex probability calculations such as Monte Carlo simulation. Though the desktop application is still a very important part of the product, the advanced Excel integration is something we have got so many requests for.
Some of the new Excel-related features and benefits of EasyFit include:
1) Visual interface for data analysis and simulation: EasyFit integrates into Excel’s main menu, enabling you to easily fit probability distributions to data and generate random numbers without the need to leave the popular spreadsheet application.
2) Worksheet functions: EasyFit makes about 300 new functions available to Excel worksheets, allowing you to perform specific probability calculations and decision making based on the analysis results.
The functions include random number generation, PDF, CDF, Inverse CDF (and more) for all the 40+ probability distributions supported by EasyFit.
3) VBA functions: All the 300 new functions (see above) will also be available to Excel Visual Basic applications, allowing you to use the features of EasyFit in your own VBA programs. You no longer need to remember complex formulas and deal with the lack of support for probability distributions in standard Excel library.
The supported Excel versions are 2000, 2002, 2003, and 2007. The latest version (2007) is worth special mention as, aside from the completely new user interface, it introduces several important features not available in the older versions, specifically the support for larger worksheets and the multi-threaded recalculation. The users of EasyFit will benefit from this new functionality as well – more on this topic next time.
The desktop application (EasyFit) has also been improved: it now provides a new graph type (Q-Q Plot), more flexible graph options, extended export capabilities, P-values calculation, an updated implementation of the Kolmogorov-Smirnov goodness-of-fit test, a new random number generator, and more.
In the meanwhile, if you order the current version of EasyFit this month, you will be able to upgrade to the upcoming new version for free. The free upgrade will also be provided to all the existing customers who purchased EasyFit less than a year ago.