SigmaPlot - Product Uses

A SigmaPlot Macro Tutorial

1. Recording a Macro – A tutorial showing how to record a macro that fits a decaying exponential curve to two data sets.
2. Creating a New Toolbox Ribbon Button and Adding a Macro Name To It – This allows you to run a macro from a ribbon button.
3. Run a Macro from a Toolbox Ribbon Button – Click a button to run the macro.
4. Adding a For-Loop to Your Macro – Allows fitting multiple data sets
5. Adding a Dialog to a Macro – Describes how to create a dialog user interface to a macro.
6. Important Issues With Recorded Macros
   1. Making the Graph Page the Currently Displayed Window – Bring the graph page to the front.
   2. Using Statements from Recorded Macros – Record a macro to get macro code for other applications.
7. Batch Processing using SigmaPlot Automation – Select a group of Excel files to process in a batch. This macro fits a user-selected SigmaPlot curve fit equation to the data, creates a graph and saves the results for all Excel files in a SigmaPlot notebook.
8. SigmaPlot Macro Sample Code – Useful macro sample code is provided for the user to copy.

• Rowwise Statistics Transform – This transform computes statistics. It complements the columnwise statistics available from the main menu.
• Transform Functions Root and Implicit– These two new functions have been added to solve equations.

1. Histogram Plus Kernel Density – Histogram and cumulative histograms are created from a single column of data. Four graph types and other options are provided. The smooth kernel density estimate of the probability density is also provided.
2. 3D Histogram – A three-dimensional bar-graph histogram is created from bivariate data.
3. Asymmetric Error Bars – This macro creates one of three types of graphs with asymmetric error bars from relative error bar data.
4. Preparing Your Graphs for Journal or Web Publication – A discussion of the graph file formats used and/or required for journal and web publication.
5. Quality Control Charts – Xbar and Range charts are created using the SigmaPlot Reference Line feature.
6. Ribbon Graph – This transform uses XZ profiles from XY Many Z data to generate the individual ribbons of a ribbon graph. This transform is located in your SigmaPlot Transforms folder.
7. Shade Between Two Curves – This macro creates a shade between two curves. It complements SigmaPlot’s built-in area plot feature that shades area under the curve to the X-axis. The macro assumes the data for both curves is strictly increasing in x.
8. Formatted SigmaPlot graphs for Submission to the FDA – The procedure is described for pasting SigmaPlot graphs into Microsoft Word that fit within specified margins and have a fixed font size.
9. Panning & Zooming Using the ScaleGraph Macro

1. Analysis of Ligand Binding Data – Competition, saturation and dose-response studies may be analyzed with SigmaPlot. Multiple replicate data sets are fit using an equation selected from a list of ten — and you may add your own. Graphical results, EC50 values and a statistical report are produced.
2. Analyzing Dissolution Test Data with SigmaPlot’s Excel Spreadsheet – An Excel worksheet analyzes up to 12 vessel by 6 sample time dissolution test data. Publication quality graphs of the results are simultaneously created.
3. Shelf Life Time Analysis
   1. Computing Shelf Life Time with SigmaPlot – An exact computation of shelf life time is computed and graph created. Four designs are available – lower specification only, upper specification only, lower and upper specification and degradant analysis.
   2. Validation of the Shelf Life Macro – Confirms accuracy of the Shelf Life Macro
   3. Simulation
   4. Transform
4. Data Smoothing – Three real-world examples with increasing variability show the usefulness of SigmaPlot’s data smoothing algorithms to visualize the information in the data.
5. Controlled Release Analysis
   1. Fitting Controlled Release and Dissolution Data – Five controlled release models for analysis of drug dissolution data are implemented as a SigmaPlot fit library. One or all models may be easily fitted to your data.
   2. Explicit Function Approximation
   3. Create These Functions
   4. Modify Equations in the SigmaPlot Fit Library
6. Global Analysis of Concentration Response Curves – Global curve fitting without data concatenation is demonstrated.
7. Global Curve Fit of Enzyme Kinetics Data – A demonstration of simultaneous fitting of multiple functions to multiple data sets with shared parameters.
8. Global Curve Fitting for Ka and Kd from Sedimentation – A global analysis of ultracentrifuge radial macromolecule concentration gradients.
9. Global Curve Fitting – Dose Response Parallelism
10. Curve Fitting / Regression
11. Piecewise Nonlinear Regression – A four-segment piecewise linear equation is fit to rowwise replicate data.
12. Weight Functions in Nonlinear Regression
13. Parameter Confidence Intervals in Reports
14. Implicit Function Curve Fitting
15. ROC Curves Analysis
16. Standard Curves Analysis

• Create a SigmaPlot Graph in Excel – An Excel macro that creates a SigmaPlot graph in Excel.
• Using Macros to Place SigmaPlot Charts Within Microsoft Aplications – The macro statements required to insert a SigmaPlot graph into a PowerPoint slide are shown and explained. The similar procedure for placing a graph in Word is then shown.

• MATLAB^® SigmaPlot^TM Functions

• Replicate Data Format
• X,Y Many Z to X, Y, Z Format -This transform converts from one format to another. For example, the 3D smoothing algorithms requires data in XYZ format.