table: Cross Tabulation and Table Creation (2024)

tableR Documentation

Description

table uses the cross-classifying factors to build a contingencytable of the counts at each combination of factor levels.

Usage

table(..., exclude = if (useNA == "no") c(NA, NaN), useNA = c("no", "ifany", "always"), dnn = list.names(...), deparse.level = 1)as.table(x, ...)is.table(x)## S3 method for class 'table'as.data.frame(x, row.names = NULL, ..., responseName = "Freq", stringsAsFactors = TRUE, sep = "", base = list(LETTERS))

Arguments

...

one or more objects which can be interpreted as factors(including character strings), or a list (or data frame) whosecomponents can be so interpreted. (For as.table, argumentspassed to specific methods; for as.data.frame, unused.)

exclude

levels to remove for all factors in .... Ifit does not contain NA and useNA is notspecified, it implies useNA = "ifany". See‘Details’ for its interpretation for non-factor arguments.

useNA

whether to include NA values in the table.See ‘Details’. Can be abbreviated.

dnn

the names to be given to the dimensions in the result (thedimnames names).

deparse.level

controls how the default dnn isconstructed. See ‘Details’.

x

an arbitrary R object, or an object inheriting from class"table" for the as.data.frame method. Note thatas.data.frame.table(x, *) may be called explicitly fornon-table x for “reshaping” arrays.

row.names

a character vector giving the row names for the dataframe.

responseName

The name to be used for the column of tableentries, usually counts.

stringsAsFactors

logical: should the classifying factors bereturned as factors (the default) or character vectors?

sep, base

passed to provideDimnames.

Details

If the argument dnn is not supplied, the internal functionlist.names is called to compute the ‘dimname names’. If thearguments in ... are named, those names are used. For theremaining arguments, deparse.level = 0 gives an empty name,deparse.level = 1 uses the supplied argument if it is a symbol,and deparse.level = 2 will deparse the argument.

Only when exclude is specified (i.e., not by default) andnon-empty, will table potentially drop levels of factorarguments.

useNA controls if the table includes counts of NAvalues: the allowed values correspond to never ("no"), only if the count ispositive ("ifany") and even for zero counts ("always").Note the somewhat “pathological” case of two different kinds ofNAs which are treated differently, depending on bothuseNA and exclude, see d.patho in the‘Examples:’ below.

Both exclude and useNA operate on an “all or none”basis. If you want to control the dimensions of a multiway tableseparately, modify each argument using factor oraddNA.

Non-factor arguments a are coerced via factor(a, exclude=exclude). Since R 3.4.0, care is taken not tocount the excluded values (where they were included in the NAcount, previously).

The summary method for class "table" (used for objectscreated by table or xtabs) which gives basicinformation and performs a chi-squared test for independence offactors (note that the function chisq.test currentlyonly handles 2-d tables).

Value

table() returns a contingency table, an object ofclass "table", an array of integer values.Note that unlike S the result is always an array, a 1Darray if one factor is given.

as.table and is.table coerce to and test for contingencytable, respectively.

The as.data.frame method for objects inheriting from class"table" can be used to convert the array-based representationof a contingency table to a data frame containing the classifyingfactors and the corresponding entries (the latter as componentnamed by responseName). This is the inverse of xtabs.

References

Becker, R. A., Chambers, J. M. and Wilks, A. R. (1988)The New S Language.Wadsworth & Brooks/Cole.

See Also

tabulate is the underlying function and allows finercontrol.

Use ftable for printing (and more) ofmultidimensional tables. margin.table,prop.table, addmargins.

addNA for constructing factors with NA asa level.

xtabs for cross tabulation of data frames with aformula interface.

Examples

