logging in or signing up Excel data entry for statistics headlessprofessor Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 600 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.
Excel data entry for statistics headlessprofessor Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 600 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