In: Statistics and Probability
2.) Using the level of significance of .01, test the claim that the proportion of college students who are not on financial aid of any sort is greater than 20%.
Find the test value using 1PropZtest on your calculator if 262 students out of 1000 students surveyed are not on any financial aid.
Find the p-value using Norm.s.dist on Excel
Find the critical value using Norm.s.inv on Excel
State the conclusion based on critical value
Translate conclusion (use complete sentence)
I NEED HELP SOLVING THIS AND TYPING ON AN EXCEL SHEET IM REALLY CONFUSED!