# Questions tagged [pivot-table]

A pivot table shows a summary table of data from a larger table generally with an interactive graphical interface; it is seen in software such as spreadsheets.

10 questions
Filter by
Sorted by
Tagged with
78 views

### How to test for difference between table of weighted proportions

Though Python is used for generating the examples this is not a Python question, links to literature/theory are welcome. I'm wondering how one would go about determining whether there was a ...
14 views

### Interpretation of “show as index” in Excel Pivots

Researching Excel Pivot table functions, I've stumbled upon "show as index" calculation and found almost no information about it. My problem is the interpretation of values it produces, and eventually ...
123 views

### Variable groupings in rpivottable

I have an data set with over 100 variables. To make it easier to use the rpivottable that I made in my shiny app, is there a way to group the variables? Such as, I have a number of county variables (...
125 views

### Permutations in pivot table

Let's assume a pivot table $P$ of shape $m\times n$ where $p_{i,j}$ is number of coincidences of $i$ and $j$. I would like to have to permute the columns and rows to see some blocks of similarity. ...
77 views

### Is there a stats tool for this analysis I run in excel?

I am trying to find a statistical or machine learning tool that replicates this analysis I am doing manually in excel. Each row in my data set is a user. ...
8k views

### What is the difference between the 'Pivot table' and 'Contingency table'?

Is there any difference? Or they are basically the same? Just Excel users call it 'pivot table' and statistically-minded people call it 'contingency table'?
150 views

### Terminology of two different tabular representations of aggregated data

think of a group of people aged from 21 to 35 years. Then we can show the number of persons regarding gender and age groups 21-25, 26-30 and 31-35 in (at least) two different ways: Type A Type B ...
251 views

### How can you summarize growth in the “production” rate per person?

I have been reading the book, Good to Great by Jim Collins. It says that you should focus on information that "cannot be ignored," and that you should focus on the right "denominator." I thought it ...