Author Question: Which of the following is used to add values in a range of cells using Microsoft Excel? A) ... (Read 87 times)

Davideckstein7

  • Hero Member
  • *****
  • Posts: 555
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

  • Sr. Member
  • ****
  • Posts: 320
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.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

chem1s3

  • Sr. Member
  • ****
  • Posts: 320

 

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

For a complete list of videos, visit our video library