Question

Please SHOW YOUR Calculations and formulas in Excel A shareholder’s group, in lodging a protest, claimed...

Please SHOW YOUR Calculations and formulas in Excel

A shareholder’s group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least 9 years. A survey of companies reported in the Wall Street Journal found a sample mean tenure of ?̅= 7.27 years for CEOs with a standard deviation of 6.38 years.

1) Formulate a hypothesis that can be used to challenge the validity of the claim made by the shareholder’s group.

2) Assume that 85 companies were included in the sample. What is the p value for your hypothesis test?

3) At a level of significance of 1%, what is your conclusion?

Show your calculations & formulas in Excel

Homework Answers

Answer #1

To Test :-

H0 :-  

H1 :-  

Test Statistic :-
t = ( X̅ - µ ) / (S / √(n) )
t = ( 7.27 - 9 ) / ( 6.38 / √(85) )
t = -2.5


Test Criteria :-
Reject null hypothesis if t > t(α, n-1)
t(α, n-1) = t(0.01 , 85-1) = 2.372
t > t(α, n-1) = -2.5 < 2.372
Result :- Fail to reject null hypothesis

Decision based on P value
P - value = P ( t > 2.5 ) = 0.9928
Reject null hypothesis if P value < α = 0.01 level of significance
P - value = 0.9928 > 0.01 ,hence we fail to reject null hypothesis
Conclusion :- Fail to reject null hypothesis

There is insufficient evidence to conclude the claim that the mean tenure for a chief executive officer (CEO) was at least 9 years.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least nine years. A survey of companies reported in The Wall Street Journal found a sample mean tenure of x = 7.27 years for CEOs with a standard deviation of s = 6.38 years. (b) Assume that 85 companies were included in the sample. What is the p value for your hypothesis test? If required, round your answer to four...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least nine years. A survey of companies reported in The Wall Street Journal found a sample mean tenure of x = 6.87 years for CEOs with a standard deviation of s = 6.38 years. (a)Choose the correct hypotheses that can be used to challenge the validity of the claim made by the shareholders' group. (b)Assume that 85 companies were included...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least nine years. A survey of companies reported in The Wall Street Journal found a sample mean tenure of x = 7.67 years for CEOs with a standard deviation of s = 6.38 years. 1)Assume that 85 companies were included in the sample. What is the p value for your hypothesis test? If required, round your answer to four decimal...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least nine years. A survey of companies reported in The Wall Street Journal found a sample mean tenure of x = 7.47 years for CEOs with a standard deviation of s = 6.38 years. (a) Choose the correct hypotheses that can be used to challenge the validity of the claim made by the shareholders' group. H0: μ years Ha: μ...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the mean tenure for a chief exective office (CEO) was at least 9 years. A survey of 91 companies reported in The Wall Street Journal found a sample mean tenure of 7.7 years for CEOs with a standard deviation of 4.5 years (The Wall Street Journal, January 2, 2007). You want to formulate and test a hypothesis that can be used to challenge the validity...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive...
A shareholders' group, in lodging a protest, claimed that the mean tenure for a chief executive officer (CEO) was at least nine years. A survey of companies reported in The Wall Street Journal found a sample mean tenure of x = 7.07 years for CEOs with a standard deviation of s = 6.38 years. (a) Choose the correct hypotheses that can be used to challenge the validity of the claim made by the shareholders' group. H0: μ - Select your...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the mean tenure for a chief exective officer (CEO) was at least 11 years. A survey of 62 companies reported in The Wall Street Journal found a sample mean tenure of 8.7 years for CEOs with a standard deviation of s = 4.7 years (The Wall Street Journal, January 2, 2007). You don't know the population standard deviation but can assume it is normally distributed....
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the mean tenure for a chief exective office (CEO) was at least 9 years. A survey of 115 companies reported in The Wall Street Journal found a sample mean tenure of 8.8 years for CEOs with a standard deviation of s = 5.1 years (The Wall Street Journal, January 2, 2007). You don't know the population standard deviation but can assume it is normally distributed....
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the mean tenure for a chief exective office (CEO) was at least 11 years. A survey of 97 companies reported in The Wall Street Journal found a sample mean tenure of 9.2 years for CEOs with a standard deviation of s=4.9 years (The Wall Street Journal, January 2, 2007). You don't know the population standard deviation but can assume it is normally distributed. You want...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the...
A shareholders' group is lodging a protest against your company. The shareholders group claimed that the mean tenure for a chief exective office (CEO) was at least 11 years. A survey of 109 companies reported in The Wall Street Journal found a sample mean tenure of 10.6 years for CEOs with a standard deviation of 4.1 years (The Wall Street Journal, January 2, 2007). You want to formulate and test a hypothesis that can be used to challenge the validity...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT