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