Call toll free: +1 (304) 900-6229 or Request a call

support@essayhelp123

Discussion Question Using the Excel Sheet and descriptive statistics page; you will write up your analysis for the 20 participants. This week, you learned

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

can you assist with a 150 word response w/ reference? 1.    Describe the roles and responsibilities of the APRN when prescribing medication APRNs conduct

can you assist with a 150 word response w/ reference? 1.    Describe the roles and responsibilities of the APRN when prescribing medication APRNs conduct comprehensive assessments, including medical history, physical exams, and diagnostic tests, to establish a diagnosis and determine the appropriate medication therapy.APRNs have prescriptive authority, allowing them

can you assist with a 150 word response w/ one reference? Describe the roles and responsibilities of the APRN when prescribing medication. Advanced

can you assist with a 150 word response w/ one reference? Describe the roles and responsibilities of the APRN when prescribing medication. Advanced Practice Registered Nurses (APRNs) play a vital role in medication management within healthcare settings. They are accountable for conducting comprehensive patient assessments, diagnosing health conditions, and formulating

Can you assist with a 150 word response and 1 reference? Effective nursing practice necessitates the adept application of knowledge, skills, and artistry

Can you assist with a 150 word response and 1 reference? Effective nursing practice necessitates the adept application of knowledge, skills, and artistry to deliver patient care in a compassionate, efficient, and proficient manner. Practice, research, and theory form the principal foundations of nursing (Jain, 2021). Thus, a dynamic interrelationship

This discussion was created to provide students time to search and synthesize additional articles needed for the Leadership paper and begin identifying

This discussion was created to provide students time to search and synthesize additional articles needed for the Leadership paper and begin identifying possible solutions to address your issue. This discussion also provides an opportunity to receive peer/instructor feedback on your ideas for possible solutions. Retrieve three (3) additional/not previously used

Exam Content As a health care manager participating in the reinvention task force, you need to formulate your strategy after completing your organization’s

Exam Content As a health care manager participating in the reinvention task force, you need to formulate your strategy after completing your organization’s SWOT analysis. Setting strategic goals establishes how your organization will align plans with the performance expectations to gain competitive advantage in the health care industry. You will demonstrate skill

Patients’ Rights, Privacy, and Confidentiality [WLOs: 1, 2, 3] [CLOs: 3, 7] Prior to beginning work on this discussion, Read Chapters 13 and 16 in your

Patients’ Rights, Privacy, and Confidentiality [WLOs: 1, 2, 3] [CLOs: 3, 7] Prior to beginning work on this discussion, Read Chapters 13 and 16 in your textbook. Read the book Patient ConfidentialityLinks to an external site.. Review the webpage Patient RightsLinks to an external site.. Watch the video Clinical Record Keeping and Confidentiality

The clinical self-evaluation allow students to reflect upon their own nursing practice utilizing the nursing program’s core competencies to identify

The clinical self-evaluation allow students to reflect upon their own nursing practice utilizing the nursing program’s core competencies to identify strengths and opportunities for improvement.  Complete both ‘beginning of rotation’ columns at the beginning of the course. Copy and paste this document in the journal area by the assigned due date.