Hypothesis testing for job satisfaction: Gender and Position type
Use the attached files.
TEST #1
Perform the following two-tailed hypothesis test, using a .05 significance level:
Intrinsic by Gender
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 variable by Position Type
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.
GENERAL ANALYSIS (Research Required)
Explain when to use a t-test and when to use a z-test. Explore the differences.
Discuss why samples are used instead of populations.
SEE the attached Templete Data sheet and the data tool pack if you don't have in your excel.
This question has the following supporting file(s):
- DataAnalysisToolPak.pdf
- DataSetandDataSetKey_1103B.zip
- BUSN311_U4IP_Template.doc
File Viewer (Click To Zoom)
File Viewer (Click To Zoom)
$2.19 
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
- Solution.docx
- Solution.doc
- Solution.xlsx
- Solution.xls
Active since 2009
Responses 476
Extracted Content from Question Files:
- DataAnalysisToolPak.pdf
Load the Analysis ToolPak
The Analysis ToolPak is a Microsoft Office Excel add‐in program that is available when you install Microsoft
Office or Excel. To use it in Excel, however, you need to load it first.
1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Add‐Ins, and then in the Manage box, select Excel Add‐ins.
3. Click Go.
4. In the Add‐Ins available box, select the Analysis ToolPak check box, and then click OK.
Tip: If Analysis ToolPak is not listed in the Add‐Ins available box, click Browse to locate it.
If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
5. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on
the Data tab.
6.
NOTE: To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you load the Analysis
ToolPak ‐ VBA add‐in the same way that you load the Analysis ToolPak. In the Add‐ins available box, select the
Analysis ToolPak ‐ VBA check box, and then click OK.
SOURCE: Microsoft.com
Although Mac is currently only supported for use in the AIU Bachelor of Fine Arts Program, this information is
provided to assist you in completing the course. Be advised that neither your instructor nor technical support
representatives may be familiar with the Mac version of Microsoft Office.
MAC HELP: I can't find the Analysis ToolPak
Cause: Excel 2008 does not include the Analysis ToolPak.
Solution: Download StatPlus:mac LE for free from AnalystSoft, and then use StatPlus:mac LE with Excel 2008.
You can use StatPlus:mac LE to perform many of the functions that were previously available in the Analysis
ToolPak, such as regressions, histograms, analysis of variance (ANOVA), and t‐tests.
1. Visit the AnalystSoft Web site, and then follow the instructions on the download page.
2. After you have downloaded and installed StatPlus:mac LE, open the workbook that contains the data
that you want to analyze.
3. Open StatPlus:mac LE.
4. From the StatPlus:mac LE menu, select the function that you want.
5. In StatPlus:mac LE, select the workbook data you want to work with, set your parameters and any
options that you want, and then click OK.
Note Excel 2008 does not include Help for StatPlus:mac LE. Help for StatPlus:mac LE is provided by
AnalystSoft.
SOURCE: Microsoft.com
- BUSN311_U4IP_Template.doc
Running head: BUSN311 - Quantitative Methods and Analysis 1
Unit 4 – Hypothesis Testing & Variance
Type your Name Here
Running head: BUSN311 - Quantitative Methods and Analysis 2
Hypothesis Test #1 Looking at Intrinsic Satisfaction by Gender
Null and alternate hypotheses.
Write out a Null & Alternate Hypothesis (alpha = .05).
The test
Use Excel to perform the test. Paste the results in the document.
In a separate sentence, specifically identify the significance level (alpha), the test
statistics and the critical value.
State your decision
State whether you are rejecting or failing to reject the null hypothesis statement.
Explanation of decision made
Comment on why you are making your decision in terms of how the test statistic
compares to the critical value or in terms of how the p value compares to the alpha.
Applications for managers
Discuss how the manager of the company could use this information specifically. Why is
this information valuable?
Hypothesis Test #2 Looking at Extrinsic Satisfaction by Position
Null and alternate hypotheses
Write out a Null & Alternate Hypothesis (alpha = .05).
The test
Use Excel to perform the test. Paste the results in the document
In a separate sentence, specifically identify the significance level (alpha), the test
statistics and the critical value.
Running head: BUSN311 - Quantitative Methods and Analysis 3
State your decision
State whether you are rejecting or failing to reject the null hypothesis statement.
Explanation of decision made
Comment on why you are making your decision in terms of how the test statistic
compares to the critical value or in terms of how the p value compares to the alpha.
Applications for managers
Discuss how the manager of the company could use this information specifically. Why is this
information valuable?
Z and T Tests
Explain the difference between the Z and T test and when each one is used.
Samples and Populations
Explain the difference between a sample and the population. Why are samples used for
hypothesis tests? Be sure to be specific.
Conclusion
Add some concluding remarks in about 2-3 sentences.
Running head: BUSN311 - Quantitative Methods and Analysis 4
References
Examples:
American Psychological Association [APA]. (2010) Publication manual of the American
Psychological association (6th ed.). Washington, DC: Author.
Association of Legal Writing Directors (ALWD) (2005). ALWD citation manual: A professional
system of citation (3rd ed.). New York: Aspen Publishers.
"thank you so much!"
"Thanks for the great help and breaking it down for me"
"Thank you for your help, one thing and its my fault not to mark in red, ***The four (4) ground water wells will cost $50,000 each to abandon.**** not $30,000 as it was in the old answer can you check that and if any changes needed...with all my respect. Regards,"
"Is it possible to run the output in SPSS?"
"Thank u. Solution was very detailed."