You Are Working on a Spreadsheet That Contains Many Different

question 25

Essay

You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations.
Your spreadsheet contains a set of test results, and your supervisor needs to know information such as the average, maximum, and minimum. Which set of functions should you use in your spreadsheet?

---

Definitions:

Independent Variable

In experimental research, the variable that is manipulated by the researcher to observe its effect on the dependent variable.

Dependent Variable

In experimental and statistical research, the variable being tested and measured, expected to change as a result of manipulations of the independent variable.

Limitation of Science

Constraints encountered in scientific research, such as biases, methodological errors, and the inability to provide absolute answers to all questions.

Scientific Method

A systematic process for investigating phenomena, acquiring new knowledge, or correcting and integrating previous knowledge.