Reference no: EM131259092
Biostatistics Excel questions
Answer fully- no plagiarism!
The purpose of this discussion is to apply what you learned in the readings in this unit related to the process of summarizing data.
If you have not already done so, complete Practice Problems 1-4 below, using an Excel file. Save the Excel file you created for with your last name in the file title.
For your post in this discussion, provide a summary of the results for each of the four problems. For each problem, your description should include a discussion of the findings, using the statistical terms appropriate to describe the characteristics you are analyzing. Things to consider for each summary include (but are not limited to) the following questions:
• How would you describe the way that the data are distributed?
• Compare the mean and the median. What does the comparison suggest, in terms of the research question?
• Are there any outliers? If so, explain what those outliers might mean in terms of the research question.
• How close is the standard deviation to the mean? What might that suggest in terms of the research question?
PRACTICE PROBLEMS
1. A study is conducted to estimate the mean total cho-lesterol level in children 2-6 years of age. A sample of 9 participants (n= 9) is selected, and their total cho-lesterol levels are measured as follows.
185 225 240 196 175 180 194 147 223
a. Use the Data Analysis lbol to compute the sample mean, standard deviation, and median.
b. Use the QUARTILE function to compute the first and third quartiles.
2. Data were collected as part of a study or coffee consumption among graduate students. The following reflect cups per day consumed:
3 4 6 8 2 1 0 2
a. Use the Data Analysis Tool to compute the sample mean, standard deviation, and median.
b. Use the QUARTILE function to compute the first and third quartiles.
3. In a study of a new antihypertensive medication, SBPs are measured at baseline (or the start of the study, before any treatment is administered). The data are as follows:
120 112 138 145 135 150 145 163
148 128 143 156 160 142 150
Use Excel functions to compute the sample mean, standard deviation, median, and quartiles.
4. The following are baby height measurements, in cen-timeters, for a sample of women participating in a study of pregnancy outcomes:
28 30 41 48 29 48 62 49 51 39
Use the Data Analysis Tool to compute summary statistics.
|
Example of a sequence that gets arbitrarily close
: (a) If possible, write down a convergent sequence that is not bounded. If this is not possible, BRIEFLY explain why (b) Give an example of a sequence that gets arbitrarily close to L=1, but does not converge to L=1.
|
|
Describe and apply various dimensions of management
: Discuss the roles managers perform, the skills they need to execute those roles effectively, and the way new information technology is affecting these roles and skills. Compare and contrast the principal challenges managers face in today's increas..
|
|
Write program named demojobs for harolds home services
: Create a program named FriendList that declares an array of eight Friend objects and prompts the user to enter data about the friends. Display the Friend objects in alphabetical order by first name.
|
|
Find manufacturing lead time for a pari coming off the line
: Suppose the part in previous Problem 2.5 is made in very large quantities on a production line in which an automated work handling system is used to transfer parts between matches.
|
|
Compute the sample mean standard deviation and median
: Data were collected as part of a study or coffee consumption among graduate students. The following reflect cups per day consumed: Use the Data Analysis Tool to compute the sample mean, standard deviation, and median.
|
|
What is this gift worth at the present time
: Your rich aunt gives you a high school graduation present of $110,000. Her present is in the form of a 7-year bond with an annual interest rate of 8.4%. The bond says that it will be worth $110,000 in 7 years.
|
|
Determining the area of a triangle
: The base of a triangle is 4 inches longer than the height. If its area is 70 square inches, then what are the base and the height?
|
|
Determine the travel speed
: Assume that the melting factor = 0.25. A continuous fillet weld is to be made with a cross-sectional area = 15.0 mm2 . Determine the travel speed at which the welding operation can be accomplished.
|
|
Problem regarding the us energy consumption
: U.S. Energy Consumption From 1950 to 1970, per capita consumption of energy in millions of Btu can be modeled by f(x) = 0.25x2 - 975x + 950,845, where x is the year.
|