Question

database help

2019S_CPS4921 5921 midterm1t [Compatibility Mode Q Search in Document Home Insert Design Layout References Mailings Review Vievw Times New Ro , 12 , A-A, AS, Paste Heading 1 Heading 2 Heading 4 Heading 5 Styles Pane Normal No IV. Similarity test. (15 points) Given the following medical records, plcase find which two pcrsons have the most similar discase and which two persons have the most dissimilar disease. Please write your analysis steps by steps. |You can set Y(yes) and P (positive, be 1, and the value N (negative) 0. · . You can refer to slides oug est- . Please fill the binary data in the converted table. (4 points) HeadacheFever Peter 2. Please make the 3 contingency tables and calculate the simillarity for each comparision.(9 points) Similarity: Similarity Similarity: 3. Please write your conclusions. 2 points) Page 5 of 5 1143 Words English (US) 100%

Answer 1

name	headache	fever	cough	test-1	test-2	test-3	test-4
peter	1	1	0	1	1	1	1
susan	0	0	1	1	1	0	1
sarah	1	1	0	0	1	1	0

	susan
peter	0	1	1
	0	0	1
	1	1	1

similarities:test-1 and test-2 and test-4 have similarities for both susan and peter.

	susan
sarah	0	1	1
	0
	1

similarities:test-2 have similarities for both susan and sarah

	peter
sarah	1	1	0
	1
	0

similarities:headache,fever,cough,test-2 and test-3 have similarities for both peter and sarah

conclusion:

In the above problem we noticed that peter and sarah have more similarities in the diseases