module 2 statistics

  Please see the attached assignment data information.  This could be used in excel or word.  Original only.  Below are just instructions from the professor.
Thanks

Updates
Announcements

M2A2 Plese Read for Assistance
Posted Apr 12, 2018 10:13 AMThis week we are looking at probability. You use simple probability every day. Think about tossing a coin. There are two outcomes for tossing a coin, heads or tails (unless you can magically get it land on its end). If you wanted to calculate the probability of getting a heads on any toss, you can easily calculate the probability. There are 2 possible outcomes and 1 that you are looking for, so the probability is ½=0.5 or 50%. If you increase the outcomes it becomes a little more complicated but not too bad. Think of throwing a die. There are 6 possible outcomes (1 through 6). If you want to know the probability of throwing a 1, you have 6 possible outcomes and you are looking for 1. The probability would be 1/6=0.166 or 16.7%. If you want to know the probability of throwing an even number, there are still 6 possible outcomes, but 3 that you are looking for (2, 4, or 6). The probability would be 3/6=0.5 or 50%.
For M2A2 you are asked to calculate 4 probabilities using data in the table and explain and analyze the data to draw some conclusions. You need to be able to do two things to calculate these 4 values correctly. First, you need to figure out what goes in the numerator and what goes in the denominator of the probability calculation. Second, you need to know where to find the data you need in the table. In other words you need to know how to read the table. This has been the biggest problem I have seen in the classes I have taught so far. So, I am going to try and give you some insight based on past mistakes.
The denominator is always the total number of participants meeting your inclusion criteria. The numerator is always the number of participants who are a subset of the group in the denominator meeting the definition of the condition you are evaluating. For example, if you want to know the probability that any child in the study is hyperlipidemic, you first have to determine how many children are in the study. This should be easy. You add all the numbers in the table (13+34+83+45+42+6=223). This would go in the denominator. Then determine of those 223 children how many are hyperlipidemic. In the table you see that the second row under Child is labeled hyperlipidemic. That means every child in that row is hyperlipidemic. If you add those numbers you get 93 (45+42+6=93). So, 93 of the 223 children in the study are hyperlipidemic. The probability that a child in the study would be hyperlipidemic would be 93/223=0.417 or 41.7%. Note: This is not one of the 4 questions in A2 so if you come with this answer for one of the four you are incorrect.
Look at the four questions. The first asks the probability that one or both parents are hyperlipidemic. This is asking how many children in the study have one or both parents who are hyperlipidemic. Figure out how many total children are in the study (hint: we did this above). Then figure out how many children have one or both parents who are hyperlipidemic (hint: you have to add the cells in two different columns).
The second calculation has the same denominator as the first because we are asking about the entire study population. The numerator here is only the group where the child and both parents are hyperlipidemic (hint: this is a number from only one cell in the table where the row for hyperlipidemic and the column for both parents hyperlipidemic intersect).
The 3rd and 4th calculations are a little trickier because we do not use the total population in the denominator. The 3rd only includes those children with neither parent hyperlipidemic (hint: this is one column in the table) in the denominator. The numerator is only children who are hyperlipidemic and who have neither of their parents hyperlipidemic (hint: this is one cell in the column you used for the denominator). The 4th calculation is similar to the 3rd but you use a different column in the table.
Remember to evaluate your answers to draw some conclusions. If you still have problems contact me.