Project_1_Probability_Report

.docx

School

Johns Hopkins University *

*We aren’t endorsed by this school

Course

101111

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by DeanCrownHamster25

Report
MA123 – Project 1: Probability (Report) Name: ____________________________________ Score: ____ pts. This project relates to concepts in epidemiology with focus on clinical usefulness of diagnostic tests. Resources (Make sure to review these resources before starting the project): • Calculating Sensitivity and Specificity using a 2 x 2 table ( Click me ). • Calculating Positive and Negative Predictive Values using a 2 x 2 table ( Click me ). • Sensitivity, Specificity, PPV, NPV ( Click me ). • How to use COUNTIF and COUNTIFS in Microsoft Excel ( Click me ). Problem: A new test to diagnose a Urinary Tract Infection ( UTI ) in women (patients) is being assessed. The comparison gold standard is positive urine dipstick plus urine culture. Data collected on this new test are provided in the accompanying Microsoft Excel file. Your task: 1. (40 points) Use Microsoft excel function “COUNTIFS” to create a confusion matrix (2 x 2 table) showing how many true-positives (TP), false-positives (FP), false-negatives (FN), and true-negatives (TN) are in the study. Place your confusion matrix here (make sure it is well labeled and it shows the row totals, column totals, and overall total) 2. Use the confusion matrix created in 1) to answer the following questions. i. (15 points) What percentage of women (patients) with a positive urine dipstick plus urine culture who have a positive diagnostic test (TP rate or Sensitivity)? Provide your answer here (Round your answer to two decimal places) ii. (15 points) What percentage of women (patients) without urine dipstick plus urine culture who have a negative diagnostic test (TN rate or Specificity)? Provide your answer here (Round your answer to two decimal places iii. (10 points) What percentage of women (patients) were correctly diagnosed with a positive test (Positive predictive value)? Provide your answer here (Round your answer to two decimal places iv. (10 points) What percentage of women (patients) were correctly diagnosed with a negative test? (Negative predictive value)? Provide your answer here (Round your answer to two decimal places 3. (10 points) Based on the results in 1, and 2 (i, ii, iii, and iv) state your conclusion about the new test to diagnose a Urinary Tract Infection ( UTI ) in women (patients). (No more than two sentences). Type your summary
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Recommended textbooks for you
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
SEE MORE TEXTBOOKS