Answer:
If function
Explanation:
In this case, the question asks to compare values in two cells and display an appropriate output based on the comparison made on the contents of both cells...
This can only be done in Excel using the if function.
Th form is as follows:
=IF(A1 < B1,"YES","NO")
Answer:
1. A billiard ball is designated as a cue ball when it is used to strike the other balls on the table.
Explanation:
That's what a billiard ball is used for
Answer:
2.57
Explanation:
Given the data:
X : 17, 17, 16, 17, 23, 22, 21
Mean absolute deviation (MAD) :
Σ|x - xbar| ÷ n
xbar = Σx/ n
n = 7
Σx = (17 + 17 + 16 + 17 + 23 + 22 + 21) = 8
xbar = 133/7 = 19
|x - xbar| :
|17 - 19|= 2
|17 - 19| = 2
|16 - 19| = 3
|17 - 19| = 2
|23 - 19| = 4
|22 - 19| = 3
|21 - 19| = 2
Therefore,
MAD = (2+2+3+2+4+3+2) / 7
MAD = 18 / 7
MAD = 2.57
Yaya says:
IQ Scores have a bell-shaped distribution with a mean of 100 and a standard deviation of 15. What percentage of IQ scores are between 70 and 130?
<span>Solution: </span>130 – 100 = 30 which is 2(15). Thus, 130 is 2 standard deviations to the right of the mean. 100 – 70 = 30 which is 2(15). Thus, 70 is 2 standard deviations to the left of the mean. Since 70 to 130 is within 2 standard deviations of the mean, we know that <span>about 95% of the IQ scores would be between 70 and 130.</span>