Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started