I need this biostatistics project done

It is a project for biostatistics based on excel.


Get Help With a similar task to - I need this biostatistics project done

Login to view and/or buy answers.. or post an answer
Additional Instructions:

infantbp Id Mn_sbp Mn_dbp MSB1slt MSB2slt MSB3slt MSB4slt MSB5slt MSB6slt MSB7slt MSB8slt MSB9slt MSB10slt MSB1sug MSB2sug MSB3sug MSB4sug MSB5sug Mn_sbp Mn_dbp 1 75.33 42.67 5 5.66 0 4.33 4.5 3.25 5 5 3.75 0 12.85 40 39 68 10.28 52 28 7 53.33 37.33 33 33 24 34 24 31 31 25 24 27 13.85 26.75 16 1.18 0 53.33 30 9 66 38.67 2 0.37 6.66 6.66 17 19 0 0 0 6 3.9 14.25 20 44.33 5.25 56.67 31 10 70.67 43.33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 57.33 32 11 84.67 53.33 0 15 6.33 6.33 10 17 16.5 15 10.66 13 0 0 0 0 0 59.33 32.33 17 72.67 42 0 23 17 6.5 24 17 1 0 0 0 15 25.25 27.75 37.33 12.16 59.33 32.67 19 63.33 48 6.33 8.5 5.33 4 8 12 2 3.5 7 0 11.6 22.79 49 85.5 5.4 59.67 32.67 20 57.33 41.67 6.33 23 3.5 4 7.33 5.66 11 0 12.5 12 6.19 18.16 34.25 28.6 10.57 60 33 21 66.67 38.67 0 0 0 0 12 10 0 0 0 0 7.66 28.66 30.5 31.5 6.59 60 33 22 81.33 54.67 7 14 7 4 3 3 0 0 2 12 12.39 20.5 25.2 146 12.57 60.67 33.33 23 82.67 61.33 5 7.5 2.5 1 1.5 0 6.5 2.33 11 24 3.4 20 24 29.25 13.28 61.33 34 24 74 43.33 0 1.5 3 0 0 2 1 0 1 0 3.92 15 34 34.25 4.46 61.33 34.33 26 70.67 48.67 6.5 3.5 4.5 2 1.66 11 7.66 12.5 12.5 23 2.12 7.33 38.66 72.5 4.27 61.33 34.33 30 71.33 38.67 3.33 8 9 5.66 6.33 4.75 5 4 6.5 2 4.19 31.66 33 15.66 12.66 62 34.67 32 64.67 44.33 29 11.5 25 21 6.66 10.5 10.5 8.33 14 7 5.25 11.39 17.5 16 4.78 62.67 35.33 33 68 41.33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 62.67 36 35 71.33 49.33 0 0 0 0 0 0 0 0 0 0 7.47 13.77 35.5 19.28 3.61 62.67 36.67 36 73.33 48.67 0 4 9.5 0 3 8 11 7 0 0 10.63 9.39 10.25 15.5 3.9 63.33 37.33 37 62.67 38 15 12.5 25 12.5 9.66 9 26 3.5 12.5 8.33 0 0 0 0 0 63.33 37.33 40 74 52 6.5 16 2 18 8.5 7.5 23 9.33 3.33 0 30 142 141 143 18.28 63.33 37.33 41 72 37.33 6.33 11.5 5 27 5.33 0 17 18 5.33 8 7.75 17.83 15.57 34.25 11 63.33 37.33 45 66.67 36 31 28 34 20 28 14.5 31 0 0 7.5 4 14.66 27.25 35 8.22 63.33 37.33 47 64.67 32.67 8 21 4.33 3 3.5 4 4 2 5 10 17.42 12.85 23.39 21.39 14.5 64 38 50 66 44 8 8 11.5 23 14.5 8 4.75 8 16 9.33 5.59 22.2 29.25 33 5 64 38 51 60.67 30 0 16.5 5.33 6 6 5 0 0 0 8.5 7.07 37 12.42 13.71 8.44 64.33 38 52 70 49.33 5.66 5.33 5.75 10 1 7 3 5 2 5 4.92 18 14.66 24.75 5.22 64.67 38 53 70 38.67 4 9 3.66 11 4.5 1 0 0 1 1 4.53 4.41 16.66 15.42 7.22 64.67 38.67 57 74 50.67 6.33 7.5 8 16 13 6 14 3 28 32 14.71 30.75 15 9.6 7.75 64.67 38.67 58 84 44 2 10.5 6.5 6.25 0 13 14.5 15 14.5 7 6.25 15.25 41.66 36.5 4.42 65 38.67 60 69.33 40.67 0 2 0 0 1.33 0 1.66 0 1.6 2.5 1 1.6 0 50 9.6 65.33 38.67 62 72.67 44 3.5 5.66 15.5 14.5 36 13.5 15 26 36 31 20.28 78.5 37.25 39 15.77 65.33 38.67 64 61.33 38 6 0 0 0 4.5 0 0 0 0 0 4.53 10.3 15.14 10.89 8.08 65.33 38.67 65 76.67 53 28 33 16 12 13.5 10 4.75 4 1 27 10.37 6.66 9 24.33 8.62 66 38.67 66 68 44 12 12 6.66 12 0 7.66 9 10.33 8.66 20 2.25 16.87 36 31 7.72 66 39 69 70 40.67 11 16 13 7.5 24 9.5 2.66 4 5.5 5.5 5 21 23.79 28.5 9.54 66.67 39.67 70 73.33 48.67 34 16.5 15 10 24 17.5 16 15 30 12.5 15.25 66 70.5 25.2 7.4 66.67 40 71 64.67 41.33 17.5 27 6.66 12.5 7 1.75 4 2 0 10 12.12 19.83 32.5 49 8.85 66.67 40 73 63.33 34.67 31 21 14 14 5 0 8 0 10 0 6 11.57 23.39 14.85 20 67 40 74 94.67 62.67 16 12.5 14 9.5 11.5 10 16.5 7.66 9 8.5 8.18 6.62 11.37 21.66 6.22 67.33 40 75 82.67 57.33 2.5 0 0 0 0 4.66 5 0 0 2 9.5 17 19.39 20.79 7 68 40 76 74.67 50 999.99 999.99 999.99 999.99 999.99 999.99 999.99 999.99 999.99 999.99 11.12 23.75 20.2 16 16 68 40.67 77 63.33 43.33 25 27 8.33 9.66 7.33 27 4.5 13.5 14.5 9 7.3 15.16 18.66 34 8.55 68 40.67 79 95.33 62.67 8 22 7 0 5.5 13 14 3.66 19 13 3 8.8 11 23.5 4.5 68 40.67 80 60 40 9.5 25 6.5 0 0 0 29 5.33 21 9.66 10.33 31.75 65 15.28 15 68.67 40.67 81 60 32.67 12 17.5 17 38 20 20.5 5 15.5 7 12 25.33 27.6 51 24.16 16 68.67 40.67 82 59.33 40.67 14 12 0 0 0 0 0 0 0 11 11.5 12.11 9.88 14.42 6.88 69 41 83 90.67 53.33 12 5 4.66 2.5 12 22 6 15 8.33 8.5 12.66 24.39 29.25 42 9.12 69.33 41 84 73.33 38.67 13.5 14.5 8.66 13.5 28 14.5 13.5 30 7.25 14.5 7.36 14.14 4.19 10.22 7.44 69.67 41.33 85 68.67 34 0 1 2 0 1 3 0 0 0 1 3.62 2.38 2 1.75 1.66 70 41.33 86 77.67 53.67 8.25 13 9.5 4 2.5 9.33 6 3.66 26 6.66 6.91 26 42.33 68 12.42 70 41.33 87 67 45 3.5 5 2 0 0 0 0 0 0 0 9.85 23.6 42.66 83.5 6.66 70 41.67 88 70.67 33.33 9 26 27 15 28 28 10.5 2 28 17 28.75 155 139 146 15.16 70 42 90 70.67 37.33 5.5 4.5 24.5 36 25 4.66 3 2 3 7 11.33 23.39 28.75 19.42 4.38 70.33 42 92 78 42.67 9 10 8 1 4.5 7 3.5 3 4.75 7.33 5.33 6.54 18.83 29.6 4.59 70.67 42 93 76.67 52 14 7 5 2 4.5 9 5 0 4.66 2.25 8.12 10.62 5.9 11 11.83 70.67 42 94 84.67 42 999.99 999.99 999.99 999.99 999.99 999.99 999.99 999.99 999.99 999.99 7.11 16 12.16 15.5 9.55 70.67 42.67 96 70.33 34.33 10.5 22 12.5 9 8 18 7.5 5 14 6.33 21.25 7.11 6.5 8.5 7.16 70.67 42.67 99 89.33 34.33 4 1 0 0 0 0 0 0 0 0 1.79 1.75 1.62 4.19 7 70.67 42.67 100 68 33 11 10.5 2.33 5 3 5.75 3 3.66 10 25 8.69 18.83 46.33 30.5 5 70.67 43.33 101 62 37.33 4 3.5 8.5 9.5 8.33 5.4 3.33 11 6 5.33 5.18 13.62 32.75 40.66 8.77 71.33 43.33 103 70.67 38.67 3.33 3.66 6.5 4 6.5 5 8 1.33 1 4 3.77 14.28 13.62 18.33 5.41 71.33 43.33 106 65.33 43.33 22 15.5 15 16 11 18 21 22 15.5 13.5 11.5 28.25 49 27.25 13.19 71.33 43.33 107 71.33 42 32 13.5 0 0 1 0 0 0 6 1 6.63 11.5 26.79 5.19 999.99 72 43.33 108 89.67 39.67 14 19 8.5 3.5 14 10.5 6.33 3.5 13 22 7.9 31 23.5 11.25 3.59 72.67 43.33 110 78.33 35.33 7 1 1 1 31 6 3 0 3 1 6.5 15.33 14.8 14.22 8.85 72.67 44 111 83.33 40 7.33 4.66 4.33 10 3.4 6 3.33 4 10.5 9 11.3 21.83 22.33 12.5 13.39 73.33 44 112 74 41 17.5 13 37 8.33 13 27 10 8.33 30 35 3.25 18 13.33 39 5.71 73.33 44 113 68 39 13 8.66 4.4 11.5 13 9 0 0 0 0 7.77 10.11 20.2 8.62 7.62 73.33 44 114 73.33 40.67 12 27 17 13 12.5 8.5 4.5 4.5 9.33 7.33 5.81 9 10.57 9 5.14 73.33 44.33 115 77.33 48.67 22 26 10 0 2.66 0 0 1 2 2.5 4 18 22.2 33 5.57 73.33 45 116 70 40 27 24 13.5 11 28 10 5.25 14 12.5 5.33 7.85 9 18.79 7.77 11.71 74 46 117 69 41 27 37 15 6.33 11.5 9 4.5 2 7.66 8.33 8 11.42 18.66 20.66 17 74 47.33 118 67.33 51 6 3.75 7 1.5 9 0 4 0 3 3.33 8.75 7.85 8 8.6 6 74 47.67 119 76 40 2.75 5 2 3.66 3.66 5.66 6.5 2.5 10 3 9 12.57 37.66 23.25 3.63 74 48 120 59.67 37.33 4 4 8 3 5.5 5.66 1.5 1 2.33 11 3.83 47 8.33 21 6.85 74.67 48.67 122 66.67 48.67 24 16 14 4.5 0 5.5 6 0 2 0 999.99 999.99 999.99 999.99 999.99 75.33 48.67 123 59.33 32 21 8.5 6 12.5 6 5 7 7.5 6 3 10.25 24.25 40 27.79 10.75 76 48.67 126 64 40 8.33 22 8.5 8 7.33 10 8 4 12.5 10.5 15.28 84.5 46 49.66 15.66 76.67 48.67 127 64 31 21 12 6.33 4 21 14 6.66 5.33 6 0 2.18 6.19 10.62 22 5 76.67 48.67 128 52 28 7.66 7 9.5 5 23.01 9.5 3.5 7 4.5 4.33 8 20.79 20 19 8.89 77.33 48.67 129 68.67 36.67 2.75 4 2.25 1.79 0 3.33 5.25 5.66 6.33 10.5 7.4 4.23 4.23 23.79 9.66 77.67 49.33 130 82 55.33 2 0 0 0 0 0 1 4 2 0 5.25 1.75 75 46.33 12.33 78 49.33 131 63.33 32.33 9.33 13.5 9.33 27 14.5 28 9 9.5 8.66 30 6.66 69.5 69 68 8.5 78.33 50 132 79.33 38 40 35 32 36 31 29 29 31 26 33 8.91 30.25 30.79 27.66 13.66 79.33 50.67 133 65.33 38.67 12.5 7.66 7 4 5.25 7.66 5.33 5.33 10.5 3.75 12.16 37.25 30.5 38 8.33 79.33 50.67 134 61.33 42 4.5 11.5 22 10.5 23 14.5 10 0 17.5 5 65.42 22.79 8.55 6.44 9.75 81.33 51 135 64.33 40.67 2 4 3.66 0 1 4.33 0 0 4.33 3.79 4.53 6 21.6 32.25 6.15 81.67 52 136 61.33 41.33 10 9 9 7 0 20 6.66 0 7 4.5 5 7.66 39.33 28.75 8.85 82 52 138 73.33 48.67 5 3.25 6.5 15 6.33 6 5 9 12.66 17 12.39 13.42 13.42 58 5.5 82.67 53 139 56.67 38 21 24 9 32 24 27 26 2.33 37 25 11.37 32 34.5 20.25 15 82.67 53.33 142 65 33 17 28 9 17 10 25 8 4 12 10.5 5.85 16 11.11 23 5.76 83.33 53.33 145 81.67 55.33 9.5 6.75 12 10.5 7 6.33 4 4 7 1 4 8 15.33 18 5 84 53.67 146 70.67 47.67 5 5.5 5 7 7.33 4.59 11 6 1 1 13.87 32.5 22.2 12.62 11.44 84.67 54.67 148 79.33 50.67 9.66 30 17.5 25 10.66 10.66 24 12.66 25 9.66 10.33 8.72 11.5 28.2 9.22 84.67 55.33 149 63.33 46 15 15 0 0 0 19 9 34 32 26 17.79 130 17 7.75 1.33 89.33 55.33 150 62.67 43.33 11 1.5 3 2 10 4 7 9 12.5 8 2.77 6 9.1 13.14 4.25 89.67 57.33 151 62.67 42.67 17 10.5 4 4.5 15 5.66 2.5 3.25 9 3.66 4.83 17.6 12.14 12.87 6 90.67 61.33 152 65.33 43.33 26 13 25 21 21 22 7 11 10.5 1 3.55 11.85 9.14 7 9 94.67 62.67 154 69.67 47.33 0 16.5 5.33 6 6 5 0 0 1 8.5 5.75 11.66 18.33 10.37 6.5 95.33 62.67

Math 4544 Spring 2020 Exam 2 Name__________________________________ Please show all of your work. Please use free space for each question. No credit will be given for incorrect work. Test = 120 points + 10 point bonus problem. 1. (G 30 points, U 40 points) A study considered risk factors for HIV infection among intravenous drug users. It was found that 40% of users who had ≤ 100 injections per month (light users) and 55% of users who had > 100 injections per month (heavy users) were HIV positive. Use the Binomial distribution for the estimation below. a) What is the probability that exactly 3 of 5 light users are HIV positive? b) What is the probability that at least 3 of 5 light users are HIV positive? c) A group of 10 heavy users is followed, and 8 of them are found to be HIV positive. Is this event unusual? 2. (G 30 points, U 40 points) a) Suppose the incidence of a specific birth defect in a high socioeconomic status (SES) census tract is 50 cases per 100,000 births. If there are 5000 births in the census tract in 1 year, then what is the probability that there will be exactly 5 cases of the birth defect during the year? Use the Poisson distribution for the estimation. b) Suppose the incidence of the same birth defect in a low SES census tract is 100 cases per 100,000 births. If there are 12,000 births in the census tract in 1 year, then what is the probability that there will be at least 8 cases of the birth defect during the year? How unusual is this event? 3. (G 30 points, U 40 points) In pharmacologic research a variety of clinical chemistry measurements are routinely monitored closely for evidence of side effects of the medication under study. Suppose typical blood-glucose levels are normally distributed, with mean = 90 mg/dL and standard deviation = 38 mg/dL. a) If the normal range is 65 – 120 mg/dL, then what percentage of values will fall in the normal range? b) In some studies only values at least 1.5 times as high as the upper limit of normal are identified as abnormal. What percentage of values would fall in the abnormal range? c) Answer Problem 3 b) for values 2.0 times the upper limit of normal. 4. (Graduate Students only: 30 points) The differential is a standard measurement made during a blood test. It consists of classifying white blood cells into the following five categories: (1) basophils, (2) eosinophils, (3) monocytes, (4) lymphocytes, and (5) neutrophils. The usual practice is to look at 100 randomly selected cells under a microscope and to count the number of cells within each of five categories. Assume that a normal adult will have the following proportions of cells in each category: basophils, 0.5%; eosinophils, 1.5%; monocytes, 4%; lymphocytes, 34%; and neutrophils, 60%. a) Physical or mental stress, and even smoking, can increase neutrophil level. What is the probability that a normal adult will have 60 or more neutrophils? Is this even unusual? b) What is the probability that a normal adult will have 70 or more neutrophils? Is this even unusual? 5. Bonus problem (10 points). An experiment is designed to test the potency of a drug on 20 rats. Previous animal studies have shown that a 10-mg dose of the drug is lethal 5% of the time within the first 4 hours; of the animals alive at 4 hours, 10% will die in the next 4 hours. What is the probability that 3 or more rats will die in the first 4 hours?

Related Questions

Similar orders to I need this biostatistics project done
34
Views
1
Answers
Coursework Plots, Grams
extra help for assignment...
72
Views
1
Answers
Statistics Final Project
**REQUIREMENTS ARE IN THE FILE THAT I HAVE UPLOADED** DUE DATE IS: November 20, 2020, 11:59 PM...
41
Views
1
Answers
Data set- statistics-
Use Excel’s COUNTIF function to find the number of days with a PM2.5 AQI value over 50. On such days, the air quality conditions are considered not to be “Good” per the EPA’s Air Quality Index. Use this to find the proportion of days for which the...
29
Views
1
Answers
Test 3, 24 Q
Pictures....