Question: Download the attached data, which provides scores for public speaking anxiety and intrinsic motivation among college students.. Complete each question using the attached dataset. analyses

Download the attached data, which provides scores for public speaking anxiety and intrinsic motivation among college students.. Complete each question using the attached dataset. analyses in Excel

1. This question has 4 parts. (2 points each)

A. Report the correlation coefficient between students' intrinsic motivation and their age (type the answer).

B. Paste a screenshot of your relevant output from Excel or SPSS.

C. Graphically depict the relationship between the data.

D. How do you interpret this data?

2. This question has 6 parts. (2 points each)

A. Produce the descriptive statistics for the public speaking anxiety score (type the answer).

B. Paste a screenshot or your relevant output from Excel or SPSS.

C. What is the confidence interval around the mean?

D. How do you interpret the confidence interval?

E. What is the Z value that corresponds to the sampling distribution of the mean for this public speaking anxiety in this sample, assuming =4.8 and =.6?

F. Interpret the z-score (e.g., indicate what percent all possible samples of this size have a sample mean below the sample score for this data).

Intrinsic Motivation

Public Speaking Anxiety

Age

Year

Sex

4.75

7

19

Sophomore

Female

1

2

19

Sophomore

Female

4.75

1

20

Sophomore

Male

3.75

1

19

First Year

Male

2

1.8

19

Sophomore

Male

3.25

1.8

18

Sophomore

Female

3

3.8

24

Senior

Female

7

2.8

18

First Year

Male

7

3.4

19

Sophomore

Male

6.75

4.2

19

Sophomore

Female

3

1.6

18

First Year

Female

5.5

1.2

19

Sophomore

Prefer not to answer

4.25

1.4

20

Sophomore

Male

2

1.6

20

Sophomore

Male

4

2.2

18

First Year

Male

3.25

1.8

19

Sophomore

Male

3.75

2.2

19

Sophomore

Male

4

2.4

19

Sophomore

Male

4

2.8

19

Sophomore

Female

3.75

2

19

Sophomore

Male

5.5

2

19

Sophomore

Female

7

1.6

19

First Year

Male

6.5

1.8

19

First Year

Male

1

2.6

20

Sophomore

Male

3.5

3

19

Sophomore

Female

5

3.2

19

Sophomore

Male

4.75

2.2

19

Sophomore

Male

4.5

2.2

19

Sophomore

Male

6

2.2

18

Sophomore

Male

5

3.8

19

Sophomore

Male

5.5

2.2

19

Sophomore

Male

5.25

3

20

Junior

Female

4.75

3.4

19

Sophomore

Female

5.75

2.4

19

Sophomore

Female

6.5

3.4

19

First Year

Male

5

4.2

21

Junior

Male

5

4.4

19

First Year

Male

5.25

4.4

19

First Year

Male

5.5

4

21

Senior

Female

4.75

4.4

19

First Year

Female

6.25

3.4

20

Junior

Male

4.75

3.4

19

Sophomore

Male

4

3.4

18

First Year

Male

3.75

1.8

19

First Year

Male

2.5

3

19

First Year

Male

1.5

2

20

Sophomore

Male

4

3.6

19

Sophomore

Male

3.5

2.8

20

Junior

Female

4.75

2.8

19

First Year

Male

5.75

3.4

22

Senior

Male

5.75

2.8

20

Sophomore

Female

4.5

3.4

18

First Year

Female

3.5

3

19

Sophomore

Female

4.75

2

22

Senior

Male

5.75

2.4

19

Sophomore

Male

6

2.8

18

First Year

Male

5.75

3.2

20

Sophomore

Male

5.25

3

19

First Year

Male

6

1.8

30

Senior

Female

3.5

3.4

19

Sophomore

Male

3.5

4

19

First Year

Male

3.5

4.4

18

First Year

Female

4

2.6

19

First Year

Male

5.25

3.4

24

Sophomore

Female

5

3.2

19

Sophomore

Male

4.75

3

19

Sophomore

Male

5.25

4.2

20

Sophomore

Female

5

3.6

19

Sophomore

Male

4.25

3

19

First Year

Female

5.75

4

19

Sophomore

Male

4

4.2

19

Sophomore

Female

4.75

3.6

20

Sophomore

Female

4.25

3.8

19

Sophomore

Male

4.75

2.6

21

Senior

Male

4.25

4.2

19

Sophomore

Male

4.75

3.4

19

First Year

Female

6

3.4

19

First Year

Male

1

3.2

21

Senior

Female

3.25

4

19

First Year

Female

5.25

4

18

First Year

