IMPACT OF INFORMATION TECHNOLOGY

/0 Comments/in /by
Final Research Paper:  The course final research paper is a formatted APA paper.  It is 12 pages, double-spaced.  Paper length requirement is 12 pages of content from Title Page through References.  The Research Paper is worth 15% of the final grade.  The Final papers will contain a title page, TOC, abstract, introduction/topic paragraph, summary/conclusion, and references page.
Research paper topic:
IMPACT OF INFORMATION TECHNOLOGY
Be advised that, your research paper will ONLY use research work that is “Peer-reviewed” from the  library for your paper.  Your paper must have a total of 10-references that support your research work.  It is important that you refer to the APA 6E guidance to make certain that your paper is APA 6E guide compliant.

Research project – Bond and Stock Performance Analysis

/0 Comments/in /by
FINC 330 Project Description
Research Project Part 2
This project is closely aligned with the Course Outcomes and Finance Program Objectives.  Completion of this project can be used as part of a portfolio to show potential employers the student is skilled at performing company valuations and financial statement analysis and can be included on the student’s resume.
Bond and Stock Performance Analysis
OBJECTIVE
In this part of the project you are to assume to have been hired to join a team serving as an internal financial analyst to THE COMPANY. Your client plans to invest in bonds and (or) stocks issued by THE COMPANY (SELECTED BY INSTRUCTOR). In part 6 of the assignment you are asked to provide some recommendations to THE COMPANY’S management.
THE COMPANY for part 2 of the project can be the company that you were using for the Research Project Part 1 or ANOTHER COMPANY determined by your professor. THE COMPANY for this part of the project must have bonds listed on the website http://finra-markets.morningstar.com/BondCenter/Default.jsp. To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.
Alternatively, you can request approval of another publicly traded company. This request must be submitted before the end of the first week of the course. The request must include

  • identification of the company by ticker symbol and name
  • a reasonable and appropriate explanation of why you want to examine the alternative company
  • the source of the analyst’s report that will be used in the analysis (which must be submitted to me)
  • acknowledgement by you that all the specific elements of the assignment (see below) will be prepared by you and included in the final research project report

SUGGESTED WEBSITES
www.morningstar.com – To find the information for your company you need to type the stock symbol in the Quotes window to get into the company’s page.
http://finra-markets.morningstar.com/BondCenter/Default.jsp – To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.
https://markets.businessinsider.com/bonds. To find the information on bonds, scroll down the page, type the name of the company in the window under Bond Finder, and click SEARCH.
www.marketwatch.com  -To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
www.money.cnn.com  -To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
www.finance.yahoo.com – To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
www.nyse.com – Click on Data, then click on Stocks (under Quotes), and type the name of the company or the stock symbol in the window “Keyword or symbol” to get into the company’s page.
www.nasdaq.com – To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
Company’s websites
YOUR SPECIFIC ASSIGNMENT
Using the information from the websites the student will develop evaluation of bond and stock performance for THE COMPANY (SELECTED BY INSTRUCTOR). (The evaluation portion will total 85% of the assignment grade)
-1—Background and Industry (one short paragraph).
-2- The financial leverage ratios (10% of the project grade)
a) Find the financial leverage ratios for THE COMPANY assigned for you of the project for the last 3-5 years in the Internet. Present these ratios as the table(s) in your project.
You can find these ratios in the Internet or calculate them. If you use published ratios you must indicate that and cite their source.

  • Debt-to-assets ratio (Debt ratio)
  • Debt-to Equity ratio
  • Interest Coverage ratio (the Times Interest Earned)

b) Write (about) 1 page of the analysis of the ratio results. In your analysis you should answer the following questions. Please explain your answer to each question.
How is THE COMPANY financing its assets? Discuss how much risk is associated with the bonds issued by the company? How can this risk be measured? Please explain.
-3- Collect and evaluate the data about bond performance of the assigned company. (15% of the project grade).
The information on bonds can be found on the website http://finra-markets.morningstar.com/BondCenter/Default.jsp. To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.
Another useful website on bond information is https://markets.businessinsider.com/bonds. To find the information on bonds, scroll down the page, type the name of the company in the window under Bond Finder, and click SEARCH.
Copy the quotations of two bonds issued by THE COMPANY (SELECTED BY INSTRUCTOR) that contain the Price. Present these quotations in your project.

  1. Assume that par value of the bond is $1,000. What were the last prices of the bonds in $$$ (listed in the Price column)? Show your work in your project.
  2. Assume that par value of the bond is $1,000. Calculate the annual coupon interest payments. Show your work in your project.
  3. Assume that par value of the bond is $1,000. Calculate the current yield of the bonds. Show your work in your project.
  4. Write a 1-2 page of the analysis of the bonds. In your analysis you should answer the following questions. Please explain your answer to each question.
    1. How much is the YTM listed in quotations is for the bonds? Explain the meaning of YTM.
    2. If you are going to buy a bond issued by THE COMPANY, which bond would you choose? Why?
    3. Are these bonds callable? If the bonds that you chose are callable (non-callable), will it change your decision to buy them?
    4. If you are an investor who is looking for a bond to invest in, are you going to buy a bond that you chose? Take a look at the balance sheet and income statement of the company. What data or ratios support your decision to buy this bond or not? You may want to incorporate the results of the Research Project Part 1, as well as the results of the financial leverage ratios to answer this question. You should develop a specific recommendation, with supporting rationale to explain your answer.

-4- Collect and evaluate the data about stock performance of the assigned company for the last one year. (totally 35% of the project grade).
1) Find the market ratios for the company for the last 1-3 years and its major competitor for the last year in the Internet. (10% of the project grade)

  • Price/Earnings ratio
  • Market/Book ratio (also called (Price/Book ratio)
  • Earnings per share
  • Dividends per share
  • Other market ratios on your choice

These ratios are available on www.morningstar.com > Company’s page – under Valuation, Financials, and under Dividends
You can find these ratios in the Internet or calculate them. If you use published ratios you must indicate that and cite their source.

  1. Present the market ratios as the table(s) in your project.
  2. Write about 1 page of analysis of the market ratio results that you found. Compare the market ratio results against the industry or main competitor. In your report please answer the question: Are the common stockholders receiving an adequate return on their investment?
  3. Compare the P/E ratio of your company with the industry average or 5-year average. Is the stock overvalued, undervalued, or properly valued? Why?  In accordance with your findings, is it reasonable to buy the stock? Please explain your answers.

-2) Analysis of the historical stock prices trend for the last year. (10% of the project grade)

  1. Collect and evaluate the data about stock prices of the assigned company for the last one year for the company and its major competitor.
  2. Create the chart(s) using the stock price chart tools on the websites or Excel. Present the chart(s) in your project.
  3. Write about 0.5 page of analysis the historic stock prices trend for the last year.

3) Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on THE COMPANY stock. Note that you will need the risk-free rate and the market return. Show this information in your project. (15% of the project grade)
1. Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on stock. Note that you will need the risk-free rate, beta, and the market return.
a) To get the current yield on 10-year Treasury securities go to www.finance.yahoo.com -click on Markets – U.S. Treasury Bonds Rates.  You will use the current yield on 10-year Treasury securities as the risk-free rate to estimate the required rate of return on stocks. Discuss how appropriate this rate is as a measure of risk.
b) Between 1926 and 2017, the compound annual rate of return of S&P 500 is estimated a 6.5%. We will use this number as the market return. Discuss how appropriate this rate is as a measure of return.
c) Beta is listed in www.finance.yahoo.com and in www.morningstar.com on the company’s front page. What is the beta listed for the company? What does it mean?
d)  Calculate the required return on the stock using the Capital Asset Pricing Model (CAPM) Security Market Line. Please show your work.
2. There are several methods how to calculate the growth rate. One of the possible ways is to calculate the sustainable growth rate as g = ROE *(1- Dividend payout ratio). You can find ROE and the Dividend Payout Ratio on www.morningstar.com > Company’s page – under Financials and under Dividends
Calculate the company’s sustainable growth rate. Please show your work.
3. Apply the Gordon model (constant growth rate model) to calculate the intrinsic (economic) value of the stock. Please show your work.
Please note that for some companies it is not possible to use the Gordon model. If that is the case, please explain why it is not possible to use this model for your company. What other models is it possible to use?
4. Compare the result of your calculations with the current stock price. Is the stock overvalued, undervalued, or properly valued? Why?  In accordance with your findings, is it reasonable to buy the stock? Why? Please explain your answer.
–5- Develop a specific recommendation, with supporting rationale for your client, as to whether the assigned company’s recent trend in financial and stock performance is of sufficient financial strength to warrant entering in a long-term investment in bonds and/or stocks of the company. Explain your answer (about 1 page) (10% of the project grade).
-6- Develop a specific recommendation, with supporting rationale for the COMPANY’S management – Think about the financial strategy of the company, how to best balance THE COMPANY’S financial leverage to optimize shareholder wealth going forward taking into consideration the company’s current market position, credit rating, dividend policy, etc.  (10% of the project grade).
-7- Reflection – the students should write a paragraph in their own words reflecting on what they learned from the assignment and how they think they could apply what they learned in the workplace. (5% of the project grade).
PRESENTATION OF PAPER AND WRITING (15%) of the project grade):
-Organization, Format and Presentation of Paper including the Title page, Introduction, Body, and Summary. Each section of the paper must begin with a sub-heading. Please use the sub-headings included in the assignment (4% of the project grade)
Use of Tables, Figures and Other Graphics to Summarize and Support Analysis Presented in the Paper (3% of the project grade)
Logical and Smooth Flowing Transitions and Relationships among Sections of the Written Report (3% of the project grade)
Research Sources and Significance of Research Information and Data, Use of APA Citation Methodology (5% of the project grade)

