logging in or signing up Excel data entry for statistics headlessprofessor Download Post to : URL : Related Presentations : Let's Connect Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Copy embed code: Embed: Flash iPad Dynamic Copy Does not support media & animations Automatically changes to Flash or non-Flash embed WordPress Embed Customize Embed URL: Copy Thumbnail: Copy The presentation is successfully added In Your Favorites. Views: 731 Category: Education License: All Rights Reserved Like it (0) Dislike it (0) Added: September 22, 2008 This Presentation is Public Favorites: 0 Presentation Description How to enter excel data for statistical analysis. Comments Posting comment... Premium member 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 You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.