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 u

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

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.

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.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

6- SOAP NOTES 1-Benign Prostate Hyperplasia 2-Asthma 3-Obesity 4-failure to thrive 5- anemia 6-Gastroenteritis

Complete the Question below:Explain why there is legal protections for occurrence reporting and peer review activities and how this facilitates performance improvement activities.Make sure you provid

Complete the Question below: Explain why there is legal protections for occurrence reporting and peer review activities and how this facilitates performance improvement activities. Make sure you provide a minimum of three references Submit as a Word document.

6- SOAP NOTES 1-Benign Prostate Hyperplasia 2-Asthma 3-Obesity 4-failure to thrive 5- anemia 6-Gastroenteritis

SOAP NOTES/APA FORMAT 1-Heart failure 2-Anemia 3- Lupus 4-Appendicitis 5-Pancreatitis 6-Hypothyoidism

For this assignment, you will read the below articles and then answer questions. List each question as a heading in your essay. Articles: How medical practices can continue the journey toward diversit

For this assignment, you will read the below articles and then answer questions. List each question as a heading in your essay. Articles: How medical practices can continue the journey toward diversity Inclusion, Diversity, Anti-Racism, and Equity (IDARE) Questions: Give an overall summary of this article. What is the main

Search the internet for “patient activation”. Define the term and determine how consumer informatics is related to patient activation? (1 page – APA style)

Soap notes 1-Heart failure 2-Anemia 3-BPH( Benign Prostatic Hyperplasia) 4-Hypothyroidism 5-Psoriasis 6-Lupus

Instructions You are the Privacy Officer at Happy Hospital. On 5/2/24 a local politician was admitted. He was discharged on 5/5/24. You have been monitoring access closely to ensure privacy was mainta

Instructions You are the Privacy Officer at Happy Hospital. On 5/2/24 a local politician was admitted. He was discharged on 5/5/24. You have been monitoring access closely to ensure privacy was maintained. You have received the Audit Trail for 5/5/24. Review the report and compile a list of which employees

Deliverables: Review Chapter 19 Case Study on page pg 386.Complete questions 1, 2 and 3TipsAnswer the questions fully.Have you ever worked in an organization that combined departments.Submit this assi

Deliverables: Review Chapter 19 Case Study on page pg 386. Complete questions 1, 2 and 3 Tips Answer the questions fully. Have you ever worked in an organization that combined departments. Submit this assignment as a Word document.Case Study Faced with rising costs and declining revenues, the board of directors

15 slide PowerPoint on Best practices for Spontaneous Breathing Trail in mechanical ventilation in respiratory care in the hospital , and how to prevent patient harm to our patients . Please include

15 slide PowerPoint on Best practices for Spontaneous Breathing Trail in mechanical ventilation in respiratory care in the hospital , and how to prevent patient harm to our patients . Please include pictures and valid information .

Respiratory Care 15 slide power point t on Best Practices for Spontaneous Breathing Trail in Mechanical ventilation ,and how to prevent patient harm. Slides Needs to be detailed with pictures , and v

Respiratory Care 15 slide power point t on Best Practices for Spontaneous Breathing Trail in Mechanical ventilation ,and how to prevent patient harm. Slides Needs to be detailed with pictures , and valid information.

Write a 4–6 page analysis of your previously selected current problem or issue in healthcare, including a proposed solution and possible ethical implications. Use scholarly information to explain a he

Write a 4–6 page analysis of your previously selected current problem or issue in healthcare, including a proposed solution and possible ethical implications. Use scholarly information to explain a he Write a 4–6 page analysis of your previously selected current problem or issue in healthcare, including a proposed solution and

MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONS OVERVIEW The Malpractice Apology Annotated Bibliography and the Malpractice Apology Research Paper are related assignments that require you to M

MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONS OVERVIEW The Malpractice Apology Annotated Bibliography and the Malpractice Apology Research Paper are related assignments that require you to MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONSOVERVIEWThe Malpractice Apology Annotated Bibliography and the Malpractice Apology ResearchPaper are related assignments that require you to research the existing literature and

Create a 2-4 page report on an interview you have conducted with a health care professional colleague. You will identify an issue from the interview that could be improved with an interdisciplinary ap

Create a 2-4 page report on an interview you have conducted with a health care professional colleague. You will identify an issue from the interview that could be improved with an interdisciplinary ap Create a 2-4 page report on an interview you have conducted with a health care professional colleague.

10 page powerpoint on infection prevention in respiratory in a hospital setting.

15 page powerpoint on infection prevention in respiratory in a hospital setting.

Consider how employees can connect with organizational culture.Propose strategies to build a healthy organizational culture.Demonstrate effective communication to lead interprofessional teams. Apply c

Consider how employees can connect with organizational culture. Propose strategies to build a healthy organizational culture. Demonstrate effective communication to lead interprofessional teams. Apply critical thinking to formulate a logical solution to a problem. The second shift housekeeping manager at St. Mary’s Nursing and Rehab Home called all her staff