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

Please help me with this comparing variance in excel Paste B I

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!