Skip to main content
Cross Validated

Return to Question

title
Link
Gala
Gala
  • 8.6k
  • 2
  • 32
  • 44

what What is it called when you analyze the grouping of variables? How to do it in Excel?

added 9 characters in body; edited tags; edited title
Source Link
Nick Cox
Nick Cox
  • 59.5k
  • 8
  • 136
  • 212

In statistical analysis, what is it called when you analyze the grouping of columns in Excelvariables?

I have 5 columns of data in an excelExcel spreadsheet. 

Each row has either a 1 or a 0 (on or off) within each column. 

I'm trying to determine the most common grouping or clustering of columns that have a 1. For example, it could be columns B&B & D are the most common grouping that have '1s'1s, followed by columns A,D D & E, etc. 

What is this method of analysis called and how do I do it in Excel?

In statistical analysis, what is it called when you analyze the grouping of columns in Excel?

I have 5 columns of data in an excel spreadsheet. Each row has either a 1 or a 0 (on or off) within each column. I'm trying to determine the most common grouping or clustering of columns that have a 1. For example it could be columns B& D are the most common grouping that have '1s', followed by columns A,D & E, etc. What is this method of analysis called and how do I do it in Excel?

what is it called when you analyze the grouping of variables?

I have 5 columns of data in an Excel spreadsheet. 

Each row has either 1 or 0 (on or off) within each column. 

I'm trying to determine the most common grouping or clustering of columns that have a 1. For example, it could be columns B & D are the most common grouping that have 1s, followed by columns A, D & E, etc. 

What is this method of analysis called and how do I do it in Excel?

Post Migrated Here from math.stackexchange.com (revisions)
Source Link
FrankLfr
FrankLfr

In statistical analysis, what is it called when you analyze the grouping of columns in Excel?

I have 5 columns of data in an excel spreadsheet. Each row has either a 1 or a 0 (on or off) within each column. I'm trying to determine the most common grouping or clustering of columns that have a 1. For example it could be columns B& D are the most common grouping that have '1s', followed by columns A,D & E, etc. What is this method of analysis called and how do I do it in Excel?