SigmaPlot Product Uses
Below are example use cases leveraging SigmaPlot within the following program areas:
A. Macro Concepts
A SigmaPlot Macro Tutorial
- Recording a Macro – A tutorial showing how to record a macro that fits a decaying exponential curve to two data sets.
- Creating a New Toolbox Ribbon Button and Adding a Macro Name To It – This allows you to run a macro from a ribbon button.
- Run a Macro from a Toolbox Ribbon Button – Click a button to run the macro.
- Adding a For-Loop to Your Macro – Allows fitting multiple data sets
- Adding a Dialog to a Macro – Describes how to create a dialog user interface to a macro.
- Important Issues With Recorded Macros
- Making the Graph Page the Currently Displayed Window – Bring the graph page to the front.
- Using Statements from Recorded Macros – Record a macro to get macro code for other applications.
- 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.
- SigmaPlot Macro Sample Code – Useful macro sample code is provided for the user to copy.
B. Transforms
C. Graphs
- 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.
- 3D Histogram – A three-dimensional bar-graph histogram is created from bivariate data.
- Asymmetric Error Bars – This macro creates one of three types of graphs with asymmetric error bars from relative error bar data.
- Preparing Your Graphs for Journal or Web Publication – A discussion of the graph file formats used and/or required for journal and web publication.
- Quality Control Charts – Xbar and Range charts are created using the SigmaPlot Reference Line feature.
- 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.
- 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.
- 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.
- Panning & Zooming Using the ScaleGraph Macro
D. Analyses
- 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.
- 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.
- Shelf Life Time Analysis
- 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.
- Validation of the Shelf Life Macro – Confirms accuracy of the Shelf Life Macro
- Simulation
- Transform
- 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.
- Controlled Release Analysis
- 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.
- Explicit Function Approximation
- Create These Functions
- Modify Equations in the SigmaPlot Fit Library
- Global Analysis of Concentration Response Curves – Global curve fitting without data concatenation is demonstrated.
- Global Curve Fit of Enzyme Kinetics Data – A demonstration of simultaneous fitting of multiple functions to multiple data sets with shared parameters.
- Global Curve Fitting for Ka and Kd from Sedimentation – A global analysis of ultracentrifuge radial macromolecule concentration gradients.
- Global Curve Fitting – Dose Response Parallelism
- Curve Fitting / Regression
- Piecewise Nonlinear Regression – A four-segment piecewise linear equation is fit to rowwise replicate data.
- Weight Functions in Nonlinear Regression
- Parameter Confidence Intervals in Reports
- Implicit Function Curve Fitting
- ROC Curves Analysis
- Standard Curves Analysis
E. SigmaPlot & Excel
F. SigmaPlot & MatLab
G. Data Formats