• TABLE OF CONTENTS
HIDE
 Historic note
 Main














Group Title: Agronomy research report - UF Agronomy Dept. ; AY-89-11
Title: Instructions for using QUATTRO and MSTAT to create, edit and statistically analyze data files
CITATION THUMBNAILS PAGE IMAGE ZOOMABLE
Full Citation
STANDARD VIEW MARC VIEW
Permanent Link: http://ufdc.ufl.edu/UF00056091/00001
 Material Information
Title: Instructions for using QUATTRO and MSTAT to create, edit and statistically analyze data files
Physical Description: 10 leaves : ; 28 cm.
Language: English
Creator: Gallaher, Raymond N
Chichester, J. R
University of Florida -- Agronomy Dept
Publisher: Department of Agronomy, Institute of Food and Agricultural Sciences, University of Florida
Place of Publication: Gainesville Fla
Publication Date: 1989?]
 Subjects
Subject: Agriculture -- Computer programs   ( lcsh )
Agriculture -- Data processing -- Florida   ( lcsh )
Genre: bibliography   ( marcgt )
non-fiction   ( marcgt )
 Notes
Statement of Responsibility: R.N. Gallaher and J.R. Chichester.
Bibliography: Includes bibliographical references (leaf 8).
General Note: Caption title.
Bibliography: Agronomy research report - UF Agronomy Dept. ; AY-89-11
 Record Information
Bibliographic ID: UF00056091
Volume ID: VID00001
Source Institution: University of Florida
Rights Management: All rights reserved by the source institution and holding location.
Resource Identifier: oclc - 62615008

Table of Contents
    Historic note
        Historic note
    Main
        Page 1
        Page 2
        Page 3
        Page 4
        Page 5
        Page 6
        Page 7
        Page 8
        Page 9
        Page 10
Full Text





HISTORIC NOTE


The publications in this collection do
not reflect current scientific knowledge
or recommendations. These texts
represent the historic publishing
record of the Institute for Food and
Agricultural Sciences and should be
used only to trace the historic work of
the Institute and its staff. Current IFAS
research may be found on the
Electronic Data Information Source
(EDIS)

site maintained by the Florida
Cooperative Extension Service.






Copyright 2005, Board of Trustees, University
of Florida






