Statistical Analysis of Data - Research Methods - IT Assignment Help

Assignment Task:

Introduction and dataset

The aim of this coursework is to investigate and predict the onset of diabetes based on various diagnostic measurements. The dataset was originally compiled by researcher at the Johns Hopkins University School of Medicine, from a larger database owned by the National Institute of Diabetes and Digestive and Kidney Diseases. All patients were females at least 21 years old of Pima Indian heritage. Note that Pima Indians have one of the highest rates of diabetes in the world. 

Creating your unique dataset

Copy the data from this file into MINITAB so that Glucose is recorded in column C1, Pregnancies in C2, etc.

(1) Generate two random numbers between 2 and 7 and provide MINITAB output. 

(2) Using MINITAB, erase columns corresponding to your generated numbers (e.g. if one of the generated numbers is 5 then erase column C5, etc). Describe how you did this and provide the sequence of actions (e.g. Calc->Descriptive Stats->....) 

(3) Using MINITAB select a random sample of 300 observations (n = 300) from your dataset. Provide the sequence of actions of how you did this. 

Your unique dataset will now consist of 300 rows and seven columns including Glucose, Age and Outcome. 

Investigating your unique dataset

(4) For your unique dataset summarise information about your observations and present graphically the frequency distributions for all variables that are left in your unique dataset including Glucose but excluding Outcome variables. Comment on unusual observations and make your own decision, how to deal with them. 

(5) Using MINITAB, define a new variable, Age_Group, by combining observations for participants younger than 30 into group 1 and all others (of age 30 and older) into group 2. Provide either a description or a screen shot of how you did this. 

(6) Investigate whether there is a significant difference in mean/median Glucose concentration between age groups. Formulate the null and alternative hypotheses; choose, justify and perform an appropriate statistical test using MINITAB; provide all MINITAB outputs; write your conclusions. 

 (7) Show whether the proportion of participants with Glucose concentration greater than 100 mg/dl is different between age groups that you defined previously. Formulate the null and alternative hypotheses; choose, justify and perform an appropriate statistical test using MINITAB; provide all MINITAB outputs; write your conclusions.

(8) Using MINITAB, produce a table of correlation coefficients. Justify the choice of correlation coefficient, investigate the resulting table and comment on most interesting relationships between chosen variables. Do not use Glucose and Outcome variables in this analysis. 

(9) Using simple linear regression, model Glucose concentration by one of the variables of your choice that are available in your unique dataset. Comment on significance of intercept and slope. 

(10) Fit a multiple regression model with Glucose being a response variable and other five variables excluding Outcome as predictors. Treat variable Pregnancies as an interval scale data. Identify insignificant predictors in the model and explain why they are insignificant. 

(11) Cluster your 300 observation into 10 groups using one of the linkage method and similarity measure from the corresponding drop-down menus. Give a brief (half a page) description of the linkage method and similarity measure chosen. Show a dendrogram with cases labelled by Outcome. Comment on the results obtained. Provide all MINITAB outputs. 

(12) It is known that the incidence of diabetes in the UK is 0.6. In a small northern village of 100 people isolated from the mainland for six months per year the pharmacy wants to know how many insulin shots to order. We want to know what is the probability that between A and B people will develop the disease during this period. To perform analysis, generate two random numbers between 0 and 100 using MINITAB and paste the outputs into your report. Denote by A the smallest number and by B the largest number out of these two generated numbers. Calculate the probability that between A and B people develop the disease and how many shots should be ordered. 

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.