Answer:
SUM, AVERAGE, MAX,MIN
Explanation:
Sum: The SUM function is categorized under Excel Math and Trigonometry functions. ... The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel. SUM helps users perform a quick summation of specified cells in MS Excel.
Average: The AVERAGE function in Excel does exactly what you think it should. It computes the mathematical average of a set of numbers. In other words, it adds up a set of numbers and then divides the sum by how many numbers are being averaged.
Max: he MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values. In financial analysis, MAX can be useful in calculating the highest score, the fastest time, the highest expense or revenue amount, etc.
Min: will return the minimum value in a given list of arguments. From a given set of numeric values, it will return the smallest value. Unlike the MINA function, the MIN function ignores numbers, text, and logical values TRUE and FALSE and text values. In financial modeling.
Complete Question:
A campus bookstore sells both types and in the last semester sold 56% laptops and 44% desktops. Reliability rates for the two types of machines are quite different, however. In the first year, 5% of desktops require service, while 15% of laptops have problems requiring service.
Given that a computer required service, what is the probability that it was a laptop?
Answer:
Probability = 0.084
Explanation:
Given
Laptops = 56%
Desktop = 44%
Service Required (Laptop) = 15%
Service Required (Desktop) = 5%
Required
Determine the probability that a selected computer is a laptop and it requires service.
The question tests our knowledge of probabilities using "and" condition.
What the question requires is that, we calculate the probability of selecting a LAPTOP that REQUIRES SERVICE
Note the capitalised words.
This will be calculated as follows:
Probability = P(Laptop) and P(Service Required (Laptop))
[Substitute values for P(Laptop) and P(Service Required (Laptop))]
Probability = 56% * 15%
[Convert to decimal]
Probability = 0.56 * 0.15
Probability = 0.084
Answer:
The answer to this question is "C++ functions can't return array type value".
Explanation:
In C++ language the method is a collection of declarations executing a process together. It is a statement, that tells the compiler to return and accept parameters of a function. In C++, it includes many standardized functions, which can be called by the software, and other choices were wrong, which can be described as follows:
- In c++ function can't return array type always.
- function is not address based.
- If array is local to function, but function will not return array value.
A. Data Type.
Data Types can be integers, strings, chars, shorts, ect, and describes what types of values can be stored.