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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!