Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

From as Little as $6

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

South University Statistical Software Applications Discussion

South University Statistical Software Applications Discussion

Question Description

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 thestatistical software applications used to analyze data for researchanalysis. For this week’s discussion, you will use Excel sheet provideto run descriptive statistics, create graphs and respond to thefollowing:

  • How could you use Excel descriptive statistics for data analysis research?
  • What are your plans for learning more about Excel and how will theinformation you learned about this software be of benefit in your futureanalysis 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 thedata from their study in another software package like Microsoft Excel.However, if the data is not available in a software spreadsheet you canmanually 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 remainingdata as shown below (set up your column labels i.e., variable). Themeasure reflects math anxiety and the study variables (cringe, uneasy,afraid, worried, understand) the math anxiety range is from 1–5 with lowbeing the least and 5 the highest.

Age

Cringe

Uneasy

Afraid

Worried

Understand

28

5

3

4

4

3

34

2

5

3

2

1

25

4

4

4

2

5

56

3

4

3

1

2

23

5

4

3

3

4

29

1

5

3

2

3

30

3

3

5

2

5

59

2

5

5

1

2

45

4

2

5

3

3

38

1

2

4

1

1

33

3

2

4

3

2

47

4

2

3

4

5

24

1

5

3

4

4

29

5

4

2

1

3

53

3

1

5

2

1

48

4

4

1

5

3

27

2

5

4

3

4

34

4

4

3

2

5

26

4

5

2

3

2

36

5

5

5

4

3

Step 2: Click on Excel tab for AddIns; if you do not see statistics; you will need to open the fileoption; click on Add ins; click on ok; a box will open which will allowyou to choose Statistics package; place a check mark in the box andclick ok. How to Run Descriptive Statistics

Now that your data is in Excel, you willlook at the descriptive statistics for this dataset. Select the data inall the columns except the top that has words for the columns; howeveryou have the file already completed and a picture of the descriptivestatistics..See end of page for a copy of the excel sheet anddescriptive statistics output.

Discussion Question Part 1

How could you use Excel descriptivestatistics for data analysis research? Write about your experiencerunning descriptive statistics. Use the results in the Session Window tosupport your response. Then add to your discussion with the informationyou learn writing up your analysis.

Step 3: Excel and Graphs

You will now look at graphing. Selectinsert graph located at the top of the sheet; highlight the data youwant to use for a chart; select the type of chart; select ok. Try usingthe histogram feature for one of the variables and select “Ok”. You cancreate other Histogram graphs by choosing different variables. You canalso choose from the other ten graph choices shown on the insert chartfunction.

Discussion Question Part 2

What are your plans for learning more aboutExcel and how will the information you learned about this software beof benefit in your future analysis of research data? Copy and paste yourgraph(s) in a Word document and attach to your discussion response.