Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bridging Algebra, Geometry, And Topology

Authors: Denis Ibadula, Willem Veys

1st Edition

3319091867, 9783319091860

More Books

Students also viewed these Mathematics questions

Question

=+ How do some of them single you out when you're the consumer?

Answered: 1 week ago