grpsumm - Obtaining Summary Statistics and Plots by...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Obtaining Summary Statistics and Plots by Treatment Groups in EXCEL
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 )
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/04/2011 for the course STA 6166 taught by Professor Staff during the Fall '08 term at University of Florida.

Page1 / 12

grpsumm - Obtaining Summary Statistics and Plots by...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online