Text book: Essentials of Biostatistics in Public Health 3rd ed. by Lisa Sullivan Instructor provided question: An...

60.1K

Verified Solution

Question

Basic Math

Text book: Essentials of Biostatistics in Public Health 3rd ed.by Lisa Sullivan
Instructor provided question: An SBB instructor wants todetermine if there is a correlation between the students incomingGPA and their overall score on their ASCP exam. Several potentialconfounders were also considered including years of clinicalpractice in blood bank and gap between completing the program andtaking the exam. Perform the appropriate analysis on the data belowand interpret the results. Do SBB ASCP scores correlate withstudent’s GPAs? Do confounders exist? Justify your response.
SBB ASCP Score
GPA
BB Experience (years)
Gap (months)
698
3.98
3
0.5
540
3.12
8
0.25
572
3.24
2
2
440
3.46
10
3
401
3.71
7
12
380
2.95
13
5
660
3.55
15
0.5
398
2.62
3
4
498
3.16
2
2
557
3.32
20
0.5
613
3.48
2
1
474
3.21
5
3
487
2.89
7
2
522
3.81
2
3
501
3.65
9
2
422
2.86
5
1
475
2.98
8
1
555
3.71
10
1
514
2.98
17
0.5
439
2.62
2
2

Answer & Explanation Solved by verified expert

3.6 Ratings (524 Votes)

We will solve this problem with the help of Excel First we would try to find the correlation between the students incoming GPA and their overall score on their ASCP exam Load the data into Excel Go to DataMegastat Select the option CorrelationRegression and go to Regression Select GPA as the independent variable x Select SBB ASCP Score as the dependent variable y Click OK The output will be as follows r 0336 n 20 r 0579 k 1 Std Error 71815 Dep Var SBB ASCP Score ANOVA table Source SS df MS F pvalue See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

SBB ASCP Score	GPA	BB Experience (years)	Gap (months)
698	3.98	3	0.5
540	3.12	8	0.25
572	3.24	2	2
440	3.46	10	3
401	3.71	7	12
380	2.95	13	5
660	3.55	15	0.5
398	2.62	3	4
498	3.16	2	2
557	3.32	20	0.5
613	3.48	2	1
474	3.21	5	3
487	2.89	7	2
522	3.81	2	3
501	3.65	9	2
422	2.86	5	1
475	2.98	8	1
555	3.71	10	1
514	2.98	17	0.5
439	2.62	2	2