Initial Data Analysis

Dr. Zobb has accumulated some data on an initial set of 20 patients across multiple age groups. She believes that the datasuggests younger individuals are affected more than others.She wants you to complete the tasks shown here based on the data below.

For each of the following, provide a detailed explanation of the process you used along with your interpretation of the results. Submit the response in a Word document and attach your Excel spreadsheet to show your calculations (where applicable). Be sure to number each response (e.g., 1.a, 1.b,...).

1. Develop an equation to model the data using a regression analysis approach and explain your calculation process in Excel.
2. Calculate the r-square statistic using Excel. Interpret the meaning of the r-square statistic in this case.
3. Determine three conclusions that address the initial observations and are supported by the regression analysis.

Patient Number	Age of Patient	Number of Lesions
1	24	16
2	63	7
3	45	12
4	17	24
5	21	20
6	72	4
7	32	13
8	36	16
9	26	21
10	47	10
11	31	15
12	23	18
13	51	8
14	24	22
15	26	18
16	25	19
17	31	12
18	19	29
19	18	25
20	21	17