Male

4

3.8

19

Sophomore

Female

4

3.6

19

First Year

Male

3.25

3.6

19

Sophomore

Male

5.5

3.6

19

First Year

Male

5.25

3.2

19

Sophomore

Male

3.75

3.6

19

Sophomore

Female

3.25

3

20

Junior

Female

4.5

3.4

20

Junior

Male

4.5

3.2

28

Junior

Male

5

3.4

18

First Year

Female

6

4.2

19

First Year

Male

5

3.8

19

First Year

Female

5.75

4.8

19

Sophomore

Female

6.25

4

19

Sophomore

Male

7

3.8

19

First Year

Female

6

2.8

34

Sophomore

Male

7

2.6

32

Sophomore

Female

3.75

3.8

19

Sophomore

Male

4

4.4

19

First Year

Female

4.25

3.6

23

Junior

Male

5.5

3.8

18

First Year

Female

6

4

21

Sophomore

Female

7

2.8

18

First Year

Male

7

4.2

20

Sophomore

Male

4.75

2.6

19

First Year

Male

4.75

3.2

18

First Year

Male

4

3.8

19

First Year

Male

4.5

4

19

Sophomore

Male

5.25

4

19

Sophomore

Male

4.25

3.6

19

Sophomore

Female

4.25

3.6

21

Junior

Male

4.75

3.8

20

Sophomore

Female

4.5

4.6

19

Sophomore

Female

5.25

3.4

20

Junior

Male

5

2.6

20

Sophomore

Female

5.5

3.6

18

First Year

Male

1

4

20

Junior

Female

4.5

3.6

18

First Year

Male

4

4

19

Sophomore

Female

4

4

19

First Year

Female Idenitfying as Male

4

4

20

Sophomore

Male

4

4

19

First Year

Male

4

4

18

First Year

Male

4.25

3.8

19

Sophomore

Male

4

4

19

First Year

Male

4

4

19

First Year

Female

4

4

20

Sophomore

Female

4

3.6

19

Sophomore

Female

5.25

3.8

19

Sophomore

Female

3.75

4

18

First Year

Male

4.75

4.2

20

Junior

Female

5.25

3.2

19

Sophomore

Male

5.5

4.4

20

Junior

Female

4.25

3.8

18

First Year

Male

5.25

3.6

19

Sophomore

Female

5.5

2.6

21

Junior

Male

4.75

4

19

Sophomore

Male

1.75

3.4

19

Junior

Male

2.25

3.2

19

Sophomore

Female

4

4

19

Sophomore

Male

3.75

4.4

18

First Year

Female

3.5

4

19

Sophomore

Male

3.5

4.4

20

Sophomore

Male

4

4.2

21

Senior

Male identifying as female

4

5

19

First Year

Male

4

4

19

Sophomore

Female

4.5

4.4

19

First Year

Male

5.25

4.8

18

First Year

Female

4.5

3.8

20

Sophomore

Male

4.5

5

19

Sophomore

Male

5.25

3.8

31

Sophomore

Male

5.75

4.4

20

Junior

Male

5.75

3.6

19

First Year

Female

4.25

5.2

20

Junior

Male

4

4.6

19

Sophomore

Female

5

5

21

Junior

Male

4.75

4.2

19

Sophomore

Female

5.5

4.8

20

Sophomore

Female

6.25

3.8

18

First Year

Female

5.5

4

19

Sophomore

Female

6.25

4.6

18

First Year

Female

6.75

4.8

18

First Year

Male

4

2.8

22

Senior

Female

3.5

3.6

20

Sophomore

Male

4

4.6

20

Sophomore

Male

4

3.2

19

Sophomore

Female

4.5

3.2

19

First Year

Male

4.25

3.4

19

First Year

Female

4.75

4

19

Sophomore

Male

5

3.8

18

First Year

Female

2.75

3.8

21

Senior

Female

3.75

4.4

19

First Year

Female

4

3.6

20

Junior

Female

4

4.2

19

Sophomore

Male

4.5

3.8

18

First Year

Male

5

3.4

18

First Year

Male

4

3.8

19

Sophomore

Female

5

4.4

33

Junior

Female

4.5

4.2

20

Junior

Male

3.75

3.4

18

First Year

Male

3.75

4

20

Sophomore

Female Idenitfying as Male

3.75

5

20

Junior

Male

4

3.6

19

Sophomore

Female

4.5

3.8

18

First Year

Male

4.75

4.8

18

First Year

Male

5.25

3.6

20

Sophomore

Male

5

4.2

20

Sophomore

Female

6.5

3.4

