Which formula/function is the correct one to calculate the correlation in B8?



a) =((B2-B5)*(C2-C5)+(B3-B5)*(C3-C5)+(B4-B5)*(C4-C5))/(B6*C6*COUNT(A2:A4))

b) =CORREL(B2:B4,C2:C4)

c) =((B2-B5)*(C2-C5)+(B3-B5)*(C3-C5)+(B4-B5)*(C4-C5))/(B6*C6*3)

d) =B7/(B6*C6)

e) All of the above


e) All of the above

Business

You might also like to view...

An employer can eliminate a worker’s medical, optical, or dental insurance coverage on the voluntary termination of the worker’s employment.

Answer the following statement true (T) or false (F)

Business

Teatro Restoration, Inc, begins renovating an old theater for Urban Edge Productions, but after three months Teatro demands an extra $250,000. Urban Edge agrees to pay. Refer to Fact Pattern 12-4. If Teatro says it is asking for the extra $250,000 because it has encountered extraordinary unforeseen difficulties that will add consid-erable cost to the project, the agreement is A) enforceable as

the consideration is past. B) ?enforceable because of unforeseen difficulties. C) ?unenforceable as an illusory promise. D) unenforceable due to the preexisting duty rule.

Business

Sam wishes to invest $8,000 into an account earning 6% compounded annually. If he invests the money today, how much will be in the account in 6 years?

If he waits three years before investing his $8,000 and invests that money for three years, will he earn one-half of the interest earned in the first scenario since he had the same amount invested at the same rate but for only one-half of the time? Explain how you arrived at your answer. What will be an ideal response?

Business

A(n) ____________________ chart is often used to display frequencies; a(n) ____________________ chart graphically shows relative frequencies

Fill in the blank(s) with correct word

Business