You wanted to verify that formula 14-2 on page 429 is correct, so you entered the formula in B7 and entered Excel’s built-in function CORREL in cell B9; however, you get 47.95% in B7 and 71.93% in B9. Since the formulas in both cells are correct, where is the error?
a) The functions on cells B5 and C5 should be MEDIAN instead of AVERAGE
b) The functions on cells B6 and C6 should be STDEV.P instead of STDEV.S
c) The functions on cells B5 and C5 should be MODE instead of AVERAGE
d) The functions on cells B6 and C6 should be STDEVA instead of STDEV
e) The functions on cells B6 and C6 should be VAR instead of STDEV
b) The functions on cells B6 and C6 should be STDEV.P instead of STDEV.S
You might also like to view...
If direct materials costs are decreased, the breakeven point will decrease
Indicate whether the statement is true or false
A firm that assumes a problem will eventually go away or be forgotten if it is ignored is using the defensive approach to crisis management
Indicate whether the statement is true or false
Most people are at the ______ level of moral development.
A. preconventional B. conventional C. postconventional D. multiconventional
Which of the following is the most accurate statement concerning the use of primary and secondary research methods?
a. Secondary research helps to establish a starting point for primary research. b. A researcher typically chooses between secondary and primary research as the better alternative for obtaining information for the particular problem. c. Primary research is the predominant research method selected for a study, with secondary research available as an option, if needed. d. Secondary research includes observation, experimentation, and normative surveys.