require(stats) # for rpois and xtabs## Simple frequency distributiontable(rpois(100, 5))## Check the design:with(warpbreaks, table(wool, tension))table(state.division, state.region)# simple two-way contingency tablewith(airquality, table(cut(Temp, quantile(Temp)), Month))a <- letters[1:3]table(a, sample(a)) # dnn is c("a", "")table(a, sample(a), deparse.level = 0) # dnn is c("", "")table(a, sample(a), deparse.level = 2) # dnn is c("a", "sample(a)")## xtabs() <-> as.data.frame.table() :UCBAdmissions ## already a contingency tableDF <- as.data.frame(UCBAdmissions)class(tab <- xtabs(Freq ~ ., DF)) # xtabs & table## tab *is* "the same" as the original table:all(tab == UCBAdmissions)all.equal(dimnames(tab), dimnames(UCBAdmissions))a <- rep(c(NA, 1/0:3), 10)table(a) # does not report NA'stable(a, exclude = NULL) # reports NA'sb <- factor(rep(c("A","B","C"), 10))table(b)table(b, exclude = "B")d <- factor(rep(c("A","B","C"), 10), levels = c("A","B","C","D","E"))table(d, exclude = "B")print(table(b, d), zero.print = ".")## NA counting:is.na(d) <- 3:4d. <- addNA(d)d.[1:7]table(d.) # ", exclude = NULL" is not needed## i.e., if you want to count the NA's of 'd', usetable(d, useNA = "ifany")## "pathological" case:d.patho <- addNA(c(1,NA,1:2,1:3))[-7]; is.na(d.patho) <- 3:4d.patho## just 3 consecutive NA's ? --- well, have *two* kinds of NAs here :as.integer(d.patho) # 1 4 NA NA 1 2#### In R >= 3.4.0, table() allows to differentiate:table(d.patho) # counts the "unusual" NAtable(d.patho, useNA = "ifany") # counts all threetable(d.patho, exclude = NULL) # (ditto)table(d.patho, exclude = NA) # counts none## Two-way tables with NA counts. The 3rd variant is absurd, but shows## something that cannot be done using exclude or useNA.with(airquality, table(OzHi = Ozone > 80, Month, useNA = "ifany"))with(airquality, table(OzHi = Ozone > 80, Month, useNA = "always"))with(airquality, table(OzHi = Ozone > 80, addNA(Month)))
table: Cross Tabulation and Table Creation (2024)

FAQs

How to do a cross-tabulation table? ›

In Microsoft Excel, cross-tabulation tables (or crosstabs) can be automated using the Pivot Table. You can either use the Pivot Table icon in the toolbar or click on Data > Pivot Table and Pivot Chart Report. Alternatively, you can press Insert and then click the PivotChart button.

How to interpret cross-tabulation results? ›

Interpret the key results for Cross Tabulation and Chi-Square
  1. Step 1: Determine whether the association between the variables is statistically significant.
  2. Step 2: Examine the differences between expected counts and observed counts to determine which variable levels may have the most impact on association.

What is an example of a cross-tabulation? ›

Cross-tabulation is used in various statistical analysis programs to analyze various data types, such as SPSS (cross tabulation SPSS) and Excel. For example, a teacher might use a cross-table to compare the rate at which juniors and seniors pass or fail an advanced statistics course.

What is the formula for crosstabulation? ›

No formula is needed for a crosstabulation, since at a crosstabulation's core it is counts and percentages of observations. The Chi-squared test often is used to accompany a crosstabulation to test if a significant relationship exists and the strength of the relationship between variables.

What is the difference between table and cross tabulation? ›

Calculation of Statistics: Crosstabs do not perform calculations on the data, while pivot tables allow you to perform calculations such as sums, averages, and standard deviations.

What is an example of a tabulation of data? ›

For example, when examining the population in Indian states, a table might compare the total number of males and females. Three-way tabulation goes a step further, presenting data from three interrelated subjects. In the previous example, it could involve analyzing literacy rates among men and women in various states.

What is an example of a cross-tabulation question? ›

The question in our example, "Do you like our products?", has been cross tabulated, with gender from another question. In the table, the total compared responses (47), matches the total survey responses (47).

What is the crosstab format? ›

The Crosstab format is one of the most popular. Crosstab stands for Cross tabulation, a process by which totals and other calculations are performed based on common values found in a set of data. In Microsoft Excel™ the term "Pivot Table" is used for a Crosstab.

Why do we use cross-tabulation? ›

Cross tabulation is used to quantitatively analyze the relationship between multiple variables. Cross tabulations — also referred to as contingency tables or crosstabs — group variables together and enable researchers to understand the correlation between the different variables.

What is the conclusion of tabulation? ›

Conclusion: Tabulation is a powerful technique in dynamic programming for solving complex problems efficiently by storing subproblems results in array.

Is cross-tabulation quantitative or qualitative? ›

Quantitative cross-tabulation analyses help identify potential statistically significant associations between data variables. (Certainly, association is not causation.)

How to read a cross-tabulation table? ›

For reading the vertical percent in a cross tab, we read from top (1), down to the vertical percent( 2), then left to the comparable variable in the row (3). In this example we would read this as follows: Of those people in the survey who said they were very interested in NFL football, 16.7 percent of them.

How to do a cross-tabulation table in Excel? ›

