Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following sample observations of two variables, x and y , have been entered into Excel: A B C 1 x y 2 2 4

The following sample observations of two variables, x and y, have been entered into Excel:

A

B

C

1

x

y

2

2

4

3

1

3

4

4

4

5

3

6

6

5

8

7

6

5

MEDIAN(A2:A7) is:

a.

3.50

b.

4.50

c.

5.00

d.

6.00

e.

None of the above

2-

The following sample observations of two variables, x and y, have been entered into Excel:

A

B

C

1

x

y

2

2

4

3

1

3

4

4

4

5

3

6

6

5

8

7

6

5

PERCENTILE.EXC(B2:B7,0.6) is:

a.

4.00

b.

5.20

c.

6.70

d.

9.00

e.

None of the above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

20 Forex Trading Strategies Collection

Authors: Thomas Carter

1st Edition

1500938599, 978-1500938598

More Books

Students also viewed these Finance questions