2. Data Collection and Summary

Data Collection: I collected data from 30 individuals, recording their average weekly exercise duration (in hours) and their corresponding resting heart rate (beats per minute). The data was obtained through self-reported exercise logs and heart rate monitors worn by the participants.

Participants	Exercise (hours/week)	Resting Heart Rate (bpm)
1	3	72
2	2.5	75
3	4	70
4	5	68
5	2	77
6	3.5	71
7	4.5	69
8	2.2	74
9	3.8	70
10	3	72
11	1.5	78
12	2.7	73
13	3.3	71
14	4	70
15	2	76
16	5	67
17	3.2	77
18	2.8	74
19	3	73
20	4.5	68
21	1.8	77
22	3.5	70
23	2.9	73
24	4.2	69
25	2.3	75
26	3.7	71
27	1.9	76
28	3.4	72,
29	2.1	75
30	3.6	70

Based on this data: Use Excel and include screenshots of the graphs please:

• make A one-variable analysis of your first variable, including a graph, measures of central tendency, and spread.
• make A one-variable analysis of your second variable, including a graph, measures of central tendency, and spread.
• make A graph of your two-variable data with regression line, r, r2, and separate residual plot.
• A discussion of the accuracy of the linear model.
• An application of your regression to predict two other outcomes not included in the original data, and discussion of limitations. REFERENCE: ILC ASSIGNMENT