Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Instructions Read Case: When Jennifer Turned Grouchy. Develop a tentative approach to the problem presented by the grouchy receptionist. Be sure to provide a reasonable opportunity for correction of

Instructions Read Case: When Jennifer Turned Grouchy.  Develop a tentative approach to the problem presented by the grouchy receptionist. Be sure to provide a reasonable opportunity for correction of behavior. Possible ways to help the employee with the problem The necessary progressive nature of any disciplinary action contemplated The needs

Read Case: “Addressing the Squeaky Wheel.” Answer questions 1-3. Case: Addressing the Squeaky Wheel You are the supervisor of 20 people in a department of one of Central Hospital’s service department

Read Case:  “Addressing the Squeaky Wheel.” Answer questions 1-3. Case: Addressing the Squeaky Wheel You are the supervisor of 20 people in a department of one of Central Hospital’s service departments. Three of your employees are titled as working group leaders, but they are usually involved in doing the work

Discuss the safety and effectiveness of alternative and complementary medicine for the treatment of specific illnesses such as cancer, diabetes, and hypertension. Share your opinions about holistic an

Discuss the safety and effectiveness of alternative and complementary medicine for the treatment of specific illnesses such as cancer, diabetes, and hypertension. Share your opinions about holistic and allopathic care. Would have any conflicts or concerns supporting a patient who chooses? 500 words.  Support your answers with the literature and

For this assignment, you will create a written plan and a PowerPoint presentation. Based on the attached assignment you completed, you will now take the system that you selected for evaluation and cre

For this assignment, you will create a written plan and a PowerPoint presentation. Based on the attached assignment you completed, you will now take the system that you selected for evaluation and create an implementation and support plan. You are to serve as the product manager for the given system.

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ AACN Essentials This is a PowerPoint presentation designed to test a student’s overall knowledge of the AACN Essentials. Conside

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */  AACN Essentials This is a PowerPoint presentation designed to test a student’s overall knowledge of the AACN Essentials. Consider how you have developed the knowledge, skills, abilities, and attitudes that enable your achievement of the RN-BSN Program Learning

The field of pharmacology has witnessed significant advancements in the treatment of endocrine disorders. Among the newer medications, Mounjaro and Ozempic have gained attention due to their efficacy

The field of pharmacology has witnessed significant advancements in the treatment of endocrine disorders. Among the newer medications, Mounjaro and Ozempic have gained attention due to their efficacy in managing conditions such as type 2 diabetes and obesity. Discuss about similarities, differences, and clinical implications of these two new drugs. 

For this assessment, you will analyze the same current healthcare problem or issue topic area you selected for Assessments 2 and 3. To explore the chosen topic, use the first four topics of the Socrat

For this assessment, you will analyze the same current healthcare problem or issue topic area you selected for Assessments 2 and 3. To explore the chosen topic, use the first four topics of the Socratic Problem-Solving Approach for critical thinking. Start by defining the healthcare problem or issue based on the selected

In your healthcare career, you will be confronted with many problems that demand a solution. By using research skills, you can learn what others are doing and saying about similar problems. Then, you

In your healthcare career, you will be confronted with many problems that demand a solution. By using research skills, you can learn what others are doing and saying about similar problems. Then, you can analyze the problem and the people and systems it affects. You can also examine potential solutions

Step 1: Reflect on your current health assessment skills and understanding of the importance of health assessment in client care. Step 2: Answer all questions below with explanations and detail. No sc

Step 1: Reflect on your current health assessment skills and understanding of the importance of health assessment in client care. Step 2: Answer all questions below with explanations and detail. No scholarly sources are required. Paragraph one: Briefly describe the type(s) of health assessments you typically perform now or have performed in the past.

Instructions Before completing this assignment, be sure you read what an AUDIT TRAIL is in your textbook. Since the HIPAA privacy rules was implemented, you have been drowning in your audit trails rev

Instructions Before completing this assignment, be sure you read what an AUDIT TRAIL is in your textbook. Since the HIPAA privacy rules was implemented, you have been drowning in your audit trails reviews. You have finally obtained permission from administration to develop and use triggers to help with the review.

reate a written assessment, including an annotated bibliography section, to document your research on a healthcare problem or an issue faced by current healthcare organizations.You will select a curre

reate a written assessment, including an annotated bibliography section, to document your research on a healthcare problem or an issue faced by current healthcare organizations.You will select a current healthcare problem or issue from the provided options for this assessment. Research your topic, and develop a written assessment, which includes

As a nurse you must base your decisions on a set of ethical principles and values. Your decisions must be fair, equitable, and defensible. Nursing has a professional Code of Ethics for Nurses to guide

As a nurse you must base your decisions on a set of ethical principles and values. Your decisions must be fair, equitable, and defensible. Nursing has a professional Code of Ethics for Nurses to guide ethical behavior. In this assessment, you wFor this assessment, you will apply the four ethical principles to

This assessment is an opportunity for you to analyze and have a better understanding of diversity, equity, and inclusion (DEI), and the importance of recognizing unconscious bias and microaggressions

This assessment is an opportunity for you to analyze and have a better understanding of diversity, equity, and inclusion (DEI), and the importance of recognizing unconscious bias and microaggressions in the field of healthcare. Your insights and reflections are valued, so feel free to draw from your own experiences to

Week 1 Discussion: Begin Your Yellowdig Discussion This course uses a tool called Yellowdig to facilitate discussions. If you have not yet read the Using Yellowdig study in this week’s activities, rea

Week 1 Discussion: Begin Your Yellowdig Discussion This course uses a tool called Yellowdig to facilitate discussions. If you have not yet read the Using Yellowdig study in this week’s activities, read that now to learn what Yellowdig is and how to use it. For this discussion, share your thoughts

Introduce Yourself One of the most important aspects of an online course is the interaction between you and your fellow learners. Write and post your self-introduction here, including mention of your

Introduce Yourself One of the most important aspects of an online course is the interaction between you and your fellow learners. Write and post your self-introduction here, including mention of your educational and employment background related to the topics of this course. Also include a response to one of the