Using excel!!!!!!! A bone mineral density test is used to identify a bone diseas

Question

Using excel!!!!!!!
A bone mineral density test is used to identify a bone disease. The result of a bone density test is commonly measured as a z score, and the population of z scores is normally distributed with a mean of 0 and and standard deviation of 1.
A.) for randomly selected subject, find the probability of a bone density test score is less than 1.54.
B.) For randomly selected subject, find the probability of of a bone density test score greater than -1.54.
C.) For a randomly selected subject, find the probability of a bone density test score between -1.33 and 2.33.
D.) Find Q1, the bone density test score separating the bottom 25% from the top 75%
E.)if the mean bone density test score is found for 9 randomly selected subjects, find the probability that the mean is greater than 0.50. Using excel!!!!!!!
A bone mineral density test is used to identify a bone disease. The result of a bone density test is commonly measured as a z score, and the population of z scores is normally distributed with a mean of 0 and and standard deviation of 1.
A.) for randomly selected subject, find the probability of a bone density test score is less than 1.54.
B.) For randomly selected subject, find the probability of of a bone density test score greater than -1.54.
C.) For a randomly selected subject, find the probability of a bone density test score between -1.33 and 2.33.
D.) Find Q1, the bone density test score separating the bottom 25% from the top 75%
E.)if the mean bone density test score is found for 9 randomly selected subjects, find the probability that the mean is greater than 0.50. Using excel!!!!!!!

A.) for randomly selected subject, find the probability of a bone density test score is less than 1.54.
B.) For randomly selected subject, find the probability of of a bone density test score greater than -1.54.
C.) For a randomly selected subject, find the probability of a bone density test score between -1.33 and 2.33.
D.) Find Q1, the bone density test score separating the bottom 25% from the top 75%
E.)if the mean bone density test score is found for 9 randomly selected subjects, find the probability that the mean is greater than 0.50.

Explanation / Answer

a)

probability of a bone density test score is less than 1.54 =P(X<1.54)=normsdist(1.54)=0.9382

b)

probability of of a bone density test score greater than -1.54 =P(X>-1.54)=1-normsdist(-1.54)=0.9382

c)

probability of a bone density test score between -1.33 and 2.33 =normsdist(2.33)-normsdist(-1.33)=0.8983

d)

Q1 =normsinv(0.25)=-0.6745

e)std error =std deviaiton/sqrt(n)=1/sqrt(9)=1/3

probability that the mean is greater than 0.50 =P(X>0.5)=1-P(X<0.5)=1-normsdist(0.5*3)=0.0668

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.