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

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

For a complete list of videos, visit our video library