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.

Filter by
Sorted by
Tagged with
1
vote
1answer
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 ...
0
votes
0answers
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 ...
0
votes
0answers
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 (...
2
votes
1answer
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. ...
2
votes
1answer
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. ...
6
votes
1answer
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'?
3
votes
1answer
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 ...
1
vote
1answer
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 ...
1
vote
1answer
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 | ...
8
votes
1answer
1k 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?