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
A trunk measures 48 inches long, 22 1 half feet wide, and 32 inches high. What is the volume of the box??
IceJOKER [234]
414720 inch^3
or 
240 feet^3
6 0
3 years ago
What is the answer??
masha68 [24]
The answer is 30, assuming it is a cube, 
7 0
3 years ago
Round 58.6790691589 to the nearest hundred-thousandth.
suter [353]

Answer:

58.678

Step-by-step explanation:

Just make the answer reach 3 numbers after the decimal point.

6 0
3 years ago
Read 2 more answers
Plz help i'm having troubled understanding how to do this
Lunna [17]

Answer:

1/2 - 2/6 = 1/6

Step-by-step explanation:

to answer two that are different simply take the lesser up or higher down example: 1/2-2/4 this would be zero because 2 x 1/2 = 2/4

8 0
3 years ago
Read 2 more answers
The coach recorded the time it took 15 students to run a mile. The times are as follows: 9:23, 8:15, 9:23, 9:01, 6:45, 6:55, 7:2
r-ruslan [8.4K]

Answer:

Therefore, the four intervals are

(1)    6 - 6.59

(2)   7 - 7.59      

(3)    8 - 8.59      

(4)    9 - 9.59

The four frequencies are

(1)   4

(2)   3

(3)   1    

(4)  6

Step-by-step explanation:

From the data, we have

                     Interval                                                       Frequency

1st                 6 - 6.59                                                        4

2nd               7 - 7.59                                                        3

3rd                8 - 8.59                                                        1

4th                 9 - 9.59                                                       6

Therefore, the four intervals are

(1)    6 - 6.59

(2)   7 - 7.59      

(3)    8 - 8.59      

(4)    9 - 9.59

The four frequencies are

(1)   4

(2)   3

(3)   1    

(4)  6

5 0
3 years ago
Other questions:
  • Please answer correctly only
    8·1 answer
  • Find the area of a regular hexagon with a base of 15 and an apothem of 20.
    9·1 answer
  • I need help and I need explanation plz
    5·1 answer
  • 40 pounds of dog food cost $50 how much would 35 pounds of dog food cost
    5·1 answer
  • Solve for x x + 6=18
    7·1 answer
  • May you please help me fix this I am confused
    6·1 answer
  • Which of the following is a conditional statement?
    9·1 answer
  • 1/4 divided by 1 3/8
    9·1 answer
  • Solving for x... please help me....​
    5·1 answer
  • URGENT Enter the values for the highlighted variables that show how to subtract the rational expressions correctly: StartFractio
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!