
Home Work Assignment 5for MSIS 385 section 01 Last modified on 

Note: 
You need to hand in parts of this assignment on a diskette or by email to alizadeh@andromeda.rutgers.edu. Use a single Excel file and put all Excel related questions in that file, one worksheet per question. Make sure the name of the worksheet matches the question number you are answering, for example you can name the worksheets Question 1, Question 2 etc. For those questions that you need to use calculator and tables in your book, you may either hand in the answers handwritten on paper or use some common text format (e.g Word or text file format) file. If you choose the latter method then use only one text/Word file and put answers to questions in that file. Make sure to put your name, student ID number and the date on the diskette . If you are using email, make sure it is sent before class period on Wednesday Decmeber 15. Put your files in a single .zip file with your first name followed by your last name, for example: JohnSmith.zip. In the email messege subject fiels write Hw5 MSIS 385 verbatim. As usual the homework is due at the beginning of the class period on the due date. Late homeworks will lose 25%. Remember: If you miss more than two homework assignments you will automatically fail the course, regardless of your score in exams and other assignments 

Question 1 
Do problem 13.6 using your calculator an tables at the back of your text. (Don't use Excel except for checking your answer.) Use the critical region method for testing your hypothesis. 

Question 2 
Do Problem 13.7 on page 470 of your text. Use appropriate Excel toolbox to solve this problem. Use Pvalue method. 

Question 3 
Do problem 13.17 on page 479 of your text. Use appropriate Excel toolbox. Use pValue method. 

Question 4 
Do problem 13.61 on page 509 of your text using an appropriate Excel toolbox. Use critical region method. 

Question 5 
Do problem 13.62 of your text on page 509 using your calculator and tables in your text. Do not use Excel except for checking your answer. Use Pvalue method. 

Question 6 
Do problem 15.13 on page 615 of your text using calculator and tables in your text. Do not use Excel except for checking your answer. Use the critical region method. 

Question 7 
Do problem 15.15 on page 615 of your text using Excel. Use pvalue method. 

Question 8 
Do problem 15.32 part a) only on pages 631632 of your text using your calculator and tables in your book. Don't use Excel except for checking your answer. Use critical value method. 

Question 9 
A die is tossed 120 times and the results are listed below. 

Up face 
1 
2 
3 
4 
5 
6 

Frequency 
18 
23 
16 
21 
18 
24 


Using Excel set up a contigency table and apply the chisquare test to determine if this die is fair with 3% significance level. Use both Critical region method and Pvalue method. 


Return to: Homework page  MSIS 385 page 
