# Problem Set 4 - Excel

Document Sample

```					                                                                                   Problem Set 4

You work for a pharmaceutical company that is currently testing a new antihypertensive (drug to reduce blood pr
preliminary analysis looking at the effectiveness of this drug. You have a sample of 104 patients who all had, prio
patients were given varying dosages of your drug, including some receiving a placebo. The quantity they were giv
"dosage." After a two month treatment period, each patient had their systolic blood pressure retested; the differ
pressure can be found in the colum "pressure." Lower (i.e. "more" negative) numbers in this column indicate a gr
that their systolic blood pressure actually increased. You also have data on patient blood type (A, B, AB, and O) in
following questions. Problem 4.1 comes from week 9 material, 4.2 comes from week 10 material, and 4.3 relates
4.3 is extra credit. Should you encounter any difficulties with these problems, the optional problems below are ve
optional questions can be found in the back of the textbook. You can also request that the tutor work extensively

Problem 4.1

The first issue your boss has asked you to address is whether or not there are differences in the effectiveness of th
significance to:
a) Perform a one-way ANOVA to look for differences in changes in blood pressure between blood types.
b) If the results in (a) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which blood ty
c) Briefly summarize (in plain English) your procedures and the results of (a) and (b) for your manager.

Excel Tips: When using the Data Analysis ToolPak, Excel requires that your data be formatted differently for ANOV
for regression analysis, so you will have to transform your data prior to estimating the ANOVA.

Problem 4.2

In addition to looking at differences between blood types, your manager also wants to know the relationship betw
is your independent variable and the change in blood pressure is your dependent variable.
a)Construct a scatter plot of the two variables (note: the scatter plot should look non-linear. Still, do these quest
b)Estimate a simple linear regression between these two variables.
c)Interpret the meaning of β0 and β1.
d)Predict the mean blood pressure change associated with dosages of 0, 2.5, 5, 7.5, 10, and 12.5 Are these appro
e)Comment briefly on the predictive power/statistical significance of your estimates.

Problem 4.3

EXTRA CREDIT. To answer this question, you will need to read the materials for week 11 of the class. Here, your ta
Your first step is to generate a quadratic term for your dosage variable (see section 15.1 in your text).

a) Estimate a multiple regression model, again using pressure as the dependent variable, however for your indepe
dosage variables (i.e. X1 is dosage and X2 is dosage squared).
b) Comment on the results from (a) in light of your results in 4.2.
c) Calculate the optimal dosage of your drug (WARNING: There are a few ways to figure this out, but dusting off y
include graphine the regression equation and locating the minimum or plugging values into the regression equatio
Optional Problems

Levine, questions 11.14, 13.74.
Problem Set 4

rtensive (drug to reduce blood pressure). Your manager has recently asked you to do a quick
e of 104 patients who all had, prior to this test, a systolic blood pressure of approximately 175. These
cebo. The quantity they were given is measured in mg/kg/day and is found in the column titled
blood pressure retested; the difference between their initial blood pressure and their new blood
mbers in this column indicate a greater reduction in systolic blood pressure, and higher numbers imply
ent blood type (A, B, AB, and O) in the column titled "blood type." Use this data to answer the
week 10 material, and 4.3 relates to week 11 material. Because this is due before week 11, question
e optional problems below are very similar to the questions in this problem set, and the answers to the
st that the tutor work extensively with you on the optional problems.

fferences in the effectiveness of the drug between the four different blood types. Use the 0.05 level of

re between blood types.
dure to determine which blood types differ in mean blood pressure changes.
(b) for your manager.

be formatted differently for ANOVA than for regression. The data as downloaded is formatted correctly
ng the ANOVA.

ants to know the relationship between dosage and change in systolic blood pressure. Thus, the dosage
nt variable.
k non-linear. Still, do these questions and we'll address the non-linearity in 4.3)

7.5, 10, and 12.5 Are these appropriate predictions?
ates.

week 11 of the class. Here, your task is directly tackle the non-linearity issue we found in problem 4.2.
ion 15.1 in your text).

variable, however for your independent variables you will want to use both the linear and quadratic

to figure this out, but dusting off your calculus skills makes this very easy! Other, less precise methods
values into the regression equation until you find the dosage that minimizes your dependent variable)
Blood Type       Pressure Dosage
3          -11       2   Note: In column A, 1=A, 2=B, 3=AB, and 4=O
4          -11       4
4          -16       2
3            2       8
3            8      10
1          -12       1
1           -3       0
1           -4       8
1           -9       0
3            5       9
1           -1       8
2          -10       3
1           -5       0
4          -11       7
1           -1       9
4           -4       1
1           -9       7
1           16      10
2           -9       0
3            5       9
2           -4       0
3           -4       0
1          -17       5
1           -4       0
1          -19       4
4            1       9
2            3       9
2          -12       5
3           -9       7
4            0       9
3           -8       1
2          -12       3
4          -11       6
1          -18       3
3           -8       7
3          -17       5
4          -15       3
2          -14       5
4          -13       1
3          -10       3
3           -5       7
2           -6       8
1           -6       8
3          -17       5
3          -13       3
4           -3       8
4    -4    0
2     2    0
1   -14    6
3    -5    0
3    -9    2
3    -6    0
2    -9    1
3   -11    7
3   -13    3
2    -5    0
4   -15    2
4   -12    1
1   -12    7
3    -5    0
2     8   10
1    -6    1
2   -17    4
1     9   10
1   -15    7
4   -14    6
4    -2    8
3    -6    0
2    -6    7
3     6    9
4    -8    8
3   -10    5
4    -7    7
4    11   10
2    -7    8
4   -17    2
1   -17    5
4    16   10
4    -9    1
2    -4    8
2   -14    2
2     8   10
2    -4    7
3   -10    2
2    -2    0
3     4   10
3    -4    8
2   -12    1
1   -13    4
4    -7    0
1     9   10
1    -4    0
4    -4    8
3    -1   0
2   -10   7
3    -7   1
3   -14   3
3   -14   4
1   -10   6
3   -14   6
2   -13   2
2    -8   7
1   -12   1
1   -18   4

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 12 posted: 9/7/2012 language: Unknown pages: 7