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.
8 questions
9
votes
1
answer
2k
views
What are pivot tables, and how can they be helpful in analyzing data?
What are pivot tables, and how can they be helpful in analyzing data?
- 765
7
votes
1
answer
10k
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'?
- 993
4
votes
1
answer
159
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
...
- 1,664
4
votes
1
answer
2k
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 ...
- 936
2
votes
1
answer
250
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.
...
- 2,846
2
votes
1
answer
84
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.
...
1
vote
1
answer
2k
views
Excel pivot table with multiple total columns
Is there a way in Excel to create a pivot table with multiple column totals?
Here's column names to demonstrate what I'm trying to do:
Jan | Feb | Mar | Apr | May | Jun | 6 Month total | Jul | Aug | ...
- 111
1
vote
1
answer
265
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 ...
- 163