Research project – Bond and Stock Performance Analysis

/0 Comments/in /by
FINC 330 Project Description
Research Project Part 2
This project is closely aligned with the Course Outcomes and Finance Program Objectives.  Completion of this project can be used as part of a portfolio to show potential employers the student is skilled at performing company valuations and financial statement analysis and can be included on the student’s resume.
Bond and Stock Performance Analysis
OBJECTIVE
In this part of the project you are to assume to have been hired to join a team serving as an internal financial analyst to THE COMPANY. Your client plans to invest in bonds and (or) stocks issued by THE COMPANY (SELECTED BY INSTRUCTOR). In part 6 of the assignment you are asked to provide some recommendations to THE COMPANY’S management.
THE COMPANY for part 2 of the project can be the company that you were using for the Research Project Part 1 or ANOTHER COMPANY determined by your professor. THE COMPANY for this part of the project must have bonds listed on the website http://finra-markets.morningstar.com/BondCenter/Default.jsp. To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.
Alternatively, you can request approval of another publicly traded company. This request must be submitted before the end of the first week of the course. The request must include

  • identification of the company by ticker symbol and name
  • a reasonable and appropriate explanation of why you want to examine the alternative company
  • the source of the analyst’s report that will be used in the analysis (which must be submitted to me)
  • acknowledgement by you that all the specific elements of the assignment (see below) will be prepared by you and included in the final research project report

SUGGESTED WEBSITES
www.morningstar.com – To find the information for your company you need to type the stock symbol in the Quotes window to get into the company’s page.
http://finra-markets.morningstar.com/BondCenter/Default.jsp – To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.
https://markets.businessinsider.com/bonds. To find the information on bonds, scroll down the page, type the name of the company in the window under Bond Finder, and click SEARCH.
www.marketwatch.com  -To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
www.money.cnn.com  -To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
www.finance.yahoo.com – To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
www.nyse.com – Click on Data, then click on Stocks (under Quotes), and type the name of the company or the stock symbol in the window “Keyword or symbol” to get into the company’s page.
www.nasdaq.com – To find the information for your company you need to type the stock symbol in the Search window to get into the company’s page.
Company’s websites
YOUR SPECIFIC ASSIGNMENT
Using the information from the websites the student will develop evaluation of bond and stock performance for THE COMPANY (SELECTED BY INSTRUCTOR). (The evaluation portion will total 85% of the assignment grade)
-1—Background and Industry (one short paragraph).
-2- The financial leverage ratios (10% of the project grade)
a) Find the financial leverage ratios for THE COMPANY assigned for you of the project for the last 3-5 years in the Internet. Present these ratios as the table(s) in your project.
You can find these ratios in the Internet or calculate them. If you use published ratios you must indicate that and cite their source.

  • Debt-to-assets ratio (Debt ratio)
  • Debt-to Equity ratio
  • Interest Coverage ratio (the Times Interest Earned)

b) Write (about) 1 page of the analysis of the ratio results. In your analysis you should answer the following questions. Please explain your answer to each question.
How is THE COMPANY financing its assets? Discuss how much risk is associated with the bonds issued by the company? How can this risk be measured? Please explain.
-3- Collect and evaluate the data about bond performance of the assigned company. (15% of the project grade).
The information on bonds can be found on the website http://finra-markets.morningstar.com/BondCenter/Default.jsp. To find the information on bonds, click on Search in the middle of the screen (under Market Center Bond Guide), under Quick Search type the Issuer Name and the Symbol, and click SHOW RESULTS.
Another useful website on bond information is https://markets.businessinsider.com/bonds. To find the information on bonds, scroll down the page, type the name of the company in the window under Bond Finder, and click SEARCH.
Copy the quotations of two bonds issued by THE COMPANY (SELECTED BY INSTRUCTOR) that contain the Price. Present these quotations in your project.

  1. Assume that par value of the bond is $1,000. What were the last prices of the bonds in $$$ (listed in the Price column)? Show your work in your project.
  2. Assume that par value of the bond is $1,000. Calculate the annual coupon interest payments. Show your work in your project.
  3. Assume that par value of the bond is $1,000. Calculate the current yield of the bonds. Show your work in your project.
  4. Write a 1-2 page of the analysis of the bonds. In your analysis you should answer the following questions. Please explain your answer to each question.
    1. How much is the YTM listed in quotations is for the bonds? Explain the meaning of YTM.
    2. If you are going to buy a bond issued by THE COMPANY, which bond would you choose? Why?
    3. Are these bonds callable? If the bonds that you chose are callable (non-callable), will it change your decision to buy them?
    4. If you are an investor who is looking for a bond to invest in, are you going to buy a bond that you chose? Take a look at the balance sheet and income statement of the company. What data or ratios support your decision to buy this bond or not? You may want to incorporate the results of the Research Project Part 1, as well as the results of the financial leverage ratios to answer this question. You should develop a specific recommendation, with supporting rationale to explain your answer.

-4- Collect and evaluate the data about stock performance of the assigned company for the last one year. (totally 35% of the project grade).
1) Find the market ratios for the company for the last 1-3 years and its major competitor for the last year in the Internet. (10% of the project grade)

  • Price/Earnings ratio
  • Market/Book ratio (also called (Price/Book ratio)
  • Earnings per share
  • Dividends per share
  • Other market ratios on your choice

These ratios are available on www.morningstar.com > Company’s page – under Valuation, Financials, and under Dividends
You can find these ratios in the Internet or calculate them. If you use published ratios you must indicate that and cite their source.

  1. Present the market ratios as the table(s) in your project.
  2. Write about 1 page of analysis of the market ratio results that you found. Compare the market ratio results against the industry or main competitor. In your report please answer the question: Are the common stockholders receiving an adequate return on their investment?
  3. Compare the P/E ratio of your company with the industry average or 5-year average. Is the stock overvalued, undervalued, or properly valued? Why?  In accordance with your findings, is it reasonable to buy the stock? Please explain your answers.

-2) Analysis of the historical stock prices trend for the last year. (10% of the project grade)

  1. Collect and evaluate the data about stock prices of the assigned company for the last one year for the company and its major competitor.
  2. Create the chart(s) using the stock price chart tools on the websites or Excel. Present the chart(s) in your project.
  3. Write about 0.5 page of analysis the historic stock prices trend for the last year.

3) Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on THE COMPANY stock. Note that you will need the risk-free rate and the market return. Show this information in your project. (15% of the project grade)
1. Apply the Capital Asset Pricing Model (CAPM) Security Market Line to estimate the required return on stock. Note that you will need the risk-free rate, beta, and the market return.
a) To get the current yield on 10-year Treasury securities go to www.finance.yahoo.com -click on Markets – U.S. Treasury Bonds Rates.  You will use the current yield on 10-year Treasury securities as the risk-free rate to estimate the required rate of return on stocks. Discuss how appropriate this rate is as a measure of risk.
b) Between 1926 and 2017, the compound annual rate of return of S&P 500 is estimated a 6.5%. We will use this number as the market return. Discuss how appropriate this rate is as a measure of return.
c) Beta is listed in www.finance.yahoo.com and in www.morningstar.com on the company’s front page. What is the beta listed for the company? What does it mean?
d)  Calculate the required return on the stock using the Capital Asset Pricing Model (CAPM) Security Market Line. Please show your work.
2. There are several methods how to calculate the growth rate. One of the possible ways is to calculate the sustainable growth rate as g = ROE *(1- Dividend payout ratio). You can find ROE and the Dividend Payout Ratio on www.morningstar.com > Company’s page – under Financials and under Dividends
Calculate the company’s sustainable growth rate. Please show your work.
3. Apply the Gordon model (constant growth rate model) to calculate the intrinsic (economic) value of the stock. Please show your work.
Please note that for some companies it is not possible to use the Gordon model. If that is the case, please explain why it is not possible to use this model for your company. What other models is it possible to use?
4. Compare the result of your calculations with the current stock price. Is the stock overvalued, undervalued, or properly valued? Why?  In accordance with your findings, is it reasonable to buy the stock? Why? Please explain your answer.
–5- Develop a specific recommendation, with supporting rationale for your client, as to whether the assigned company’s recent trend in financial and stock performance is of sufficient financial strength to warrant entering in a long-term investment in bonds and/or stocks of the company. Explain your answer (about 1 page) (10% of the project grade).
-6- Develop a specific recommendation, with supporting rationale for the COMPANY’S management – Think about the financial strategy of the company, how to best balance THE COMPANY’S financial leverage to optimize shareholder wealth going forward taking into consideration the company’s current market position, credit rating, dividend policy, etc.  (10% of the project grade).
-7- Reflection – the students should write a paragraph in their own words reflecting on what they learned from the assignment and how they think they could apply what they learned in the workplace. (5% of the project grade).
PRESENTATION OF PAPER AND WRITING (15%) of the project grade):
-Organization, Format and Presentation of Paper including the Title page, Introduction, Body, and Summary. Each section of the paper must begin with a sub-heading. Please use the sub-headings included in the assignment (4% of the project grade)
Use of Tables, Figures and Other Graphics to Summarize and Support Analysis Presented in the Paper (3% of the project grade)
Logical and Smooth Flowing Transitions and Relationships among Sections of the Written Report (3% of the project grade)
Research Sources and Significance of Research Information and Data, Use of APA Citation Methodology (5% of the project grade)

What is EMDR Therapy?

/0 Comments/in /by
Research the website on What is EMDR Therapy on the emdria.org site
https://www.emdria.org/page/EMDREarlyIntervention
After researching the site, Write a 3-4 paper on the following
Ø what is EMDR therapy
Ø what is EMDR early intervention,
Ø EMDR Training and Certification and the process
Ø Tell me what you have learned and what to gain from learning and practicing EMDR therapy to Veterans with combat trauma
You do not need to create an account or sign in. You can navigate and search through the tabs in the site.
 
APA format and intext Citations and References
References to use
EMDR International Association. (2020). What is EMDR therapy?. Retrieved from https://www.emdria.org/
EMDR International Association. (2020). Combat Trauma . Retrieved from https://www.emdria.org/page/CombatTrauma

What is EMDR Therapy?

/0 Comments/in /by
Research the website on What is EMDR Therapy on the emdria.org site
https://www.emdria.org/page/EMDREarlyIntervention
After researching the site, Write a 3-4 paper on the following
Ø what is EMDR therapy
Ø what is EMDR early intervention,
Ø EMDR Training and Certification and the process
Ø Tell me what you have learned and what to gain from learning and practicing EMDR therapy to Veterans with combat trauma
You do not need to create an account or sign in. You can navigate and search through the tabs in the site.
 
APA format and intext Citations and References
References to use
EMDR International Association. (2020). What is EMDR therapy?. Retrieved from https://www.emdria.org/
EMDR International Association. (2020). Combat Trauma . Retrieved from https://www.emdria.org/page/CombatTrauma

Sustainable Urban Development, Governance And Policy: A Comparative Overview Of EU Policies And Projects

/0 Comments/in /by
This will be a detailed summary of the research paper of at least 2 papers without abstract and references, and what you gained from the research.  Each week, you will find an article/peer-reviewed research paper that pertains “sustainable urban development, Governance and policy: A comparative overview of EU policies and projects”
The paper should contain in-text citations of (Abstract, body, conclusion), and References. Paper selection should be after 2015.
NOTE: All outside sources must be referenced and cited in your paper.  All papers will be reviewed with plagiarism software. Any references not properly referenced and cited will result in a 0 on your paper. Multiple violations will result in a failure for the course!

Sustainable Urban Development, Governance And Policy: A Comparative Overview Of EU Policies And Projects

/0 Comments/in /by
This will be a detailed summary of the research paper of at least 2 papers without abstract and references, and what you gained from the research.  Each week, you will find an article/peer-reviewed research paper that pertains “sustainable urban development, Governance and policy: A comparative overview of EU policies and projects”
The paper should contain in-text citations of (Abstract, body, conclusion), and References. Paper selection should be after 2015.
NOTE: All outside sources must be referenced and cited in your paper.  All papers will be reviewed with plagiarism software. Any references not properly referenced and cited will result in a 0 on your paper. Multiple violations will result in a failure for the course!

Risk Management Strategies (Research)

/0 Comments/in /by

Pick a topic relevant to Risk Management Strategies and write a 10 page paper.  The format of your paper will need to follow the following outline in APA format (include title page, abstract page, content pages, and reference page):
INTRODUCTION

  • State the topic you are attempting to cover
  • State the issues involved
  • State why we should be concerned with resolving whatever issues are involved
  • State how answering the issues will help us
  • State the implications and consequences of dealing with or resolving the issues involved

REVIEW OF THE LITERATURE (5 sources minimal, at least 3 needs to be peer-reviewed)
Identify who has tried to answer the question before by doing the following:

  • Summarize how each of the sources presents and deals with the subject
  • Explain how each source presents and deals with its findings or results
  • Explain the relevancy of each source to your topic
  • State what you learned from each of your sources
  • State in what way(s) each source contributes to answering your issues

DISCUSSION

  • State your answer to your issue
  • State how and elaborate on how, explain how, illustrate how each of the sources you previously reviewed help you answer your issue
  • State what questions about your topic you still have that your sources may not have answered

CONCLUSIONS

  • Indicate how each of the sources have contributed to your conclusions (and clearly, accurately, correctly document those sources within your text)
  • State the implications of your conclusions
  • State what might be the possible consequences of your conclusions
  • State the significance these implications and consequences might have in the information technology / information security realm

DOCUMENTATION

  • On a separate page, include a section labeled References which provides the full publication information for all the sources you used in your paper
  • You should have a MINIMUM of five (5) sources for your paper, at least 3 source needs to be peer-reviewed
  • Not meeting this minimum requirement of five (5) sources will lead to a lower evaluation of your paper for each missing source
  • Use APA format for documenting your sources

Statistical Analysis of Data Using MINITAB

