Research data analysis
Description
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 weeks readings and video tutorials before starting this two part discussion question assignment.
Step 1: Entering Data
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 15 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 |
|
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
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.
Health-related quality of life
Having Trouble Meeting Your Deadline?
Get your assignment on Research data analysis completed on time. avoid delay and – ORDER NOW
References:
Nursing Standards
Nursing and Midwifery Board of Australia. (2018). Code of conduct for midwives. https://www.nursingmidwiferyboard.gov.au/Codes-Guidelines-Statements/Professional-standards.aspx
Clinical Guidelines
Guideline Adaption Committee. (2016). Clinical practice guidelines and principles of care for people with dementia. NHMRC Partnership Centre for Dealing with Cognitive and Related Function Decline in Older People. https://cdpc.sydney.edu.au/wp-content/uploads/2019/06/CDPC-Dementia-Guidelines_WEB.pdf
Living Guideline
Stroke Foundation. (2022). Australian and New Zealand living clinical guidelines for stroke management – chapter 1 of 8: Pre-hospital care. https://app.magicapp.org/#/guideline/NnV76E
Evidence-based practice
BMJ Best Practice
Goldfarb, S., & Josephson, M. (2020). Cystic fibrosis. BMJ Best Practice. https://bestpractice.bmj.com/
Schub, T., & Cabrera, G. (2018). Bites: Head lice [Evidence-based care sheet]. Cinahl Information Systems. https://www.ebscohost.com
Beyea, S. C., & Slattery, M. J. (2006). Evidence-based practice in nursing: A guide to successful implementation. http://www.hcmarketplace.com/supplemental/3737_browse.pdf
JBI: Evidence summary
Swe, K. K. (2022). Blood glucose levels: Self-monitoring [Evidence summary]. JBI EBP Database. https://jbi.global
JBI: Best practice information sheet
Bellman, S. (2022). Experiences of living with juvenile idiopathic arthritis [Best practice information sheet]. JBI EBP Database, 24(1), 1-4.
Cochrane Database of Systematic Reviews
Srijithesh, P. R., Aghoram, R., Goel, A., & Dhanya, J. (2019). Positional therapy for obstructive sleep apnoea. Cochrane Database of Systematic Reviews. https://doi.org/10.1002/14651858.CD010990.pub2
Drug Information
Codeine. (2023, January). In Australian medicines handbook. Retrieved February 2, 2023, from https://amhonline.amh.net.au
Colorado State University. (2011). Why assign WID tasks? http://wac.colostate.edu/intro/com6a1.cfm
Dartmouth Writing Program. (2005). Writing in the social sciences. http://www.dartmouth.edu/~writing/materials/student/soc_sciences/write.shtml
Rutherford, M. (2008). Standardized nursing language: What does it mean for nursing practice? [Abstract]. Online Journal of Issues in Nursing, 13(1). http://ojin.nursingworld.org/MainMenuCategories/ThePracticeofProfessionalNursing/Health-IT/StandardizedNursingLanguage.html
Wagner, D. (n.d.). Why writing matters in nursing. https://www.svsu.edu/nursing/programs/bsn/programrequirements/whywritingmatters/
Writing in nursing: Examples. (n.d.). http://www.technorhetoric.net/7.2/sectionone/inman/examples.html
Perth Children’s Hospital. (2022, April). Appendicitis [Emergency Department Guidelines]. Child and Adolescent Health Service. https://www.pch.health.wa.gov.au/For-health-professionals/Emergency-Department-Guidelines/Appendicitis
Department of Health. (n.d.). Who is being active in Western Australia? https://ww2.health.wa.gov.au/Articles/U_Z/Who-is-being-active-in-Western-Australia
Donaldson, L. (Ed.). (2017, May 1). Healthier, fairer, safer: The global health journey 2007-2017. World Health Organisation. https://www.who.int/publications/i/item/9789241512367
NCBI Bookshelf
Rodriguez Ziccardi, M., Goyal, G., & Maani, C. V. (2020, August 10). Atrial flutter. In Statpearls. StatPearls Publishing. https://www.ncbi.nlm.nih.gov/books/NBK540985/
Royal Perth Hospital. (2016). Procedural management: Pre and post (24-48 hours) NPS. Canvas. https://courses.ecu.edu.au
Explanation & Answer
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.