.. Merge & Center. $. % , ..: Condtional pormat Cell Formatting as Table Styles

Question

.. Merge & Center. $. % , ..: Condtional pormat Cell Formatting as Table Styles Paste An employme ent survey asked a random sample of human resource executives (some from public and some from private companies] whether their companies plan to 2 employees, lay off employees, or have no change in employees over the next 12 months. (See exercise 22 on page 515 of your textbook for a similar problem.) Use the data in the Workforce sheet in this workbook to generate excel output to answer the following questions. Each orange numerical answer cell below MUST reference E output cells in the workforce sheet Oestion 4A . Can you see fromdata that the proporton of hblic comoariel pia" to add engloyees over the net umoma the next 12 monchs is different from the prepartion of Private compenies who plan to do so at 0 005? State the hypothesis in terms of Publc- Private snep 1: Step 2: Step ill in row 183 If the n row 183 if ehe hypothesis is two tailed The smaler number must be typed fest Reject HO if cep 4 Step 5 Step S0ep 7; 4Question 4 Construct a nterval for the ditference in population propoions se the C.l.Excel gives for Pabilic-Prlivate to stace the C.I, in terms of Prhate-Puble Lower Endpeint Upper Endpoint 4HWNotes HW Camera Workforce Razor Ready

Explanation / Answer

Test and CI for Two Proportions

Method

Descriptive Statistics

Estimation for Difference

CI based on normal approximation

Test

The pooled estimate of the proportion (0.379573) is used for the tests.

Step 3

critical value = 2.807

it is z0.0025 not z0.005   

Rest are correct

p: proportion where Sample 1 = Event p: proportion where Sample 2 = Event Difference: p - p

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.