# Excel data entry for statistics

Views:

Category: Education

## Presentation Description

How to enter excel data for statistical analysis.

## Presentation Transcript

### Each row represents :

Each row represents A single case A single person A single subject A single participant Synonymous terms

### Each column represents a :

Each column represents a variable

### Each cell represents :

Each cell represents A value representing that row’s subject for that column’s variable

### Hint: :

Hint: enter all values as numbers

### Ratio & Interval Scales :

Ratio & Interval Scales Just enter the numbers

### Ordinal Scales :

Ordinal Scales Enter the ranks

### Example :

Example Jones sold the most Johnson was next Smith sold the least

### Example :

Example Jones sold the most = 3 Johnson was next = 2 Smith sold the least = 1

### Ordinal Scales :

Ordinal Scales Enter the levels

### Example :

Example Excellent Good Fair Poor

### Example :

Example Excellent = 4 Good = 3 Fair = 2 Poor = 1

### Example (Likert) :

Example (Likert) Strongly Agree Mostly Agree Don’t Know Mostly Disagree Strongly Disagree

### Example (Likert) :

Example (Likert) Strongly Agree = 5 Mostly Agree = 4 Don’t Know = 3 Mostly Disagree = 2 Strongly Disagree = 1

### Example (frequency) :

Example (frequency) Always Usually Occasionally Rarely Never

### Example (frequency) :

Example (frequency) Always = 5 Usually = 4 Occasionally = 3 Rarely = 2 Never = 1

### Binary Nominal :

Binary Nominal Yes/ No Male / Female Experimental / Control Pass / Fail

### Binary Nominal :

Binary Nominal Yes = 1 Male = 1 Experimental = 1 Pass = 1

### Binary Nominal :

Binary Nominal No = 0 Female = 0 Control = 0 Fail = 0

### Example of Excel data entered :

Example of Excel data entered

### Determine sample size :

Determine sample size N = number of rows - 1

### Example of Excel data entered :

Example of Excel data entered