Data Entry
Enter following data using the keyboard.
Enter following data using the keyboard.
Student | DOB | Exam 1 | Exam 2 | Exam 3 |
---|---|---|---|---|
Perera.L. | 1/9/1980 | 75 | 62 | 88 |
Kumara.P. | 3/22/1985 | 66 | 78 | 73 |
Sarath.D. | 9/25/1986 | 92 | 96 | 98 |
Nalin.S. | 7/15/1987 | 86 | 77 | 79 |
Rangana.K. | 2/8/1980 | 95 | 92 | 92 |
Samanthi.D. | 5/2/1984 | 79 | 71 | 85 |
Other Methods of Importing Data
- From External Files (Like from Excel)
- File > Open Worksheet
- Using the Clipboard
- Edit > past cells
Manipulating Data
- Stack
- Combine two or more columns into one column.
- Data > Stack > Columns…
- Unstack
- Separate one or more columns into blocks of columns.
- Data > Unstack Columns
- Coding Data
- Converts data to text, numeric or date/time data.
- Data > Code > …
- Copying Data
- Copy data from columns, constants and matrices to new columns, constants or matrices.
- Data > Copy >
- Summarizing Data
- Signs: Convert negative, zero and positive values to -1, 0 and +1.
- Parsum: calculates and stores partial sums (similar to cumulative sum) .
- Calc > Calculator
- Ranking Data
- Rank the data values in order of magnitude.
- Data > Rank
- Sorting Data
- Orders text or numeric data in one or more columns. Missing values are sorted last in numeric columns and first in text columns.
- Data > Sort
- Data Display
- Display data on session window
- Data > Display Data
Doing Calculations
- Compute algebraic expressions, comparison and logical operations.
- Algebraic expressions: +, -, *, / and **, commands (mean, sum, etc.)
- Comparison operations: = or EQ (Equal to); ~=, <>, or NE; < or LT; > or GT; <= or LE; and >= or GE
- Logical operations: & or AND; | or OR; and ~ or NOT.
- Calc > Calculator
Entering Patterned Data
- A sequence of data, repeated data or repeated sequences can be entered easily.
- Calc > Make Patterned Data
MINITAB GRAPHS
This comment has been removed by the author.
ReplyDelete