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

STOP WASTING YOUR TIME ON STUDYDADDY — HERE’S WHERE WRITERS ACTUALLY GET PAID If you’re still writing for StudyDaddy.com, ask yourself why you’re putting in real hours for a platform that has shown w

STOP WASTING YOUR TIME ON STUDYDADDY — HERE’S WHERE WRITERS ACTUALLY GET PAID If you’re still writing for StudyDaddy.com, ask yourself why you’re putting in real hours for a platform that has shown writers exactly what it will do the moment their balance is worth something: block the account, keep

Discussion 2 – Topic from Chapters 1-3Instructions: Choose one topic from the suggested list below, corresponding to the chapters provided. Create an initial post of at least 250 words explaining your

Discussion 2 – Topic from Chapters 1-3Instructions: Choose one topic from the suggested list below, corresponding to the chapters provided. Create an initial post of at least 250 words explaining your selected topic. Use examples where applicable and demonstrate your understanding of the key terms, concepts, and their relevance to

Taxonomies, Clinical Vocabularies, and Medical Terminologies – Part Two Classification and terminology professionals ensure that the coding rules, conventions, and guidelines are applied correctly and

Taxonomies, Clinical Vocabularies, and Medical Terminologies – Part Two Classification and terminology professionals ensure that the coding rules, conventions, and guidelines are applied correctly and consistently. They ensure that medical records are suitable for communication among a variety of users, including care providers, clinical researchers, and business operations managers. The

Taxonomies, Clinical Vocabularies, and Medical Terminologies – Part Two Classification and terminology professionals ensure that the coding rules, conventions, and guidelines are applied correctly and

Taxonomies, Clinical Vocabularies, and Medical Terminologies – Part Two Classification and terminology professionals ensure that the coding rules, conventions, and guidelines are applied correctly and consistently. They ensure that medical records are suitable for communication among a variety of users, including care providers, clinical researchers, and business operations managers. The

Medical Terminology For Health care Professions Instructions: Choose one topic from the suggested list below, corresponding to the chapters provided. Create an initial post of at least 250 words exp

Medical Terminology For Health care Professions Instructions: Choose one topic from the suggested list below, corresponding to the chapters provided. Create an initial post of at least 250 words explaining your selected topic. Use examples where applicable and demonstrate your understanding of the key terms, concepts, and their relevance to

For this assignment, I want you to explore the communication about an organization, and the impact it has on the facility. I want you to pick a local hospital or hospital system, and search for their

 For this assignment, I want you to explore the communication about an organization, and the impact it has on the facility. I want you to pick a local hospital or hospital system, and search for their publicly reported metrics and communication about the organization (HCAHPS, Leapfrog, Hospital Compare, etc.). Discuss what you

For this assignment, I want you to explore the communication about an organization, and the impact it has on the facility. I want you to pick a local hospital or hospital system, and search for their

 For this assignment, I want you to explore the communication about an organization, and the impact it has on the facility. I want you to pick a local hospital or hospital system, and search for their publicly reported metrics and communication about the organization (HCAHPS, Leapfrog, Hospital Compare, etc.). Discuss what you

Important Notice for StudyDaddy Users It’s time to move to a platform that actually works for you. If you’re currently using StudyDaddy, this is your sign to switch. StudyAce.net is a modern, professi

Important Notice for StudyDaddy Users It’s time to move to a platform that actually works for you. If you’re currently using StudyDaddy, this is your sign to switch. StudyAce.net is a modern, professional academic platform built with one priority above all else — you. Your privacy is non-negotiable at StudyAce.net.

write a brief paper 450 word in which you reflect on at least two (2) of the different communities of which you are a part and how they affect your health and well-being (physical and/or mental), posi

write a brief paper 450 word in which you reflect on at least two (2) of the different communities of which you are a part and how they affect your health and well-being (physical and/or mental), positively and negatively. For example, your communities might include your ethnic community, occupational community,

write a brief paper (450 words) in which you reflect on at least two (2) of the different communities of which you are a part and how they affect your health and well-being (physical and/or mental), p

write a brief paper (450 words) in which you reflect on at least two (2) of the different communities of which you are a part and how they affect your health and well-being (physical and/or mental), positively and negatively. For example, your communities might include your ethnic community, occupational community, neighborhood community, etc. Perhaps you

Instructions: Signature Assignment : Cerebral Vascular Accident /Stroke . Once the population is chosen, find one evidence-based technology to help support the improvement of outcomes in the global b

Instructions: Signature Assignment :  Cerebral Vascular Accident /Stroke . Once the population is chosen, find one evidence-based technology to help support the improvement of outcomes in the global burden of disease chosen. You are to write a three-to-five-page paper in APA format 7th edition with the following sections and level