Question about Hypothesis Testing:Intrinsic by Gender&Extrinsic by Position
TEST #1 Intrinsic by gender
Perform the following two-tailed hypothesis test, using a .05 significance level:
State the null and an alternate statement for the test
Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test. Copy and paste the results of the output to your report in Microsoft Word.
Identify the significance level, the test statistic, and the critical value.
State whether you are rejecting or failing to reject the null hypothesis statement.
Explain how the results could be used by the manager of the company.
Test 2 - extrinsic by position
State the null and an alternate statement for the test
Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test.
Copy and paste the results of the output to your report in Microsoft Word.
Identify the significance level, the test statistic, and the critical value.
State whether you are rejecting or failing to reject the null hypothesis statement.
Explain how the results could be used by the manager of the company
Solution Summary
The solution provides step by step method for the calculation of test statistic for the comparison of population mean. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included.
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
- Hypothesis Testing-Intrinsic & Extrinsic Values.doc
- HT & ANOVA.xlsx
Active since 2008
Responses 2624

"Thank you for the help. Can you show me how you got Critical values = ±2.575829304? I'm having a hard time finding how to get this. Thanks!"
"Thanks great help"
"Hi thanks for the excel format explanation, it makes it easy for me to understand."
"how exactly do you get = 0.1655 + 0.1146 + … + 0.0001 = P (X ≥ 12) = P (X = 12) + P (X = 13) + … + P (X = 18) = 0.1655 + 0.1146 + … + 0.0001 = 0.3743"
"Thanks for the great explanation and the excel fine."