Need help with these questions, any help would be so appreciated, thank you

The number of psychology majors at a small liberal arts college indicating interest in taking the following electives.

Physiological Psychology Cultural Psychology Psychology of Aging

16 24 31

3. A researcher is doing applied research on preventing falls in the elderly. He wants to run an experiment on the impact of a series of Wii (computer assisted) exercises on the balance ability of elderly residents of an assisted living facility. He randomly assigns half his participants to engage in the Wii program for six weeks and the other half to engage in traditional balance promoting exercises.

It will be important that the two groups have equal spatial ability before he runs the experiment. Using the Analysis Toolpak in Excel calculate the descriptive statistics for the experimental (Wii) group and the control (traditional exercises) group. Compare them in terms of measures central tendency, variation, skewness, and kurtosis. What do they tell you about the two groups?

Spatial Ability Scores

Wii Group Traditional Exercise Group

100 100

108 103

88 104

70 98

82 102

110 95

104 100

94 101

98 121

118 103

88 106

89 103

101 106

96 99

91 105

4. Use the following data to produce a pivot table. Explain what it tells you.

ID Risk Level Locus of Control

1 1 A

2 2 B

3 2 B

4 2 B

5 1 A

6 3 B

7 3 B

8 3 A

9 2 B

10 2 A

11 3 B

12 3 B

13 1 A

14 2 A

15 2 B

16 2 B

17 3 B

18 2 A

19 2 B

20 3 B

1 = Low A = Internal

2 = Medium B = External

5. = High

5. For each of the following correlations report:

- the type of correlation (positive or negative)
- what the correlation means in words. (For example, in a positive correlation we could say “As ____ increases, _____ increases.”
- the general interpretation of the correlation coefficient, i.e., whether it is a very strong relationship, a moderate relationship, a weak relationship, etc.

a) The correlation between grades in basic math and advanced math classes at a small liberal arts college where r = +.78.

b) The correlation between reading ability and social science grades in a middle school where r = +.52.

c) The correlation between test anxiety scores and grade on an achievement test where r = -.42.

d) The correlation between math aptitude scores and musical aptitude scores in second graders where r = +.28.

e) The correlation between the number of books read over a year and the scores on a popular video game where r = -.38.

6. A researcher in animal behavior was interested increasing veterinarian care for dogs. He was particularly interested in the effect of the time spent in the waiting room of a vet’s office on the dog’s heart rate when first taken in the examination room.

Use the following data to:

- compute a correlation coefficient using Excel.

- What data scatterplot using Excel.

- explain in words what the correlation coefficient tells you about the relationship between time in the waiting room and heart rate. What does it not tell you?

Time in Waiting Room Heart Rate

14 116

15 104

10 102

21 98

11 103

16 114

12 116

18 90

16 103

10 123

7. Which type of correlation would be appropriate to calculate for each of the following sets of data?

A. Correlating gender and whether one is a college graduate (yes/no)

B. Correlating rank in a graduating class (1st, 2nd, 3rd, etc.) and score on a test of optimism

C. Correlating gender and score on a test of optimism.

D. Correlating scores on a test of optimism and scores on a test of subjective well-being

E. Correlating rank in a graduating class of traditional college students and rank in initial salary offering for first job after graduating

For students who are struggling with essay writing, we can be a lifesaver. We offer **essay writing help **for students of all levels, from elementary school to college. Our team of **experienced assignment writers** can help you with any type of essay, from persuasive essays to comparative essays. So if you're struggling with essay writing, don't hesitate to contact us for assistance.

Looking For Plagiarism Free Answers For Your College/ University Assignments.