/0 Comments/in , /by
Statistical Analysis of Data Using MINITAB
Deadline: 5pm Monday 16th October 2017
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.
This dataset includes 392 observations, taken at the individual level and available from
diabetes_dataset.xlsx file in Statistical Data Analysis Coursework folder on NOW.
The key indicator of diabetes (response variable), as defined by the World Health
Organization, is a plasma glucose concentration greater than 200 mg/dl two hours
following ingestion of a 75 gm carbohydrate solution (variable Glucose).
The  explanatory variables (or predictors) are known risk factors for diabetes: number of
pregnancies, diastolic blood pressure, triceps skinfold thickness (an indicator of
bodyfat), 2 hour serum insulin, body mass index, age, and diabetes pedigree function
(see Table).
Table. Measurements recorded in the dataset,
Measurement/variables Description
Glucose plasma glucose concentration 2 hours in an
oral glucose tolerance test
Pregnancies number of times pregnant
BloodPressure diastolic blood pressure (mm Hg)
SkinThickness triceps skin fold thickness (mm)
Insulin 2-Hour serum insulin (mu U/ml)
BMI body mass index (weight in kg/(height in m)2
)
DiabetesPedigreeFunction diabetes pedigree function*
Age age (years)
Outcome class variable (0 or 1)**
* a synthesis of diabetes history in an individual’s relatives
**negative (0)/positive (1) diabetes test
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.
(1 mark)
(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->….)
(2 mark)
(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.
(1 mark)
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.
(6 marks)
(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.
(3 marks)
(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.
(10 marks)
(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.
(10 marks)
(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.
(4 marks)
(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.
(4 marks)
(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.
(4 marks)
(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.
(6 marks)
(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.
(9 marks)

Glucose Pregnancies BloodPressure SkinThickness Insulin BMI DiabetesPedigreeFunction Age Outcome
56 2 56 28 45 24.2 0.332 22 0
68 2 62 13 15 20.1 0.257 23 0
68 2 70 32 66 25 0.187 25 0
68 10 106 23 49 35.5 0.285 47 0
71 1 48 18 76 20.4 0.323 22 0
71 1 78 50 45 33.2 0.422 21 0
74 0 52 10 36 27.8 0.269 22 0
74 3 68 28 45 29.7 0.293 23 0
74 8 70 40 49 35.3 0.705 39 0
75 2 64 24 55 29.7 0.37 33 0
77 1 56 30 56 33.3 1.251 24 0
77 5 82 41 42 35.8 0.156 35 0
78 3 50 32 88 31 0.248 26 1
78 0 88 29 40 36.9 0.434 21 0
79 1 80 25 37 25.4 0.583 22 0
79 1 60 42 48 43.5 0.678 23 0
80 1 74 11 60 30 0.527 22 0
80 3 82 31 70 34.2 1.292 27 1
81 1 72 18 40 26.6 0.283 24 0
81 3 86 16 66 27.5 0.306 22 0
81 2 72 15 76 30.1 0.547 25 0
81 1 74 41 57 46.3 1.096 32 0
81 7 78 40 48 46.7 0.261 42 0
82 1 64 13 95 21.2 0.415 23 0
82 2 52 22 115 28.5 1.699 25 0
83 7 78 26 71 29.3 0.767 36 0
83 2 66 23 50 32.2 0.497 22 0
83 3 58 31 18 34.3 0.336 25 0
83 2 65 28 66 36.8 0.629 24 0
84 2 50 23 76 30.4 0.968 21 0
84 3 68 30 106 31.9 0.591 25 0
84 0 64 22 66 35.8 0.545 21 0
84 1 64 23 115 36.9 0.471 28 0
84 0 82 31 125 38.2 0.233 23 0
84 4 90 23 56 39.5 0.159 25 0
85 4 58 22 49 27.8 0.306 28 0
86 5 68 28 71 30.2 0.364 24 0
86 1 66 52 65 41.3 0.917 29 0
87 2 58 16 52 32.7 0.166 25 0
87 1 78 27 32 34.6 0.101 22 0
87 1 60 37 75 37.2 0.509 22 0
87 1 68 34 77 37.6 0.401 24 0
88 5 66 21 23 24.4 0.342 30 0
88 3 58 11 54 24.8 0.267 22 0
88 2 58 26 16 28.4 0.766 22 0
88 2 74 19 53 29 0.229 22 0
88 1 62 24 44 29.9 0.422 23 0
88 1 78 29 76 32 0.365 29 0
88 12 74 40 54 35.3 0.378 48 0
88 1 30 42 99 55 0.496 26 1
89 1 24 19 25 27.8 0.559 21 0
89 1 66 23 94 28.1 0.167 21 0
89 3 74 16 85 30.4 0.551 38 0
89 1 76 34 37 31.2 0.192 23 0
90 2 80 14 55 24.4 0.249 24 0
90 1 62 18 59 25.1 1.268 25 0
90 1 62 12 43 27.2 0.58 24 0
90 4 88 47 54 37.7 0.362 29 0
91 1 54 25 100 25.2 0.234 23 0
91 4 70 32 88 33.1 0.446 22 0
91 0 68 32 210 39.9 0.381 25 0
92 1 62 25 41 19.5 0.482 25 0
92 12 62 7 258 27.6 0.926 44 1
92 6 62 32 126 32 0.085 46 0
93 0 60 25 92 28.7 0.532 22 0
93 6 50 30 64 28.7 0.356 23 0
93 2 64 32 160 38 0.674 23 1
93 0 100 39 72 43.4 1.021 35 0
94 2 68 18 76 26 0.561 21 0
94 2 76 18 66 31.6 0.649 23 0
94 7 64 25 79 33.3 0.738 41 0
94 0 70 27 115 43.5 0.347 21 0
95 1 66 13 38 19.6 0.334 25 0
95 1 60 18 58 23.9 0.26 22 0
95 1 74 21 73 25.9 0.673 36 0
95 2 54 14 88 26.1 0.748 22 0
95 1 82 25 180 35 0.233 43 1
95 0 80 45 92 36.5 0.33 26 0
95 0 85 25 36 37.4 0.247 24 1
95 0 64 39 105 44.6 0.366 22 0
96 4 56 17 49 20.8 0.34 26 0
96 2 68 13 49 21.1 0.647 26 0
96 3 56 34 115 24.7 0.944 39 0
96 1 64 27 87 33.2 0.289 21 0
96 5 74 18 67 33.6 0.997 43 0
97 1 64 19 82 18.2 0.299 21 0
97 1 66 15 140 23.2 0.487 22 0
97 0 64 36 100 36.8 0.6 25 0
97 7 76 32 91 40.9 0.871 32 1
98 0 82 15 84 25.2 0.299 22 0
98 6 58 33 190 34 0.43 43 0
98 2 60 17 120 34.7 0.198 22 0
99 3 80 11 64 19.3 0.284 30 0
99 2 70 16 44 20.4 0.235 27 0
99 3 62 19 74 21.8 0.279 26 0
99 4 76 15 51 23.2 0.223 21 0
99 2 52 15 94 24.6 0.637 21 0
99 3 54 19 86 25.6 0.154 24 0
99 6 60 19 54 26.9 0.497 32 0
99 5 54 28 83 34 0.499 30 0
99 2 60 17 160 36.6 0.453 21 0
99 1 72 30 18 38.6 0.412 21 0
100 1 74 12 46 19.5 0.149 28 0
100 1 66 15 56 23.6 0.666 26 0
100 1 72 12 70 25.3 0.658 28 0
100 12 84 33 105 30 0.488 46 0
100 0 70 26 50 30.8 0.597 21 0
100 3 68 23 81 31.6 0.949 28 0
100 1 66 29 196 32 0.444 42 0
100 2 66 20 90 32.9 0.867 28 1
100 14 78 25 184 36.6 0.412 46 1
100 2 54 28 105 37.8 0.498 24 0
100 2 68 25 71 38.5 0.324 26 0
100 8 74 40 215 39.4 0.661 43 1
100 2 70 52 57 40.5 0.677 25 0
100 0 88 60 110 46.8 0.962 31 0
101 2 58 35 90 21.8 0.155 22 0
101 2 58 17 265 24.2 0.614 23 0
101 1 50 15 36 24.2 0.526 26 0
101 10 76 48 180 32.9 0.171 63 0
102 0 86 17 105 29.3 0.695 27 0
102 3 44 20 94 30.8 0.4 26 0
102 0 78 40 90 34.5 0.238 24 0
102 7 74 40 105 37.2 0.204 45 0
102 0 64 46 78 40.6 0.496 21 0
102 2 86 36 120 45.5 0.127 23 1
103 1 80 11 82 19.4 0.491 22 0
103 4 60 33 192 24 0.966 33 0
103 3 72 30 152 27.6 0.73 27 0
103 6 72 32 190 37.7 0.324 55 0
103 1 30 38 83 43.3 0.183 33 0
104 0 64 23 116 27.8 0.454 23 0
104 6 74 18 156 29.9 0.722 41 1
104 0 64 37 64 33.6 0.51 22 1
105 6 70 32 68 30.8 0.122 37 0
105 2 80 45 191 33.7 0.711 29 1
105 2 58 40 94 34.9 0.225 25 0
105 5 72 29 325 36.9 0.159 28 0
105 0 64 41 142 41.5 0.173 22 0
106 2 56 27 165 29 0.426 22 0
106 2 64 35 119 30.5 1.4 34 0
106 3 54 21 158 30.9 0.292 24 0
106 1 70 28 135 34.2 0.142 22 0
106 0 70 37 148 39.4 0.605 22 0
107 3 62 13 48 22.9 0.678 23 1
107 1 72 30 82 30.8 0.821 24 0
107 2 74 30 100 33.6 0.404 23 0
107 0 62 30 74 36.6 0.757 25 1
108 6 44 20 130 24 0.813 35 0
108 2 62 32 56 25.2 0.128 21 0
108 2 62 10 278 25.3 0.881 22 0
108 2 52 26 63 32.5 0.318 22 0
108 1 60 46 178 35.5 0.415 24 0
108 5 72 43 75 36.1 0.263 33 0
109 1 38 18 120 23.1 0.407 26 0
109 1 56 21 135 25.2 0.833 23 0
109 1 60 8 182 25.4 0.947 21 0
109 8 76 39 114 27.9 0.64 31 1
109 1 58 18 116 28.5 0.219 22 0
109 4 64 44 99 34.8 0.905 26 1
109 5 62 41 129 35.8 0.514 25 1
110 4 76 20 100 28.4 0.118 27 0
110 2 74 29 125 32.4 0.698 27 0
111 1 62 13 182 24 0.138 23 0
111 3 90 12 78 28.4 0.495 29 0
111 3 58 31 44 29.5 0.43 22 0
111 4 72 47 207 37.1 1.39 56 1
112 2 68 22 94 34.1 0.315 26 0
112 9 82 32 175 34.2 0.26 36 1
112 1 72 30 176 34.4 0.528 25 0
112 1 80 45 132 34.8 0.217 24 0
112 2 86 42 160 38.4 0.246 28 0
112 2 78 50 140 39.4 0.175 24 0
113 3 50 10 85 29.5 0.626 25 0
114 7 76 17 110 23.8 0.466 31 0
114 1 66 36 200 38.1 0.289 21 0
114 0 80 34 285 44.2 0.167 27 0
115 1 70 30 96 34.6 0.529 32 1
115 3 66 39 140 38.1 0.15 28 0
116 4 72 12 87 22.1 0.463 37 0
116 3 74 15 105 26.3 0.107 24 0
116 1 78 29 180 36.1 0.496 25 0
117 2 90 19 71 25.2 0.313 21 0
117 0 66 31 188 30.8 0.493 22 0
117 4 64 27 120 33.2 0.23 24 0
117 1 60 23 106 33.8 0.466 27 0
117 1 88 24 145 34.5 0.403 40 1
117 5 86 30 105 39.1 0.251 42 0
117 0 80 31 53 45.2 0.089 24 0
118 1 58 36 94 33.3 0.261 23 0
118 0 84 47 230 45.8 0.551 31 1
119 1 54 13 50 22.3 0.205 24 0
119 6 50 22 176 27.1 1.318 33 1
119 0 64 18 92 34.9 0.725 23 0
119 1 44 47 63 35.5 0.28 25 0
119 1 88 41 170 45.3 0.507 26 0
119 1 86 39 220 45.6 0.808 29 1
120 9 72 22 56 20.8 0.733 48 0
120 0 74 18 63 30.5 0.285 26 0
120 1 80 48 200 38.9 1.162 41 0
120 2 76 37 105 39.7 0.215 29 0
120 11 80 37 150 42.3 0.785 48 1
120 3 70 30 135 42.9 0.452 30 0
121 5 72 23 112 26.2 0.245 30 0
121 0 66 30 165 34.3 0.203 33 1
121 1 78 39 74 39 0.261 28 0
121 2 70 32 95 39.1 0.886 23 0
122 2 60 18 106 29.8 0.717 22 0
122 1 64 32 156 35.1 0.692 30 1
122 2 76 27 200 35.9 0.483 26 0
122 2 52 43 158 36.2 0.816 28 0
122 1 90 51 220 49.7 0.325 31 1
123 4 80 15 176 32 0.443 34 0
123 9 70 44 94 33.1 0.374 40 0
123 6 72 45 230 33.6 0.733 34 0
123 5 74 40 77 34.1 0.269 28 0
123 2 48 32 165 42.1 0.52 26 0
123 3 100 35 240 57.3 0.88 22 0
124 0 56 13 105 21.8 0.452 21 0
124 7 70 33 215 25.5 0.161 37 0
124 8 76 24 600 28.7 0.687 52 1
124 2 68 28 205 32.9 0.875 30 1
124 3 80 33 130 33.2 0.305 26 0
124 9 70 33 402 35.4 0.282 34 0
125 1 70 24 110 24.3 0.221 25 0
125 4 70 18 122 28.9 1.144 45 1
125 6 68 30 120 30 0.464 32 0
125 10 70 26 115 31.1 0.205 41 1
125 1 50 40 167 33.3 0.962 28 1
125 2 60 20 140 33.8 0.088 31 0
126 8 74 38 75 25.9 0.162 39 0
126 0 86 27 120 27.4 0.515 21 0
126 1 56 29 152 28.7 0.801 21 0
126 5 78 27 22 29.6 0.439 40 0
126 0 84 29 215 30.7 0.52 24 0
126 8 88 36 108 38.5 0.349 49 0
126 3 88 41 235 39.3 0.704 27 0
127 2 58 24 275 27.7 1.6 25 0
127 2 46 21 335 34.4 0.176 22 0
127 4 88 11 155 34.5 0.598 28 0
127 0 80 37 210 36.3 0.804 23 0
128 1 82 17 183 27.5 0.115 22 0
128 0 68 19 180 30.5 1.391 25 1
128 1 98 41 58 32 1.321 33 1
128 3 72 25 190 32.4 0.549 27 1
128 1 88 39 110 36.5 1.057 37 1
128 1 48 45 194 40.5 0.613 24 1
128 2 78 37 182 43.3 1.224 31 1
129 6 90 7 326 19.6 0.582 60 0
129 3 64 29 115 26.4 0.219 28 1
129 4 60 12 231 27.5 0.527 31 0
129 2 74 26 205 33.2 0.591 25 0
129 4 86 20 270 35.1 0.231 23 0
129 10 76 28 122 35.9 0.28 39 0
129 3 92 49 155 36.4 0.968 32 1
129 7 68 49 125 38.5 0.439 43 1
129 0 110 46 130 67.1 0.319 26 1
130 1 70 13 105 25.9 0.472 22 0
130 3 78 23 79 28.4 0.323 34 1
130 1 60 23 170 28.6 0.692 21 0
131 1 64 14 415 23.7 0.389 21 0
131 4 68 21 166 33.1 0.16 28 0
133 7 88 15 155 32.4 0.262 37 0
133 1 102 28 140 32.8 0.234 45 1
134 9 74 33 60 25.9 0.46 81 0
134 0 58 20 291 26.4 0.352 21 0
134 6 70 23 130 35.4 0.542 29 1
134 6 80 37 370 46.2 0.238 46 1
135 0 94 46 145 40.6 0.284 26 0
135 0 68 42 250 42.3 0.365 24 1
136 7 74 26 135 26 0.647 51 0
136 11 84 35 130 28.3 0.26 42 1
136 5 84 41 88 35 0.286 35 1
136 15 70 32 110 37.1 0.153 43 1
136 1 74 50 204 37.4 0.399 24 0
137 0 68 14 148 24.8 0.143 21 0
137 0 40 35 168 43.1 2.288 33 1
138 0 60 35 167 34.6 0.534 21 1
138 11 74 26 144 36.1 0.557 50 1
139 0 62 17 210 22.1 0.207 21 0
139 5 64 35 140 28.6 0.411 26 0
139 1 46 19 83 28.7 0.654 22 0
139 5 80 35 160 31.6 0.361 25 1
139 1 62 41 480 40.7 0.536 21 0
140 1 74 26 180 24.1 0.828 23 0
140 12 82 43 325 39.2 0.528 58 1
140 0 65 26 130 42.6 0.431 24 1
141 2 58 34 128 25.4 0.699 24 0
142 2 82 18 64 24.7 0.761 21 0
142 7 60 33 190 28.8 0.687 61 0
142 7 90 24 480 30.4 0.128 43 1
143 1 74 22 61 26.2 0.256 21 0
143 1 86 30 330 30.1 0.892 23 0
143 11 94 33 146 36.6 0.254 51 1
143 1 84 23 310 42.4 1.076 22 0
144 4 58 28 140 29.5 0.287 37 0
144 2 58 33 135 31.6 0.422 25 1
144 5 82 26 285 32 0.452 58 1
144 6 72 27 228 33.9 0.255 40 0
144 1 82 46 180 46.1 0.335 46 1
145 13 82 19 110 22.2 0.245 57 0
145 9 88 34 165 30.3 0.771 53 1
145 9 80 46 130 37.9 0.637 40 1
146 2 70 38 360 28 0.337 29 1
146 4 85 27 100 28.9 0.189 27 0
146 2 76 35 194 38.2 0.329 29 0
147 4 74 25 293 34.9 0.385 30 0
148 4 60 27 318 30.9 0.15 29 1
148 10 84 48 237 37.6 1.001 51 1
149 1 68 29 127 29.3 0.349 42 1
150 7 66 42 342 34.7 0.718 42 0
150 7 78 29 126 35.2 0.692 54 1
151 6 62 31 120 35.5 0.692 28 0
151 12 70 40 271 41.8 0.742 38 1
151 8 78 32 210 42.9 0.516 36 1
152 13 90 33 29 26.8 0.731 43 1
152 9 78 34 171 34.2 0.893 33 1
152 0 82 39 272 41.5 0.27 27 0
153 1 82 42 485 40.6 0.687 23 0
153 13 88 37 140 40.6 1.174 39 0
154 6 74 32 193 29.3 0.839 39 0
154 9 78 30 100 30.9 0.164 45 0
154 4 72 29 126 31.3 0.338 37 0
154 4 62 31 284 32.8 0.237 23 0
154 6 78 41 140 46.1 0.571 27 0
155 2 74 17 96 26.6 0.433 27 1
155 11 76 28 150 33.3 1.353 51 1
155 8 62 26 495 34 0.543 46 1
155 2 52 27 540 38.7 0.24 25 1
155 5 84 44 545 38.7 0.619 34 0
156 9 86 28 155 34.3 1.189 42 1
157 1 72 21 168 25.6 0.123 24 0
157 2 74 35 440 39.4 0.134 30 0
158 3 64 13 387 31.2 0.295 24 0
158 3 76 36 245 31.6 0.851 28 1
158 3 70 30 328 35.5 0.344 35 1
158 5 84 41 210 39.4 0.395 29 1
160 7 54 32 175 30.5 0.588 39 1
161 10 68 23 132 25.5 0.326 47 1
162 0 76 56 100 53.2 0.759 25 1
163 3 70 18 105 31.6 0.268 28 1
163 17 72 41 114 40.9 0.817 47 1
164 1 82 43 67 32.8 0.341 50 0
165 6 68 26 168 33.6 0.631 49 0
165 0 76 43 255 47.9 0.259 26 0
165 0 90 33 680 52.3 0.427 23 0
166 5 72 19 175 25.8 0.587 51 1
167 1 74 17 144 23.4 0.447 33 1
167 8 106 46 231 37.6 0.165 43 1
168 7 88 42 321 38.2 0.787 40 1
169 3 74 19 125 29.9 0.268 31 1
170 3 64 37 225 34.5 0.356 30 1
171 3 72 33 135 33.3 0.199 24 1
171 9 110 24 240 45.4 0.721 54 1
172 1 68 49 579 42.4 0.702 28 1
173 4 70 14 168 29.7 0.361 33 1
173 3 78 39 185 33.8 0.97 31 1
173 3 84 33 474 35.7 0.258 22 1
173 3 82 48 465 38.4 2.137 25 1
173 0 78 32 265 46.5 1.159 58 0
174 3 58 22 194 32.9 0.593 36 1
174 2 88 37 120 44.5 0.646 24 1
176 3 86 27 156 33.3 1.154 52 1
176 8 90 34 300 33.7 0.467 58 1
177 0 60 29 478 34.6 1.072 21 1
179 8 72 42 130 32.7 0.719 36 1
179 0 50 36 159 37.8 0.455 22 1
180 3 64 25 70 34 0.271 26 0
180 0 90 26 90 36.5 0.314 35 1
180 0 78 63 14 59.4 2.42 25 1
181 8 68 36 495 30.1 0.615 60 1
181 1 64 30 180 34.1 0.328 38 1
181 7 84 21 192 35.9 0.586 51 1
181 1 78 42 293 40 1.258 22 1
181 0 88 44 510 43.3 0.222 26 1
184 4 78 39 277 37 0.264 31 1
186 8 90 35 225 34.5 0.423 37 1
187 7 50 33 392 33.9 0.826 34 1
187 3 70 22 200 36.4 0.408 36 1
187 7 68 39 304 37.7 0.254 41 1
187 5 76 27 207 43.6 1.034 53 1
188 0 82 14 185 32 0.682 22 1
189 1 60 23 846 30.1 0.398 59 1
189 5 64 33 325 31.2 0.583 29 1
191 3 68 15 130 30.9 0.299 34 0
193 1 50 16 375 25.9 0.655 24 0
195 7 70 33 145 25.1 0.163 55 1
196 1 76 36 249 36.5 0.875 29 1
196 8 76 29 280 37.5 0.605 57 1
197 2 70 45 543 30.5 0.158 53 1
197 4 70 39 744 36.7 2.329 31 0
198 0 66 32 274 41.3 0.502 28 1

MINITAB Statistical Analysis of Data get help

/0 Comments/in , /by
MINITAB Statistical Analysis of Data get help
Deadline: 5pm Monday 16th October 2017
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.
This dataset includes 392 observations, taken at the individual level and available from
diabetes_dataset.xlsx file in Statistical Data Analysis Coursework folder on NOW.
The key indicator of diabetes (response variable), as defined by the World Health
Organization, is a plasma glucose concentration greater than 200 mg/dl two hours
following ingestion of a 75 gm carbohydrate solution (variable Glucose).
The  explanatory variables (or predictors) are known risk factors for diabetes: number of
pregnancies, diastolic blood pressure, triceps skinfold thickness (an indicator of
bodyfat), 2 hour serum insulin, body mass index, age, and diabetes pedigree function
(see Table).
Table. Measurements recorded in the dataset,
Measurement/variables Description
Glucose plasma glucose concentration 2 hours in an
oral glucose tolerance test
Pregnancies number of times pregnant
BloodPressure diastolic blood pressure (mm Hg)
SkinThickness triceps skin fold thickness (mm)
Insulin 2-Hour serum insulin (mu U/ml)
BMI body mass index (weight in kg/(height in m)2
)
DiabetesPedigreeFunction diabetes pedigree function*
Age age (years)
Outcome class variable (0 or 1)**
* a synthesis of diabetes history in an individual’s relatives
**negative (0)/positive (1) diabetes test
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.
(1 mark)
(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->….)
(2 mark)
(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.
(1 mark)
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.
(6 marks)
(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.
(3 marks)
(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.
(10 marks)
(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.
(10 marks)
(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.
(4 marks)
(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.
(4 marks)
(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.
(4 marks)
(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.
(6 marks)
(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.
(9 marks)

Glucose Pregnancies BloodPressure SkinThickness Insulin BMI DiabetesPedigreeFunction Age Outcome
56 2 56 28 45 24.2 0.332 22 0
68 2 62 13 15 20.1 0.257 23 0
68 2 70 32 66 25 0.187 25 0
68 10 106 23 49 35.5 0.285 47 0
71 1 48 18 76 20.4 0.323 22 0
71 1 78 50 45 33.2 0.422 21 0
74 0 52 10 36 27.8 0.269 22 0
74 3 68 28 45 29.7 0.293 23 0
74 8 70 40 49 35.3 0.705 39 0
75 2 64 24 55 29.7 0.37 33 0
77 1 56 30 56 33.3 1.251 24 0
77 5 82 41 42 35.8 0.156 35 0
78 3 50 32 88 31 0.248 26 1
78 0 88 29 40 36.9 0.434 21 0
79 1 80 25 37 25.4 0.583 22 0
79 1 60 42 48 43.5 0.678 23 0
80 1 74 11 60 30 0.527 22 0
80 3 82 31 70 34.2 1.292 27 1
81 1 72 18 40 26.6 0.283 24 0
81 3 86 16 66 27.5 0.306 22 0
81 2 72 15 76 30.1 0.547 25 0
81 1 74 41 57 46.3 1.096 32 0
81 7 78 40 48 46.7 0.261 42 0
82 1 64 13 95 21.2 0.415 23 0
82 2 52 22 115 28.5 1.699 25 0
83 7 78 26 71 29.3 0.767 36 0
83 2 66 23 50 32.2 0.497 22 0
83 3 58 31 18 34.3 0.336 25 0
83 2 65 28 66 36.8 0.629 24 0
84 2 50 23 76 30.4 0.968 21 0
84 3 68 30 106 31.9 0.591 25 0
84 0 64 22 66 35.8 0.545 21 0
84 1 64 23 115 36.9 0.471 28 0
84 0 82 31 125 38.2 0.233 23 0
84 4 90 23 56 39.5 0.159 25 0
85 4 58 22 49 27.8 0.306 28 0
86 5 68 28 71 30.2 0.364 24 0
86 1 66 52 65 41.3 0.917 29 0
87 2 58 16 52 32.7 0.166 25 0
87 1 78 27 32 34.6 0.101 22 0
87 1 60 37 75 37.2 0.509 22 0
87 1 68 34 77 37.6 0.401 24 0
88 5 66 21 23 24.4 0.342 30 0
88 3 58 11 54 24.8 0.267 22 0
88 2 58 26 16 28.4 0.766 22 0
88 2 74 19 53 29 0.229 22 0
88 1 62 24 44 29.9 0.422 23 0
88 1 78 29 76 32 0.365 29 0
88 12 74 40 54 35.3 0.378 48 0
88 1 30 42 99 55 0.496 26 1
89 1 24 19 25 27.8 0.559 21 0
89 1 66 23 94 28.1 0.167 21 0
89 3 74 16 85 30.4 0.551 38 0
89 1 76 34 37 31.2 0.192 23 0
90 2 80 14 55 24.4 0.249 24 0
90 1 62 18 59 25.1 1.268 25 0
90 1 62 12 43 27.2 0.58 24 0
90 4 88 47 54 37.7 0.362 29 0
91 1 54 25 100 25.2 0.234 23 0
91 4 70 32 88 33.1 0.446 22 0
91 0 68 32 210 39.9 0.381 25 0
92 1 62 25 41 19.5 0.482 25 0
92 12 62 7 258 27.6 0.926 44 1
92 6 62 32 126 32 0.085 46 0
93 0 60 25 92 28.7 0.532 22 0
93 6 50 30 64 28.7 0.356 23 0
93 2 64 32 160 38 0.674 23 1
93 0 100 39 72 43.4 1.021 35 0
94 2 68 18 76 26 0.561 21 0
94 2 76 18 66 31.6 0.649 23 0
94 7 64 25 79 33.3 0.738 41 0
94 0 70 27 115 43.5 0.347 21 0
95 1 66 13 38 19.6 0.334 25 0
95 1 60 18 58 23.9 0.26 22 0
95 1 74 21 73 25.9 0.673 36 0
95 2 54 14 88 26.1 0.748 22 0
95 1 82 25 180 35 0.233 43 1
95 0 80 45 92 36.5 0.33 26 0
95 0 85 25 36 37.4 0.247 24 1
95 0 64 39 105 44.6 0.366 22 0
96 4 56 17 49 20.8 0.34 26 0
96 2 68 13 49 21.1 0.647 26 0
96 3 56 34 115 24.7 0.944 39 0
96 1 64 27 87 33.2 0.289 21 0
96 5 74 18 67 33.6 0.997 43 0
97 1 64 19 82 18.2 0.299 21 0
97 1 66 15 140 23.2 0.487 22 0
97 0 64 36 100 36.8 0.6 25 0
97 7 76 32 91 40.9 0.871 32 1
98 0 82 15 84 25.2 0.299 22 0
98 6 58 33 190 34 0.43 43 0
98 2 60 17 120 34.7 0.198 22 0
99 3 80 11 64 19.3 0.284 30 0
99 2 70 16 44 20.4 0.235 27 0
99 3 62 19 74 21.8 0.279 26 0
99 4 76 15 51 23.2 0.223 21 0
99 2 52 15 94 24.6 0.637 21 0
99 3 54 19 86 25.6 0.154 24 0
99 6 60 19 54 26.9 0.497 32 0
99 5 54 28 83 34 0.499 30 0
99 2 60 17 160 36.6 0.453 21 0
99 1 72 30 18 38.6 0.412 21 0
100 1 74 12 46 19.5 0.149 28 0
100 1 66 15 56 23.6 0.666 26 0
100 1 72 12 70 25.3 0.658 28 0
100 12 84 33 105 30 0.488 46 0
100 0 70 26 50 30.8 0.597 21 0
100 3 68 23 81 31.6 0.949 28 0
100 1 66 29 196 32 0.444 42 0
100 2 66 20 90 32.9 0.867 28 1
100 14 78 25 184 36.6 0.412 46 1
100 2 54 28 105 37.8 0.498 24 0
100 2 68 25 71 38.5 0.324 26 0
100 8 74 40 215 39.4 0.661 43 1
100 2 70 52 57 40.5 0.677 25 0
100 0 88 60 110 46.8 0.962 31 0
101 2 58 35 90 21.8 0.155 22 0
101 2 58 17 265 24.2 0.614 23 0
101 1 50 15 36 24.2 0.526 26 0
101 10 76 48 180 32.9 0.171 63 0
102 0 86 17 105 29.3 0.695 27 0
102 3 44 20 94 30.8 0.4 26 0
102 0 78 40 90 34.5 0.238 24 0
102 7 74 40 105 37.2 0.204 45 0
102 0 64 46 78 40.6 0.496 21 0
102 2 86 36 120 45.5 0.127 23 1
103 1 80 11 82 19.4 0.491 22 0
103 4 60 33 192 24 0.966 33 0
103 3 72 30 152 27.6 0.73 27 0
103 6 72 32 190 37.7 0.324 55 0
103 1 30 38 83 43.3 0.183 33 0
104 0 64 23 116 27.8 0.454 23 0
104 6 74 18 156 29.9 0.722 41 1
104 0 64 37 64 33.6 0.51 22 1
105 6 70 32 68 30.8 0.122 37 0
105 2 80 45 191 33.7 0.711 29 1
105 2 58 40 94 34.9 0.225 25 0
105 5 72 29 325 36.9 0.159 28 0
105 0 64 41 142 41.5 0.173 22 0
106 2 56 27 165 29 0.426 22 0
106 2 64 35 119 30.5 1.4 34 0
106 3 54 21 158 30.9 0.292 24 0
106 1 70 28 135 34.2 0.142 22 0
106 0 70 37 148 39.4 0.605 22 0
107 3 62 13 48 22.9 0.678 23 1
107 1 72 30 82 30.8 0.821 24 0
107 2 74 30 100 33.6 0.404 23 0
107 0 62 30 74 36.6 0.757 25 1
108 6 44 20 130 24 0.813 35 0
108 2 62 32 56 25.2 0.128 21 0
108 2 62 10 278 25.3 0.881 22 0
108 2 52 26 63 32.5 0.318 22 0
108 1 60 46 178 35.5 0.415 24 0
108 5 72 43 75 36.1 0.263 33 0
109 1 38 18 120 23.1 0.407 26 0
109 1 56 21 135 25.2 0.833 23 0
109 1 60 8 182 25.4 0.947 21 0
109 8 76 39 114 27.9 0.64 31 1
109 1 58 18 116 28.5 0.219 22 0
109 4 64 44 99 34.8 0.905 26 1
109 5 62 41 129 35.8 0.514 25 1
110 4 76 20 100 28.4 0.118 27 0
110 2 74 29 125 32.4 0.698 27 0
111 1 62 13 182 24 0.138 23 0
111 3 90 12 78 28.4 0.495 29 0
111 3 58 31 44 29.5 0.43 22 0
111 4 72 47 207 37.1 1.39 56 1
112 2 68 22 94 34.1 0.315 26 0
112 9 82 32 175 34.2 0.26 36 1
112 1 72 30 176 34.4 0.528 25 0
112 1 80 45 132 34.8 0.217 24 0
112 2 86 42 160 38.4 0.246 28 0
112 2 78 50 140 39.4 0.175 24 0
113 3 50 10 85 29.5 0.626 25 0
114 7 76 17 110 23.8 0.466 31 0
114 1 66 36 200 38.1 0.289 21 0
114 0 80 34 285 44.2 0.167 27 0
115 1 70 30 96 34.6 0.529 32 1
115 3 66 39 140 38.1 0.15 28 0
116 4 72 12 87 22.1 0.463 37 0
116 3 74 15 105 26.3 0.107 24 0
116 1 78 29 180 36.1 0.496 25 0
117 2 90 19 71 25.2 0.313 21 0
117 0 66 31 188 30.8 0.493 22 0
117 4 64 27 120 33.2 0.23 24 0
117 1 60 23 106 33.8 0.466 27 0
117 1 88 24 145 34.5 0.403 40 1
117 5 86 30 105 39.1 0.251 42 0
117 0 80 31 53 45.2 0.089 24 0
118 1 58 36 94 33.3 0.261 23 0
118 0 84 47 230 45.8 0.551 31 1
119 1 54 13 50 22.3 0.205 24 0
119 6 50 22 176 27.1 1.318 33 1
119 0 64 18 92 34.9 0.725 23 0
119 1 44 47 63 35.5 0.28 25 0
119 1 88 41 170 45.3 0.507 26 0
119 1 86 39 220 45.6 0.808 29 1
120 9 72 22 56 20.8 0.733 48 0
120 0 74 18 63 30.5 0.285 26 0
120 1 80 48 200 38.9 1.162 41 0
120 2 76 37 105 39.7 0.215 29 0
120 11 80 37 150 42.3 0.785 48 1
120 3 70 30 135 42.9 0.452 30 0
121 5 72 23 112 26.2 0.245 30 0
121 0 66 30 165 34.3 0.203 33 1
121 1 78 39 74 39 0.261 28 0
121 2 70 32 95 39.1 0.886 23 0
122 2 60 18 106 29.8 0.717 22 0
122 1 64 32 156 35.1 0.692 30 1
122 2 76 27 200 35.9 0.483 26 0
122 2 52 43 158 36.2 0.816 28 0
122 1 90 51 220 49.7 0.325 31 1
123 4 80 15 176 32 0.443 34 0
123 9 70 44 94 33.1 0.374 40 0
123 6 72 45 230 33.6 0.733 34 0
123 5 74 40 77 34.1 0.269 28 0
123 2 48 32 165 42.1 0.52 26 0
123 3 100 35 240 57.3 0.88 22 0
124 0 56 13 105 21.8 0.452 21 0
124 7 70 33 215 25.5 0.161 37 0
124 8 76 24 600 28.7 0.687 52 1
124 2 68 28 205 32.9 0.875 30 1
124 3 80 33 130 33.2 0.305 26 0
124 9 70 33 402 35.4 0.282 34 0
125 1 70 24 110 24.3 0.221 25 0
125 4 70 18 122 28.9 1.144 45 1
125 6 68 30 120 30 0.464 32 0
125 10 70 26 115 31.1 0.205 41 1
125 1 50 40 167 33.3 0.962 28 1
125 2 60 20 140 33.8 0.088 31 0
126 8 74 38 75 25.9 0.162 39 0
126 0 86 27 120 27.4 0.515 21 0
126 1 56 29 152 28.7 0.801 21 0
126 5 78 27 22 29.6 0.439 40 0
126 0 84 29 215 30.7 0.52 24 0
126 8 88 36 108 38.5 0.349 49 0
126 3 88 41 235 39.3 0.704 27 0
127 2 58 24 275 27.7 1.6 25 0
127 2 46 21 335 34.4 0.176 22 0
127 4 88 11 155 34.5 0.598 28 0
127 0 80 37 210 36.3 0.804 23 0
128 1 82 17 183 27.5 0.115 22 0
128 0 68 19 180 30.5 1.391 25 1
128 1 98 41 58 32 1.321 33 1
128 3 72 25 190 32.4 0.549 27 1
128 1 88 39 110 36.5 1.057 37 1
128 1 48 45 194 40.5 0.613 24 1
128 2 78 37 182 43.3 1.224 31 1
129 6 90 7 326 19.6 0.582 60 0
129 3 64 29 115 26.4 0.219 28 1
129 4 60 12 231 27.5 0.527 31 0
129 2 74 26 205 33.2 0.591 25 0
129 4 86 20 270 35.1 0.231 23 0
129 10 76 28 122 35.9 0.28 39 0
129 3 92 49 155 36.4 0.968 32 1
129 7 68 49 125 38.5 0.439 43 1
129 0 110 46 130 67.1 0.319 26 1
130 1 70 13 105 25.9 0.472 22 0
130 3 78 23 79 28.4 0.323 34 1
130 1 60 23 170 28.6 0.692 21 0
131 1 64 14 415 23.7 0.389 21 0
131 4 68 21 166 33.1 0.16 28 0
133 7 88 15 155 32.4 0.262 37 0
133 1 102 28 140 32.8 0.234 45 1
134 9 74 33 60 25.9 0.46 81 0
134 0 58 20 291 26.4 0.352 21 0
134 6 70 23 130 35.4 0.542 29 1
134 6 80 37 370 46.2 0.238 46 1
135 0 94 46 145 40.6 0.284 26 0
135 0 68 42 250 42.3 0.365 24 1
136 7 74 26 135 26 0.647 51 0
136 11 84 35 130 28.3 0.26 42 1
136 5 84 41 88 35 0.286 35 1
136 15 70 32 110 37.1 0.153 43 1
136 1 74 50 204 37.4 0.399 24 0
137 0 68 14 148 24.8 0.143 21 0
137 0 40 35 168 43.1 2.288 33 1
138 0 60 35 167 34.6 0.534 21 1
138 11 74 26 144 36.1 0.557 50 1
139 0 62 17 210 22.1 0.207 21 0
139 5 64 35 140 28.6 0.411 26 0
139 1 46 19 83 28.7 0.654 22 0
139 5 80 35 160 31.6 0.361 25 1
139 1 62 41 480 40.7 0.536 21 0
140 1 74 26 180 24.1 0.828 23 0
140 12 82 43 325 39.2 0.528 58 1
140 0 65 26 130 42.6 0.431 24 1
141 2 58 34 128 25.4 0.699 24 0
142 2 82 18 64 24.7 0.761 21 0
142 7 60 33 190 28.8 0.687 61 0
142 7 90 24 480 30.4 0.128 43 1
143 1 74 22 61 26.2 0.256 21 0
143 1 86 30 330 30.1 0.892 23 0
143 11 94 33 146 36.6 0.254 51 1
143 1 84 23 310 42.4 1.076 22 0
144 4 58 28 140 29.5 0.287 37 0
144 2 58 33 135 31.6 0.422 25 1
144 5 82 26 285 32 0.452 58 1
144 6 72 27 228 33.9 0.255 40 0
144 1 82 46 180 46.1 0.335 46 1
145 13 82 19 110 22.2 0.245 57 0
145 9 88 34 165 30.3 0.771 53 1
145 9 80 46 130 37.9 0.637 40 1
146 2 70 38 360 28 0.337 29 1
146 4 85 27 100 28.9 0.189 27 0
146 2 76 35 194 38.2 0.329 29 0
147 4 74 25 293 34.9 0.385 30 0
148 4 60 27 318 30.9 0.15 29 1
148 10 84 48 237 37.6 1.001 51 1
149 1 68 29 127 29.3 0.349 42 1
150 7 66 42 342 34.7 0.718 42 0
150 7 78 29 126 35.2 0.692 54 1
151 6 62 31 120 35.5 0.692 28 0
151 12 70 40 271 41.8 0.742 38 1
151 8 78 32 210 42.9 0.516 36 1
152 13 90 33 29 26.8 0.731 43 1
152 9 78 34 171 34.2 0.893 33 1
152 0 82 39 272 41.5 0.27 27 0
153 1 82 42 485 40.6 0.687 23 0
153 13 88 37 140 40.6 1.174 39 0
154 6 74 32 193 29.3 0.839 39 0
154 9 78 30 100 30.9 0.164 45 0
154 4 72 29 126 31.3 0.338 37 0
154 4 62 31 284 32.8 0.237 23 0
154 6 78 41 140 46.1 0.571 27 0
155 2 74 17 96 26.6 0.433 27 1
155 11 76 28 150 33.3 1.353 51 1
155 8 62 26 495 34 0.543 46 1
155 2 52 27 540 38.7 0.24 25 1
155 5 84 44 545 38.7 0.619 34 0
156 9 86 28 155 34.3 1.189 42 1
157 1 72 21 168 25.6 0.123 24 0
157 2 74 35 440 39.4 0.134 30 0
158 3 64 13 387 31.2 0.295 24 0
158 3 76 36 245 31.6 0.851 28 1
158 3 70 30 328 35.5 0.344 35 1
158 5 84 41 210 39.4 0.395 29 1
160 7 54 32 175 30.5 0.588 39 1
161 10 68 23 132 25.5 0.326 47 1
162 0 76 56 100 53.2 0.759 25 1
163 3 70 18 105 31.6 0.268 28 1
163 17 72 41 114 40.9 0.817 47 1
164 1 82 43 67 32.8 0.341 50 0
165 6 68 26 168 33.6 0.631 49 0
165 0 76 43 255 47.9 0.259 26 0
165 0 90 33 680 52.3 0.427 23 0
166 5 72 19 175 25.8 0.587 51 1
167 1 74 17 144 23.4 0.447 33 1
167 8 106 46 231 37.6 0.165 43 1
168 7 88 42 321 38.2 0.787 40 1
169 3 74 19 125 29.9 0.268 31 1
170 3 64 37 225 34.5 0.356 30 1
171 3 72 33 135 33.3 0.199 24 1
171 9 110 24 240 45.4 0.721 54 1
172 1 68 49 579 42.4 0.702 28 1
173 4 70 14 168 29.7 0.361 33 1
173 3 78 39 185 33.8 0.97 31 1
173 3 84 33 474 35.7 0.258 22 1
173 3 82 48 465 38.4 2.137 25 1
173 0 78 32 265 46.5 1.159 58 0
174 3 58 22 194 32.9 0.593 36 1
174 2 88 37 120 44.5 0.646 24 1
176 3 86 27 156 33.3 1.154 52 1
176 8 90 34 300 33.7 0.467 58 1
177 0 60 29 478 34.6 1.072 21 1
179 8 72 42 130 32.7 0.719 36 1
179 0 50 36 159 37.8 0.455 22 1
180 3 64 25 70 34 0.271 26 0
180 0 90 26 90 36.5 0.314 35 1
180 0 78 63 14 59.4 2.42 25 1
181 8 68 36 495 30.1 0.615 60 1
181 1 64 30 180 34.1 0.328 38 1
181 7 84 21 192 35.9 0.586 51 1
181 1 78 42 293 40 1.258 22 1
181 0 88 44 510 43.3 0.222 26 1
184 4 78 39 277 37 0.264 31 1
186 8 90 35 225 34.5 0.423 37 1
187 7 50 33 392 33.9 0.826 34 1
187 3 70 22 200 36.4 0.408 36 1
187 7 68 39 304 37.7 0.254 41 1
187 5 76 27 207 43.6 1.034 53 1
188 0 82 14 185 32 0.682 22 1
189 1 60 23 846 30.1 0.398 59 1
189 5 64 33 325 31.2 0.583 29 1
191 3 68 15 130 30.9 0.299 34 0
193 1 50 16 375 25.9 0.655 24 0
195 7 70 33 145 25.1 0.163 55 1
196 1 76 36 249 36.5 0.875 29 1
196 8 76 29 280 37.5 0.605 57 1
197 2 70 45 543 30.5 0.158 53 1
197 4 70 39 744 36.7 2.329 31 0
198 0 66 32 274 41.3 0.502 28 1