MA 203 DL Excel Project 5

Chapter 8

Stem Cell Survey

Adults were randomly selected for a Newsweek poll. They were asked if they "favor or oppose using federal tax dollars to fund medical research using stem cells obtained from human embryos." Of those polled, 481 were in favor, 401 were opposed and 120 were unsure. A politician claimed that people don't really understand the issue and their responses to such questions are as random as a coin toss. 1) Excluding the 120 participants who were unsure, use a 0.01 significance level to test the claim of the politician (that the proportion of subjects who respond in favor is equal to 0.5). 2) What does the result of your test suggest about the politician's claim?

Medical Malpractice In a study of 1228 randomly selected medical malpractice lawsuits, it was found that 856 of them were dropped or dismissed (based on information from the Physicians Insurers Association of America). 3) Use a 0.01 significance level to test the claim that most medical malpractice lawsuits are dropped or dismissed. 4) Should your conclusion be comforting to physicians? Why or why not?

Speed Dating Data set 18 "Speed Dating" includes "attractive" ratings of male dates made by female dates. The summary statistics are: n = 199, mean = 6.19, standard deviation = 1.99 5)Use a 0.01 significance level to test the claim that the population mean of these ratings is less than 7.00. 6) What do you conclude about these ratings?

Got a Minute? Fifteen students were asked to estimate the length of time equal to one minute without the benefit of a watch or clock. Their responses are listed below. 69 81 39 65 42 21 60 63 66 48 64 70 96 91 65 7) Use a 0.05 significance level to test the claim that these times are from a population with a mean of 60 seconds. 8) Does it appear that the students are reasonably good at estimating one minute?

Birth Weights A simple random sample of birth weights of 30 girls has a standard deviation of 829.5hg. Data Set 4, "Births," provides a standard deviation in weights of boys as being 660.2 hg. 9) Use a 0.01 significance level to test the claim that the birth weights of girls have the same standard deviation as those of boys. 10) Be sure to express your conclusion in a complete sentence.

Stats Test Scores

Your textbook author, Mario Triola, is a professor in NY. Over time, his students' test scores have had a standard deviation equal to 14.1.A particular class had 27 scores witha standard deviation of 9.3. 11) Use a 0.01 significance level to test the claim that this class has less variation than other past classes. 12) Does the lower standard deviation imply that the students are doing better?

Don't forget to utilize/copy paste the calculator and to be careful about changing what needs to be changed and squaring standard deviation since the calculator uses variance.

n	25			Remember to update your chi square values with each problem
s	0.24			And be aware of the tails:
Confidence	95				95		0.975	0.025
					90		0.95	0.05
Chi Sq L	12.401
ChiSq R	39.364
Variance Lower Bound	0.035118
Variance Upper Bound	0.111475
SD Lower Bound	0.187399
SD Upper Bound	0.333879