Question: Please help me with this comparing variance in excel Paste B I Uvab x x Av DV Av E Count of StdDey of Row Labels
Please help me with this comparing variance in excel

Paste B I Uvab x x Av DV Av E Count of StdDey of Row Labels GPA GPA2 Var of GPA3 Senior 28 0.459216033 0.210879365 Sophomore 24 0.229175823 0.052521558 Grand Total 52 0.466333335 0.21746678 What is the CLAIM you are making regarding the data you have chosen? REMEMBER, you should make your claim BEFORE analyzing your dat Type your CLAIM in the textbox below. You do NOT need statistical symbols. Type your claim in words. In the textbox below, explain whether your claim is a Null or Alternative Hypothesis 2 pts Which of the following distributions will you use to test your claim? 1 et What level of significance are you using to for your test of significance? (choose from the list below) 1 pt In the textbox below, explain what the level of significance means IN CONTEXT FOR THIS ANALYSIS In the box below use EXCEL to compute your CRITICAL VALUE (if you have 2 critical values, compute both). If you have one use the appropriate box: negative critical value 1pt Posititxe critical value 1pt In the box below use the DATA FROM YOUR PIVOT TABLE & EXCEL formulas to compute your TEST STATISTIC: 2 pts In the box below use an EXCEL formula to compute your P-VALUE: 2 pts In the textbox below, explain what your p-value means IN THE CONTEXT OF THIS ANALYSIS 3 pts Given the calculations above, what is your decision/conclusion? 2 pts We know Hypothesis Testing is not 100% accurate. If you made an Error, which Type would it be: 2 pts In the textbox below, give honest feedback as to whether this project is helping your understanding of the concepts (As long as you give feedback, you will receive full credit for this question. Hey - this is 2 free points!) 2 pts 294 words X English (United
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
