Using the Excel Sheet and descriptive statistics page; you will write up your analysis for the 20 participants. This week, you
Discussion Question
Using the Excel Sheet and descriptive statistics page; you will write up your analysis for the 20 participants.
This week, you learned about the statistical software applications used to analyze data for research analysis. For this week's discussion, you will use Excel sheet provide to run descriptive statistics, create graphs and respond to the following:
- How could you use Excel descriptive statistics for data analysis research?
- What are your plans for learning more about Excel and how will the information you learned about this software be of benefit in your future analysis of research data?
Refer to this week’s readings and video tutorials before starting this two part discussion question assignment
3/4/22, 10:45 AM Rubric Assessment – NSG6101-Nursing Research Methods CP02 – South University
https://myclasses.southuniversity.edu/d2l/lms/competencies/rubric/rubrics_assessment_results.d2l?ou=85407&evalObjectId=431951&evalObjectType… 1/3
NSG6101 Discussion Rubric (20 Points) – Version
1.0 Course: NSG6101-Nursing Research Methods CP02
Participation No Submission 0 points
Emerging (F- D: 1-2) 2 points
Satisfactory (C) 3 points
Proficient (B) 4 points
Exemplary (A:) 5 points
Criterion Score
Discuss
your library
search
strategies
and briefly
summarize
the
literature
you
reviewed.
Focus your
discussion
on the
“problem”
and how the
literature
you
identified
provides
evidence of
the
existence of
the problem.
/ 5Student did not submit
assignment
Student
provided an
under-
developed
description of
the for
problem with
little or no
analysis of
supportive
evidence for
the problem
identified.
Student
provided a
minimally
developed
description of
of problem
with limited
analysis of
supportive
evidence for
the problem
identified.
Student
provided a
developed
description of
the required
elements for
for the
problem
identified with
reasonable
analysis of
concepts and
related issues.
Student
provided a
fully
developed
description of
the required
the “problem”
and how the
literature you
identified
provides
evidence of
the existence
of the
problem.
3/4/22, 10:45 AM Rubric Assessment – NSG6101-Nursing Research Methods CP02 – South University
https://myclasses.southuniversity.edu/d2l/lms/competencies/rubric/rubrics_assessment_results.d2l?ou=85407&evalObjectId=431951&evalObjectType… 2/3
Participation No Submission 0 points
Emerging (F- D: 1-2) 2 points
Satisfactory (C) 3 points
Proficient (B) 4 points
Exemplary (A:) 5 points
Criterion Score
Include in
your
discussion a
potential
innovation
that you
might
consider as
a solution to
the problem
identified.
/ 5
Include
citations/ref
erences in
APA style
format,
using
citations
where
appropriate.
/ 5
Student did
not submit
assignment.
Student
provided a
under-
developed
discussion of
how the
problem and
solution are
viable with
little or no
analysis of
concepts and
related issues.
Student
provided a
minimally
developed
discussion of
how selected
innovation
with limited
analysis of
concepts and
related issues.
Student
provided a
developed
discussion of
potential
innovations no
older than 5
years since
publication
with
reasonable
analysis of
concepts and
related issues.
Student
provided a
fully
developed
discussion of
potential
innovation for
problem
identified.
Student did
not submit
assignment.
Demonstrates
limited
sentence,
paragraph, and
essay level
skills. Has
limited use of
evidence with
few or no
sources to
support the
content. Does
not meet the
graduate level
of writing and
does not meet
the minimum
requirement.
Demonstrates
limited APA
formatting
with multiple
formatting
errors.
Demonstrates
minimally
developed
sentence,
paragraph, and
essay level
skills.
Minimally
meets the
graduate level
with several
writing issues
and meets the
minimum
reference
requirement.
Demonstrates
minimally
developed
APA
formatting
with several
formatting
errors.
Demonstrates
developed
sentence,
paragraph, and
essay level
skills. Meets
the graduate
level with
minimal
writing issues
and exceeds
the minimum
reference
requirement.
Demonstrates
developed
APA
formatting
with minimal
formatting
errors.
Demonstrates
fully
developed
sentence,
paragraph and
essay level
skills. Meets
the graduate
level with no
writing issues
and exceeds
the minimum
reference
requirement.
Demonstrates
fully
developed
APA
formatting
with no errors.
Writing No Submission 0 points
Emerging (F- D: 1-2) 2 points
Satisfaction (C) 3 points
Proficient (B) 4 points
Exemplary (A) 5 points
Criterion Score
3/4/22, 10:45 AM Rubric Assessment – NSG6101-Nursing Research Methods CP02 – South University
https://myclasses.southuniversity.edu/d2l/lms/competencies/rubric/rubrics_assessment_results.d2l?ou=85407&evalObjectId=431951&evalObjectType… 3/3
Total / 20
Overall Score
Writing No Submission 0 points
Emerging (F- D: 1-2) 2 points
Satisfaction (C) 3 points
Proficient (B) 4 points
Exemplary (A) 5 points
Criterion Score
Participation
No later
than by the
end of the
week,
review and
comment on
the
discussion
question
responses
posted by at
least two of
your peers.
/ 5Student did not submit
assignment.
Demonstrates
limited
sentence,
paragraph, and
essay level
skills. Has
limited use of
evidence with
few or no
sources to
support the
content. Does
not meet the
graduate level
of writing and
does not meet
the minimum
requirement.
Demonstrates
limited APA
formatting
with multiple
formatting
errors.
Demonstrates
minimally
developed
sentence,
paragraph, and
essay level
skills.
Minimally
meets the
graduate level
with several
writing issues
and meets the
minimum
reference
requirement.
Demonstrates
minimally
developed
APA
formatting
with several
formatting
errors.
Demonstrates
developed
sentence,
paragraph, and
essay level
skills. Meets
the graduate
level with
minimal
writing issues
and exceeds
the minimum
reference
requirement.
Demonstrates
developed
APA
formatting
with minimal
formatting
errors.
Demonstrates
fully
developed
sentence,
paragraph and
essay level
skills. Meets
the graduate
level with no
writing issues
and exceeds
the minimum
reference
requirement.
Demonstrates
fully
developed
APA
formatting
with no errors.
No
Submission 0 points
minimum
Emerging (F to D
Range) 1 point minimum
Satisfactory (C
Range) 14 points minimum
Proficient (B
Range) 16 points
minimum
Exemplary (A
Range) 18 points
minimum
,
3/4/22, 10:50 AM Week 9 Discussion – NSG6101-Nursing Research Methods CP02
https://myclasses.southuniversity.edu/d2l/le/content/85407/viewContent/3978076/View 1/5
Week 9 Discussion
NSG6101-Nursing Research Methods CP02 IP
Discussion Questions
By the due date assigned, post your response to the assigned discussion questions in the
below Discussion Area. It is important to support what you say with relevant citations in the
APA format from both the course materials and outside resources. Include the South
University Online Library in your research activities utilizing not only the nursing resource
database, but also those pertaining to education, business, and human resources.
No later than by the end of the week, review and comment on the discussion question
responses posted by at least two of your peers. Be objective, clear, and concise. Always use
constructive language. All comments should be posted to the appropriate topic in this
Discussion Area.
Discussion Question
Using the Excel Sheet and descriptive statistics page; you will write up your analysis for the
20 participants.
This week, you learned about the statistical software applications used to analyze data for
research analysis. For this week's discussion, you will use Excel sheet provide to run
descriptive statistics, create graphs and respond to the following:
How could you use Excel descriptive statistics for data analysis research?
What are your plans for learning more about Excel and how will the information you
learned about this software be of benefit in your future analysis of research data?
Refer to this week’s readings and video tutorials before starting this two part discussion
question assignment.
Step 1: Entering Data
3/4/22, 10:50 AM Week 9 Discussion – NSG6101-Nursing Research Methods CP02
https://myclasses.southuniversity.edu/d2l/le/content/85407/viewContent/3978076/View 2/5
Open a blank worksheet in the Excel program
You will now use Excel to view a sample dataset
Dataset Options
In many cases, researchers may have the data from their study in another software package
like Microsoft Excel. However, if the data is not available in a software spreadsheet you can
manually enter the data. Option 2: Manual Data Entry
In the Worksheet window, type “Age” in C1. Enter the numbers as shown in the dataset
below. Enter the remaining data as shown below (set up your column labels i.e., variable). The
measure reflects math anxiety and the study variables (cringe, uneasy, afraid, worried,
understand) the math anxiety range is from 1–5 with low being the least and 5 the highest.
Age Cringe Uneasy Afraid Worried Understand
28 5 3 4 4 3
34 2 5 3 2 1
25 4 4 4 2 5
56 3 4 3 1 2
23 5 4 3 3 4
29 1 5 3 2 3
30 3 3 5 2 5
59 2 5 5 1 2
45 4 2 5 3 3
38 1 2 4 1 1
33 3 2 4 3 2
3/4/22, 10:50 AM Week 9 Discussion – NSG6101-Nursing Research Methods CP02
https://myclasses.southuniversity.edu/d2l/le/content/85407/viewContent/3978076/View 3/5
47 4 2 3 4 5
24 1 5 3 4 4
29 5 4 2 1 3
53 3 1 5 2 1
48 4 4 1 5 3
27 2 5 4 3 4
34 4 4 3 2 5
26 4 5 2 3 2
36 5 5 5 4 3
Step 2: Click on Excel tab for Add Ins; if you do not see statistics; you will need to open the
file option; click on Add ins; click on ok; a box will open which will allow you to choose
Statistics package; place a check mark in the box and click ok. How to Run Descriptive
Statistics
Now that your data is in Excel, you will look at the descriptive statistics for this dataset.
Select the data in all the columns except the top that has words for the columns; however
you have the file already completed and a picture of the descriptive statistics..See end of
page for a copy of the excel sheet and descriptive statistics output.
Discussion Question Part 1
How could you use Excel descriptive statistics for data analysis research? Write about your
experience running descriptive statistics. Use the results in the Session Window to support
your response. Then add to your discussion with the information you learn writing up your
analysis.
Step 3: Excel and Graphs
3/4/22, 10:50 AM Week 9 Discussion – NSG6101-Nursing Research Methods CP02
https://myclasses.southuniversity.edu/d2l/le/content/85407/viewContent/3978076/View 4/5
Reflect in ePortfolio
Due March 10 at 11:59 PM
Rubrics
SUO Discussion Rubric (20 Points) – Version 1.2
NSG6101 Discussion Rubric (20 Points) – Version 1.0
Start a New Thread
Filter by:
Sort by:
Most Recent Activity
There are no threads in this topic.
Task: Reply to this topic Assessment
You will now look at graphing. Select insert graph located at the top of the sheet; highlight
the data you want to use for a chart; select the type of chart; select ok. Try using the
histogram feature for one of the variables and select "Ok". You can create other Histogram
graphs by choosing different variables. You can also choose from the other ten graph choices
shown on the insert chart function.
Discussion Question Part 2
What are your plans for learning more about Excel and how will the information you learned
about this software be of benefit in your future analysis of research data? Copy and paste
your graph(s) in a Word document and attach to your discussion response.
All Threads
Activity Details
3/4/22, 10:50 AM Week 9 Discussion – NSG6101-Nursing Research Methods CP02
https://myclasses.southuniversity.edu/d2l/le/content/85407/viewContent/3978076/View 5/5
SUO Discussion
Rubric (20 Points) –
Version 1.2
NSG6101 Discussion
Rubric (20 Points) –
Version 1.0
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.