Stem Cell Transplant & Worker Motivation Problems

See attached file for data.

10.28 Multiple myeloma, or blood plasma cancer, is characterized by increased blood vessel formulation (angiogenesis) in the bone marrow that is a prognostic factor in survival. One treatment approach used for multiple myeloma is stem cell transplantation with the patient's own stem cells. The following data (stored in the file myeloma.xlx) represent the bone marrow microvessel density for patients who had a complete response to the stem cell transplant, as measured by blood and urine tests. The measurements were taken immediately prior to the stem cell transplant and at the time of the complete response:

Patient Before After
1 158 284
2 189 214
3 202 101
4 353 227
5 416 290
6 426 176
7 441 290

a. At the 0.05 level of significance, is there evidence that the mean bone marrow microvessel density is higher before the stem cell transplant than after the stem cell transplant?
b. Interpret the meaning of the p-value in (a).
c. Construct and Interrupt a 95% confidence interval estimate of the mean difference in bone marrow micro vessel density before and after the stem cell transplant.
d. What assumption is necessary to perform the test in (a)?

10.29 Over the past year, the vice president for human resources at a large medical center has run a series of three-month workshops aimed at increasing worker motivation and performance. To check the effectiveness of the workshops, she selected a random sample of 35 employees from the personnel files and recorded their most recent annual performance rating, along with their ratings prior to attending the workshops. (The data are stored in the file perform.xls.) The Microsoft Excel results in Panel A and B both descriptive and inferential information so that you can analyze the results and examine the assumptions of the hypothesis test used: State your findings and conclusions I a report to the vice president for human resources.