« previous next »

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

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

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?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Human immunodeficiency virus gains entry into helper T cells, uses the cell DNA to replicate, interf Human immunodeficiency virus gains entry into helper T cells, uses the cell DNA to replicate, interf
Crossing over during meiosis leads to allele combinations in sex cells that are not present in the p Crossing over during meiosis leads to allele combinations in sex cells that are not present in the p
A schematic representation of the convergence of cones and rods on retinal ganglion cells. There is ... A schematic representation of the convergence of cones and rods on retinal ganglion cells. There is ...
Long-Range Forecasts Long-Range Forecasts
Red blood cells with normal hemoglobin, like the three similar ones, are smooth and round Red blood cells with normal hemoglobin, like the three similar ones, are smooth and round
The extracellular matrix is nonliving material secreted by the cells The extracellular matrix is nonliving material secreted by the cells
Video: Non-specific disease resistance mechanisms & Skin's defense barriers

For a complete list of videos, visit our video library