ZuoTi.Pro
Question

NEED EXCEL FORMULAS!!! Suppose the variable is the population of IQs, which are normally distributed with...

NEED EXCEL FORMULAS!!! Suppose the variable is the population of IQs, which are normally distributed with a mean of 100 and a standard deviation of 16.

a. About what proportion of people have IQ scores equal to or less than 116?

b. About what proportion of people have IQ scores between 100 and 116?

c. About what proportion have IQ scores greater than 120?

d. What would your IQ need to be to be in the top 2% of all people (this qualifies you for MENSA)?

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution

clownload link https://drive.google.com/open?id=1qvzWe5bgmdJDXoV5r3b4USb6YV3wIm_H

ormula to be used

Use ctrl+ to view all formulas used

I 100 I 16 mean standard deviation Let X be IQ score of population P(less than 116) NORMDIST(H9,G4,G5,TRUE) PX 116) PK116)

inal results

100 16 mean standard deviation Let X be IQ score of population P(less than 116) P(X< 116) P(X<116)0.84134 P(between 100 and 116) P 100 <X 116) P(X<116)-0.84134 P(X<100)-0.50000 P(116<X<100)- P(X<116)-P(X<100) P(116<X<100)0.34134 C. P(greater than 120) P(X> 120) P(X>120) 0.10565 top 0 Z-score IQ Score- 2.054 132.86

0 0
Add a comment
Know the answer?
Add Answer to:
NEED EXCEL FORMULAS!!! Suppose the variable is the population of IQs, which are normally distributed with...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Mensa is an organization whose members possess IQs in the top 2% of the population. If...

    Mensa is an organization whose members possess IQs in the top 2% of the population. If IQs are normally distributed, with a mean of 100 and a standard deviation of 16, what is the middle spread (or interquartile range)? Approximately a. 65.6 b. 21.28 c. 75-125 d. 84-116 e. 10.72

  • IQ scores are normally distributed with a mean of 100 and a standard deviation of 15....

    IQ scores are normally distributed with a mean of 100 and a standard deviation of 15. Mensa is an international society that has one - and only one - qualification for membership: a score in the top 2% of the population on an IQ test. (a) What IQ score should one have in order to be eligible for Mensa? (b) In a typical region of 145,000 people, how many are eligible for Mensa?

  • Suppose IQs are normally distributed with a mean of 100 and a standard deviation of 16....

    Suppose IQs are normally distributed with a mean of 100 and a standard deviation of 16. a) If one person is randomly selected, what is the probability that the person’s IQ is higher than 90 but lower than 115? b) If eight people are randomly selected, what is the probability that the sample mean IQ is higher than 90 but lower than 115?

  • Suppose IQ scores are normally distributed with mean 100 and standard deviation 10. Which of the...

    Suppose IQ scores are normally distributed with mean 100 and standard deviation 10. Which of the following is false? Group of answer choices A normal probability plot of IQ scores of a random sample of 1,000 people should show a straight line. Roughly 68% of people have IQ scores between 90 and 110. An IQ score of 80 is more unusual than an IQ score of 120. An IQ score greater than 130 is highly unlikely, but not impossible.

  • Find the probability that a person has an IQ greater than 120. Include a sketch of...

    Find the probability that a person has an IQ greater than 120. Include a sketch of the graph and shade the area under the normal curve corresponding to this probability. Mensa is an organization whose members have the top 2% of all IQs. Find the minimum IQ needed to qualify for the Mensa organization. Sketch the graph and shade the area under the curve corresponding to this score and above. IQ scores between 90 and 110 are considered to be...

  • The IQs of 600 applicants to a certain college are approximately normally distributed with a mean...

    The IQs of 600 applicants to a certain college are approximately normally distributed with a mean of 115 and a standard deviation of 12. Note that IQs are recorded to the nearest integers. a) If the college requires an IQ of at least 95, how many of these students will be rejected on this basis of IQ, regardless of their other qualifications? b) What is the minimum IQ of the top 30 applicants?

  • The IQs of 600 applicants to a certain college are approximately normally distributed with a mean...

    The IQs of 600 applicants to a certain college are approximately normally distributed with a mean of 115 and a standard deviation of 12. Note that IQs are recorded to the nearest integers. 1) If the college requires an IQ of at least 95, how many of these students will be rejected? 2) What is the minimum IQ of the top 30 applicants?

  • Problem #2: IQs are known to be normally distributed with mean 100 and standard deviation 15....

    Problem #2: IQs are known to be normally distributed with mean 100 and standard deviation 15. (a) What percentage of people have an IQ lower than 90? (b) Fill in the blank. 75% of the population have an IQ that is greater than NOTE: Do not use the first half of the normal table (i.e., page 742 in the textbook, with negative z-values) because it will not be provided with the tests. Problem =2(a): Enter your answer as a percentage,...

  • Please provide clear writing and show calculations Step by Step! Thank you! Recall IQs are normally...

    Please provide clear writing and show calculations Step by Step! Thank you! Recall IQs are normally distributed such that the mean is 100 and the standard deviation is 15 or N(100, 225) namely μ 100and σ-225 25 is chosen answer a, b and c. orơ-15 . If a simple random sample of n- a) What is the probability that the average IQ would be less than 80? b) What is the probability that the avearge IQ would be more than...

  • Starting with a population that is normally distributed with a mean of 100 and a standard...

    Starting with a population that is normally distributed with a mean of 100 and a standard deviation of 12, answer the following questions (if possible).          What is the percentage of scores greater than 104?          What is the probability of randomly selecting a score great than 104?          What is the percentage of scores less than or equal to 95?          What is the probability of randomly selecting a score less than or equal to 95?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT