The ultimate statistics add-in for MS Excel

Unistat

You can order this product Unistat directly at the vendor now (list of items)

The ultimate statistics add-in for MS Excel

Data Handling

UNISTAT for Windows comes complete with a fully-featured Excel-like spreadsheet custom-designed for statistical data handling. UNISTAT provides all the benefits of working in a true Windows environment.

• Spreadsheet: The Data Processor has all standard spreadsheet functions such as copy, move, erase, insert / delete columns and rows, undo / redo, transpose, column, matrix and key sorts (up to 9 keys). It also features a number of functions designed for scientific data handling such as ranks, dummy variables, moving averages, standardise, stack, unstack, recode, aggregate and select row.
• Formula Editor: Columns can be defined as functions of other columns using multi-function / multi-nested formulae, conditional functions and Boolean operators. The Formula Editor dialog will construct complex transformations with ease.
• Data Types: Numeric, alphanumeric (with up to eight characters per cell), date and time data can be entered, edited and transformed with full support for missing values.
• Data Import / Export: In addition to copy / paste between UNISTAT and other Windows applications, files can be loaded, merged or saved in Excel (V3/4, 95, 98, 2000), CSV, Lotus, DIF, Sylk, fixed (nondelimited) and free format (by column and by row) ASCII formats. It is possible to select any characters as field and text delimiters including tab, comma, semicolon and spaces.
• ODBC and SQL: During the setup of UNISTAT you will have the option of installing ODBC drivers. If this has been selected it is possible to open any database for which drivers are installed in the Windows system. It is also possible to execute SQL statements to extract subsets from large databases. The ODBC drivers supplied with UNISTAT include Access, dBASE, FoxPro, Paradox and Btrive.
• Security: With UNISTAT it is possible to password-protect selected UNISTAT internal files.
• Intermediary Output: In any UNISTAT procedure where a table is part of the output, there is the option of sending it to the spreadsheet for further analysis by simply clicking on a button.
• Wizards: All variable selections and selection of other options specific to each graphics and statistics procedure are made from hierarchical Wizard dialogs. Variables can also be selected for analysis by highlighting the columns to be analysed in the Data Processor. In this case the program will generate the output instantly with default options. Defaults options can be customised and saved on disk.
• Macros: It is possible to record and playback macros to automate repetitive tasks.

Integration with MS Office

UNISTAT provides researchers with a completely new intuitive way of analysing data and preparing reports. Close integration with MS Office via OLE automation enables the use of MS Excel for Windows as the spreadsheet for data preparation and UNISTAT for data analysis, while retaining MS Word as the preferred output medium, making full use of its formatting capabilities. It is possible to use UNISTAT as an Excel add-in, as a developers tool and of course as an advanced stand-alone statistical package.
UNISTAT is a unique statistical package to address this need. It is no longer necessary to use UNISTAT's own output media. If MS Word is installed then UNISTAT will automatically detect this on setup so that the user is offered its use as default medium for both text and graphics output. If this option is chosen then all text will be output as formatted Word Tables via OLE automation. The researcher is no longer limited to 'line printer' type output. Similarly if Excel is installed, both statistics and graphics can be output as formatted Excel worksheets. It is of course still possible to use UNISTAT's own excellent text and graphics output windows as default media and send only selected output to Word or Excel.

• UNISTAT as an Excel Add-In
  Many Excel users are faced with the dilemma of either analysing their data with limited Excel add-ins or switching to a powerful but inflexible statistical package. UNISTAT is a unique full power stand-alone statistical package that can also work as an Excel add-in. If UNISTAT's setup program detects the existence of MS Excel for Windows, it automatically creates an Excel add-in icon within the UNISTAT group. By double clicking on this icon you can launch Excel with UNISTAT's pull-down statistics and graphics menu options added to the Excel menu system. After preparatory data handling in Excel, all that is necessary is to highlight the block of data to be analysed and select a UNISTAT procedure from the menu. After selecting options from UNISTAT Wizard dialogs, UNISTAT will present the output as a new Excel worksheet. All except the UNISTAT Wizards will remain invisible to the Excel user. Moreover, when UNISTAT is run in Excel add-in mode, Word can still be selected as default output medium. Researchers who use Excel for data handling and Word for report compilation will find this feature most convenient.
