I DO NOT UNDERSTAND HOW TO MAKE MY VARIABLES "CONNECT" IN EXCEL

Questions:

1. Use your spreadsheet software to perform a linear regression analysis using technology.Determine the strength of the linear correlation between your two-variables. State and interpret your r-value.
2. Represent your data on a scatter plot and show the line of best fit.
3. If you had any outliers in your data, describe their impact on the line of best fit.
4. Using multiple scatter plots, show how the line of best fit changes if you remove any outliers. If your data did not contain any outliers, indicate and choose one point to remove in order to see how its removal impacts the line of best fit.
5. Lastly, pick and calculate the residuals for three different points in your data set. Discuss how the results of your calculations relate to your data set and the line of best fit.

Information needed,

these are the two separate variables:

BMI values	Frequency		Hours spent exercising per week (hours)	Frequency(f)
17-18.5	1		1	0
18.6-20.1	1		2	4
20.2-21.7	3		3	3
21.8-23.3	8		4	11
23.4-24.9	7		5	8
25-26.5	3		6	5
26.6-28.1	5		7	2
28.2-29.7	4		8	0
29.8-31.3	1
31.4-32.9	0