PCR Data File Upload Instruction - How to use this tool?  Play Movie Guide   or   Take a Test Run
Catalog #:      Or      

  1. Choose the correct PCR Array Catalog number from the drop list. Browse and select the MS Excel file containing your PCR Array data with a maximum number of 50 samples. Click "Upload".

  2. On the "Readout" page:

    1. In the "Basic Setup" section, assign samples to different groups. At least two groups are needed and up to a maximum of 11 are allowed, where one of those groups must be the control group. Click "Update" when finished.
    2. The "View Housekeeping Genes" section allows you to remove or add preferred housekeeping genes for data normalization by clicking the appropriate checkboxes. Click "Update" when finished.
    3. Review the "Data Overview" section to see each groups' distribution of threshold cycle values and the average of the raw data in each group.
    4. Review the "Data QC" section to assess each groups' PCR reproducibility, reverse transcription efficiency, and level of genomic DNA contamination.
  3. On the "Analysis Result" page:
    1. See the "Average Ct", "2^(- Ct)", "Fold Change", "p-value", and "Fold Regulation" sections for the results processed by the software from your data. The "Fold Change" and "p-value" results are used by the software in subsequent graphical analyses.
    2. In the "Heat Map" section, define Groups to be compared and whether to report the fold-change results as a log transformation or not (default recommended). Click "Update" once changes have been made. Click "Export Data" to download the results as an Excel file.
  4. Scatter Plot and Volcano Plot
    1. Define Groups to be compared. Choose the fold-change boundary (and p-value for Volcano Plot) of interest. Click "Update".
    2. Click on symbols to identify gene and fold-change (and p-value for Volcano Plot); mouse over table entries to point to symbol on plot.
    3. Click check boxes to remove genes from or add genes to plot. Click "Update".
    4. Click "Export Data" to download the results as an Excel file.
  5. Clustergram
    1. Sort samples by "Array" or by "Group".
    2. Select "Join Type". The default of "Average" is recommended.
    3. Cluster in "1-D" by genes only or in "2-D" by genes and samples.
    4. Color code the graph by "Genes", "Samples" or "Entire Dataset". The default of "Genes" is recommended.
    5. Choose whether or not to display the gene symbols and array or group names.
    6. Click check boxes to remove genes from or add genes to plot.
    7. Click "Update".
  6. Multigroup Plot
    1. Click check boxes to add genes to or remove genes from plots.
    2. Choose results to plot on the y-axis, either "AVG Delta Ct", "2^Delta Ct", or "Fold Change".
    3. Click "Update".
    4. Review either the line plot (above) or the column chart (below).
  7. Click "Export All" to download a MS Excel file containing all raw and processed data from the "Readout" and "Analysis Result" sections.
File:                      

  1. File must be a MS Excel Sheet. 

    * Excel Sheet Template for SABiosciences's cataloged PCR Arrays.

    * Excel Sheet Template for custom PCR Arrays.

  2. New users- Please take a test run. A set of data from Human Common Cytokines PCR Array were preloaded for your convenience.

  3. Format Peek

  4. Please note that you must complete all of your work with the PCR Array Data Analysis Web Portal in the same session. Your data is not stored on a server meaning that all work is lost once the session (or your web browser) is closed. Be sure to export all processed data and results to an Excel file saved on your local computer

  5. For the best view of this tool, please set your display resolution to 1024 X 768 or more