In Microsoft Excel, cross tabulation tables (or crosstabs) can be automated using the Pivot Table. You can either use the Pivot Table icon in the toolbar or click on Data > Pivot Table and Pivot Chart Report. Alternatively, you can press Insert and then click the PivotChart button.

What is the difference between a Pivot Table and a crosstab? ›

While the cross tab assumes there is only one horizontal dimension and all the values belong to that dimension, pivot assumes there might exist one or more horizontal dimensions. (dimension gender or dimension age) can be "pivoted" into a new column in the spreadsheet table.

How to do tabulation in Excel? ›

Click Analysis > Tabulation. 1010data displays the Tabulation dialog. The Tabulation dialog allows you to create a basic tabulation. By default, columns in the resultant worksheet are named t0 , t1 , t2 , and so on.

How to do cross tabulation in Tableau? ›

Create Crosstab Excel Output from Tableau with Dimensions on each row
  1. Add the desired dimensions to the Rows shelf.
  2. Go to Analysis > Create Calculated Field. ...
  3. Place Index on the Rows shelf.
  4. Right-click on Index in the Rows shelf and select Discrete.
  5. Move Index to the left most position on the Rows shelf.

Is a pivot table a cross tabulation? ›

Pivot tables and crosstabs are nearly identical in form, and the terms are often used interchangeably. However, pivot tables present some added benefits that regular crosstabs do not.

What is a cross table chart? ›

A cross table is a two-way table consisting of columns and rows. It is also known as a pivot table or a multi-dimensional table. Its greatest strength is its ability to structure, summarize and display large amounts of data.

References

Top Articles
Newsday Crossword Puzzle Brains Only
SUGARED + BRONZED hiring Professional Esthetician - Sugar Training in Los Angeles, California, United States | LinkedIn
Mansfield Shower Surround
Vons Credit Union Routing Number
Nbc4 Columbus Facebook
Abcm Corp Training Reliaslearning
Kiwifarms Shadman
Ark Ragnarok Map Caves
Bingo Bling Promo Code 2023
Log in or sign up to view
Orange Craigslist Free Stuff
Tamara Lapman
Accident On May River Road Today
Chs.mywork
'A Cure for Wellness', Explained
Sauce 423405
Do people over 65 pay federal income tax?
Juliewiththecake Wiki / Biography - Age, Boyfriend, Height, Net Worth - WikiBravo
Journeys Employee Discount Limit
Mhgu Bealite Ore
LeBron Glazing Poem / Boy Oh Boy, Where Do I Even Begin?
Lufkin Isd Calendar
Envy Nail Bar Memphis
102Km To Mph
Truist Drive Through Hours
Zwei-Faktor-Authentifizierung (2FA) für Ihre HubSpot-Anmeldung einrichten
Vegamovies Marathi
Springfield Ma Craigslist
A 100% Honest Review of M. Gemi Shoes — The Laurie Loo
Daggett Funeral Home Barryton Michigan
Walgreens On Nacogdoches And O'connor
3Kh0 1V1 Lol
359 Greenville Ave Staunton Va
Movies123 Avatar 2
Dfw Rainfall Last 72 Hours
Target Savannah Mall Evicted
Rule 34 Supreme Court: Key Insights and Implications
Franco Loja Net Worth
Tandon School of Engineering | NYU Bulletins
Of Course! havo/vwo bovenbouw
Coventry Evening Telegraph Ccfc
1984 Argo JM16 GTP for sale by owner - Holland, MI - craigslist
Pulp Fiction 123Movies
Best Homemade Tartar Sauce
A look back at the history of the Capital One Tower
Stock Hill Restaurant Week Menu
Epiq Document Delivery
Mazda 6 GG/GG1; GY/GY1 2.3 MPS Test : MPSDriver
Raleigh Craigs List
Make Monday Better: Dive Into These Hilarious Monday Memes!
Samanthaschwartz Fapello
Kaiju Universe: Best Monster Tier List (January 2024) - Item Level Gaming
Latest Posts
Article information

Author: Frankie Dare

Last Updated:

Views: 5490

Rating: 4.2 / 5 (53 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Frankie Dare

Birthday: 2000-01-27

Address: Suite 313 45115 Caridad Freeway, Port Barabaraville, MS 66713

Phone: +3769542039359

Job: Sales Manager

Hobby: Baton twirling, Stand-up comedy, Leather crafting, Rugby, tabletop games, Jigsaw puzzles, Air sports

Introduction: My name is Frankie Dare, I am a funny, beautiful, proud, fair, pleasant, cheerful, enthusiastic person who loves writing and wants to share my knowledge and understanding with you.