Statistical Analysis Stack Exchange
Statistical Analysis Stack Exchange

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.

A pivot table shows a summary table of data from a larger table generally with an interactive graphical interface.

Pivot tables are often seen in business software such as spreadsheets, including Excel.

Reference: Wikipedia: Pivot table

9 questions
9
votes
1 answer

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?
Rizwan Kassim
  • 745
  • 7
  • 10
7
votes
1 answer

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'?
Bogaso
  • 675
  • 6
  • 13
4
votes
1 answer

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 significant difference between the column/row values of a…
baxx
  • 738
  • 6
  • 21
3
votes
1 answer

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 What I am curious about is what names are used to…
Raffael
  • 1,424
  • 3
  • 18
  • 30
2
votes
1 answer

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. Some artificial data generated in the following…
Karel Macek
  • 2,463
  • 11
  • 23
2
votes
1 answer

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. User | sites visits | pages viewed | items added to cart | Purchased (1 or 0) I set up a pivot…
Jason Schwartz
  • 41
  • 2
1
vote
1 answer

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 would be good to measure "Average Growth Rate per…
Scott
  • 153
  • 1
  • 4
1
vote
1 answer

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 | Sep | Nov | Dec | 6 Month total | 12 Month…
ak112358
  • 111
  • 3
0
votes
0 answers

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 (indicators for inclusion in a county, multiple are…
Pareto
  • 1