Author Question: Which of the following is used to add values in a range of cells using Microsoft Excel? A) ... (Read 90 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?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

For a complete list of videos, visit our video library