# Get instant live Excel expert help to learn how to find max and min in Excel?

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Need constraints or if then formula to only calculate a subtraction if a maximum is exceeded. Not sure.
Solved by K. L. in 27 mins
1. A prison administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged.
Solved by I. J. in 24 mins
An administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged. a) independent variable? b) What is the dependent variable?
Solved by X. J. in 23 mins
A prison administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged. What is the dependent variable? What is the null hypothesis? What is the research hypothesis? Interpret the results.
Solved by I. Q. in 21 mins
A prison administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged. What is the dependent variable?
Solved by I. H. in 17 mins
A prison administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged a) What is the independent variable? b) What is the dependent variable? c) What is the null hypothesis?
Solved by K. Q. in 17 mins
A prison administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged. a) What is the independent variable? b) What is the dependent variable? c) What is the null hypothesis?
Solved by V. S. in 16 mins
1. A prison administrator is interested in examining the relationships between the type of prison security (maximum, medium, and minimum) and the number of previous offenses committed by an inmate. He believes that maximum security prisons have inmates with many prior offenses, medium security with not so many offenses, and minimum security with almost no prior offenses. He randomly selects eight new inmates from each of the three security levels and compares the number of offenses for which they have ever been charged. a) What is the independent variable? b) What is the dependent variable? c) What is the null hypothesis?
Solved by Z. Y. in 15 mins
suppose I have three columns...country,continent,population...how to get the maximum of each continent
Solved by O. Q. in 19 mins
The formula for conditional formatting 3-color scale. Minimum 1 to 69 Midpoint 70 to 89 Maximum 90 to 100 I have data in = \$ E: \$ E and data from 0 to 100, I want it to look degraded, from 0 to 69 red scale, from 70 to 89 yellow scale and from 89 to 100 green scale.
Solved by O. A. in 14 mins