Tell me more ×
Cross Validated is a question and answer site for statisticians, data analysts, data miners and data visualization experts. It's 100% free, no registration required.
up vote -2 down vote favorite

How to do cluster analysis if you have all variables in array from 1 to 5, and 1 dummy variable (0 and 1). can you explain from the beginning--Excel format, please.

share|improve this question
6  
I don't think anybody does clustering analysis in Excel. – Jonathan Christensen Dec 21 '12 at 18:45
1  
Explaining cluster analysis from the beginning requires at least a long article, if not a book. Also, in my experience dummy variables tend to dominate cluster solutions so that, even in the presence of a variety of continuous variables, to include something like gender tends to yield two clusters: the girls and the boys. Not very helpful, unfortunately. – rolando2 Dec 21 '12 at 23:28

closed as not a real question by whuber♦ Jan 24 at 23:38

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 0 down vote

I recommend starting with the Wikipedia article on "cluster analysis", then you should go to a book store web site and order a book on the foundations on data mining techniques.

Make sure to get a book that covers all of them. Many books only cover prediction, unfortunately.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.