« previous next »

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

Davideckstein7

  • Hero Member
  • *****
  • Posts: 555
on: Jun 24, 2018
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
Reply #1 on: Jun 24, 2018
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

Davideckstein7

  • Hero Member
  • *****
  • Posts: 555
Reply #2 on: Jun 24, 2018
Thank you :)


chem1s3

  • Sr. Member
  • ****
  • Posts: 320
Reply #3 on: Jun 24, 2018
Happy to help you


« previous next »
 

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Cycle of phage that lyses the host cells Cycle of phage that lyses the host cells
Each subculture provides its members with values and distinctive ways of viewing the world. What ... Each subculture provides its members with values and distinctive ways of viewing the world. What ...
The formed elements: In this image, the red cells are red, the white cells are white, and the ... The formed elements: In this image, the red cells are red, the white cells are white, and the ...
Intracellular relationships involving the glyoxylate cycle in plant cells Intracellular relationships involving the glyoxylate cycle in plant cells
From Cells to Organs and Organ Systems From Cells to Organs and Organ Systems
An electron micrograph of a synapse between two nerve cells. An electron micrograph of a synapse between two nerve cells.
Video: Buffers definition and the role of buffer in the body

For a complete list of videos, visit our video library