Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Health & Medical

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

Based on your prior research of healthcare objectives, complete the following: Select 1 of the following and identify 1 healthcare objective.Meaningful use regulationsMerit-Based Incentive Payment Sys

Based on your prior research of healthcare objectives, complete the following: Select 1 of the following and identify 1 healthcare objective. Meaningful use regulations Merit-Based Incentive Payment System (MIPS) Medicare Access and CHIP Reauthorization Act (MACRA) Physician Quality Reporting System (PQRS) Value-Based Payment Modifier (VBM). Then identify 1 type of information

Instructions In a few brief sentences, write a convincing argument you might use in trying to get a reluctant employee to agree to completing and submitting a self-evaluation (we are assuming that a s

Instructions In a few brief sentences, write a convincing argument you might use in trying to get a reluctant employee to agree to completing and submitting a self-evaluation (we are assuming that a self-evaluation is optional in your evaluation system.) APA but no references needed for this assignment! Just your own

Instructions Read Case: Surprise! Found in Chapter 15. Answer questions 1 – 3. Please be sure that each response is 5-10 sentences Case: Surprise! When the business office employees arrived at the

Instructions Read Case: Surprise! Found in Chapter 15. Answer questions 1 – 3. Please be sure that each response is 5-10 sentences Case: Surprise! When the business office employees arrived at the hospital Monday morning, they immediately noticed the apparent absence of the office manager. This was not unusual; the manager was

Read Case: Never to Blame in Chapter 14. In a 2-page paper, answer the 2 questions for the case. APA format. Case: Never to Blame You are the administrative director of clinical laboratories at Com

Read Case: Never to Blame in Chapter 14. In a 2-page paper, answer the 2 questions for the case. APA format. Case: Never to Blame You are the administrative director of clinical laboratories at Community Hospital. One of your section supervisors has come to you with a complaint about a

Breaches have become more and more common in healthcare. Review the HHS website: https://www.hhs.gov/hipaa/newsroom/index.html and report about a recent breach. You will need to summarize IN YOUR OWN

Breaches have become more and more common in healthcare. Review the HHS website: report about a recent breach. You will need to summarize IN YOUR OWN WORDS the incident and provide the link to the incident your are discussing

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. The Health Information Data Exc

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. The Health Information Data Exchange is an emerging topic within healthcare systems. Discuss the following: Explain what use the health information data exchange could

See attachment…Introduction to Current Procedural Terminology

Dialysis care has become a popular healthcare service over the last few decades. Your employer has decided to get into the market and open a dialysis clinic. Your background in CPT coding and knowledg

Dialysis care has become a popular healthcare service over the last few decades. Your employer has decided to get into the market and open a dialysis clinic. Your background in CPT coding and knowledge of medical terminology has landed you the task of training the new staff on dialysis and the

For this essay, you will examine a scenario and apply sound ethical decision-making to determine the proper course of action. Scenario: Cindy Lou Kodingwho is a new coder at Southern Columbia Su

For this essay, you will examine a scenario and apply sound ethical decision-making to determine the proper course of action. Scenario: Cindy Lou Kodingwho is a new coder at Southern Columbia Surgical Center. She works under the Office Manager, Martha May, but also closely works with the physicians directly when

See attachment This class is Introduction to ICD-10-PCS: Googling did help with all the questions bc it gives the wrong answer for questions about

Imagine that you are a health information management (HIM) supervisor analyzing a computer-assisted coding system to find out if it will work well for your facility. The following is an operative note

Imagine that you are a health information management (HIM) supervisor analyzing a computer-assisted coding system to find out if it will work well for your facility. The following is an operative note with the ICD-10-PCS codes assigned by the computer-assisted coding (CAC) system that is being reviewed. Analyze the operative

Assignment objective: Imagine you are a new medical coder, and you are learning the process for looking up extracorporeal cases in ICD-10-PCS. Analyze and review an extracorporeal assistance case and

Assignment objective: Imagine you are a new medical coder, and you are learning the process for looking up extracorporeal cases in ICD-10-PCS. Analyze and review an extracorporeal assistance case and an extracorporeal performance case, and discuss proper ICD-10-PCS code assignment for these sections. Length: Your submission should be a minimum

Nursing Leadership and Management Assignment Topic: Qualities of a Nurse Leader Essay Write a 1500-1750 word essay addressing each of the following points/questions. Be sure to completely answer all t

Nursing Leadership and Management Assignment Topic: Qualities of a Nurse Leader Essay Write a 1500-1750 word essay addressing each of the following points/questions. Be sure to completely answer all the questions for

Health Assessment Assignment Topic: Emergency Plan for the Older Adult (OA) Based on what you have learned so far in this course, create a PowerPoint presentation that addresses each of the following

Health Assessment Assignment Topic: Emergency Plan for the Older Adult (OA) Based on what you have learned so far in this course, create a

1- Compare the four levels of prevention (primordial, primary, secondary, and tertiary) with the levels of service provision available across the life span. (CLO #2) 2- Compare the purposes, benefits,

1- Compare the four levels of prevention (primordial, primary, secondary, and tertiary) with the levels of service provision available across the life span. (CLO #2) 2- Compare the purposes, benefits, and limitations of Medicare, Medicaid, and other government sponsored programs in achieving health equity. (CLO #2) 3- Discuss selected cultural

Submit a 2-3 page double-spaced Essay: Examining the Micromanager as found in the chapter. Make sure to include APA cited references and in-text citations for any information that you use from other

Submit a 2-3 page double-spaced Essay: Examining the Micromanager as found in the chapter. Make sure to include APA cited references and in-text citations for any information that you use from other sources. Essay: Examining the Micromanager Surely most, if not all, readers ofthis text are familiar with the term

Hide Assignment InformationInstructions Read Case: The Employee in the Corner. Describe in detail what you would do in this situation. For each decision or action you mention, explain why you are taki

Hide Assignment InformationInstructions Read Case: The Employee in the Corner. Describe in detail what you would do in this situation. For each decision or action you mention, explain why you are taking this particular step. (It is acceptable for you to make a few reasonable assumptions about you and your circumstances, as

Now that you have suggested an agile systems development life cycle (SDLC) and explored the requirements of the Health Insurance Portability and Accountability Act (HIPAA), you need to ensure that you

Now that you have suggested an agile systems development life cycle (SDLC) and explored the requirements of the Health Insurance Portability and Accountability Act (HIPAA), you need to ensure that your processes support the security of patient data. Complete the following: Conduct research to identify a healthcare data security plan