Purchase Solution

Test hypothesis: 40% of employees have a college degree

Not what you're looking for?

Ask Custom Question

Please assist answering the following question. Please use the attached Excel spreadsheet to answer the question.

The Excel file Call Center Data provides data on the background of call center employees. The company would like at least 40% of its employees to have a college degree. Perform a test with this data to determine whether there is evidence to claim that the company's requirements are not met. Assume that the level of significance is .05.

Attachments
Purchase this Solution
Solution Summary

Your tutorial is attached (in Excel) with a reference to the steps to the statistical test needed. You have to first create a "count" which was down by sorting the variable column. Next, you create an observed vs. expected table. Then, the statistical test is done and interpreted.

Solution Preview

Your tutorial is attached (in Excel) with a reference to the steps to ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance

This quiz test introductory finance topics.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

View More Free Quizzes
Related BrainMass Solutions

  • Predicting Employee Wages at Southern Textiles

    Employees are categorized as having a college degree or not having a college degree in their personnel files, so the variable "education" is a qualitative variable. Thus, X2 is an indicator (0, 1) variable.

  • Hypothesis testing and scatter plots using Excel

    Hypothesis testing on a proportion: The administration of a college is concerned that a significant number of their students are not graduating in 4 years.

  • Hypothesis Test

    C) Test the null hypothesis that the average length of service for individuals with a college degree is the same as for individuals without a college degree. D) Now conduct tests of hypothesis for equality of variances.

  • Hypothesis and Error Type Questions

    Original Claim: "The mean length of time for students at Givens College to complete their bachelor's degree is less than four years." Initial Conclusion: "Reject the null hypothesis." 16. Find the value of the test statistic.

  • Applied Statistics in Business and Economics

    A p-value is a measure of how much evidence we have against the null hypothesis.

  • Statistics - Null and Alternative Hypothesis, Type 1 Error

    We suspect that the mean number of hours worked per week by college graduates mean (mu) of a population, is different from 40 hours and wish to do a statistical test.

  • Hypothesis Testing with Nonparametric Tests

    174728 Hypothesis Testing with Nonparametric Tests Based on the data below, this is what I need help with: A) Help me formulate a hypothesis, (I am thinking, "Women with a 4 yr. college degree earn more than women with a 2 yr. college degree") B) Perform

  • Some hypothesis testing problems

    155954 Some hypothesis testing problems Assume that a hypothesis test of the given claim will be conducted. The college Dean of Admissions claims that the times students require to earn a bachelors degree have a mean less than five years.

  • Hypothesis Testing of Mean & Proportion

    At the 0.05 level of significance, use the five step p-value approach ( use the hypothesis test one sample) Suppose you saw an email that stated that the mean age of employees in your company is less than 40 years and that more than 50% of the employees

View More Related Solutions