Excel Computing Normal and Binomial Distribution

docx

School

Liberty University *

*We aren’t endorsed by this school

Course

501

Subject

Health Science

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by SuperHumanStar18109

HLTH 501 E XCEL : C OMPUTING N ORMAL AND B INOMIAL D ISTRIBUTION For this exercise, please refer to the Navigate eBook Access for Essentials of Biostatistics for public Health, Fourth Edition. Please upload your answers as an excel file with properly labeled answers. Please answer in excel only under practice problems 5.4 questions (Page E-62): 1, 2, 3, 4, 5. If help is needed, tutorials are found in the workbook with relevant problems. Note: These pictures will give you an idea where it is in the workbook. You are responsible to use the workbook. 1. A. x mean std dev p 180 191 22.4 0.31168 Page 1 of 4

HLTH 501 8 190 191 22.4 0.48219 6 0.17050 8 B. 200 191 22.4 0.34392086 8 C. 0.9 191 22.4 219.706 8 2. A. 2 3.2 0.8 0.93319279 9 B. 4 3.2 0.8 0.84134 5 C. 0.95 3.2 0.8 4.51588 3 About 4.5 cups per day 3. A. Page 2 of 4 x n p 4 8 0.4 0.23224 3

HLTH 501 B. X N P 0 8 0.4 0.01679 6 1 8 0.4 0.08958 2 8 0.4 0.20901 9 3 8 0.4 0.27869 2 4 8 0.4 0.23224 3 5 8 0.4 0.12386 3 6 8 0.4 0.04128 8 0.99148 4. A. 5 15 0.3 0.20613038 1 B. 0 15 0.3 0.00474756 2 C. 7 15 0.3 0.94998746 5. A. X MEAN SD 90 85 12 0.66153 9 Page 3 of 4

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

HLTH 501 B. C. X N P 100 85 12 0.89435 89 th percentile Page 4 of 4 X MEAN SD 80 85 12 0.33846 1 90 85 12 0.66153 9 0.32307 8

Excel Computing Normal and Binomial Distribution

Related Documents