Question

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 students graduated in the spring of 2016 (i.e., four academic years after matriculation). Use a significance level of 5%.

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.

Homework Answers

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
In the past, 60% of all undergraduate students enrolled at State University earned their degrees within...
In the past, 60% of all undergraduate students enrolled at State University earned their degrees within four years of matriculation. A random sample of 95 students from the class that matriculated in the fall of 2014 was recently selected to test whether there has been a change in the proportion of students who graduate within four years. Administrators found that 40 of these 95 students graduated in the spring of 2018 (i.e., four academic years after matriculation). Given the sample...
In the past, 60% of all undergraduate students enrolled at State University earned their degrees within...
In the past, 60% of all undergraduate students enrolled at State University earned their degrees within 5 years of matriculation. A random sample of 36 students from the class that matriculated in the fall of 2018 was recently selected to test whether there has been a change in the proportion of students who graduate within 5 years. Select ALL that apply. a. One sample Test for Proportions b. One sample Test for Means c. 2 Sample Test for Means- independent...
Subject: Human Resource Management Main question: Which benefit plans would you choose, and which wouldn't you...
Subject: Human Resource Management Main question: Which benefit plans would you choose, and which wouldn't you choose and give reasons why you would or would not want a benefit that were used in making the benefit selections (specially at at entry level making $30000). PROCEDURES: Assume that you recently graduated from college and are just starting a new job at a large firm. You will be receiving a starting net pay (net of all taxes and mandatory deductions) of $30,000....