Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, im very confused with my professor's instructions on our discussion. I'm not good in excel. This week, you learned about the statistical software applications

Hi, im very confused with my professor's instructions on our discussion. I'm not good in excel.

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,

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

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Analysis

Authors: Stephen Abbott

1st Edition

6610189684, 9786610189687

More Books

Students also viewed these Mathematics questions

Question

32. f(t) = the-2t66. f (x) = In c 32. f(t) = t2e-2t

Answered: 1 week ago

Question

1. Effort is important.

Answered: 1 week ago