Bio-Rad iQ™5 Optical System Software, Version 2.1 - Manual (Page 100)

Section 6 Data Analysis Module
- 91 -
Where n = number of measurements
The Standard Error for Normalized Expression equation is shown below:
2
) (Re
) (Re
2
) 2 (Re
) 2 (Re
2
) 1 (Re
) 1 (Re
Re
Re
Re
Re
Re
Re








Ч
+ + 







Ч
+ 







Ч
Ч =
n f sample
n f sample
f sample
f sample
f sample
f sample
n n
Quant l n
Quant l SE
Quant l n
Quant l SE
Quant l n
Quant l SE
NF NF SE L
Where NF = Normalization Factor
The Standard Error for Normalized GOI equation is the following:
2 2






+ 





× =
GOI
GOI SE
NF
NF SE
GOI GOI SE
n
n
norm norm
Where GOI
norm
= the Normalized Gene of Interest
Exporting Data from the Data Table
1. Make sure the Data Table button is activated. If not, click Data Table.
2. Right-click on the spreadsheet. A shortcut menu appears (Figure 6.49).
3. Select Export to Excel.
4. Enter a name and file destination for the Excel file generated with your data export.
Fig. 6.49. Exporting Data Table Spreadsheets to Microsoft Excel.
Printing Data
The Print command on the spreadsheet menu will print the displayed spreadsheet (Gene List,
Condition List, Data Set List, or Data Table). When selected, a Print Preview box is opened,
which contains an illustration of the spreadsheet as it will appear once printed. Clicking the
printer icon opens the Windows Print dialog box. Click OK to complete the printing task.
The Export to Excel command on the spreadsheet menu is useful for exporting exact values from
the spreadsheet. When the Export to Excel command is selected from the menu, an Export to
Excel file save box is displayed. Choose a location of where the Excel file is to be saved and click
Save. The iQ5 software automatically exports the selected data into a protected workbook.
The protected workbook generated by the iQ5 software contains the text values of what is
represented on the spreadsheet. For example, checkboxes from the software application are
replaced by “True” or “False” text in Excel.
The numeric values contained in the protected workbook are exact values from the software
application that include several non-significant figures beyond the decimal point. This is
important to note when considering whether to transfer data by a copy and paste command or
the Export to Excel command. With the copy and paste command only the significant digits
displayed in the iQ5 software interface are transferred to Excel.