Download the Self-Efficacy Dataset and save to your computer.
Install the Excel Analysis ToolPak if you have a Microsoft computer or the StatPlus Analysis ToolPak if you have a MAC computer (see course resources for directions).
Run descriptive statistics (DS) as requested below using the ToolPak you downloaded. Save the output to a new worksheet in the Excel spreadsheet and re-label the tab as “DS of Data”.
Compute a difference in means as requested below.
Determine percentages as requested below.
Calculate percent change as requested below.
Click on the tab “Answers to Questions”. Provide your responses to each of the questions below on this worksheet. Include with your answers the formula you used for the questions that require the calculation of difference in means, percentages, and percent change.
Save your Excel file using the following format “Last Name_Assignment2_NUR 707”.
Questions:
What was the total number of participants?
How many participants were male? How many participants were female? What was the percentage of male versus female participants?
What was the overall group mean, minimum, and maximum values for age? What was the mean age for males? What was the mean age for females?
Which ethnic group did the greatest proportion of participants comprise? Of this ethnic group, what percentage of individuals used the Internet to retrieve health information?
What was the overall group mean, minimum, and maximum values for the total scale score pre project implementation?
What was the overall group mean, minimum, and maximum values for the total scale score post project implementation?
What was the difference in means for the overall group mean total scale scores pre and post project implementation? What was the percent change in means for the overall group mean total scale scores pre and post project implementation? What do you conclude from these findings regarding the identified benchmark for this project?
Excel Spreadsheet at address below:
https://www.mediafire.com/file/6kohkyp3gjy0w0l/NUR_707_Self-Efficacy_Dataset_Assignment%25232_Summer_2016_%25281%2529_%25281%2529.xlsx/file
