descriptive statistics

Discussion Questions

By 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.

No 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.

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.

 Age

 Cringe

 Uneasy

 Afraid

 Worried

 Understand

 28