subject;- business analytics

solve the following mcqs

Question 1

Not yet answered

Marked out of 1.00

Flag question

Question text

Riya wants to calculate remainder of division of two numbers in Excel. Find out the required function from the list below.

Select one:

a. ROUND( )

b. MOD( )

c. FACT( )

d. DIV( )

Clear my choice

Question 2

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is the source of semi-structured data?

Select one:

a. Spreadsheets

b. Chats

c. XML documents

d. Facebook posts

Clear my choice

Question 3

Not yet answered

Marked out of 1.00

Flag question

Question text

A single variable X can explain a large percentage of the variation in some other variable Y when the two variables are

Select one:

a. inversely related.

b. mutually exclusive.

c. highly correlated.

d. directly related.

Clear my choice

Question 4

Not yet answered

Marked out of 1.00

Flag question

Question text

If you have a vector stored as A in R, then A[-1] would result in?

Select one:

a. All the elements replaced by -1

b. All the elements except the first item in the vector

c. None of the options

d. First element replaced by -1

Clear my choice

Question 5

Not yet answered

Marked out of 1.00

Flag question

Question text

Simon wants to add two numbers in cells F4 & H11. Which of the following is a valid example of an Excel formula?

Select one:

a. =TOTAL(F4:H11)

b. =SUM(H11:F4)

c. =DOSUM(F4:H11)

d. =ADD(F4:H11)

Clear my choice

Question 6

Not yet answered

Marked out of 1.00

Flag question

Question text

What does a beta of 0.578 mean in a simple linear regression model?

Select one:

a. That the correlation is significant

b. Means that for every unit increase in dependent variable, independent variable increases by 0.578 units

c. Means that for every unit increase in independent variable, dependent variable increases by 0.578 units

d. That the regression is not significant

Clear my choice

Question 7

Not yet answered

Marked out of 1.00

Flag question

Question text

Mike has defined a vector as w <- c(0.078828,0.078531,0.078431,0.078063,0.078069, 0.078125,0.078827). What would be the output of the command range(w) ?

Select one:

a. 0.078531, 0.078827

b. 0.078069, 0.078531

c. 0.078431, 0.078818

d. 0.078063, 0.078828

Clear my choice

Question 8

Not yet answered

Marked out of 1.00

Flag question

Question text

How many coefficients do you need to estimate in a simple linear regression model?

Select one:

a. 1

b. 4

c. 2

d. 3

Clear my choice

Question 9

Not yet answered

Marked out of 1.00

Flag question

Question text

A numerical variable across categories of some categorical variable is with

Select one:

a. neither a side-by-side box plot nor side-by-side pivot table.

b. a side-by-side box plot.

c. side-by-side pivot table.

d. a side-by-side plot or side-by-side pivot table.

Clear my choice

Question 10

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following commands will be used in R to read tab delimited text file?

Select one:

a. read.table(file.choose(), header=T, sep=\t)

b. read.csv(file.choose(), header=T, sep=\t)

c. read.csv(file.choose())

d. read.table(file.choose(), header=T, sep=\;)

e. read.table(file.choose(), header=T, sep=,)

Clear my choice