19

Sophomore

Female

7

3.2

20

Junior

Female

3

3.8

18

First Year

Male

3.75

4.6

19

First Year

Male

3.5

4.2

19

First Year

Female

4

4.6

18

First Year

Male

4

3.4

19

Sophomore

Male

5.25

4.4

18

First Year

Female

4.5

4.2

18

First Year

Male

5

4.8

19

Sophomore

Female

4

4.6

20

First Year

Female

5.75

4.6

20

Sophomore

Female

6.25

4.4

21

Sophomore

Male

1.25

4.6

19

First Year

Male

2

4.4

22

Senior

Male

3.25

4.6

20

Sophomore

Male

2

4.6

19

First Year

Female

3.75

4.4

19

Sophomore

Female

2.25

4

19

First Year

Female

3

4.8

19

First Year

Female

2.75

4.6

21

Senior

Female

3

5.4

20

Sophomore

Female

3.75

4.8

18

Sophomore

Female

4.5

4.4

19

Sophomore

Male

3.5

5

21

Junior

Female

3.5

4

18

First Year

Male

4.25

4.2

18

First Year

Male

4

4.8

19

Sophomore

Male

4.5

4.6

19

Sophomore

Male

3.75

4.8

21

Junior

Female

4

4.4

20

Sophomore

Male

4

4

18

Sophomore

Female

3.75

4.4

20

Sophomore

Female

4

4.8

18

First Year

Female

4.5

4.8

21

Senior

Female

4.5

4.2

18

First Year

Male

3.25

4.6

19

Sophomore

Female

4.25

4.6

19

Sophomore

Male

4.25

4

18

First Year

Male

4

5.2

22

Senior

Male

4.25

4.4

22

First Year

Male

4.75

4.6

19

Sophomore

Female

4.5

4.8

19

Sophomore

Male

5.25

4.2

19

Sophomore

Female

5.25

4.8

20

Sophomore

Male

5

5.2

19

Sophomore

Male

5.5

4.6

21

Senior

Female

3.5

4.6

20

Junior

Female

5.25

5

19

Sophomore

Female Idenitfying as Male

4.75

4.6

18

Sophomore

Female

5

4.2

20

Junior

Female

6.25

3.4

19

Sophomore

Female

4.75

5.2

18

First Year

Female

5

5.2

19

First Year

Male

4.5

5.2

20

Sophomore

Male

4

5

19

Sophomore

Female

4.75

5.2

18

Sophomore

Male

6.25

4.6

18

Sophomore

Male

5

3

19

Sophomore

Female

5.25

4.8

19

First Year

Male

5.25

4.2

19

Sophomore

Female

5.25

4.6

19

Sophomore

Female

5.5

4.8

19

First Year

Male

6.25

3.8

20

Junior

Female

6.25

5.2

19

Sophomore

Female

1

4.2

20

Junior

Female

2

5.4

19

First Year

Female

3.25

5

20

Sophomore

Female

2.75

5

19

Sophomore

Female

2.75

5.4

18

First Year

Female

4

4.8

19

First Year

Male

3.75

5.4

19

Sophomore

Female

4

5.4

19

First Year

Male

5

5

22

Senior

Female

4.25

4.2

19

First Year

Male

4.75

4.8

19

Sophomore

Female

3.75

4.2

19

Sophomore

Female

4.75

5.6

19

Sophomore

Female

5.75

3.6

25

Senior

Female

4.5

5.2

20

Sophomore

Female

5.75

5.6

18

First Year

Female

6

4.2

21

Junior

Female

5.5

4

19

Sophomore

Female

6

5.2

18

First Year

Female

4.75

4.8

19

Sophomore

Male

4.25

5.4

18

First Year

Female

4.5

4.2

21

Senior

Male

3.75

4.6

22

Senior

Female

6.75

4.6

20

Sophomore

Male

3.5

5.4

18

First Year

Male

3

4.6

20

Sophomore

Male

5.75

4.4

22

Senior

Female

4.5

3.2

19

Sophomore

Prefer not to answer

4

3.8

18

First Year

Female

3.5

5.2

19

Sophomore

Female

3.75

4.6

20

Junior

Male

4.5

4.6

20

Junior

Male

4.5

4

19

First Year

Female

1.25

5.4

19

First Year

Female

2.25

4.8

19

First Year

Male

4.5

4.4

21

Junior

Female

4

4.4

21

Senior

Male

2.75

4.6

18

First Year

Female

2.5

5.4

19

Sophomore

Female

3

3.8

20

Sophomore

Female

2.25

5

20

Sophomore

