Q7 Which of the following EXCEL commands would give you the 46 th percentile 2

# Q7 which of the following excel commands would give

• Notes
• kristinakim12
• 8
• 100% (1) 1 out of 1 people found this document helpful

This preview shows page 3 - 6 out of 8 pages.

Q7.Which of the following EXCEL commands would give you the 46thpercentile?(2 marks)(a)=normsinv(.46) (b) =normsdist(.46) (c) =normdist(46,46,20) (d) =norminv(.46,46,20) (e) none of (a) – (d) Answer: D
Q8.Barbara’sscore was at the 46thpercentile. What was her exam score? (2 marks)Q9.“The difference in points between the 46thpercentile and the66thpercentile is the same as the difference in points between the 66thpercentile and the 86thpercentile”. True or False and briefly explain. (3 marks)Q10.A quiz is administered to a large group of students. Four scores are shown below, in original and standard units. Original Units:18 42 72 Ans: 60Fill in the blanks.(5 marks)0 Q11. A drug company tests two treatments for a disease. The results are shown below. First TrialTreatment Number of Subjects Success Rate A 200 20% B 200 15% Second TrialTreatment Number of Subjects Success Rate A 100 86% B 400 75% (a) What is the overall success rate of Treatment A? (1 mark) (b) What is the overall success rate of Treatment B? (1 mark)(c) Is there anything paradoxical about your answers in parts (a) and (b)? If so, explain.(Don’t just name it, but explain it). Use the extra page to explain why.(4 marks)
STAT 20 Lec 1: Fall 2015: QUIZ 1: My GSI is: ____________ Sec time: _____ Name: _________Solutions___________ SID: _______________ Score: /30 Instructions: For Q1 – Q7, mark your answers on your SCANTRON form. For Q8 – Q11, show ALL your work. The table below shows the distribution of ages in a population of people less than 82 years. The intervals include the right endpoint. When a histogram is drawn assume an even distribution over each individual interval. Age (years)0 - 10 10 - 20 20 - 30 30 - 35 35 - 40 40 - 50 50 - 82 Percentage (%)10 ? 12 10 10 Q1.The height of the rectangle over the interval 10-20is: (2 marks)(the units are % per year)10 40