Question

A kayak race is held each August on the South Arm of Lake Charlevoix, Charlevoix County, Michigan. The "course" starts at the public launch in East Jordan, MI and ends at the DNR launch at Dutchman's Bay, a distance of approximately two nautical miles. Participants are individual paddlers in identical Old Town sit inside Sorrento 106sk kayaks. The organizer wants to investigate if there is a relationship between the amount of experience (three categories) and minutes to complete the course. She wants to control for age. She also wants suggestions about other data that might be collected to find additional relationships (e.g. water temperature).

The data from a random sample from a recent year's event is provided below:

KAYAK RACE DATA SET

Randomly selected participant	experience	age	time
1	1	32	70.6
2	3	34	78.1
3	2	29	76.1
4	1	27	61.7
5	2	28	67.6
6	3	31	77.8
7	1	35	85.2
8	1	35	74.8
9	2	29	75.8
10	1	35	72.2
11	3	28	94.5
12	1	25	35.6
13	2	34	94.8
14	3	38	98.4
15	2	27	43.8
16	3	43	106.3
17	3	25	65.6
18	1	31	56.7
19	2	37	95.8
20	1	33	75.4
21	3	39	105.8
22	2	26	61.6
23	3	26	55.7
24	2	36	85.4

Experience

1 = participation in 10 or more kayak events

2 = participation in 4 to 9 kayak events

3 = participation in 3 kayak events

Complete the following:

Import / post the data above to create an SPSS data file (sav)

Conduct an ANCOVA analysis

Respond to the organizers current research question

Propose two future data categories (not including example above of water temperature) and rationale for each.

Answer 1

The SPSS data is:

The SPSS output is:

There is a significant main effect of age.

There is no significant main effect of experience.

There is no significant interaction effect.

The two future data categories are:

IQ level and athletism level

Please give me a thumbs-up if this helps you out. Thank you!