(5/5)

which has 8 numerical attributes and a binary class attribute (1 indicates that the person is assumed to have diabetes), indicating the following information:

1. Number of times pregnant

2. Plasma glucose concentration a 2 hours in an oral glucose tolerance test

3. Diastolic blood pressure (mm Hg)

4. Triceps skin fold thickness (mm)

5. 2-Hour serum insulin (mu U/ml)

6. Body mass index (weight in kg/(height in m)^2)

7. Diabetes pedigree function

8. Age (years)

9. Class variable (0 or 1)

5 Examples in the Pima Indians Diabetes Dataset:

6,148,72,35,0,33.6,0.627,50,1

1,85,66,29,0,26.6,0.351,31,0

8,183,64,0,0,23.3,0.672,32,1

1,89,66,23,94,28.1,0.167,21,0

0,137,40,35,168,43.1,2.288,33,1

Question 2 Sub-Tasks

Apply the following exploratory data analysis techniques using Weka or Orange (or other tools of your preference) to the original/cleaned Pima Indian Diabetes Dataset; if not otherwise stated, use the original dataset:

a. Compute the mean value and standard deviation for attributes 2, 3, 6, and 7. Remove 0’s that do not make sense prior to computing these statistics. Compute the covariance matrix for four attributes next, compute the correlations for each of the 6 pairs of the 4 attributes. Interpret the statistical findings!

Remove 0’s that do not make sense prior to computing the covariance matrix and correlations.

b. Create histograms for attributes 2 and 4. Then create the same histograms for the 2 attributes for the instances of class 1 and for the instances of class 0; interpret the obtained 6 histograms.

c. Create box plots for the 6nd and 8th attribute; one for the whole dataset and one each for the instances of the two classes. Remove 0’s that do not make sense prior to computing the box plots. Interpret and compare the obtained 6 boxplots!

d. Write a conclusion (at most 13 sentences!) summarizing the most important findings of the assignment—what did we learn about the dataset? In particular, discuss the findings obtained related to predicting diabetes.

e. Calculate the row-wise Euclidean distance matrix of all attributes and plot in Matrix

Data Mining

By Ansif Arooj

Question 3:

Download the Wine, Forest Fire, and Adult datasets from UCI Machine Learning Repository. Read the datasets’ instructions and report the following:

a. The types of the attributes (continuous [interval, ratio], categorical [nominal, ordinal]). Also identify which attribute(s) are input attribute(s) and which are class attribute(s) (if any).

b. Compute the five-number summary for the continuous attributes (you may create boxplots for this). Compute the mode for categorical attributes.

c. Compute the mean and standard deviation for the continuous attributes.

d. Generate the quantile (percentile) plots for two key attributes in each dataset.

e. Generate the histogram or distribution plot for each of the two attributes selected in (d).

f. Generate the scatter plots for the two attributes selected in (d). (in MS. Excel)

g. Compute and visualize correlation matrices for the continuous attributes.

h. Comment on the results regarding characteristics of this database. (one Paragraph)

(5/5)

CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,

Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This

7COM1028 Secure Systems Programming Referral Coursework: Secure

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme