Information submitted through the support site is private but is not hosted within your secure CDD Vault. Please do not include sensitive intellectual property in your support requests.

How is standard deviation handled for average values in the export file?

You wanted to make a plot of average pEC50 from one protocol vs. pEC50 for another protocol but the average values appear in this format: 5.34539 ± 1.20 (n=3). You want to plot this data without the Std. D. and the n. Is there a way to simply get the average pEC50?

 

When you pull up data for your protocols, you can plot the data without the Standard Deviation and N count values in Visualization with the Launch Visualization button.

Screen_Shot_2022-07-01_at_11.36.04_AM.png

 

You can also perform a CDD data export of averaged data values and you will receive a three-column format of the value together with the standard deviation and the number of times tested. This happens for the XLSX, CSV, and SDF export formats.

 

Here is a CSV example:

Screen_Shot_2022-07-01_at_11.25.34_AM.png