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

Complete Chapter 28 – Exercise: Your Career Development Plan. APA format. Exercise: Your Career Development Plan This is an especially personal exercise in that it asks you to plot out a likely care

Complete Chapter 28 – Exercise:  Your Career Development Plan.  APA format. Exercise: Your Career Development Plan This is an especially personal exercise in that it asks you to plot out a likely career path for the remainder of your working years, subject to the following guidelines: Begin with your present

On pages 103 – 106, the statistical tool known as the “paired t-test” is described. The example (Example 5.14 on page 104) analyzes Coder Productivity. Please describe one other example within a typ

On pages 103 – 106, the statistical tool known as the “paired t-test” is described.  The example (Example 5.14 on page 104) analyzes Coder Productivity.  Please describe one other example within a typical HIM office where the use of the “paired t-test” might be an appropriate tool for data analysis.

CHAPTER 3 Checklist Items Pg/NA Comment History Introduction Restate the study purpose as described in chapter 1. Preview major sections of the chapter. Research Design and Rationale Concisely sta

CHAPTER 3 Checklist Items Pg/NA Comment History Introduction Restate the study purpose as described in chapter 1. Preview major sections of the chapter. Research Design and Rationale Concisely state the study variables (independent, dependent, covariate, mediating, and/or moderating variables, as appropriate.    Identify the research design and its connection to

For Analysis #2, you will write an APA-formatted paper using your selected study, Option A: Effect of canine play intervention as a stress reduction strategy in college students by Cheryl Delgado, Mar

For Analysis #2, you will write an APA-formatted paper using your selected study, Option A: Effect of canine play intervention as a stress reduction strategy in college students by Cheryl Delgado, Margaret Toukonen, and Corinne Wheeler (2018), published in Nurse Educator, and you will answer Questions 7–13 in paragraph form

For Analysis #2, you will write an APA-formatted paper using your selected study, Option A: Effect of canine play intervention as a stress reduction strategy in college students by Cheryl Delgado, Mar

For Analysis #2, you will write an APA-formatted paper using your selected study, Option A: Effect of canine play intervention as a stress reduction strategy in college students by Cheryl Delgado, Margaret Toukonen, and Corinne Wheeler (2018), published in Nurse Educator, and you will answer Questions 7–13 in paragraph form

I chose this article for my research.Review the Analysis Criteria Template and complete Assignment #2. Be sure to answer the questions for analysis 2. Option A: Effect of canine play intervention

I chose this article for my research.Review the Analysis Criteria Template and complete Assignment #2. Be sure to answer the questions for analysis 2.  Option A:  Effect of canine play intervention as a stress reduction strategy in college students Links to an external site.by Cheryl Delgado, Margaret Toukonen, and Corinne Wheeler. This

I need help with two research article analysis papers for my class. Both papers require me to analyze the same research study and answer different sets of questions about it using APA 7th edition for

I need help with two research article analysis papers for my class. Both papers require me to analyze the same research study and answer different sets of questions about it using APA  7th edition format. The first analysis focuses on the introduction, problem statement, hypotheses, variables, literature review, and study

I need help with two research article analysis papers for my class. Both papers require me to analyze the same research study and answer different sets of questions about it using APA format. The firs

I need help with two research article analysis papers for my class. Both papers require me to analyze the same research study and answer different sets of questions about it using APA format. The first analysis focuses on the introduction, problem statement, hypotheses, variables, literature review, and study design, while

On Page 27 of the CMS Quality Strategy Document “Engage Individuals and Communities to become partners in their care” is stated to be an overall objective of this quality initiative. The author(s) of

On Page 27 of the CMS Quality Strategy Document “Engage Individuals and Communities to become partners in their care” is stated to be an overall objective of this quality initiative.  The author(s) of this article then provide four specific outcomes which demonstrate this.  How might the HIM Profession contribute to

On Page 27 of the CMS Quality Strategy Document “Engage Individuals and Communities to become partners in their care” is stated to be an overall objective of this quality initiative. The author(s) of

On Page 27 of the CMS Quality Strategy Document “Engage Individuals and Communities to become partners in their care” is stated to be an overall objective of this quality initiative.  The author(s) of this article then provide four specific outcomes which demonstrate this.  How might the HIM Profession contribute to

Question : Write a Case study on Lynch Syndrome and Ethical Implications in Nursing Practice Content: CaseStudy is summarized with constructs well defined. Evident that student synthesized learning.

Question : Write a Case study on  Lynch Syndrome and Ethical Implications in Nursing Practice Content: CaseStudy is summarized with constructs well defined. Evident that student synthesized learning. Includes introduction, summary and implications for practice.                              

Follow instructions below for case analysis and rubric is links below: Use the same case that you began to analyze in part 1 with assessment of: medical indicationspatient preferencesSegment 2 will co

Follow instructions below for case analysis and rubric is links below: Use the same case that you began to analyze in part 1 with assessment of: medical indications patient preferences Segment 2 will continue your assessment with inclusion of:  3. quality-of-life considerations   4. contextual features Segment 2 will also include an organized problem-solving section that:  defines