Home Work Assignment 5

for MSIS 385 section 02

Last modified on 5/5/99 9:10 PM

Due May 10 1999

Note: This is a firm deadline; no late homework will be accepted. Answers will be posted on the night of tenth on the home page.


Make sure to put your name, student ID number and the date on the Assignment. The results of question 1 should be handed in on a floppy disk. You may use Excel to do any of the problems. However, make sure to document the worksheets well. Make sure each worksheet is clearly marked as to which question it is related to. Also make sure that the formulas you are using in your Excel worksheets are well documented and justified. Finally make sure to put your name ID and Homework number 4 on the diskette's label.


Question 1

Power curve with Excel

Consider problems 11.45 and 11.48 that you did for the last homework assignment. For part a) of each of these questions plot the power curve using Excel. Make sure to calculate the power for a relevant range of values for the alternative hypothesis that makes sense. Use data table tool (as was done in class) to get the value of power of the test for a range of values with increments of 100. Then use chart wizard to chart the table you generated. Pattern your work after the Excel worksheet problem121.xls that I posted in the home page.

Question 2

Do problem 12.13 on page 436.

Question 3

Do problem 12.15 on page 436.

Question 4

Do problem 15.3 on page 609

Question 5

Do problem 15.11 on page 614

Question 6

Do problem 15.21 on page 623

Question 7

Do problem 15.31 on page 631

For problems 8 through 11 you may use either direct calculation or Excel. However if you are using Excel you must enter the formulas in the worksheet yourself. DO NOT USE EXCEL DATA ANALYSIS TOOL TO SOLVE THEM. You may use Excel data analysis tool to check your answers if you wish.

Question 8

Do problem 13.5 on page 469

Question 9

Do problem 13.9 on page 471

Question 10

Do problem 13.15 on page 479.

Question 11

Do problem 13.19 on page 479.

Question 12

Consider the data in problem 14.6 on page 543. Use this data and do the following (you donít need to do problem 14.6, just use its data to answer the questions below.) Also do not use Excelís ANOVA data analysis tool to answer the following questions do the calculations manually or if you use Excel, enter the formulas explicitly to carry out the computations.

  1. Calculate for each drug (and the placebo) the mean and sum of squares. Calculate the mean of the whole population. Calculate the Sum of Squares Within drug groups (SSW). What is the distribution of this statistic (make sure to specify the degrees of freedom)?
  2. Calculate the Sum of Squares Among all drugs (SSA). What is the distribution of this statistic (make sure to specify the degrees of freedom)?
  3. For the Null hypothesis: H0: "all drugs have the same effect, thus all means are equal", and the alternative hypothesis Ha: "means are not equal for all drugs", calculate the F statistic, the P-value and the critical value for the significance level 0.05. Should you reject the null hypothesis based on your calculations?

Question 13

An optional bonus question

Two of your fellow students, Kalpana and Claudio, each have produced a sequence of 60 heads and tails. However, only one of them has actually tossed a coin, the other has created this sequence by him/herself attempting to make a random sequence. The data is stores in an Excel file. Determine which one has used a coin and which has made the data. Make sure to qualify your judgment by a significance level (of your own choice.)