Exporting ICER Scatterplot to Excel
Belinda Orme
TreeAge Pro can export many graphs and other reports to Excel.
When running Probabilistic Sensitivity Analysis (PSA), one graph of interest is the ICER scatter plot. In TreeAge Pro, this graph has a straight line representing the Willingness to pay (WTP) and an ellipsis representing 95% confidence interval.
When this chart is exported to Excel, Excel does not automatically create the line or the ellipsis and only plots the points.
A TreeAge Pro modeller provided a solution to adding both the line and ellipsis in Excel.
To add the line in Excel:
- Create two columns in excel, the first to be values from the x-axis. This creates the x-coordinate for the WTP line.
- The second column values will be set equal to the WTP divided by value from the x-axis. This creates the y-coordinate for the WTP line.
- Select these two columns and then in the toolbar, use the Graph Design option tab and selected Layout Option 3. This is a graph with a trend line. This adds the WTP line.
To add the Ellipsis:
- Install XLSTAT,
- In Visualization, you choose scatter plot, and then choose x, y for the ellipse.
- In the Options, select Confidence Interval and set to an appropriate value to generate the ellipsis
This solution has been provided by a TreeAge Pro modeller to assist other people who might have the same question.
Comments
I recently found this out that we can do this in Excel without the need of XLSTAT add-in. TreeAge creates two datasheets when we export ICE data to Excel - 'Incremental CE scatter plot' and 'monteCarloDataSet'. Create two series of scatter plot using 'Costvalue' and 'EffectValue' in both the sheets. MonteCarlo.. sheet contains data points for ellipsis.
The simple method to add additional series to any graph is by copying the data for new series, then click on the Paste tab on Home Ribbon (top left corner). It will bring paste special, then add copied data as new series.
Thank you, Ruchi.
I hope others find your tips useful.
Please sign in to leave a comment.