Question: Calculate using excel formulas to get t= and p-value: Accessibility tab summary: Given information for this question is presented in row 2. Requirement information is
Calculate using excel formulas to get t= and p-value: Accessibility tab summary: Given information for this question is presented in row 2. Requirement information is presented in rows 5 through 16. A hiring company claims it finds jobs for its candidates with an annual salary of at least $260,000. To test the claim, you take a random sample of 100 individuals who used the hiring service and recorded their annual salary. Can we conclude at the 5 percent level of significance that the claim is true? Required: H0: 260,000 Ha: 260,000 Using the data contained in tab "Annual Salaries", determine the following: Sample Mean 263,377.92 Sample Standard Deviation 21,377.27925 Sample Size 100 t = p-value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
