d

DATA FILE:

Age,Sex,BP,Cholesterol,Na,K,Drug 23,F,HIGH,HIGH,0.792535,0.031258,drugY 47,M,LOW,HIGH,0.739309,0.056468,drugC 47,M,LOW,HIGH,0.697269,0.068944,drugC 28,F,NORMAL,HIGH,0.563682,0.072289,drugX 61,F,LOW,HIGH,0.559294,0.030998,drugY 22,F,NORMAL,HIGH,0.676901,0.078647,drugX 49,F,NORMAL,HIGH,0.789637,0.048518,drugY 41,M,LOW,HIGH,0.766635,0.069461,drugC 60,M,NORMAL,HIGH,0.777205,0.05123,drugY 43,M,LOW,NORMAL,0.526102,0.027164,drugY 47,F,LOW,HIGH,0.896056,0.076147,drugC 34,F,HIGH,NORMAL,0.667775,0.034782,drugY 43,M,LOW,HIGH,0.626527,0.040746,drugY 74,F,LOW,HIGH,0.792674,0.037851,drugY 50,F,NORMAL,HIGH,0.82778,0.065166,drugX 16,F,HIGH,NORMAL,0.833837,0.053742,drugY 69,M,LOW,NORMAL,0.848948,0.074111,drugX 43,M,HIGH,HIGH,0.656371,0.046979,drugA 23,M,LOW,HIGH,0.55906,0.076609,drugC 32,F,HIGH,NORMAL,0.643455,0.024773,drugY 57,M,LOW,NORMAL,0.536746,0.028061,drugY 63,M,NORMAL,HIGH,0.616117,0.023773,drugY 47,M,LOW,NORMAL,0.809199,0.026472,drugY 48,F,LOW,HIGH,0.87444,0.058155,drugY 33,F,LOW,HIGH,0.858387,0.025634,drugY 28,F,HIGH,NORMAL,0.556833,0.029604,drugY 31,M,HIGH,HIGH,0.740936,0.0244,drugY 49,F,NORMAL,NORMAL,0.694689,0.074055,drugX 39,F,LOW,NORMAL,0.649096,0.028598,drugY 45,M,LOW,HIGH,0.753504,0.041976,drugY 18,F,NORMAL,NORMAL,0.553567,0.063265,drugX 74,M,HIGH,HIGH,0.715337,0.074773,drugB 49,M,LOW,NORMAL,0.625889,0.056828,drugX 65,F,HIGH,NORMAL,0.828898,0.026004,drugY 53,M,NORMAL,HIGH,0.644936,0.045632,drugX 46,M,NORMAL,NORMAL,0.526226,0.072234,drugX 32,M,HIGH,NORMAL,0.52975,0.056087,drugA 39,M,LOW,NORMAL,0.604973,0.043404,drugX 39,F,NORMAL,NORMAL,0.517515,0.053301,drugX 15,M,NORMAL,HIGH,0.64236,0.07071,drugX 73,F,NORMAL,HIGH,0.832683,0.043321,drugY 58,F,HIGH,NORMAL,0.868924,0.061023,drugB 50,M,NORMAL,NORMAL,0.747815,0.04736,drugY 23,M,NORMAL,HIGH,0.593596,0.048417,drugX 50,F,NORMAL,NORMAL,0.601915,0.048957,drugX 66,F,NORMAL,NORMAL,0.611333,0.075412,drugX 37,F,HIGH,HIGH,0.559171,0.042713,drugA 68,M,LOW,HIGH,0.726677,0.070616,drugC 23,M,NORMAL,HIGH,0.888629,0.028045,drugY 28,F,LOW,HIGH,0.606933,0.030659,drugY 58,F,HIGH,HIGH,0.560854,0.028886,drugY 67,M,NORMAL,NORMAL,0.846892,0.077711,drugX 62,M,LOW,NORMAL,0.804173,0.029584,drugY 24,F,HIGH,NORMAL,0.648646,0.035144,drugY 68,F,HIGH,NORMAL,0.77541,0.0761,drugB 26,F,LOW,HIGH,0.578002,0.040819,drugC 65,M,HIGH,NORMAL,0.635551,0.056043,drugB 40,M,HIGH,HIGH,0.557133,0.020022,drugY 60,M,NORMAL,NORMAL,0.645515,0.063971,drugX 34,M,HIGH,HIGH,0.888144,0.047486,drugY 38,F,LOW,NORMAL,0.598753,0.020042,drugY 24,M,HIGH,NORMAL,0.613261,0.064726,drugA 67,M,LOW,NORMAL,0.820638,0.039657,drugY 45,M,LOW,NORMAL,0.532632,0.063636,drugX 60,F,HIGH,HIGH,0.800607,0.060181,drugB 68,F,NORMAL,NORMAL,0.821584,0.030373,drugY 29,M,HIGH,HIGH,0.625272,0.048637,drugA 17,M,NORMAL,NORMAL,0.722286,0.06668,drugX 54,M,NORMAL,HIGH,0.504995,0.02048,drugY 18,F,HIGH,NORMAL,0.564811,0.023266,drugY 70,M,HIGH,HIGH,0.658606,0.047153,drugB 28,F,NORMAL,HIGH,0.860775,0.04375,drugY 24,F,NORMAL,HIGH,0.80554,0.07596,drugX 41,F,NORMAL,NORMAL,0.844196,0.036857,drugY 31,M,HIGH,NORMAL,0.88624,0.051922,drugY 26,M,LOW,NORMAL,0.790664,0.037815,drugY 36,F,HIGH,HIGH,0.734119,0.065556,drugA 26,F,HIGH,NORMAL,0.823793,0.042994,drugY 19,F,HIGH,HIGH,0.516973,0.038832,drugA 32,F,LOW,NORMAL,0.724422,0.066829,drugX 60,M,HIGH,HIGH,0.805651,0.057821,drugB 64,M,NORMAL,HIGH,0.5126,0.066049,drugX 32,F,LOW,HIGH,0.730854,0.075256,drugC 38,F,HIGH,NORMAL,0.733842,0.064793,drugA 47,F,LOW,HIGH,0.539774,0.05362,drugC 59,M,HIGH,HIGH,0.816356,0.058583,drugB 51,F,NORMAL,HIGH,0.678646,0.04991,drugX 69,M,LOW,HIGH,0.854733,0.055221,drugY 37,F,HIGH,NORMAL,0.795312,0.034443,drugY 50,F,NORMAL,NORMAL,0.73961,0.042972,drugY 62,M,NORMAL,HIGH,0.755873,0.045551,drugY 41,M,HIGH,NORMAL,0.658397,0.043442,drugY 29,F,HIGH,HIGH,0.857934,0.029132,drugY 42,F,LOW,NORMAL,0.763404,0.026081,drugY 56,M,LOW,HIGH,0.812663,0.054123,drugY 36,M,LOW,NORMAL,0.52765,0.046188,drugX 58,F,LOW,HIGH,0.886865,0.023188,drugY 56,F,HIGH,HIGH,0.750962,0.029571,drugY 20,M,HIGH,NORMAL,0.764067,0.021439,drugY 15,F,HIGH,NORMAL,0.697052,0.041677,drugY 31,M,HIGH,NORMAL,0.695183,0.058559,drugA 45,F,HIGH,HIGH,0.547821,0.042619,drugA 28,F,LOW,HIGH,0.656292,0.049997,drugC 56,M,NORMAL,HIGH,0.627866,0.070026,drugX 22,M,HIGH,NORMAL,0.860621,0.030417,drugY 37,M,LOW,NORMAL,0.616692,0.068765,drugX 22,M,NORMAL,HIGH,0.536324,0.044871,drugX 42,M,LOW,HIGH,0.756097,0.03778,drugY 72,M,HIGH,NORMAL,0.72142,0.074552,drugB 23,M,NORMAL,HIGH,0.543355,0.032247,drugY 50,M,HIGH,HIGH,0.518285,0.069193,drugA 47,F,NORMAL,NORMAL,0.526835,0.078828,drugX 35,M,LOW,NORMAL,0.685143,0.074717,drugX 65,F,LOW,NORMAL,0.760221,0.055214,drugX 20,F,NORMAL,NORMAL,0.581591,0.062667,drugX 51,M,HIGH,HIGH,0.83849,0.045831,drugY 67,M,NORMAL,NORMAL,0.721257,0.075808,drugX 40,F,NORMAL,HIGH,0.512517,0.05073,drugX 32,F,HIGH,NORMAL,0.724375,0.070383,drugA 61,F,HIGH,HIGH,0.63126,0.02478,drugY 28,M,NORMAL,HIGH,0.584179,0.021585,drugY 15,M,HIGH,NORMAL,0.58301,0.033885,drugY 34,M,NORMAL,HIGH,0.602557,0.026833,drugY 36,F,NORMAL,HIGH,0.563217,0.033618,drugY 53,F,HIGH,NORMAL,0.760809,0.060889,drugB 19,F,HIGH,NORMAL,0.742092,0.028576,drugY 66,M,HIGH,HIGH,0.84985,0.051988,drugY 35,M,NORMAL,NORMAL,0.523623,0.066745,drugX 47,M,LOW,NORMAL,0.84773,0.025274,drugY 32,F,NORMAL,HIGH,0.549375,0.073474,drugX 70,F,NORMAL,HIGH,0.725424,0.035406,drugY 52,M,LOW,NORMAL,0.663146,0.020143,drugY 49,M,LOW,NORMAL,0.510473,0.037539,drugX 24,M,NORMAL,HIGH,0.854591,0.033142,drugY 42,F,HIGH,HIGH,0.533228,0.025348,drugY 74,M,LOW,NORMAL,0.787812,0.065984,drugX 55,F,HIGH,HIGH,0.637231,0.058054,drugB 35,F,HIGH,HIGH,0.869854,0.06746,drugA 51,M,HIGH,NORMAL,0.832467,0.073392,drugB 69,F,NORMAL,HIGH,0.773798,0.076882,drugX 49,M,HIGH,NORMAL,0.500169,0.079788,drugA 64,F,LOW,NORMAL,0.554182,0.021529,drugY 60,M,HIGH,NORMAL,0.635762,0.073744,drugB 74,M,HIGH,NORMAL,0.818999,0.053057,drugY 39,M,HIGH,HIGH,0.731091,0.075652,drugA 61,M,NORMAL,HIGH,0.745123,0.078906,drugX 37,F,LOW,NORMAL,0.804155,0.066981,drugX 26,F,HIGH,NORMAL,0.781928,0.063535,drugA 61,F,LOW,NORMAL,0.522891,0.071238,drugX 22,M,LOW,HIGH,0.526672,0.064617,drugC 49,M,HIGH,NORMAL,0.538183,0.061859,drugA 68,M,HIGH,HIGH,0.639888,0.058123,drugB 55,M,NORMAL,NORMAL,0.509181,0.070126,drugX 72,F,LOW,NORMAL,0.7586,0.05181,drugX 37,M,LOW,NORMAL,0.73154,0.043743,drugY 49,M,LOW,HIGH,0.655222,0.062181,drugC 31,M,HIGH,NORMAL,0.749717,0.06678,drugA 53,M,LOW,HIGH,0.618603,0.026939,drugY 59,F,LOW,HIGH,0.640455,0.06132,drugC 34,F,LOW,NORMAL,0.825542,0.063881,drugX 30,F,NORMAL,HIGH,0.501956,0.048067,drugX 57,F,HIGH,NORMAL,0.754166,0.075832,drugB 43,M,NORMAL,NORMAL,0.538856,0.041905,drugX 21,F,HIGH,NORMAL,0.745098,0.026023,drugY 16,M,HIGH,NORMAL,0.561019,0.029516,drugY 38,M,LOW,HIGH,0.851019,0.046516,drugY 58,F,LOW,HIGH,0.887928,0.033324,drugY 57,F,NORMAL,HIGH,0.596099,0.041931,drugX 51,F,LOW,NORMAL,0.876828,0.038118,drugY 20,F,HIGH,HIGH,0.887426,0.078798,drugA 28,F,NORMAL,HIGH,0.744956,0.057843,drugX 45,M,LOW,NORMAL,0.71486,0.071367,drugX 39,F,NORMAL,NORMAL,0.809196,0.046978,drugY 41,F,LOW,NORMAL,0.749905,0.040018,drugY 42,M,HIGH,NORMAL,0.85794,0.067203,drugA 73,F,HIGH,HIGH,0.808019,0.044038,drugY 48,M,HIGH,NORMAL,0.769197,0.073633,drugA 25,M,NORMAL,HIGH,0.775702,0.040803,drugY 39,M,NORMAL,HIGH,0.609566,0.038171,drugY 67,F,NORMAL,HIGH,0.785251,0.049416,drugY 22,F,HIGH,NORMAL,0.817625,0.035832,drugY 59,F,NORMAL,HIGH,0.882486,0.063563,drugX 20,F,LOW,NORMAL,0.811023,0.069402,drugX 36,F,HIGH,NORMAL,0.575058,0.037124,drugY 18,F,HIGH,HIGH,0.88515,0.023802,drugY 57,F,NORMAL,NORMAL,0.551967,0.021317,drugY 70,M,HIGH,HIGH,0.589493,0.059854,drugB 47,M,HIGH,HIGH,0.56332,0.054152,drugA 65,M,HIGH,NORMAL,0.8645,0.024702,drugY 64,M,HIGH,NORMAL,0.739914,0.035349,drugY 58,M,HIGH,HIGH,0.76909,0.040497,drugY 23,M,HIGH,HIGH,0.53406,0.066666,drugA 72,M,LOW,HIGH,0.547347,0.03356,drugY 72,M,LOW,HIGH,0.50482,0.074573,drugC 46,F,HIGH,HIGH,0.773569,0.022302,drugY 56,F,LOW,HIGH,0.848774,0.07338,drugC 16,M,LOW,HIGH,0.743021,0.061886,drugC 52,M,NORMAL,HIGH,0.549945,0.055581,drugX 23,M,NORMAL,NORMAL,0.78452,0.055959,drugX 40,F,LOW,NORMAL,0.683503,0.060226,drugX

