Minitab Intro note by sciedu2011

VIEWS: 475 PAGES: 71

									                                      3/12/2011




    MINITAB
M. Sc. In Science Education – 2010/2011




                                             1
                          3/12/2011




     MINITAB

               Menu bar




Session Window



  Worksheet




                                 2
                                     3/12/2011




      Saving the MINITAB project: 




File  Save project as …




                                            3
                                      3/12/2011




               Enable Commands

Click on the session window. Then, 
        Editor  Enable Commands 




                                             4
                                      3/12/2011




               Naming Columns

MTB > Name C1 ‘Registration Number’




                                             5
                                                3/12/2011




                  Entering Data 




1. Typing data in the cells of worksheet
2. Using session commands to enter numerical data
3. Importing data from an external file




                                                       6
                                                  3/12/2011




                    Exercise: 

Enter the following data into columns C1, C2 and C3




                        Month – Date ‐ Year




                                                         7
                                      3/12/2011




                  Missing Data




Missing data are represented by “*”




                                             8
                                               3/12/2011




                    Data Types

1. Numeric Data
2. Text Data
3. Date and Time

         Text      Date and Time    Numeric 




                                                      9
                                             3/12/2011




            Format Numerical Data

Select Column.
1. Right Click on column header  Format Column
    Numeric
2. Editor  Format Column  Numeric




                                                   10
                                             3/12/2011




             Format Date and Time
Select Column.
1. Right Click on column header  Format Column
    Date/Time
2. Editor  Format Column  Date/Time




                                                   11
                                                    3/12/2011




                      Exercise:

Represent the Date of Birth with the following format.




                                                          12
                                                  3/12/2011




                 Defining Constants

The letter ‘k’ is used to define the constants.


1. Numeric constants
        MTB > let k1=98


2. Constants with text values
        MTB > let k1=“Sciecne Education”




                                                        13
                                                     3/12/2011




                  Print Command

‘Print’ command is used to print something in the 
session window.

           MTB > print c1‐c6

           MTB > print c4 c3

           MTB > print k1

           MTB > print k2




                                                           14
                                  3/12/2011




                Erase Variables

Manip  Erase variables




                                        15
                                3/12/2011




          Delete Rows (Cont.)


   Manip  Delete rows …




                                      16
                                                 3/12/2011




                    Copy data

MTB > copy c1 c8
     Copying the column c1into c8 

MTB > delete c4‐c6 c8‐c10
     Copying the columns c4, c5 and c6 into the 
      columns c8, c9 and c10 columns respectively.

MTB > copy k1‐k3 k5‐k7
     Copying the values stored in the 
      constants into another set of constants




                                                       17
                                                       3/12/2011




              Copy data: ‘Use’ command
Select a set of rows which satisfies a certain condition.

 MTB > copy c4 c7;
 SUBC> use c4 67;
 SUBC> end


 MTB > copy c4‐c6  c8‐c10;
 SUBC> use c4 65;
 SUBC> end




                                                             18
                                           3/12/2011




        Copy data: ‘Use’ command (Cont.)

MTB > copy c4‐c6 c11‐c13;
SUBC> use c4 68:100.
SUBC> end

MTB > copy c4‐c6 c11‐c13;
SUBC> use c4 65 68:100
SUBC> end




                                                 19
                                                      3/12/2011




            Copy data: ‘Omit’ command

Ignore a set of rows which satisfies a certain condition.

MTB > copy c4‐c6 c7‐c9;
SUBC> omit c4 65.

MTB > copy c4‐c6 c7‐c9;
SUBC> omit c4 67:100.

MTB > copy c4‐c6 c11‐c13;
SUBC> omit c4 65 68:100
SUBC> end




                                                            20
                               3/12/2011




               Sorting Data 

Manip  Sort




                                     21
                              3/12/2011




               Ranking Data

Manip  Rank




                                    22
                                                   3/12/2011




                   Coding Data

Code: Replace some values with different values.


      Numeric to Numeric
      Numeric to Text
      Text to Numeric
      Text to Text




                                                         23
                                          3/12/2011




              Coding Data (Cont.)

Ex:
     Gender  ‐ Text to Numeric
               Female 1
               Male  0


     Priority Levels – Numeric to Text
               1Highest
               2Moderate
               3Lowest




                                                24
                                                  3/12/2011




              Coding Data (Cont.)

Ex:
     Gender  ‐ Text to Text
               F Female
               M  Male

     Yield of a field (y) – Numeric to Numeric
                 y >= 5000 kg      5
               4999>=y>=2000     2.5
               1999>=y>=0        0




                                                        25
                      3/12/2011




Coding Data (Cont.)




                            26
                                                               3/12/2011




               Coding Data (Example)


 Reg number Gender      Date of Birth   Maths Stat Comp Scie

PGIS0912      F      03‐December‐1984    45    67     81
PGIS0911      F      21‐April‐1973       67    86     98
PGIS0915      M      23‐August‐1971      65    64     71
PGIS0916      F      10‐October‐1981     78    45     45
PGIS0910      M      24‐February‐1976    56    78     89
PGIS0921      M      02‐February‐1961    67    ‐1     ‐1
PGIS0923      F      12‐April‐1982       34    ‐1     ‐1




                                                                     27
                                       3/12/2011




                  Example (Cont)

• Text to Text : Convert the gender;
        M into “Male”
        F into “Female”




                                             28
                                           3/12/2011




                  Example (Cont)

• Text to Numeric : Convert the gender ,
            M into 1
            F into 0




                                                 29
                                                  3/12/2011




      Code: Using session commands (Cont.)

• Numeric to Text :Convert the gender into text
            0 into Male
            1 into Female




                                                        30
                                                     3/12/2011




                 Code: Exercise




