{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# grpsumm - Obtaining Summary Statistics and Plots by...

This preview shows pages 1–5. Sign up to view the full content.

Obtaining Summary Statistics and Plots by Treatment Groups in EXCEL

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Data Format Data are in a Block of ( n +1) rows and ( f+m ) columns where: Variable labels are in row 1 Data on n units are in rows 2: n +1 f Columns of factor levels (one column per factor) m Columns of response measurements (one column for each response variable) For this presentation, we will assume n =24 f = 2 (With Factor A at 2 Levels, B at 3 Levels) m = 2 Response Variables ( X , Y )
Data Layout Row 1 Row 25 Data in Columns A-D Highlight the data, then click: Insert Name Define type in a name (e.g. expdat ) OK Factor A Factor B X Y 1 1 76.54 539.43 1 1 78.02 556.10 1 1 79.26 553.53 1 1 78.82 542.07 1 2 99.26 564.42 1 2 95.14 569.95 1 2 95.33 576.09 1 2 97.15 571.91 1 3 117.24 594.91 1 3 118.72 599.49 1 3 116.16 604.30 1 3 116.89 602.08 2 1 85.50 523.72 2 1 89.58 514.91 2 1 87.75 520.08 2 1 85.74 520.14 2 2 106.92 534.14 2 2 109.82 539.98 2 2 109.26 550.64 2 2 105.10 534.95 2 3 129.65 565.16 2 3 126.98 562.24 2 3 125.37 570.77 2 3 127.80 575.81

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Obtaining Summaries for 1 Factor (I) Go to cells outside the range of the data (different columns) Type in the Factor label in as many cells in a row as there are levels
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 12

grpsumm - Obtaining Summary Statistics and Plots by...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online