
Home Work Assignment 5for MSIS 385 section 02Last modified on 5/5/99 9:10 PM Due May 10 1999Note: This is a firm deadline; no late homework will be accepted. Answers will be posted on the night of tenth on the home page. 

Note: 
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.


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.) 