If a particular mark is ‘‐1’ then represent it by 
“Absent” and otherwise represent it by “Present”. 
Store the new values of three subjects in three 
different columns.




                                                           31
                                                   3/12/2011




                  Code: Exercise

Display the grades of each subject for each student,
according to the following criteria.


       100>=marks>=75  “A”
       75>marks>=65  “B”
       65>marks>=55  “C”
       55>marks>=45  “D”
       Other wise  “F”




                                                         32
                                                             3/12/2011




                          Example : 

   C1‐T     C2‐T            C3‐D         C4    C5       C6

   Reg                                               Computer 
           Gender       Date of Birth   Maths Stat
 number                                               Science

PGIS0912     F      December‐03‐1984     45    67       81
PGIS0911     F      April‐21‐1973        67    86       98
PGIS0915     M      August‐08‐1971       65    64       71
PGIS0916     F      October‐10‐1981      78    45       45
PGIS0910     M      February‐24‐1976     56    78       89
PGIS0921     M      September‐13‐1961    67    ‐1       ‐1
PGIS0923     F      April‐15‐1982        34    ‐1       ‐1




                                                                   33
                                                3/12/2011




                    Stack Data

Add the data in two or more columns into one 
column.




                                                      34
                                            3/12/2011




      Stack Data : Using Session Commands

Manip  stack  columns.




                                                  35
                                                    3/12/2011




                   Unstack Data

Split the content in one column into two or more 
columns.
Manip  Unstack Columns




                                                          36
                                                    3/12/2011




        Changing the data type of a column



Click on the column of which the data type to be 
changed.


Manip  Change data type  Select the proper 
conversion to be done 




                                                          37
                                                      3/12/2011




                  Concatenating




Combine two or more text columns with equal 
length side by side and store them in a new column.




                                                            38
                                                     3/12/2011




                       Concatenating

 C8‐T       C9‐T         C10‐T
Country    District 
                        Number    Telephone Number
 Code       Code
 (094)      ‐081‐      2389685
 (094)      ‐081‐      2453677
 (094)      ‐011‐      2987574
 (094)      ‐035‐      2987475
 (094)      ‐037‐      2276855
 (094)      ‐060‐      3227685
 (094)      ‐091‐      8975043




                                                           39
                                    3/12/2011




            Concatenating (Cont.)

Manip  Concatenate




                                          40
                                                    3/12/2011




                Concatenating (Cont.)

 C8‐T       C9‐T        C10‐T           C11‐T
Country    District 
                       Number    Telephone Number
 Code       Code
 (094)      ‐081‐      2389685   094‐081‐ 2389685
 (094)      ‐081‐      2453677   094‐081‐ 2453677
 (094)      ‐011‐      2987574   094‐011‐ 2987574
 (094)      ‐035‐      2987475   094‐035‐ 2987475
 (094)      ‐037‐      2276855   094‐037‐ 2276855
 (094)      ‐060‐      3227685   094‐060‐ 3227685
 (094)      ‐091‐      8975043   094‐091‐ 8975043




                                                          41
                    3/12/2011




COLUMN STATISTICS




                          42
                                     3/12/2011




                 Column Statistics

Calc  Column Statistics




                                           43
                 3/12/2011




ROW STATISTICS




                       44
                                            3/12/2011




     Row Statistics : Using Menu Commands

Calc  Row Statistics




                                                  45
                                                              3/12/2011




                          Exercise: 

Find the average of three marks, for each student separately. 
The ‘‐1’ represent the absence of the student. In that case the ‐
1 should be considered as 0.




                                                                    46
                                                   3/12/2011




                     Exercise: 

Display the grades of each subject for each student,
according to the following criteria.


       100>=marks>=75  “A”
       75>marks>=65  “B”
       65>marks>=55  “C”
       55>marks>=45  “D”
       Other wise  “F”




                                                         47
                         3/12/2011




DESCRIPTIVE STATISTICS




                               48
                                                       3/12/2011




      Descriptive Statistics : Menu Commands

Stat  Basic Statistics  Display Descriptive Statistics




                                                             49
                         3/12/2011




Descriptive Statistics




                               50
                                       3/12/2011




Descriptive Statistics : By variable




                                             51
                                      3/12/2011




Descriptive Statistics : Statistics




                                            52
                                  3/12/2011




Descriptive Statistics : Graphs




                                        53
         3/12/2011




GRAPHS




               54
                              3/12/2011




                     Graphs

Import the pulse dataset.




                                    55
                    3/12/2011




        Bar Chart

Graph  Chart




                          56
                     3/12/2011




         Pie Chart

Graph  Pie chart




                           57
                    3/12/2011




        Histogram

Graph  Histogram




                          58
                    3/12/2011




        Histogram

Graph  Histogram




                          59
                             3/12/2011




Histogram: Edit Attributes




                                   60
                     3/12/2011




Histogram: Options




                           61
                   3/12/2011




     Box plot

Graph  Box plot




                         62
                                3/12/2011




        Stem and Leaf Diagram

Graph  Stem‐and‐Leaf




                                      63
                3/12/2011




         Plot

Graph  Plot




                      64
         3/12/2011




Tables




               65
                                  3/12/2011




                     Tally data
Stat  Tables Tally variables




                                        66
                                  3/12/2011




  Cross Tabulation
Stat  Tables Cross tabulation




                                        67
             3/12/2011




Calculator




                   68
                             3/12/2011




Importing / Exporting Data




                                   69
                                     3/12/2011




                Exporting data

MTB > WRITE ‘H:\dataset.txt’ C1‐C7




                                           70
                                    3/12/2011




                 Importing Data

MTB > read ‘H:\dataset.txt’ C4‐C7

Works only for numerical data




                                          71

								
To top