Statistical Computing Using Excel. Please preserve your results as a 97/2003 Excel smooth. Answers should be in the similar workbook and 5.1 custom problems on Worksheet 1, 6.6 problems on Worksheet 2 and 7.9 Custom Problems on worksheet 3. Highlight the answers.
5.1 Custom Problems (Worksheet 1)
1. Entirety cholesterol in offspring primeval 10-15 is inconsequent to flourish a regular arrangement after a while a average of 191 and a exemplar failure of 22.4.
a. What scold of offspring 10-15 years of age possess entirety cholesterol among 180 and 190?
b. What scold of offspring 10-15 years of age would be classified as hyperlipidemic (Assume that hyperlipidemia is defined as a entirety cholesterol flatten aggravate 200)?
c. What is the 90th percentile of cholesterol?
2. Among coffee draughters, men draught a average of 3.2 cups per day after a while a exemplar failure of 0.8 cups. Assume the sum of coffee draughts per day flourishs a regular arrangement.
a. What scold draught 2 cups per day or over?
b. What scold draught no over than 4 cups per day?
c. If the top 5% of coffee draughters are considered laborious coffee draughters, what is the minimum sum of cups consumed by a laborious coffee draughter? Hint: Find the 95th percentile.
6.6 Custom Problems (Worksheet 2)
3. A consider is run to love the average entirety cholesterol flatten in offspring 2-6 years of age. A case of 9 participants is selected and their entirety cholesterol flattens are measured as flourishs.
185 225 240 196 175 180 194 147 223
Genescold a 95% trust intermission for the gentleman average entirety cholesterol flattens in adults after a while a truth of hypertension.
7.9 Custom Problems (Worksheet 3)
1. The flourishing axioms were placid in a clinical proof evaluating a new amalgamation calculated to correct mortify healthful in trauma patients. The new amalgamation was compared resisting a placebo. After matter for 5 days after a while the new amalgamation or placebo the magnitude of mortify healthful was measured and the axioms are shown underneath.
Percent Mortify Healing
Treatment 0-25% 26-50% 51-75% 76-100%
New Amalgamation (n=125) 15 37 32 41
Placebo (n=125) 36 45 34 10
Is there a variety in the magnitude of mortify healthful by matter? (Hint: Are matter and the percent mortify healthful rebellious?) Run the expend cupel at a 5% flatten of sensation.
2. Use the axioms in Problem #1 and pool the axioms despite the matters into one case of magnitude n=250. Use the pooled axioms to cupel whether the arrangement of the percent mortify healthful is closely regular. Specifically, use the flourishing arrangement: 30%, 40%, 20% and 10% and a=0.05 to run the expend cupel.
3. The flourishing axioms were placid in an trial calculated to question the collision of divergent poses of the dame on fetal courage scold. Fetal couragescold is measured by ultrasound in beats per exact. The consider modescold 20 women who were assigned to one pose and had the fetal courage scold measured in that pose. Each dowager was among 28-32 weeks gestation. The axioms are shown underneath.
Back Side Sitting Standing
20 21 24 26
24 23 25 25
26 25 27 28
21 24 28 29
19 16 24 25
Is there a weighty variety in average fetal courage scolds by pose? Run the cupel
at a 5% flatten of sensation.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more