1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
qaws [65]
3 years ago
12

Which function in Excel is used to perform a test of independence? a. T.TEST b. CHISQ.TEST c. NORM.S.DIST d. Z.TEST

Mathematics
1 answer:
denis23 [38]3 years ago
3 0

Answer:

b. CHISQ.TEST

Step-by-step explanation:

Notation and previous concepts

A chi-square test is "used to test if the variance of a population is equal to a specified value. This test can be either a two-sided test or a one-sided test. The two-sided version tests against the alternative that the true variance is either less than or greater than the specified value"

The statistic is given by:

\chi^2 = \sum_{i=1}^n \frac{(O_i-E_i)^2}{E_i}

In order to calculate the p value we need to have in count the degrees of freedom , on this case df=(rows-1)(#cols-1). And we can calculate the p value would be given by:

p_v =P(\chi^2 >\chi^2_{calc})

But the correct comand is given by:

b. CHISQ.TEST(Actual range, Expected range)

We just need to put in one column the Observed values and in other the expectec values.

You might be interested in
Help maths i’m bad at this :)))(
Tju [1.3M]
I suck at math to I’m so so sorry Ask a tutor they will help
6 0
3 years ago
Simplify 2(4+8)÷2(8+8)​
inna [77]

192.

2(8+4)÷2(8+8) = 1(4+8)×(8+8)

1×12×16=192.

6 0
3 years ago
Read 2 more answers
The number of hearing aids that needs to be produced and sold is??
juin [17]

Answer:

14.36 AND 9.89 ===> 14 or 10

Step-by-step explanation:

Y =  Ax2 Bx C

Enter coefficients here >>>  -4 97 -568

   

Standard Form: y = -4x²+97x-568    

-24.25 -12.125 147.015625 -588.0625 20.0625

Grouped  Form: No valid Grouping      

   

Graphing Form: y = -4(x-12.13)²+20.06    

     

Factored Form: PRIME    

   

Solution/X-Intercepts: 14.36 AND 9.89    

   

Discriminate =321 is positive, two real solutions    

   

VERTEX: (12.13,20.06)     Directrix: Y=20.13    

7 0
3 years ago
mrs. Hudson invested $700 into an account that draws 3% interest, compounded annually. what is the total value of the account af
nadezda [96]
700 x .03 x 20 = 420
420 + 700
1120 is in the account after 20 years
7 0
3 years ago
Help i forgot 3(x−4)≥−2x+3
alekssr [168]

Answer:

The answer is x_> 3

Step-by-step explanation:

6 0
3 years ago
Read 2 more answers
Other questions:
  • A candidate took a phone poll of 110 people. Of the 110 people polled, 87 said they would vote for the other person. There are 9
    9·2 answers
  • Step by step PLEASE!!!
    10·1 answer
  • Fill in blank to show steps in solving the inequality.
    5·2 answers
  • Can you help me, friends, please?
    11·1 answer
  • An equilateral triangle has an altitude of 15 m. What is the perimeter of the triangle?
    5·2 answers
  • Solve this question for me​
    14·1 answer
  • Matt and Mindy each built a rectangular prism that has a length of 5 units,a width of 2 units, and a height of 4 units.Matt used
    10·1 answer
  • Find each of the numbers below. Simplify your answers as much as possible.
    6·1 answer
  • Plz help______________
    10·2 answers
  • ) Turner helped his grandfather build a raised garden bed for Turner's grandmother. The
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!