• Default Output Medium
  First and foremost, UNISTAT is a fully-featured stand-alone statistical package including a Text Output Window and a unique Multiple Graphics Editor Window, which are used to capture, view, edit and print the statistics and graphics output from UNISTAT. However, many users of statistical packages agree that an ideal output medium should be able to handle both text and graphics output simultaneously and test results should be best presented as formatted tables.
• UNISTAT as a Development Tool
  It is also possible to run UNISTAT from another application without any part of UNISTAT appearing on the screen. If the developer has an application which requires the use of UNISTAT's powerful data analysis and graphics procedures, then UNISTAT can be called from within the application in any programming language (C, C++, VB, VBA, Pascal, FORTRAN, etc.), passing the data and receiving the results. This facility makes UNISTAT a powerful yet flexible programmer's utility for corporate users and specialised scientific software developers. Please contact Unistat Ltd for a free copy of 'Developer's Disk'.

Data Visualisation

UNISTAT displays a fully scaled and annotated graph by a single mouse click. However, a full suite of graphic editing tools is also provided.

• On-screen editing: UNISTAT supports full on-screen object editing of graphs. All text, legends, and the graph itself can be drag-dropped and resized and new text and shape objects added. The final configuration can be saved as a graphics template file for future use.
• Full control: UNISTAT permits the user to zoom into a smaller part of the graph area, to unzoom, double click on any text, to edit, redraw, print, etc. All graphics attributes including fonts, colours, titles, legends, axes, frame, tick marks, line styles, line thickness can be controlled from a series of dialogs available under the graphics menu.
• Axes: UNISTAT can display axis titles and X-axis tick labels at 0º, 90º, 270º rotations or in top-to-bottom orientation, format the scale numbers and even enter mathematical expressions for the minimum, maximum, minor and major tick values (e.g. 2*Pi()).
• Symbols: It is possible to select from the ten standard symbol types for each data series, or to load special fonts (symbol,wingdings, etc.) to display as symbols. Symbols enclosing an area (such as circles, squares, triangles) can be filled with solid colours or coloured patterns and their size adjusted.
• Error bars: Vertical / horizontal, symmetric / asymmetric error bars can be drawn for each data point on 2D and 3D scatter plots, bar, area and ribbon charts.
• Interactive graphics: Clicking on and highlighting points on a number of graphs (in 2D and 3D scatter diagrams, 3D spin, polar, normal probability and regression plots) displays information on these selected points. Simultaneously, the row of the spreadsheet containing the point is also highlighted. Or alternatively, clicking on a row of the spreadsheet highlights the point(s) representing this particular row on the graph. In this way, it is easy to determine which points are outliers in the data set. In regression plots, if the key is pressed while a point is highlighted, then this point will be omitted and the graph redrawn with a new regression equation.
• 3D options: The Spin Plot procedure permits the drawing of an X-Y-Z scatter diagram of three variables and rotation of the plot in all directions in real time. All 3D graphics procedures allow the rotationand selection of the view point, as well as selecting one of parallel, one-point, or three-point perspectives. It is possible to draw contour maps on top and / or bottom planes for 3D graphs displaying a surface (i.e. X-Y-Z graphs with surface fitting, plot of 3D functions, 3D grid plot), or alternatively display a 2D contour map with extended annotation.
• Exporting: The current image can be sent to Word or Excel simply by clicking on the Word or Excel buttons on the toolbar. Graphs can be exported to other applications via the clipboard or as a file in the form of bitmap images or Windows metafiles.
• Chart Galleries: The same data set can be plotted in many different graph styles instantly, without going through the variable selection process for a second time.

back