Question: What does standard normal mean? A normal distribution with a mean and standard deviation of the population A normal distribution with a mean of 0



What does standard normal mean?
| A normal distribution with a mean and standard deviation of the population | ||
| A normal distribution with a mean of 0 and a standard deviation of 1 | ||
| A normal distribution with a mean and standard deviation of the sample size |
Which formula does a count of numbers if they meet a certain criteria?
| Countif | ||
| Sumif | ||
| Indirect | ||
| Index |
Use the following table to answer the question. A B 1 10 5.5 2 20 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: =max(B1,B2), what will display once the formula is evaluated? 50 150 12 10 Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: =sum(A2,A5), what will display once the formula is evaluated? 70 35 150 O 140 Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 | 40 4 5 50 10 Assume the following formula exists: -AVERAGEIF(A1:A5,">="&30,B1:B5). What will display once the formula is evaluated? 30 7.8 40 7.2 Use the following table to answer the question. A B 1 10 5.5 2 20 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: =max(B1,B2), what will display once the formula is evaluated? 50 150 12 10 Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 40 4 5 50 10 Assume the following formula exists: =sum(A2,A5), what will display once the formula is evaluated? 70 35 150 O 140 Use the following table to answer the question. A B 1 10 5.5 220 12 3 30 7.5 4 | 40 4 5 50 10 Assume the following formula exists: -AVERAGEIF(A1:A5,">="&30,B1:B5). What will display once the formula is evaluated? 30 7.8 40 7.2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