1. Provide a descriptive analysis of the data as provided from your stream file. Include the source descriptions including any trials or multiple versions of data. Summarize the data in a table or paragraph fomat in your Word document, 2. Prepare the data for analysis. The data treatment provided is supplied in the SPSS Modeler Stream you submit. 3. Model the data provided. The model is provided in the SPSS Modeler Stream you submit. 4. Write a description explaining why the particular.statistical modeling approach was chosen, along with an analysis of the model results, in your Word document. Be sure to identify any dependent and independent variables from your analysis with a description of the analysis Problem Decision trees are great at splitting samples based on field values. For this next problem, use the C5.0 Modeling Node which you can read about in the Modeling Nodes manual. You are a medical researcher compiling data for a study. You have collected data about a set of patients, all of whom suffered from the same illness. During their course of treatment, each patient responded to one of five medications. The attached dataset contains a list of patients that have previously been treated. The data file is a text file with delimited columns. The data fields are defined as: Data field Description Age (Number) Sex Mor F BP Blood pressure: HIGH, NORMAL, O LOW Cholesterol Blood cholesterol- NORMAL or HIGH Na Blood sodium concentration Blood potassium concentration Drug Prescription drug to which a patient responded Explore the data and generate some graphs to examine the output Consider a Distribution graph. Scatterplot and Web Graph. Do they reveal anything useful? Consider the ratio of sodium to potassium as a predictor of which drug to use Calculate a new field that contains the value of the ratio and generate a histogram to view the results. This can be done in a new branch from the source node. Is this a valid indicator? Explore the ratio in conjunction with the other characteristics to see if you can create a predictive model to determine which drugs are suitable for treating the different patients Compare the accuracy of your model with the drug the patient was actually treated with, by using an Analysis node 1. Provide a descriptive analysis of the data as provided from your stream file. Include the source descriptions including any trials or multiple versions of data. Summarize the data in a table or paragraph fomat in your Word document, 2. Prepare the data for analysis. The data treatment provided is supplied in the SPSS Modeler Stream you submit. 3. Model the data provided. The model is provided in the SPSS Modeler Stream you submit. 4. Write a description explaining why the particular.statistical modeling approach was chosen, along with an analysis of the model results, in your Word document. Be sure to identify any dependent and independent variables from your analysis with a description of the analysis Problem Decision trees are great at splitting samples based on field values. For this next problem, use the C5.0 Modeling Node which you can read about in the Modeling Nodes manual. You are a medical researcher compiling data for a study. You have collected data about a set of patients, all of whom suffered from the same illness. During their course of treatment, each patient responded to one of five medications. The attached dataset contains a list of patients that have previously been treated. The data file is a text file with delimited columns. The data fields are defined as: Data field Description Age (Number) Sex Mor F BP Blood pressure: HIGH, NORMAL, O LOW Cholesterol Blood cholesterol- NORMAL or HIGH Na Blood sodium concentration Blood potassium concentration Drug Prescription drug to which a patient responded Explore the data and generate some graphs to examine the output Consider a Distribution graph. Scatterplot and Web Graph. Do they reveal anything useful? Consider the ratio of sodium to potassium as a predictor of which drug to use Calculate a new field that contains the value of the ratio and generate a histogram to view the results. This can be done in a new branch from the source node. Is this a valid indicator? Explore the ratio in conjunction with the other characteristics to see if you can create a predictive model to determine which drugs are suitable for treating the different patients Compare the accuracy of your model with the drug the patient was actually treated with, by using an Analysis node