Statistics: paried observations

  • Thread starter Thread starter k77i
  • Start date Start date
  • Tags Tags
    Statistics
Click For Summary
SUMMARY

The forum discussion centers on calculating a 95.8% confidence interval for the mean difference in LDL levels before and after administering a cholesterol-lowering medication. The initial calculations presented by the user yielded an incorrect confidence interval of (-122.586, 162.586). However, a correction was provided, indicating that the sample mean difference is 20, with a sample standard deviation of 15.3695, leading to the correct confidence interval of (8.5, 31.5). The calculations were verified using both Maple and Excel, confirming the accuracy of the latter method.

PREREQUISITES
  • Understanding of paired observations in statistics
  • Familiarity with confidence intervals and their calculations
  • Proficiency in using Excel for statistical analysis
  • Knowledge of sample standard deviation and mean difference
NEXT STEPS
  • Learn how to calculate confidence intervals using R or Python
  • Explore the use of Maple for statistical analysis
  • Study the concept of paired t-tests and their applications
  • Investigate common pitfalls in statistical calculations using Excel
USEFUL FOR

Statisticians, data analysts, healthcare researchers, and anyone involved in clinical trials or statistical analysis of medical data.

k77i
Messages
28
Reaction score
0

Homework Statement



To test the efficacy of a new cholesterol-lowering medication, 10 people are selected at random. Each has their LDL levels measured (shown below as Before), then take the medicine for 10 weeks, and then has their LDL levels measured again (After).

Before After
195 175
131 129
141 105
182 184
173 138
123 120
147 115
156 144
125 87
161 137

Give a 95.8% confidence interval for meanB - meanA , the difference between LDL levels before and after taking the medication.



Homework Equations




d(bar) - t(alpha/2)(Sd/sqrt(n)) < meanDifference < d(bar) + t(alpha/2)(Sd/sqrt(n))

The Attempt at a Solution



I found all the values using excel:

d(bar) = 20
t(alpha/2) = 2.368676
Sd = 190.36
n = 10 (given)

and my answer was (-122.586 < meanDifference < 162.586)

but this is incorrect
 
Physics news on Phys.org
k77i said:

Homework Statement



To test the efficacy of a new cholesterol-lowering medication, 10 people are selected at random. Each has their LDL levels measured (shown below as Before), then take the medicine for 10 weeks, and then has their LDL levels measured again (After).

Before After
195 175
131 129
141 105
182 184
173 138
123 120
147 115
156 144
125 87
161 137

Give a 95.8% confidence interval for meanB - meanA , the difference between LDL levels before and after taking the medication.



Homework Equations




d(bar) - t(alpha/2)(Sd/sqrt(n)) < meanDifference < d(bar) + t(alpha/2)(Sd/sqrt(n))

The Attempt at a Solution



I found all the values using excel:

d(bar) = 20
t(alpha/2) = 2.368676
Sd = 190.36
n = 10 (given)

and my answer was (-122.586 < meanDifference < 162.586)

but this is incorrect

I don't know what your Sd is, but if it is the sample standard deviation of the difference, then it is wrong. I get sample mean difference = m = 20, sample standard dev. of diff. = s = 15.3695 (your Sd?). This gives a confidence interval very different from yours.

RGV
 
yes it was the standard deviation of the means and I don't get why it would be wrong, I used excel to calculate it..

Anyways the correct interval was (8.5,31.5)
 
I first used Maple to do the calculation. Then, to see if Excel was giving you the trouble, I re-did the analysis using Excel. It agreed with the Maple calculation and disagreed with yours. I suggest you search for a typo or something similar.
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 7 ·
Replies
7
Views
6K
  • · Replies 24 ·
Replies
24
Views
3K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 28 ·
Replies
28
Views
7K
  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 61 ·
3
Replies
61
Views
13K
  • · Replies 125 ·
5
Replies
125
Views
20K