# Homework 3

**Exercises 7.1**

1. Using =TINV( ) and Equation 7.1, compute the just 95 percent surpassing and inferior dependence conditions for hr succeedingcited:

a. *n = *40, moderation = 32, *S.E. =* 1.23

b. *n = *40, moderation = 32, *S.E. = *3.23

c. *n = *140, moderation = 32, *S.E. = *1.23

d. *n = 140, *moderation = 32, *S.E. = *3.23

2. Using *t = *2 and Equation 7.1, compute border 95 percent surpassing and inferior dependence conditions for the succeedingcited:

a. *n = *40, moderation = 32, *S.E. = *1.23

b. *n = *40, moderation = 32, *S.E. = *3.23

c. *n = 140, *moderation = 32, *S.E. = *1.23

d. *n = 140, *moderation = 32, *S.E. = *3.23

3. How polite do the prizes in Exercise 2 border those in Exercise 1?

7. Use the hospital load worksheet in the finish Chpt 4-1.xls. Assume that the facts personate a chance scantling from a wider population and do the succeedingcited:

a. Calculate the just 95 percent surpassing and inferior dependence conditions for the population moderation of LOS.

b. Calculate the just 95 percent surpassing and inferior dependence conditions for the population moderation of loads.

c. Calculate the just 95 percent surpassing condition simply for the population moderation of loads-that is, the prize beneath which 95 percent of all scantling moderations accomplish be respected to descend.

d. Calculate the just 95 percent surpassing and inferior dependence conditions for the population uniformity, which is womanly.

**Exercises 7.2**

1. Use the finish generated by selecting one hundred scantlings of thirty indecision intervals (see unshaken facts set for Exercise 7.2).

a. Calculate the just 95 percent surpassing inferior dependence conditions for each scantling.

b. Use the =AND( ) announcement, as loving in Figure 7.3, to detail whether the dependence conditions for each scantling include the gentleman population moderation.

c. Use =COUNTIF( ) to detail whether the uniformity of scantlings of the one hundred substantially includes the gentleman moderation of the population among the 95 percent conditions.

d. Can you recital for the issue you got in (c)?

**Exercises 7.3**

(SEE ATTACHED IMAGE FOR EXERCISE 7.3) #1 simply

**Exercises 7.4**

6. Consider the succeedingcited conjecture. H0: mediocre require per come in a wide hospital is $6,200, and H1: mediocre require per come is $5,600, to be ordealed at the 95 percent plane of dependence. A scantling of one hundred and twenty memorials has been selected and assessed for require. The gauge hiatus of the requires is $3,100.

a. Is alpha unreserved in element? If yes, can its prize be methodic from the knowledge loving? If yes, what is the alpha?

b. Is beta unreserved in element? If yes, can its prize be methodic from the knowledge loving? If yes, what is beta?

**Exercises 7.5**

1. Calculate the border extent required for each of the succeedingcited at 95 percent dependence:

a. Standard hiatus = 10, (ME) = 0.5, two tail

b. Standard hiatus = 10, (ME) = 0.5, one tail

c. Standard hiatus = 10, (ME) = 1.5, two tail

d. Standard hiatus = 10, (ME) = 1.5, one tail

e. Standard hiatus = 35, (ME) = 5, two tail

f. Standard hiatus = 35, (ME) = 5, one tail

g. Standard hiatus = $3,200, (ME) = 400, two tail

h. Standard hiatus = $3,200, (ME) = 400, one tail

2. A hospital dignitary wants to appraise mediocre require per come in his literature. He is accomplishing to be among $200 of the gentleman prize delay a chance of 95 percent. An judicious scrutiny of a chance scantling of ten memorials detaild that the gauge hiatus of require was $3,987. How wide a scantling accomplish scarcity to be taken to coalesce the dignitary’s scarcitys?

**(PLEASE DO THE FOLLOWING QUESTIONS BELOW ON A SEPARATE EXCEL WORKBOOK)**

** **

** **

**Exercises 9.1**

1. (SEE ATTACHED IMAGE FOR EXERCISE 9.1, Number 1). Please repartee 1a-c simply.

2. Determine the chance of *t *in each stance in Exercise 1a-c simply, and determine for each whether you would recognize or decline H0.

**Exercises 9.2**

1. (SEE ATTACHED IMAGE FOR EXERCISE 9.2, Number 1). Please repartee 1a-b simply.

2. Detail the chance of the *t *ordeal issue in (a) and (b) of Exercise 1 and determine whether you would recognize or decline the conjecture of no dissimilarity among the two collections in each predicament.

3. (SEE ATTACHED IMAGE FOR EXERCISE 9.2, Number 3). Please repartee 3a-b simply.

4. Determine the chance of the *t *ordeal issue in (a) and (b) of Exercise 3 and determine whether you would recognize or decline the conjecture of no dissimilarity among the two collections in each predicament.

8. (SEE ATTACHED IMAGE FOR EXERCISE 9.2, Number 8). Please repartee 8a-b simply.

**Exercises 9.3**

2. The facts on the Power worksheet of Chpt 9-2.xls personate the power of twenty five who wen tin a prescribed victuals at the fixation of one year interval age. The Anteriorly powers are their powers at the initiate of the program and Succeeding are their powers one year succeeding.

a. Use the formula in Equation 9.13 to ordeal the conjecture that power anteriorly equals power succeeding resisting the opinion that power succeeding is near than anteriorly, and denote your blank.

b. Use the Excel add-in for cognate facts and involve the issues fix in (a).

**Exercises 10.1**

1. Use the facts on the Costs worksheet of Chpt 10-1.xls and involve the calculations in Figure 10.3.

a. Use a pivot consideration and the formula in Equation 10.1 to compute the among collection sums of balance (*SS *8) for the requires in the indelicate hospitals.

b. Use the issues of the pivot consideration from (a) and the formula in Equation 10.2 to compute the among collections sums of balances (*SS* w) for the requires in the indelicate hospitals.

c. Use the formula in Equation 10.3 to compute the sum sum of balances (*SS T) *for the requires in the indelicate hospitals.

d. Determine the misspend degrees o immunity and use the formula in Equation 10.4 to compute the *F *prize for a ordeal of the void conjecture tat the moderation requires in the indelicate hospitals are all the selfsame.

e. Use the =FDIST( ) administration to accomplish the chance of the *F *prize and inhale the misspend blank in reverence to the void conjecture.

(I besides unshaken a draw of Exercises 10.1, #1 for improve reason).

3. On a novel spreadsheet, substitute the facts on the Costs worksheet of Chpt 10-1.xls into indelicate columns, as shown in Figure 10.4.

a. Use the ANOVA: Single-Factor facts resolution add-in to raise out the resolution of antagonism

b. Confirm that the issues are the selfselfsimilar as those accomplished in Exercise 1.

**Exercises 10.3**

3. Substitute the facts for hospital LOS as loving in Figure 10.16 and raise out the resolution of antagonism using he ANOVA: Two-factor delay Republican add-in. Confirm that the issues are the selfselfsimilar as those fix in Exercise 1.