Homework/math

• Question: The file IQscores.csv contains the IQ scores for 31 randomly selected grade 7 girls in a particular school district. Find the mean of the sample using Excel (include your Excel formula in your solutions). b) IQ scores typically follow a Normal distribution and are
  1. The file IQscores.csv contains the IQ scores for 31 randomly selected grade 7 girls in
  a particular school district.
  1. Find the mean of the sample using Excel (include your Excel formula in your solutions).
  b) IQ scores typically follow a Normal distribution and are designed so that σ = 15. Using this information, compute three confidence intervals (90%, 95%, and 98%) for the mean IQ score and fill in the table below. Please show any computations needed to find the margin of error.Confidence levelZ-critical valueMargin of errorConfidence intervalLength of interval90%95%98%c) What seems to be happening to the size of the interval as we increase our level of confidence?IQscores.csv is as followsIQ Score1141001048910291114114103105108130120132111128118119867211110374112107103989611211293

Answer

From Column A1 to A30 is the data

Z-critical value=ABS(NORM.S.INV((1-0.90)/2)) for 90%

                         =ABS(NORM.S.INV((1-0.95)/2)) for 95%

                            =ABS(NORM.S.INV((1-0.98)/2)) for 98%

Margin of error = Z-critical value*s.d./sqrt(30)

Length of interval = Upper limit – lower limit

1. Education Tags
2. :
   • Homework help
   • Study resources
   • Academic assistance
   • Le
   • arning materials
   • Educational support
   • Online tutoring
   • Study guides
   • Exam preparation
   • Homework solutions
   • School assignments
3. Subject-specific Tags:
   • Mathematics
   • Science
   • English/Language Arts
   • History
   • Geography
   • Computer Science
   • Economics
   • Psychology
   • Sociology
   • Literature
4. Grade Level Tags:
   • Elementary school
   • Middle school
   • High school
   • College
   • University
   • Graduate level
   • K-12
5. Study Tools Tags:
   • Practice problems
   • Worksheets
   • Flashcards
   • Quiz questions
   • Lecture notes
   • Textbook solutions
   • Study tips
   • Exam strategies
6. Online Learning Tags:
   • E-learning
   • Distance education
   • Virtual classroom
   • Online courses
   • Digital learning
   • Remote learning
   • Internet resources
7. Additional Tags:
   • Free answers
   • Homework assistance
   • Academic resources
   • Study community
   • Student help
   • Assignment help
   • Problem-solving
   • Tutoring services
   • Peer collaboration
8. Chegg Unlock
   • Chegg free questions
   • Chegg Answers
   • Bartleby Answers
   • CourseHero unlock
9. Mail us or contact us if you need any help related to your homework and assignments. Also, for the projects as well.