[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