# Lernkarten

Marco Wernli
Karten 43 Karten 2 Lernende English Universität 23.01.2021 / 28.01.2021 Keine Angabe
0 Exakte Antworten 1 Text Antworten 42 Multiple Choice Antworten

Descriptive analytics ... ... can predict risk and find relationships in data not readily apparent with traditional analyses. ... helps companies classify their customers into segments to develop specific marketing campaigns. ... helps detect hidden patterns in large quantities of data to group data into sets to predict behavior. ... can use mathematical techniques with optimization to make decisions that take into account the uncertainty in the data.

Which of the following is an example of a measure of continuous metrics? four errors revealed in an invoice a delivery delayed by seven days weight and volume of a sheet of steel three incomplete orders on a day

Which of the following is the mathematical model for deriving total cost of only manufacturing? TC = VC + (C × Q) TC = F + (C × Q) TC = F + C TC = F + (V × Q)

Which of the following ways would 102 × 53/100 - 73 be represented in an Excel spreadsheet? 10(2) * 5(3) / 100 ^ 73 10(2) ^ 5(3) / 100 - 73 10^2 * 5^3 / 100 - 73 10*2 ^ 5*3 / 100 - 73 Lizenzierung: Keine Angabe

Below is the spreadsheet for demand prediction of a company that sells chocolates.

Given that D = a-bP, where D, is demand, "a" and "b," are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing? B4-B5*A9 C5-C6*A10 B4-B5*A10 B5-B6*A10

Which EXCEL function is used to find the largest value in a range of cells? SUM(range) COUNT(range) MAX(range) COUNTIF(range, criteria)

________ is a logical function that returns one value if the condition is true and another if the condition is false. OR(condition 1, condition 2…) AND(condition 1, condition 2…) TO(value if true, value if false) IF(condition, value if true, value if false)

If cell G7 contains the function ________, it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7. =IF(G7=9)(G7=7)=OR(G7=4) =IF(G7=7)=THEN(C3=9)=OR(C3=4) =IF(C3=9)(C3=7)=OR(C3=4) =IF(C3=9,7,4)