SLibrary J
SEE r, 2 gS 199(

Agronomy Research Report:AY-89-11 '.


Instructions for Using QUATTRO and MSTAT to Create, Edit and
Statistically Analyze Data Files


R. N. Gallaher and J. R. Chichester
Professor and Chemist II, Department of Agronomy, Institute of Food
and Agricultural Sciences, University of Florida, Gainesville, FL
32611

Introduction

The purpose of creating a data file is to ultimately run an
analysis of variance in order to determine if differences exist
between or among experimental treatments. It is assumed that most
experiments for which data files will be needed will be either
Completely Randomized Designs, Randomized Complete Block,
Completely Randomized with a split plot, Randomized Complete Block
with a split, or Randomized Complete Block with split-split plots.
This document will attempt to provide steps one should go through
to establish MSTAT (MSTAT 4.0-C, 1988) data files from QUATTRO
(QUATTRO 1.0, 1988) spreadsheet data files. We will then provide
explanations on how to run ANOVA on a data file for one of the
above experimental designs using MSTAT.

Data Organization

Large data sheets should be used to first organize data by
hand before attempting to create a QUATTRO data file. We will use
a Split Plot experimental design to illustrate how to organize the
data. In our example we will have THREE FACTOR VARIABLES. These
include the REPLICATION variable, the WHOLE PLOT variable, and the
SPLIT PLOT variable. You may also have other factor variables such
as LOCATION, if you have more than one location; YEAR, if you have
more than one year; ETC. MSTAT will request the factor variables
in the order of rep first, whole plot second, and split plot third
when you begin the ANOVA. Therefore, in setting up your original
data sheets you could begin this order from the start. This is
what we will do in our example. The variables in our example that
we are testing will include DRY MATTER YIELD and CONTENTS OF N, P,
K, CA, MG, CU, FE, MN, and ZN.

The hand prepared table will have the variables at the top of
the page with designated headings for columns in this order Rep(1
to 4), Corn hybrid(1 to 4 whole plots), Sampling date(1 to 4 Split
plots), DM, N, P, K, Ca, Mg, Cu, Fe, Mn, Zn (Table 1.). In our
case we will have 4 reps X 4 Whole plots X 4 sampling dates for a
total of 64 lines of data (64 CASES).









When this hand prepared data sheet is completed and all data
is double checked for errors you are ready to begin the data file
using QUATTRO. Note: We will enter the case variable to help keep
ourselves straight during data entry. We will not, however,
transfer this data to MSTAT, since MSTAT adds case numbers when the
data is transferred.

QUATTRO data files
Use the following steps to load QUATTRO. It is assumed that
you will be using an IBM PC or compatible computer with a hard disk
and floppy disk drives.
1. Turn on the computer.
2. Turn on the monitor.
3. From the main menu highlight SPREADSHEET and enter or type 4.
You will see a spreadsheet submenu, either highlight QUATTRO
and enter or press 2 and the QUATTRO spreadsheet will be
loaded into RAM (Random Access Memory). The spreadsheet has
row numbers listed on the y axis and column headings A, B, C
etc. on the x axis at the top of the screen. A cell is
the point where a row number and column letter intersect,
such as 1A, 1B 2A, etc. One can move from cell to cell by
using the arrow keys. Nine characters can be entered into
each cell.
4. Press the slash key (/) and you will get the main QUATTRO
menu.
5. Press ESC to return to the spreadsheet. These operations
can be done at any time while working on the data, without
any loss of data .
6. Press / to get the QUATTRO menu and highlight LAYOUT and
enter or press L and you will get a submenu. Press D on the
submenu to get a DESCRIPTOR line to appear in the top left of
the screen. This will allow you to see what is being typed.
Press Q to return to the spreadsheet.
7. Press Fl to get QUATTRO Help Topics. Read and study by
highlighting topics desired and enter. To get back to the
spreadsheet at any time press ESC.
8. Before typing each cell heading or column heading, if you
want to center the heading, press shift and the ^ symbol at
the top of the number 6, then type the heading. For example
highlight cell 1A and type shift ^ and REP and enter. REP
will be centered over the A column. Now highlight cell 1B
and press shift and type ^ HYBRID and enter, it will be
centered over column B. Repeat this for cell 1C for DATE and
1D for DM, etc. until all vertical columns have been labeled.
9. This step is optional, but highly recommended. Place the
curser in the cell just below the title line. Press / for the
Main Menu, the L for Layout, the T for Titles, then H for
Horizontal. This will freeze the title line so it will not
scroll off the screen as data lines are added.









10. Now highlight the cell 2A and begin entering data from your
hand prepared data sheet. For example in 2A type 1 and press
the right arrow. The 1 will be entered into cell 2A for CASE
1 and Cell 2B will automatically be highlighted. Type 1 from
your data sheet for REP and press right arrow, Type 1 for
HYBRID and press the right arrow, type 1 for DATE and press
the right arrow and it will be stored in Cell 2D. Now type
7181 and press the right arrow to enter the DM data in cell
2E. Repeat this process all the way across row 2 until all of
case 1 data is entered.
11. If you make a mistake, move the cursor to the cell with the
incorrect data and type the correct value. When you press
Enter or an arrow key the correct value will replace the
incorrect one.
12. When the last data for case 1 is entered press the down arrow
one time, (if using the Tandy 1000 SX) turn off the NUM LOCK,
press END and press the left arrow. This will return the
cursor all the way back to cell 3A. Now the case 2 data
can be entered as above. Repeat this process until all data
is entered into the spreadsheet.
13. Press the / to get the QUATTRO menu.
14. Press F for the file menu.
15. Press S for the save menu.
16. If you wish to save on a floppy disk press ESC twice so that
it will not be saved on the C (hard disk) drive.
17. Type B:Name (8 characters maximum) and enter. This file is
now saved on the disk in drive B.
18. To get out of QUATTRO press the slash / and press Q for quit
and Yes on the submenu to go back to DOS.

Transfer QUATTRO File to ASCII File

1. Load QUATTRO file as follows.
2. Press / to get the Main QUATTRO Menu.
3. Press F for File.
4. Press R for Retrieve.
5. You will get a list of files stored on the hard drive. To
load one of these files, simply highlight the file name and
press enter. To load a file from the floppy drive, press ESC
2 times and type the drive name (A: or B:) then enter. A
list of all QUATTRO files on the disk will be displayed.
Highlight the file name you want to load and press enter.
6. Press P for print or highlight Print and enter. This will
give you the Print Menu.
7. Press B for Block (another menu) or highlight Block and
enter.
8. Place cursor at the upper left or lower right corner of the
block of data you wish to transfer to an ASCII file.
9. Press (period) but do not enter. This anchors the upper
left hand corner or lower right of the block.









10. Paint (highlight) the block using the arrow keys right and
down or up and left depending on which way you anchor. Do
not paint anymore columns than you can see on the screen at
one time. Press enter after you have painted the block. The
print menu comes back after pressing enter here.
11. Press D or highlight Destination and enter. This will give
you a menu that says, Printer or File? Press F for file.
12. The computer will request a file name. You will see
something like C:\Quat\*.prn. This means that the C = hard
drive, \ = back slash, Quat = Sub directory that holds
QUATTRO, \ = back slash, = this is where the new ASCII file
will go, and prn = Extension that QUATTRO puts on the name.
13. At this point if you just type a new name with up to 8
characters it will be stored on the C drive (Hard disk). If
you press ESC twice and type B:name or A:name it will be
stored on a floppy disk in the appropriate drive.
14. We should be back to the print menu now. Press G for Go -
the file will now be stored where you told it to be stored
(drive a, b, or c ). If a file already existed with the
name you typed a new menu will appear act accordingly.
15. Press ESC to get the main menu in QUATTRO.
16. Press Q.
17. Press Y.
18. Press 3 for statistics.

Transfer of ASCII to MSTAT Files
1. Press 1 for MSTAT
2. Press File and enter
3. Press Open and enter
4. In order to load an ASCII file into an MSTAT data file you
must have an active (open) MSTAT data file to load the ASCII
file into.
5. You now will be asked for a file name press Fl and a list
of MSTAT files on disk in drive B (or A depending on the
computer you are using) will appear. This is a list of
MSTAT files not ASCII files. See "Creating an MSTAT data
file" on page 7 for instructions on creating a data file.
6. HOLD is the file name of the file that has been created by
Jim Chichester to bring ASCII files into MSTAT. This file,
HOLD, is used as a temporary file to hold MSTAT data until
it can be transferred to a large MSTAT data file.
7. You may load one of the MSTAT files now by moving the marker
to the desired file and pressing enter 2 times. For the
purpose of this exercise we will use the file HOLD, which
will appear as B:HOLD on the screen.
8. You will now return to the Main menu which offers a choice of
File, Menu and Quit. Press M for Menu then press enter or
highlight Menu, using cursor movement keys, and press enter.
9. Press YES we want to use B:HOLD.









10. Check for accuracy and press enter if ok. It will be ok so
just press enter.
11. You will get the 13 choice menu. Press 9 to get the ASCII
file management menu.
12. Press 3 and enter to read the ASCII file into the active
MSTAT file.
13. Type the name of ASCII file and enter. IF it is on the
floppy disk in drive B type the file name followed by .PRN
like this B:fn.PRN and enter. If your ASCII file is on the
hard drive, type C:\QUAT\fn.prn and press enter.
14. You will be asked for the delimiter. The delimiter will be a
space, so press the space bar 1 time and enter.
15. You will be asked if you want to establish new variables.
Press N then enter.
16. You will be asked to enter the variable list we can only
have 8 variables because there are only 8 in the HOLD file.
17. Therefore type and enter or 1-8 and enter or 1-to some
number between 2 and 8 or 3-5, 3,7, etc. and enter. The *
gets all variables in the file. The = gets a range between
two values. A = individual variables. If the file you are
transferring has less than 8 variables, use the 1-X method
of variable number designation.
18. Very seldom would you want to add new cases at the end of the
file, therefore press N and enter when this comes up.
19. It will ask "What is the number of the first case for data
entry"? Usually this will be number 1, therefore press 1 and
enter.
20. It will ask if the ASCII file is from a data logger? You will
type Yes and press enter.
21. It will ask if you want to include this line over and over.
You will press no and enter until your first case of data
appears then you will press yes and enter. The file data
will start being transferred from ASCII to MSTAT.
22. Press 1 and enter when the transfer is complete and you will
be back to the file manager main menu.
23. You are now ready to transfer your data from HOLD to your
large MSTAT file. This is covered in the next section.

Building a Large MSTAT File

1. If building a big MSTAT file press the number 13 and enter.
This starts a transfer sequence of combining small MSTAT files
to one large MSTAT file. However the large MSTAT file must be
created before you can do this process. This will be the
MSTAT file created earlier.
2. The first step in the transfer procedure is to attach a
destination file, which will be the large MSTAT file you have
already created. Press 2 and enter.
3. Enter the name of the large MSTAT file and press enter.









4. Press Y and enter to see a list of the variables in the
destination file. Press enter and inspect the description of
the data file. Press enter to accept.
5. Press 3 and enter to begin the transfer procedure.
6. Since you will be transferring all the data press Y and
enter.
7. You want to enter data into case 1 of the destination file
so press 1 and enter.
8. If you want to see a list of the variables you are
transferring press Y and enter, otherwise press N and enter.
9. Enter the variable list you want to transfer. You can enter
a range such as 1-4, individuals such as 1,4,6 or a single
variable 4. A loads all variables. After entering the
desired variables press enter.
10. Now you must tell the computer what variable in the
destination file to put the first variable you transfer.
Type the variable numbers and press enter. Do not use the *
at this point.
11. Press N and enter.
12. Press 7 and enter to save what you transferred.
13. Press 1 and enter to return to the file manager.
14. If you need to transfer more data to the large MSTAT file go
through the ASCII file transfer procedure for each portion.
15. If you are ready to run your statistics press 0 and enter.
This will take you to the MSTAT Function Menu.

MSTAT Statistical analysis

1. At the MSTAT Function Menu highlight AOV and enter or just
press A.
2. If you just finished transferring your data from QUATTRO
press N and enter the name of the file to be analyzed.
Otherwise, press Y and enter.
3. Since our experiment is a split plot press 5 for factorial.
4. Press yes or no and enter.
5. When it asks for "How many factors including reps"? type 3
and enter because you have reps, whole plot treatments, and
split plot treatments.
6. Variable number, lowest level of that variable, and highest
level of that number will be requested for factor 1, 2, and
3. Factor 1 is reps and will be entered as 1,1,4 for 1 =
reps, 1 lowest level, 4 = highest level. For factor 2 it
will be entered as 2,1,4 for factor 2 for whole plots, 1 is
first hybrid, 4 is the last hybrid, for factor 3 it will be
entered as 3,1,4 for factor 3 for split plots, 1 is the first
date of harvest or the lowest split plot value, 4 is the last
or highest date.
7. You will be ask if this is ok. You will enter yes or no as
appropriate.
8. It will ask if you will use all cases. You will usually
enter yes.









9. It will ask you to list the variables. Do not include
variables used as factors here. In our example these would
be variables 1, 2, and 3. These were reps, whole plots, and
split plots. Therefore you would press 4-8 and enter if you
want to analyze all variables or press the one or more
variables you wish to analyze. such as 4 or 4-5 if these two
or 4,5 or 4,7 or 4-7 and enter.
10. A new menu will appear now. You must make a choice of
experimental design. In our case it will be a RCB with a
split or it could be a CRD with a split. Press the
appropriate number, in our case press 9 and enter.
11. View the DF table for accuracy. In other words is this the
DF table you are expecting.
12. Press y or n as appropriate.
13. You will not usually want to store means. Therefore press N
and enter when you are ask this question.
14. When the analysis is complete you will get a factor option
menu. You can print and/or view the ANOVA as desired.

COMPUTER SHUTDOWN
1. If you are not at the Main MSTAT Menu, get there by following
the Return To DOS instructions.
2. Press Q twice.
3. On the Tandy highlight DOS UTILITIES and press enter.
4. Highlight COMPUTER SHUTDOWN and press enter.
5. Turn off computer and monitor.

CREATING AN MSTAT DATA FILE

1. Turn on computer and monitor.
2. Highlight statistics and press enter.
3. Highlight MSTAT and press enter.
4. If you are using the Tandy press enter again.
5. Highlight File and press enter, or press F.
6. Highlight New and press enter, or press N.
7. Type in the filename you wish to use, 8 characters maximum,
and press enter.
8. Press enter to keep file size at 127.
9. Type in a descriptive title for your file and press enter.
10. You are back at the File Option Menu. Highlight Menu and
press enter.
11. You are at the Main MSTAT Menu. Highlight Manager and press
enter.
12. Press enter 3 times noting the file name and description as
you go.
13. Press 2 and enter. This will allow you to enter new variable
information.
14. You will define each variable. Giving the type, numeric or
text, the name or description and the number of digits on
each side of the decimal point.









15. Press enter for the variable type, since we are using numeric
data.
16. Type in name or description of the variable.
17. We must tell the computer how many digits there are on
each side of the decimal. Enter the number of digits to the
left of the decimal and press enter. Now enter the number of
digits to the right of the decimal and press enter.
18. A summary of the variable is now displayed. If it is
correct press enter. If it is wrong press N and then enter.
This will allow you to reenter the data for that variable.
19. Continue with steps 15-18 until all variables have been
entered. After the final variable has been described, press
the / and then press enter. You are now ready to place data
into the file.
20. At this point you can go through the exit and shutdown or
you can bring data into the file and continue with the
analysis.
21. If you are not doing anything else at this time, press 0 and
enter. This returns you the the Main MSTAT Menu.

References

1. MSTAT 4.0-C. 1985. A microcomputer program for the Design,
Management, and Analysis of Agronomic Research Experiments.
MSTAT Development Team, Michigan State University. E.
Lansing, Mi 48824-1325.
2. QUATTRO 1.0. 1987. A microcomputer spreadsheet program.
Boroland International, 4585 Scotts Vally Drive, Scotts
Valley, Ca 95266, USA.








Table 1. Dry Matter and Plant Nutrient Content of Four Corn
hybrids at fout stages of growth from in-row subsoil no-tillage
planting.

Case Rep Hyb Date DM N P K Ca Mg Cu Fe Mn Zn
---------- Kq/A --------- ------ q/A ------

1 1 1 1 7181 152 19 273 18 13 23 196 '85 65
2 2 1 1 6980 119 21 237 17 12 29 159 95 67
3 3 1 1 7900 158 19 324 20 15 43 144 104 72
4 4 1 1 7880 182 20 331 24 18 36 215 86 89
5 1 1 2 15420 193 39 262 32 25 77 420 140 147
6 2 1 2 19040 204 59 267 53 27 86 605 69 147
7 3 1 2 18540 232 37 260 45 33 101 673 194 143
8 4 1 2 14160 198 40 198 34 26 51 257 96 161
9 1 1 3 29720 350 71 368 48 35 94 522 230 230
10 2 1 3 21900 221 46 263 39 33 99 597 209 219
11 3 1 3 25140 287 50 302 50 38 103 457 217 228
12 4 1 3 21980 231 37 330 46 33 100 699 190 210
13 1 1 4 28380 301 77 426 51 34 129 644 142 245
14 2 1 4 28280 297 57 367 42 37 154 514 128 270
15 3 1 4 24540 260 59 368 34 34 134 446 134 212
16 4 1 4 29180 298 70 350 38 44 159 397 133 344
17 1 2 1 8200 151 25 279 20 14 34 186 112 78
18 2 2 1 6740 137 19 236 16 14 28 153 61 80
19 3 2 1 9880 180 30 316 25 16 54 224 117 139
20 4 2 1 6600 123 22 191 20 13 24 150 57 63
21 1 2 2 18120 261 38 344 45 29 58 411 206 255
22 2 2 2 15680 191 35 267 41 24 50 285 93 135
23 3 2 2 17180 230 48 258 41 29 63 546 195 148
24 4 2 2 13600 178 37 231 37 18 43 494 86 124
25 1 2 3 23680 270 52 332 45 33 97 645 247 247
26 2 2 3 25140 284 55 327 50 33 114 1712 217 274
27 3 2 3 21800 244 55 262 37 33 89 495 178 208
28 4 2 3 25140 249 60 302 50 38 103 685 148 263
29 1 2 4 27320 391 63 383 44 33 285 744 199 298
30 2 2 4 23520 249 61 306 38 33 246 428 128 267
31 3 2 4 27060 279 60 325 43 33 295 491 172 344
32 4 2 4 28500 259 57 285 40 31 324 388 155 336
33 1 3 1 7200 135 17 209 22 17 33 163 85 62
34 2 3 1 6780 142 18 224 21 12 34 185 83 65
35 3 3 1 9600 157 23 269 24 16 44 218 113 83
36 4 3 1 9280 204 22 371 30 17 59 211 76 84
37 1 3 2 17140 195 33 257 36 29 55 623 117 125
38 2 3 2 14500 168 31 203 36 35 53 329 138 112
39 3 3 2 17540 216 33 346 44 35 64 319 143 127
40 4 3 2 15500 191 33 233 43 20 56 352 106 106
41 1 3 3 18440 216 35 240 38 31 167 921 193 218
42- 2 3 3 21260 240 49 255 43 30 193 579 154 241
43 3 3 3 20940 247 48 314 52 40 238 570 181 290
44 4 3 3 22540 241 52 316 47 34 143 716 123 256
45 1 3 4 24740 252 45 297 27 27 124 337 146 157










Table 1. Continued
Case Rep Hyb Date DM N P K Ca Mg Cu Fe Mn Zn
---------- Kq/A --------- ------ g/A ----


4 37180
4 32520
4 30800
1 7740
1 8520
1 6540
1 7600
2 15800
2 17680
2 14700
2 14420
3 22340
3 19660
3 26040
3 21420
4 31680
4 29200
4 31400
4 21700


387
368
314
159
158
139
141
199
212
159
175
277
203
339
229
383
345
308
241


446
280
431
271
281
196
220
237
265
221
231
268
295
417
214
317
234
258
260


186 506
148 590
84 419
39 141
31 155
27 208
45 207
65 359
56 401
67 400
66 262
142 3347
98 446
130 1419
117 486
115 575
80 398
100 713
79 591


46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64


203
162
112
130
62
98
76
129
153
127
98
253
134
236
136
187
119
285
177


388
266
196
74
70
65
66
115
145
147
138
243
187
248
195
173
186
200
168




University of Florida Home Page
© 2004 - 2010 University of Florida George A. Smathers Libraries.
All rights reserved.

Acceptable Use, Copyright, and Disclaimer Statement
Last updated October 10, 2010 - - mvs