Excel data entry for statistics

Views:
 
Category: Education
     
 

Presentation Description

How to enter excel data for statistical analysis.

Comments

Presentation Transcript

Excel data entry : 

Excel data entry headlessprofessor

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

Excel data entry : 

Excel data entry headlessprofessor

authorStream Live Help