I have a dataset with two variables that are factors:
1) Decision Making Satisfaction (DMS), values = A - Completely, B -
Mostly, C - Partly, D - Not at all
2) IT Satisfaction values (ITS), values = A - Completely, B - Mostly, C
- Partly, D - Not at all
I would like to produce a table (matrix) and a chart of the factors,
with counts at the cross sections:
A B C D
A
B counts
C
D
How can I do this in R?
Many thanks,
Chris
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
The 'table' function will give you the simple counts. Plotting a table with the 'plot' function gives common charts for this. The 'CrossTable' function in the gmodels package creates the table along with additional information. There are a lot of other functions for creating/working with tables depending on what you are trying to do. Hope this helps, -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare greg.snow at intermountainmail.org (801) 408-8111> -----Original Message----- > From: r-help-bounces at r-project.org > [mailto:r-help-bounces at r-project.org] On Behalf Of christopher snow > Sent: Thursday, December 06, 2007 5:51 AM > To: r-help at r-project.org > Subject: [R] relationship between two factors > > I have a dataset with two variables that are factors: > > 1) Decision Making Satisfaction (DMS), values = A - > Completely, B - Mostly, C - Partly, D - Not at all > 2) IT Satisfaction values (ITS), values = A - Completely, B - > Mostly, C > - Partly, D - Not at all > > I would like to produce a table (matrix) and a chart of the > factors, with counts at the cross sections: > > A B C D > A > B counts > C > D > > How can I do this in R? > > Many thanks, > > Chris > > -- > This message has been scanned for viruses and dangerous > content by MailScanner, and is believed to be clean. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >
On Thu, 2007-12-06 at 12:51 +0000, christopher snow wrote:> I have a dataset with two variables that are factors: > > 1) Decision Making Satisfaction (DMS), values = A - Completely, B - > Mostly, C - Partly, D - Not at all > 2) IT Satisfaction values (ITS), values = A - Completely, B - Mostly, C > - Partly, D - Not at all > > I would like to produce a table (matrix) and a chart of the factors, > with counts at the cross sections: > > A B C D > A > B counts > C > D > > How can I do this in R? > > Many thanks, > > ChrisSee ?table, for example: table(DMS, ITS) You did not indicate the type of chart you want to create, but some possibilities, using base graphics, would be barplot(), dotchart() and mosaicplot(). The latter is in the vcd package on CRAN. HTH, Marc Schwartz
?table should work table (DMS, ITS) I am not clear on what kind of chart you want. will plot(DMS, ITS) do what you want? --- christopher snow <snowch at coralms.com> wrote:> I have a dataset with two variables that are > factors: > > 1) Decision Making Satisfaction (DMS), values = A - > Completely, B - > Mostly, C - Partly, D - Not at all > 2) IT Satisfaction values (ITS), values = A - > Completely, B - Mostly, C > - Partly, D - Not at all > > I would like to produce a table (matrix) and a chart > of the factors, > with counts at the cross sections: > > A B C D > A > B counts > C > D > > How can I do this in R? > > Many thanks, > > ChrisLooking for the perfect gift? Give the gift of Flickr!
Try this: df <- data.frame(DMS=factor(rep(LETTERS[1:4], 10)), ITS=factor(rep(LETTERS[1:4], 10))) table(df) plot(table(df)) -- Henrique Dallazuanna Curitiba-Paran?-Brasil 25? 25' 40" S 49? 16' 22" O On 06/12/2007, christopher snow <snowch at coralms.com> wrote:> I have a dataset with two variables that are factors: > > 1) Decision Making Satisfaction (DMS), values = A - Completely, B - > Mostly, C - Partly, D - Not at all > 2) IT Satisfaction values (ITS), values = A - Completely, B - Mostly, C > - Partly, D - Not at all > > I would like to produce a table (matrix) and a chart of the factors, > with counts at the cross sections: > > A B C D > A > B counts > C > D > > How can I do this in R? > > Many thanks, > > Chris > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >
Thanks to everyone for their answers. What a helpful community! christopher snow wrote:> I have a dataset with two variables that are factors: > > 1) Decision Making Satisfaction (DMS), values = A - Completely, B - > Mostly, C - Partly, D - Not at all > 2) IT Satisfaction values (ITS), values = A - Completely, B - Mostly, C > - Partly, D - Not at all > > I would like to produce a table (matrix) and a chart of the factors, > with counts at the cross sections: > > A B C D > A > B counts > C > D > > How can I do this in R? > > Many thanks, > > Chris > >-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.