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
0
votes
0answers
98 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
105 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
74 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. ...
7
votes
1answer
7k 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
149 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
249 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?