Msis 3223 okstate - Study guides, Class notes & Summaries

MSIS 3223 - Nord - Okstate - Exam 1 Questions With Complete Solutions.

"centering" of a set of data - Measures of location provide estimates of a single value that in some fashion represents the absolute address - An absolute address uses a dollars sign ($) before either the row or column or both (for example $A2, C$23, or $B$15) Add third dimension to analysis in Pivot Table - Dragging a field into the Filters area in the PivotTable field list Addition in excel - + Advantages of Using Tableau - Fantastic Visualizations, In-depth Insights, User-friendly Ap...

_______ is a measure of the linear relationship between two variables, X and Y, which does not depend on the units of measurement. - Correlation ________ is a logical function that returns one value if the condition is true and another if the condition is false. - IF(condition, value if true, value if false) ________ is a measure of the linear association between two variables, X and Y - Covariance ________ measures the worth of a stream of cash flows, taking into account the time value o...

Building spreadsheet models, often called _____________, is part art and part science - ANSWERspreadsheet engineering The Process of developing good, useful, and correct spreadsheet models is known as spreadsheet engineering A. True B. False - ANSWERTrue The Process of developing good, useful, and correct spreadsheet models is known as spreadsheet _________ - ANSWERengineering In predictive modeling, validity refers to how well a model represents reality. A. True B. False - ANSWER...

Addition in excel - ANSWER+ Subtraction in Excel - ANSWER- Multiplication in Excel - ANSWER* Division in Excel - ANSWER/ Raised to the power (exponentiation) - ANSWER^ How would 10 raised to the power of 2 × 5 raised to the power of 3/ 100 - 73 be represented in an Excel spreadsheet? - ANSWER10^2 * 5^3/100-73 relative address - ANSWERA relative address uses just the row and column label in the cell reference (for example A4 or C23) absolute address - ANSWERAn absolute addre...

The process of developing good, useful, and correct spreadsheet models is known as spreadsheet engineering T/F - ANSWERTrue In predictive modeling, validity refers to how well a model represents reality T/F - ANSWERTrue Two-way data tables can evaluate only one output variable T/F - ANSWERTrue Models can capture every detail of a real problem T/F - ANSWERFalse Verification is the process of ensuring that a model is accurate and free from logical errors T/F - ANSWERTrue Excel...

Addition in excel - ANSWER-+ Subtraction in Excel - ANSWER-- Multiplication in Excel - ANSWER-* Division in Excel - ANSWER-/ Raised to the power (exponentiation) - ANSWER-^ How would 10 raised to the power of 2 × 5 raised to the power of 3/ 100 - 73 be represented in an Excel spreadsheet? - ANSWER-10^2 * 5^3/100-73 relative address - ANSWER-A relative address uses just the row and column label in the cell reference (for example A4 or C23) absolute address - ANSWER-An absolu...

Variable cost = - ANSWERUnit Variable Cost * Quantity Produced (Descriptive Model) Total Cost = - ANSWERFixed Cost + Variable Cost * Quantity Produced Also written as FC + VC * QP = TC (Descriptive Model) Logic suggests that variable cost is the unit variable cost times the quantity of item produced. - ANSWERTrue __________ has an influence on profit by predicting how many units of a product will be sold. - ANSWERDemand ______________produced is a decision option typically based on...

The process of developing good, useful, and correct spreadsheet models is known as spreadsheet engineering T/F - ANSWER-True In predictive modeling, validity refers to how well a model represents reality T/F - ANSWER-True Two-way data tables can evaluate only one output variable T/F - ANSWER-True Models can capture every detail of a real problem T/F - ANSWER-False Verification is the process of ensuring that a model is accurate and free from logical errors T/F - ANSWER-True ...

Which of the following ways would 10 raised to the power of 2 × 5 raised to the power of 3/ 100 - 73 be represented in an Excel spreadsheet? - ANSWER10^2 * 5^3 / 100 - 73 Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel? - ANSWERA relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label. To copy a formula from a singl...