Female

2.75

5

19

Sophomore

Female

3.75

4.8

19

Sophomore

Female

4

5.4

19

Sophomore

Male

4.25

5.4

19

First Year

Female

3.75

5

45

Sophomore

Female

4.75

5

18

First Year

Female

4.5

5

19

First Year

Female

4

4.6

19

First Year

Prefer not to answer

3.75

4.4

19

Sophomore

Female

4.25

4.8

19

First Year

Male

3.75

4.8

18

First Year

Male

4.5

5.2

19

First Year

Female

4.75

5.6

21

Junior

Female

4.5

5.2

20

Junior

Female

4.5

5.2

28

Junior

Male

3.5

5.6

19

Sophomore

Female

4.5

5.8

19

Sophomore

Female

4.25

4

20

Sophomore

Male

5.75

5

19

Sophomore

Female

5

5.4

20

Sophomore

Female

5

5.6

19

Sophomore

Female

5

5.2

19

Sophomore

Female

4.25

5.2

20

Sophomore

Male

4.5

5.2

19

Sophomore

Female

4.5

4.6

18

First Year

Female

4.5

5.4

19

Sophomore

Male

5.25

4.2

19

First Year

Male

4

6.2

19

First Year

Male

5.25

4.8

21

Junior

Female

5.75

5.4

18

First Year

Female

6.5

4.2

18

First Year

Female

5.5

5.2

21

Junior

Female

3.75

5.4

19

First Year

Female

2

6.4

21

Sophomore

Female

4

6.2

20

Sophomore

Female

4.25

6

19

Junior

Female

4

6

19

Sophomore

Female

3.25

6.2

19

Sophomore

Female

2.5

6

18

First Year

Female

2

5.4

18

First Year

Female

3.75

5.8

19

Sophomore

Male

3

5.6

20

Sophomore

Female

4.75

5.4

18

First Year

Female

3.25

6

19

First Year

Female

5.25

6

20

Sophomore

Female

4

5.6

19

Sophomore

Male

4

4.4

20

Junior

Female

4.25

5.6

18

First Year

Male

4

4.8

19

Sophomore

Female

3.5

5.2

20

Sophomore

Female

4

5.8

20

Sophomore

Female

4

5.4

20

Sophomore

Female

3.75

5.6

24

Junior

Female

4

6

19

First Year

Male

4

6.4

19

Junior

Female

3.75

5.8

19

Sophomore

Female

5.5

4.6

18

First Year

Female

4.25

6

19

Sophomore

Female

5.25

5

19

Sophomore

Female

5

6.2

20

Junior

Female

5

5

19

Sophomore

Female

3.75

5.2

19

Sophomore

Male

5.5

4.8

23

Senior

Male

5

5.4

19

Sophomore

Female

4.5

5.8

19

Sophomore

Female

5

6

19

Sophomore

Male

4.25

5.8

19

Sophomore

Female

4

5.6

19

Sophomore

Female

5.75

6

19

Sophomore

Female

5.25

5.6

19

Sophomore

Female

5.75

5

18

First Year

Female

5.75

5.2

42

Sophomore

Prefer not to answer

5.75

4.8

19

Sophomore

Female

5.5

5

20

Sophomore

Male

5.25

5.8

19

Sophomore

Female

5.75

6

18

First Year

Male

4.75

4.6

19

Sophomore

Female

4

4.4

21

Senior

Female

6

6

21

Junior

Female

7

4.2

20

Junior

Male

4

5.2

21

Junior

Female

4

5.6

20

Junior

Prefer not to answer

3.75

6.6

19

Sophomore

Female

5

6.4

22

Junior

Female

4.5

5.2

21

Senior

Female

4.75

5.6

19

Sophomore

Female

6

3.4

19

Sophomore

Female

3

5.8

19

Sophomore

Female

3.5

4.6

19

First Year

Female

5

5.2

19

Sophomore

Female

6

5.6

18

First Year

Female

4.75

4.6

19

First Year

Female

1

6

19

Sophomore

Male

3

5.4

19

Sophomore

Female

2.75

5.4

19

Sophomore

Female

2

6.2

20

Sophomore

Male

2.75

5.2

20

Sophomore

Female

3.75

6.2

19

First Year

Female

4

6.4

20

Sophomore

Male

4.5

4.8

18

First Year

Male

5.5

5.2

19

Sophomore

Female

4.5

5.8

18

First Year

Female

4

4.6

19

First Year

Female

4.75

5.4

18

First Year

Male

5

6

19

Sophomore

Female

6

5.4

22

Senior

Male

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!