Question

PLEASE SOLVE USING EXCEL FORMULAS #1 The CEO of a software company is committed to expanding...

PLEASE SOLVE USING EXCEL FORMULAS

#1

The CEO of a software company is committed to expanding the proportion of highly qualified women in the organization’s staff of salespersons. He believes that the proportion of women in similar sales positions across the country in 2004 is less than 45%. Hoping to find support for his belief, he directs his assistant to collect a random sample of salespersons employed by his company, which is thought to be representative of sales staffs of competing organizations in the industry. The collected random sample of size 50 showed that only 18 were women.

a)Formulate the hypotheses.

b)What is the value of the test statistic?

c)What is the critical value of the test?

d)Find the p-value of the test.

e)What is your conclusion? Explain it in the context of the problem.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
PLEASE SOLVE USINS EXCEL FORMULAS In the past, 60% of all undergraduate students enrolled at a...
PLEASE SOLVE USINS EXCEL FORMULAS In the past, 60% of all undergraduate students enrolled at a State University in NY earned their degrees within four years of matriculation. Administrators want to test the claim made by some faculty memebers that this proportion has fallen below the historical value of 60%. A random sample of 95 students from the class that matriculated in the fall of 2012 was recently selected to test this hypothesis. Administrators found that 44 of these 95...
Please, i need Unique answer, Use your own words (don't copy and paste). Please, don't use...
Please, i need Unique answer, Use your own words (don't copy and paste). Please, don't use handwriting, Use your keyboard. Q1: Suppose you survey that a random sample of 150 people from one hospital has been given cholesterol tests, and 60 of these people had levels over the “safe” count of 200. Construct a 95% confidence interval for the population proportion of people in test with cholesterol levels over 200. Q2: A research conducted by the University of Michigan claimed...
What strategy would you recommend for Dove (1) in responding (or in not responding) to consumers...
What strategy would you recommend for Dove (1) in responding (or in not responding) to consumers and (2) going forward (or not going forward) with the campaign? If they were to go forward with this campaign, should Dove revise its Real Beauty message and if, so, how? The Dove Real Beauty Campaign In 2004, with sales at approximately $2.5 billion, Dove saw an opportunity to tap into women’s self-perceptions of beauty to address female insecurities while building a connection between...
Gender Bias in the Executive Suite Worldwide The Grant Thornton International Business Report (IBR) has described...
Gender Bias in the Executive Suite Worldwide The Grant Thornton International Business Report (IBR) has described itself as "a quarterly survey of business leaders from across the globe … surveying 11,500 businesses in 40 economies across the globe on an annual basis." 1 According to the 2011 IBR, the Asia Pacific region had a higher percentage (27 percent) of female chief executive officers (CEOs) than Europe and North America. Japan is the only Asia Pacific region exception. The report further...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet...
CASE STUDY – Jacobson Carpet Company In January 2002, Ms. Mary Lewis was preparing to meet with Mr. Carpenter, President of Jacobson Carpet Company. Ms. Lewis assumed that the meeting was related to the recent Board of directors of the company. As a direct assistant to the President, she knew from experience that this type of meeting often resulted in a project to be studied. Her expectation was confirmed as soon as Mr. Carpenter began to inform her of the...
Using the model proposed by Lafley and Charan, analyze how Apigee was able to drive innovation....
Using the model proposed by Lafley and Charan, analyze how Apigee was able to drive innovation. case:    W17400 APIGEE: PEOPLE MANAGEMENT PRACTICES AND THE CHALLENGE OF GROWTH Ranjeet Nambudiri, S. Ramnarayan, and Catherine Xavier wrote this case solely to provide material for class discussion. The authors do not intend to illustrate either effective or ineffective handling of a managerial situation. The authors may have disguised certain names and other identifying information to protect confidentiality. This publication may not be...
What role could the governance of ethics have played if it had been in existence in...
What role could the governance of ethics have played if it had been in existence in the organization? Assess the leadership of Enron from an ethical perspective. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among the top Fortune 500 companies, collapsed in 2001 under a mountain of debt...
Discuss ethical issues that can be identified in this case and the mode of managing ethics...
Discuss ethical issues that can be identified in this case and the mode of managing ethics Enron finds itself in this case. How would you describe the ethical culture and levels of trust at Enron? Provide reasons for your assessment. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT