I have some data that I would like to cluster/ order. My goal is to identify common elements across all the rows (samples). Any suggestions are welcome. I've tried using statistical tools (i.e. pearson coefficient) and can generate a matrix but it does not either order the data nor tell me the values common across the data.
There are values which do not contribute to the correlation (0). Values 1-4 are significant and I would like to have the data sorted by similarity and a table of those common elements between samples. It's a large matrix, 605 samples, 282 values.
Here is an example, columns are numerical values, rows are sample names.
sample val1 val2 val3 val4 val5 val6 val7 val8 val9 val10
A001 0 0 0 1 0 0 2 0 1 0
A002 0 1 0 0 0 0 2 0 1 0
A003 0 0 0 1 0 0 2 0 0 0
A004 0 0 0 1 0 0 2 0 0 0
A005 0 1 0 1 0 0 0 0 0 0
Hello,
I have installed the Analysis ToolPak successfully (and have used the Data
Analysis tools many times before), but sometimes the Data Analysis option
simply fails to appear in the menu. What could be causing this?
Thanks,
Eric
hello
i have collected feedback regarding the usage of timesheet as a part of my MBA project.
the feedback is in MS EXCEL.
I would like to do some data analysis and put the data in form of charts.
pie charts are too elementary.
my professor insists in statistical tools which i dnt have.
the questions are given and the employees were asked to give the opinion on based of 5 point scale.
Strongly Disagree 1
Disagree 2
Undecided 3
Agree 4
Strongly Agree 5
what can i do in excel? I have no clue about it...
pls help me out...
I am new to excel and need to install the "data analysis" add-ins found under
"Tools" for an assignment for a statistics class. I do not have the original
CD used to install Office 2003 and hope there is a way to access and install
these add-ins from the web.
Hello friends!
I want to know about data analysis through application of Excel. Please guide me if anybody knows about this.
Awaiting for your earliest reply.
Thanking you.
I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.
Please can anyone help me answer any of these questions:
How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help
How do you format a cell to have dollar signs next to the numbers?
How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?
How do you rename a sheet?
Can I delete the sheets that I don't need? If so how?
How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A
How do you add up all the contents of column D and make the answer show
up in column C?
Thanks in advance!
abi
I am looking to run certain statistics in Excel and I was wondering if this was possible:
I want to calculate a certain number of people in a category on a spreadsheet by age and race and I wanted to know if it could be done in Excel. We do not have a specific program here to calculate statistics like SPSS.
I have a spreadsheet of patients with their information such as age, telephone number, Date of birth, race, location of cancer screen, date of cancer screen, and results of cancer screenings.
I have a lot of information and I was interested to know if I could select only certain columns (age, race, cancer result) to run the statistics. I need to make charts containing the number of people who screened for cancer and out of those people, how many were which race and how many were in each age group.
If this kind of data is possible to obtain in Excel, how do I go about doing that?
Thank you!!
