Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you set up the data to perform a Anova 2 Factor/w reps?
I keep getting the error: "each sample must conatin the same number of rows",
when I select my data. It is 32 row, but each replication is 4 rows. So there is eight replications. I have 4 rows by 6 colums of data. I have tried doing 4 by 4 and that still does not work, does anyone know how to get this data analysis function to work? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you set up the data to perform a Anova 2 Factor/w reps?
Mack -
In Excel 2003 off-line Help, search for the "About Statistical Analysis Tools" topic and expand the ANOVA section to see the proper layout of data on the worksheet. Or, consult a statistics book that uses Excel, like my "Data Analysis Using Microsoft Excel: Updated for Office XP." - Mike www.mikemiddleton.com "Mack" wrote in message ... I keep getting the error: "each sample must conatin the same number of rows", when I select my data. It is 32 row, but each replication is 4 rows. So there is eight replications. I have 4 rows by 6 colums of data. I have tried doing 4 by 4 and that still does not work, does anyone know how to get this data analysis function to work? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you set up the data to perform a Anova 2 Factor/w reps?
I figured it out. When using the Anova 2 factor data analysis part of excel,
you need to have a blank row at the top of the page where you highlight the cells, either that or a title at the top of the data. So in any case your data should start on row 2 and when you highlight the data include row 1. "Mike Middleton" wrote: Mack - In Excel 2003 off-line Help, search for the "About Statistical Analysis Tools" topic and expand the ANOVA section to see the proper layout of data on the worksheet. Or, consult a statistics book that uses Excel, like my "Data Analysis Using Microsoft Excel: Updated for Office XP." - Mike www.mikemiddleton.com "Mack" wrote in message ... I keep getting the error: "each sample must conatin the same number of rows", when I select my data. It is 32 row, but each replication is 4 rows. So there is eight replications. I have 4 rows by 6 colums of data. I have tried doing 4 by 4 and that still does not work, does anyone know how to get this data analysis function to work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel |