\u00a0
\nDiscussion Questions
\nBy the due date assigned, post your response to the assigned discussion questions in the below Discussion Area. It is important to support what you say with relevant citations in the APA format from both the course materials and outside resources. Include the South University Online Library in your research activities utilizing not only the nursing resource database, but also those pertaining to education, business, and human resources.
\nNo later than by the end of the week, review and comment on the discussion question responses posted by at least two of your peers. Be objective, clear, and concise. Always use constructive language. All comments should be posted to the appropriate topic in this Discussion Area.
\nDiscussion Question
\nUsing the Excel Sheet and descriptive statistics page; you will write up your analysis for the 20 participants.
\nThis 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:
\nHow could you use Excel descriptive statistics for data analysis research?
\nWhat 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?
\nRefer to this week\u2019s readings and video tutorials before starting this two part discussion question assignment.\u00a0
\nStep 1: Entering Data
\nOpen a blank worksheet in the Excel program
\nYou will now use Excel to view a sample dataset
\nDataset Options
\nIn 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
\nIn the Worksheet window, type \u201cAge\u201d 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\u20135 with low being the least and 5 the highest.
\n\u00a0Age
\n\u00a0Cringe
\n\u00a0Uneasy
\n\u00a0Afraid
\n\u00a0Worried
\n\u00a0Understand
\n\u00a028
\n\u00a05
\n\u00a03
\n\u00a04
\n\u00a04
\n\u00a03
\n\u00a034
\n\u00a02
\n\u00a05
\n\u00a03
\n\u00a02
\n\u00a01
\n\u00a025
\n\u00a04
\n\u00a04
\n\u00a04
\n\u00a02
\n\u00a05
\n\u00a056
\n\u00a03
\n\u00a04
\n\u00a03
\n\u00a01
\n\u00a02
\n\u00a023
\n\u00a05
\n\u00a04
\n\u00a03
\n\u00a03
\n\u00a04
\n\u00a029
\n\u00a01
\n\u00a05
\n\u00a03
\n\u00a0 2
\n\u00a03
\n\u00a030
\n\u00a03
\n\u00a03
\n\u00a05
\n\u00a02
\n\u00a05
\n\u00a059
\n\u00a02
\n\u00a05
\n\u00a05
\n\u00a01
\n\u00a02
\n\u00a045
\n\u00a04
\n\u00a02
\n\u00a05
\n\u00a03
\n\u00a03
\n\u00a038
\n\u00a01
\n\u00a02
\n\u00a04
\n\u00a01
\n\u00a01
\n\u00a033
\n\u00a03
\n\u00a02
\n\u00a04
\n\u00a03
\n\u00a02
\n\u00a047
\n\u00a04
\n\u00a02
\n\u00a03
\n\u00a04
\n\u00a05
\n\u00a024
\n\u00a01
\n\u00a05
\n3
\n\u00a04
\n\u00a04
\n\u00a029
\n\u00a05
\n\u00a04
\n\u00a02
\n\u00a01
\n\u00a03
\n\u00a053
\n\u00a03
\n\u00a01
\n\u00a05
\n\u00a02
\n\u00a01
\n\u00a048
\n\u00a04
\n\u00a04
\n\u00a01
\n\u00a05
\n\u00a03
\n\u00a027
\n\u00a02
\n\u00a05
\n\u00a04
\n\u00a03
\n\u00a04
\n\u00a034
\n\u00a04
\n\u00a04
\n\u00a03
\n\u00a02
\n\u00a05
\n\u00a026
\n\u00a04
\n\u00a05
\n\u00a02
\n\u00a03
\n\u00a02
\n\u00a036
\n\u00a05
\n\u00a05
\n\u00a05
\n\u00a04
\n\u00a03
\nStep 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
\nNow 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.
\nDiscussion Question Part 1
\nHow 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.
\nStep 3: Excel and Graphs
\nYou 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 \u00a0feature 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.
\nDiscussion Question Part 2
\nWhat 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.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0 Discussion Questions By the due date assigned, post your response to the assigned discussion questions in the below Discussion Area. It is important to…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-21893","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts\/21893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/comments?post=21893"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts\/21893\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/media?parent=21893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/categories?post=21893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/tags?post=21893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}