Bring dynamic scripting of R to Excel spreadsheets
Inference in Excel brings the benefits of R dynamic scripting to your Excel spreadsheets. Inference in Excel is an essential tool for business and technical professionals who regularly use Excel and need to expand its computational, graphic and automation capabilities. It provides a way for business analysts, financial analysts, line-of-business managers, scientists, engineers, educators and researchers to to perform flexible, interactive exploration, analysis and visualization of multidimensional data by leveraging the power of R dynamic scripting within the Microsoft Excel environment. With Inference in Excel, you can have it all: the power and sophistication of R along with the familiarity and convenience of Excel.
Inference in Excel bridges the functionality of Excel and R, giving you the best of both worlds. By using data preparation in Excel in conjunction with R dynamic scripts, technical analysts can answer key questions, solve technical and business problems, and present results in ways that help drive decision making. The self-service nature of Inference in Excel means that users do not depend on IT support to get the job done. Inference in Excel adds thousands of new and powerful analysis and visualization functions to Excel. Inference in Excel provides a bidirectional link between Excel and the dynamic scripting platform that can be used to:
- create spreadsheet formulas that call the R scripting functions from Excel;
- read and write data from R to Excel ranges—that is, seamless bi-directional data exchange between Excel and R;
- enable strict data typing in Excel by assigning data types to Excel ranges;
- create dynamic spreadsheets that include R scripting code that interacts with and automates execution of data analyses and creation of graphics;
- develop custom Excel import and export routines in dynamic scripting code;
- display formatted text and graphical output from execution of dynamic scripts in Excel;
- publish custom Excel-based reports directly from your R-based analysis; and
- use Excel as a gateway to feed live data and your latest data model parameters in a R scripting protocol.
Inference in Excel is tightly integrated with the patent-pending Inference platform, enabling technical analysts to interoperate their multidimensional explorations developed with Inference in Excel for technical reporting and analysis with Inference in Word and Inference Studio.
Inference in Excel's integration with the familiar Microsoft Office environment requires that Microsoft Office 2003 or 2007 be installed prior to use.