« previous next »

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

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

The structure of stomatal guard cells affects their function. The structure of stomatal guard cells affects their function.
Although Neandertal brain sizes fall well within the modern human range, their EQ is lower than mode Although Neandertal brain sizes fall well within the modern human range, their EQ is lower than mode
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 ...
A goniometer is used to measure range of motion of the patient’s arm. A goniometer is used to measure range of motion of the patient’s arm.
Interphase in Plant and Animal Cells Interphase in Plant and Animal Cells
Mitosis (A comparison of plant vs. animal cells) Mitosis (A comparison of plant vs. animal cells)
Video: A timeline of the teeth (Explained - No Audio)

For a complete list of videos, visit our video library