NURS 5024 (Research) Data Analysis Using Excel

Purpose

The objective of this assignment is to give you the opportunity to enter and analyze data using the Excel software program. Excel is a program used frequently in data entry and analysis. Developing this skill will help you in analyzing basic descriptive data and some group comparison analyses. This will be helpful in your future evidence-based nursing practices (e.g., analyzing clinic data, conducting evidence-based practice projects).

Deliverables

• Excel data file with your completed analysis (70 points)
• One paragraph narrative summarizing analysis completed and your interpretation of results (30 points)

Instructions

Also, make sure that the Analysis ToolPak Add-in is installed in your Excel program. Review Load the Analysis ToolPak in ExcelLinks to an external site. article to learn more.

Enter the Data

If you are not that familiar with Excel, below are two YouTube videos explaining how to enter data into an Excel spreadsheet. I particularly like the second video as it is more comprehensive. Click each tab to access the video.(Video links attached)

Below is some raw data on 11 subjects that I want you to use and enter first into an Excel file. Then, complete the required statistical analyses. Exercise motivation is divided into two types (variables): paratelic and telic. Paratelic motivation refers to motives for exercising that people feel are spontaneous, exciting, and fun. Telic motivation refers to motives for exercising that are serious and strategies for goal setting and planning.With all data, create a frequency table (Counts, Relative Frequency, and Percent). Review the video tutorial below if you need help:

TASK 1:Frequency Table With all data, create a frequency table (Counts, Relative Frequency, and Percent). Review the video tutorial below if you need help:

Task 2: Descriptive Statistics

With ordinal and continuous data, run descriptive statistics, showing Mean, Median, Mode, Standard deviation, etc. Review the video tutorial below if you need help:

Task 3: Correlation Analyses

Run correlation analyses between paratelic and telic exercise motivation scores. Review the video tutorial below if you need help:

TASK 4

Obtain P-value for the correlation coefficient r. Review the video tutorial below if you need help:

Note: Unlike the simple correlation coefficient r, which tells both the strength and direction of the association between two variables, Multiple R tells only the strength of the association and is never a negative value. So, report the simple correlation coefficient r value (rather than Multiple R value) and p-value.