Home Work Assignment 5

for MSIS 385 section 01

Last modified on 12/5/99
Due on December 15 1999 in class

Note:

You need to hand in parts of this assignment on a diskette or by e-mail 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 e-mail, 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 e-mail 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 P-value method.

Question 3

Do problem 13.17 on page 479 of your text. Use appropriate Excel toolbox. Use p-Value 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 P-value 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 p-value method.

Question 8

Do problem 15.32 part a) only on pages 631-632 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 chi-square test to determine if this die is fair with 3% significance level. Use both Critical region method and P-value method.


Return to: Homework page | MSIS 385 page