Which of the following is used to add values in a range of cells ...

[Davideckstein7]

Which of the following is used to add values in a range of cells using Microsoft Excel?
 
  A) ADD(range)
  B) MIN(range)
  C) SUM(range)
  D) PLUS(range)

Question 2

A matched pairs experiment yielded the following results:Number of positive differences = 20,Number of negative differences = 8Number of zero differences = 2Can we infer at the 5 significance level that the location of population 1 is to the right
 
  of the location of population 2?

[chem1s3]

Answer to Question 1

C

Answer to Question 2

H0 : The two population locations are the same.
H1 : The location of population 1 is to the right of the location.
We apply the normal approximation of the binomial distribution and use the sign test with n = 28.
Test statistic: z = 2.08
Reject H0 if z > z0.05 = 1.645, therefore, H0 is rejected. We conclude at the 5 significance level that the location of population 1 is to the right of the location of population 2.

[Davideckstein7]

Thank you

[chem1s3]

Happy to help you