[R] Assigning colors on low p-values in table

Rmillan emiln_leifsson at hotmail.com
Mon Aug 27 11:05:38 CEST 2012


Hi all R-users,

I’m trying to assign colors on those p-value in my table output that fall
above a certain critical value, let’s say a p-value >0.05.
My table looks like this:

                  Assets	                 ADF-Level	   P-Value	    
ADF-First D      P-Value      ADF-Second D    P-Value
[1,]	Liabilities	                   -2.3109	    0.1988	        -3.162            
0.025	-6.0281	        0.01
[2,]	Long.Bond	-0.2934	    0.9172	      -6.1667             0.01	-7.897	       
0.01
[3,]	Stocks	                   -0.5539  	    0.8503        -5.5787            
0.01	-8.9303	        0.01
[4,]	CPI	                   -2.1352	    0.264	      -2.705	             
0.0794	-6.0953	        0.01
[5,]	Nom.10Y	                   -2.6968	    0.0807	      -1.3854            
0.542	-5.846	        0.01
[6,]	T.Bills	                   -2.0429	    0.2982	      -2.2508            
0.2211	-4.761	        0.01
[7,]	Commodities	-0.3973	    0.9031	      -5.0478             0.01	-6.7784	       
0.01
[8,]	Real.Estate	-0.6468	    0.8159	      -4.8601             0.01	-8.6037	       
0.01
[9,]	Credit.Spread	 0.4181	    0.9816	      -3.7542             0.01	-5.9572	       
0.01
[10,]	Term.Spread	-0.6243	    0.8242	      -4.1885             0.01	-6.4269	       
0.01
[11,]	Dividend.Yield	 2.9316	    0.99	      -1.6759             0.4343
-5.1065	        0.01

What could be nice was, if it is possible to highlight, for instance, all
the p-values in this table that are larger than 0.05 with the color red.
Any ideas on how this can be done?

All the values in this table are stored in vectors that I have combined as a
matrix and thereafter plotted as a matrix. Therefore this problem 
could also be solved if the values that are larger than 0.05 in the vector
“adf.pvalue” are saved as colored values.
After the values are stored in the vectors, adf.tvalue, adf.pvalue,
adf.tvalue1, adf.pvalue1, adf.tvalue2 and adf.pvalue2, the code looks like
this: 

>output<-matrix(c(col.names,adf.tvalue,adf.pvalue,adf.tvalue1,adf.pvalue1,adf.tvalue2,adf.pvalue2),ncol=7)
>colnames(output)<-c("Assets","ADF-Level","P-Value","ADF-First
D","P-Value","ADF-Second D","P-Value")
>output

Thanks in advance.

Sincerely,

Emil




--
View this message in context: http://r.789695.n4.nabble.com/Assigning-colors-on-low-p-values-in-table-tp4641395.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list