Purchase Solution

How to Test a Hypothesis

Not what you're looking for?

Ask Custom Question

I need help with hypothesis testing and excel.
I have attached the sample database for use.

Can you please explain how this is done in excel and what the statistical formulas are.
I do know that for a hypothesis test with .05 or 95% must compute the z-value which is actual - predit/som var - how do I do this.

1. Test a hypothesis to see whether the average overall job satisfaction (in the population of all workers in the USA) is equal to 4.5 with a = .05.
a. State the null hypothesis, the alternative hypothesis, and the significance level.
b. Using the data in our database, calculate the test statistic.
c. What is the critical level for the significance level?
d. What is your conclusion? Do we accept or reject the null hypothesis?
You may use Excel for the calculations, but you need to answer all four parts of this question.
2. Propose a hypothesis test for the mean intrinsic job satisfaction, similar to the test from problem 1, and answer parts a, b, c, and d of problem 1 for this hypothesis test. You may use Excel for the calculations, but you need to answer the four questions.

3. We believe that half of the population would have an extrinsic job satisfaction of 5.0 or greater. Answer parts a, b, c, and d of problem 1 for this hypothesis test of a proportion. You may use Excel for the calculations, but you need to answer the four questions.

4. We believe that the variance of the overall job satisfaction is equal to 1.0 Answer parts a, b, c, and d of problem 1 for this hypothesis test of a variance. You may use Excel for the calculations, but you need to answer the four questions.

5. We will call a "deskbody" a person whose intrinsic job satisfaction level is higher than their extrinsic job satisfaction level (i.e. happy with their job more than their office). We will call a "socialbody" a person whose extrinsic job satisfaction level is higher than their intrinsic job satisfaction level (i.e. happy with the office more than their job). We believe that there are equal deskbodies and socialbodies in the work force.
a. State an appropriate null hypothesis and its alternative hypothesis.
b. In our database, what percent of the employees are deskbodies? Are socialbodies?
c. What did you do with the employees who had equal intrinsics and extrinsics?
6. Determine the required sample size if you need to estimate the number of workers in the United States who are highly satisfied with their job and you want the estimate to be within 2 percentage points with a 96% confidence interval.

Attachments
Purchase this Solution
Solution Summary

This Solution contains over 1000 words and calculations to aid you in understanding the Solution to these questions.

Solution provided by:
Changping Wang, MA
Education
  • BSc , Wuhan Univ. China
  • MA, Shandong Univ.
Recent Feedback
  • "Your solution, looks excellent. I recognize things from previous chapters. I have seen the standard deviation formula you used to get 5.154. I do understand the Central Limit Theorem needs the sample size (n) to be greater than 30, we have 100. I do understand the sample mean(s) of the population will follow a normal distribution, and that CLT states the sample mean of population is the population (mean), we have 143.74. But when and WHY do we use the standard deviation formula where you got 5.154. WHEN & Why use standard deviation of the sample mean. I don't understand, why don't we simply use the "100" I understand that standard deviation is the square root of variance. I do understand that the variance is the square of the differences of each sample data value minus the mean. But somehow, why not use 100, why use standard deviation of sample mean? Please help explain."
  • "excellent work"
  • "Thank you so much for all of your help!!! I will be posting another assignment. Please let me know (once posted), if the credits I'm offering is enough or you ! Thanks again!"
  • "Thank you"
  • "Thank you very much for your valuable time and assistance!"
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Left-Tailed, Two-Tailed, and Right-Tailed Testing

    How can we tell the direction of the test by looking at a pair of hypothesis? How can we tell which direction (or no direction) to make the hypothesis by looking at the problem statement (research question)?

  • How do you perform a t-test?

    How do you determine which t-test is most appropriate to use? Q1. How is hypothesis testing performed using t-tests? In the following three cases, one needs a t test.

  • 1 Tailed vs 2 Tailed Test and Null vs Alternative Hypothesis

    How can we tell the direction of the test by looking at a pair of hypothesis? How can we tell which direction (or no direction) to make the hypothesis by looking at the problem statement (research question)? 2.

  • Statistics - Hypothesis Testing

    197763 Hypothesis Testing - 1. How can we tell the direction (left tail, two-tailed, and right tailed test) of a hypothesis test? 2. When would we choose a two tailed test by looking at a pair of hypothesis? ...

  • Hypothesis & P Value

    328697 Hypothesis & P Value Hypothesis, Null and Alternative, & P-values Q1: What is a p-value in testing hypothesis? Q2: How does this p-value help us to decide to/not to reject a Null hypothesis?

  • Null hypotheses: t-test, one-way ANOVA, two-way ANOVA

    This solution explains, using an hypothetical situation, how to convert a null hypothesis for a t-test to a null hypothesis for a one-way ANOVA. Also included is how to extend the null hypothesis for a t-test to a null hypothesis for a two-way ANOVA.

  • Measurement Scale Types, Test Stats & Probability

    How would you arrive at a probability value (given in the z-score table) to reflect a two-tailed hypothesis? How would you arrive at a probability value to reflect a one-tailed hypothesis?

  • Identifying type of Hypothesis Test to be used in a situation

    What test would the researchers use to test their hypothesis about student satisfaction? g) The director of a juvenile drug rehabilitation center wants to see how their relapse rates compare to the state average.

  • Hypothesis Testing

    (b) How do you know when to perform a "left-tailed" test in a hypothesis-testing situation versus a "right-tailed" or "two-tailed" test? 5. A hypothesis test is used to test a claim.

  • Hypothesis Testing in Work, Education, or Politics

    A test is called a left tailed test when the alternative hypothesis involves a less-than symbol. A test is called a right tailed test when the alternative hypothesis involves a greater-than symbol. And a two tailed when it involves a not-equal to.

View More Related Solutions