The FAMT macro is an Excel interface to use the FAMT R package. The use of R through Excel is possible thanks to RExcel.
You can use two different ways to install RExcel:
Once everything has been installed, a new icon appears in your desktop. This icon integrates RExcel. A new tab "RExcel" (or "Complements" depending on your Microsoft Office version) has been added.
Download the Excel file and open it:
Some guidelines about the macro Excel 2003 are given below. The FAMT interface for Excel 2007 works in the same way but the buttons appear in the Excel Ribbon.
Figure 1. Illustration of the FAMT macro
The macro contains 4 sheets:
The data must be stored in each sheet as above-mentioned. Note that Covariates and Annotations datasets are optional.The number of columns of expression must correspond to the number of rows of covariates and furthermore expression and annotations must have the same number of rows.
If covariates dataset is not provided the procedure aims at testing the significance of the mean expression. If annotations dataset is not provided, a basic annotations dataset is created with row indices as variables identifiers.
Import your data (copy and paste the data in each sheet or use the excel menu via import extern data). Be careful to the decimal mark (comma or point).
The following figures present the different sheets with the data provided in the package. This dataset concerns hepatic transcriptome profiles for 9893 genes of 43 half sib male chickens selected for their variability on abdominal fatness.
Figure 2. An example of the “Expression” sheet
Figure 3. An example of the “Covariates” sheet
Figure 4. An example of the “Annotations” sheet
Another sheet, called graph, is automatically created to store all the graphs provided by the functions of the package.
The buttons in the Macro sheet allow to run the package by step.
Some guidelines about the macro are given below and in the help file.
The DATA button enables you to define the datasets, to create the FAMT data and to summarize the FAMT data.
Figure 5. The DATA button
You have to select the available datasets (expression, covariates and/or annotations), then some other dialog box allow to precise the class of variables.
The FAMT model button enables to implement the FAMT complete multiple testing procedure.
Figure 6. The FAMT model button
This step builds the FAMT model and enables you to analyse the results (with the Results button). You can fit different models but the last one is used for the analysis of the results.
The RESULTS button proposes three functions to analyse and display the results. The first function provides information about the rejected genes,
the second one gives an estimation of the proportion of true null hypotheses,
and the last one helps the user to describe and interpret the factors.
Figure 7. The RESULTS button
Details to fill the form are given in the help file .
Results are displayed in the Macro sheet. For each request, the results (tables or comments) are cleared and the new results are shown.
The CLEAR button clears the Macro sheet and the graph sheet (this sheet is automatically added with some functions).