logistic

LOM 3300 Computing Exercise 1 Due 2-16-16

15 pts

Consider the data in the file “Computing Exercises 1&2 Data” on MyGateway. Add four new observations 6st, 6uv, 6wx, and 6yz, where stuvwxyz are the eight digits of this number. For example, if your number is 18051821, then you would add 612, 634, 656, and 678. Assume this data follows a normal distribution with standard deviation 115. Following the approach on page 436 of the text, use Excel to perform each of the following three tests about the mean of the distribution the data comes from, each at the .05 level:

(a) test whether the mean is above 440,

(b) test whether the mean equals 515,

(c) test whether the mean is below 565.

Submit printouts of your spreadsheet(s) in two versions: one with numbers showing and one with formulas showing. On the numerical printout(s) for each test circle the appropriate p-value and write whether the conclusion is to accept or to reject.