1.Graphical method can't be used to track relationships between variables. True /False .

2.Spreadsheet data is considered to be three-dimensional file True /False .

3.One of the skills of a business analyst is to use data intelligently. True/False .

4.Data mining dose not require data preparation befor e the commencement of data analysis True/False.

5.Missing values in a data set should be replaced by the lowest value in data perpetration stage. True/False.

6.What-if analysis is used to test numerical assumptions. True/False.

7.Numerical Categorical values may need to be converted to numerical values in data preparation. True/False.

8.Optimization analysis is used to achieves best possible value of an output. True/False.

9.What is not a limitation of a Tornado chart :

a. We can be confident that drawing conclusions about the sensitivity of a model outside the range of the parameters tested

b. Assuming every parameter varies by the same percentage of the base case .

C.Accurate results can be obtained as output is and input changes in a nonlinear fashion .

d. All of the above

10.An example of a Ordinal data Select one:

A.Gender B. All of the above C.Age D.High, medium and low.

11.What is not a limitation of a Tornado chart Select one:

A .Assuming every parameter varies by the same percentage of the base case

B. Accurate results can be obtained as output is and input changes in a nonlinear fashion

C.All of the above

D.We can be confident that drawing conclusions about the sensitivity of a model outside the range of the parameters tested.

12.Prior to data mining, which of the following should be done Select one: A.Replacing missing values

B.Removing missing values

C.All of the above

D. Normalizing data

13.Prior to data mining, which of the following should be done Select one:

A.Replacing missing values

B. Removing missing values

C. All of the above

D. Normalizing data

14Excel provides many functions that are useful for investigating individual variables

Select one: O True O False

15.Benchmarking will help test key structural assumptions

Select one: O True O False

16.Being skeptical of data would mean Select one: A .Knowing what type of data are represented

B.Knowing what are the units are the data in

C. All of the above Finding out how fields are defined

17.Bench marking involves records base case and compare the results choose function

Select one: O True O False

18.A Breakeven analysis is analyzes where a particular point of interest Occurs

Select one: O True O False

19.Properties of one variable is more important than relationships among variables in most cases

Select one: O True O False

20.In a WHAT-IF analysis, we can change which of the following

Select one: A. Data analysis B.Database C.Input D.Output