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?
Which EXCEL function is used to find the largest value in a range of cells?
________ 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.
Which of the following charts provides a useful means for displaying data over time?
A doughnut chart
Which of the following charts shows three-dimensional data?
The purpose of sampling is to ________.
enumerate all the values in the population
measure all items of interest for a particular interest or investigation
obtain sufficient information to draw a valid inference about a population
calculate all variables and observations within a population
In statistical notation, the elements of a data set are typically labeled as ________.
letters in capitals
According to statistical notations, what does Σ stand for?