We are analyzing how much the use of fertilizers affects the agricultural yield of the farmers.
Which Excel function would you use as a starting point in this analysis?
A.
STDEV.P()
B.
STDEV.S()
C.
SLOPE()
D.
EXACT()
A published solution is not available for this question yet.
A very large Matrix **A** has a lot of zero entries in it. Which function from the scipy library is useful in
efficient storage of such a matrix **A**?
A.
csr_matrix
B.
interpolate
C.
compressed_mat
D.
zip_mat
A published solution is not available for this question yet.
You developed a sudden interest in English Premier League. Post the TDS course, you wanted to
perform an analysis on all teams which played EPL from the year 1992. You performed PDF
scraping using ‘tabula’ and appended every year standings of teams one below the other and
saved as a single csv file. For looking at aggregating at various levels (viz Year wise, Team wise) the
following can be used in Excel:
A.
Pilot Table
B.
Pivot Table
C.
Pivol Table
D.
None of these
A published solution is not available for this question yet.
Assume you have data with a column “Direction” which takes the values “Left”, “Right”. If you had
used one hot encoding, the new columns added would be:
A.
Direction_Left, Direction_Right
B.
Left_Direction, Right_Direction
C.
Left-Direction, Right-Direction
D.
Direction-Left, Right-Direction
A published solution is not available for this question yet.
You decide to use keras to classify images into one of the following categories: cat, dog, bull.
Which of the following loss functions from Keras would you pick for the task?
A.
binary_crossentropy
B.
categorical_crossentropy
C.
mean_squared_error
D.
mean_absolute_error
A published solution is not available for this question yet.
The dataset consists of geographic, demographic information about countries and their respective
GDPs. You would like to visualize this data and study the relationship between the location of
countries and their GDPs. You decide to use Tableau to visualize the dataset. But you would also
like to generate a summary of the data. Choose the most suitable answer among the given
options.
A.
The summary can be generated using Quill and this is possible because Quill
can be used as an extension in Tableau.
B.
Tableau can be used for visualization. But Quill is incompatible with Tableau.
C.
Quill does not support generation of summary. Therefore using other
visualization tools such as Tableau would work.
D.
None of the options are appropriate for the generation of summary for the
given question.
A published solution is not available for this question yet.
We are interested in analyzing the effect of money spent on TV advertising on the sales volume of
a product. Which Excel function would you use as a starting point in this analysis?
A.
STDEV.P()
B.
STDEV.S()
C.
SLOPE()
D.
EXACT()
A published solution is not available for this question yet.
You are working on a piece of code that classifies different vehicles into its respective class (car,
LCV, truck, earth movers). Which of the following loss functions from Keras would you pick for the
task?
A.
binary_crossentropy
B.
categorical_crossentropy
C.
mean_squared_error
D.
Mean_absolute_error
A published solution is not available for this question yet.
We are interested in fitting an ARIMA model to our time series data. Specifically, we are interested
in a moving average model of 0, setting a lag value of 4 for autoregression, and a difference order
of 1. Which of the following gives you such a model?
A.
ARIMA(..., trend = (4,1,0))
B.
ARIMA(..., order = (4,1,0))
C.
ARIMA(..., order = (0,4,1))
D.
ARIMA(..., trend = (0,4,1))
A published solution is not available for this question yet.
Scikit-learn has a DecisionTreeClassifier module that is useful in building decision tree classifiers.
Suppose, our dataset is imbalanced in class. Which feature in the DecisionTreeClassifier() will help
us tackle this problem?
A.
random_state
B.
min_sample_split
C.
class_balance
D.
class_weight
A published solution is not available for this question yet.
The data consists of prices of three shares in the stock market over a period of six months. To
compute the correlation coefficients between these three shares: (Choose the most suitable
option)
A.
It is sufficient if you specify these three shares as input variables in the excel
‘data analysis toolpak’ feature.
B.
You must specify both input and target variables in the excel ‘data analysis
toolpak’ to obtain the correlation coefficient values.
C.
It is sufficient if you specify these three shares as target variables in the excel
‘data analysis toolpak’ feature.
A published solution is not available for this question yet.
Assume the data provided to you has a column that consists of sales dates. You would want to
extract the week number from the column for further analysis. Which among the following excel
function enables you to perform the above-mentioned task?
A.
WEEKGET()
B.
GETWEEKNUM()
C.
NUMWEEK()
D.
None of these
A published solution is not available for this question yet.
The given piece of code extract details of all Bollywood movies that were released in Jan – March
2009 and later prints out only those rows where the respective movie was categorized only as a
Drama. Identify which block of code executes without any errors.
A.B.C.D.
A published solution is not available for this question yet.
Identify which of the following statements is/are TRUE
1. A story contains a single view along with shelves, cards, legends, and the Data and Analytics
panes in its side bar.
2. A worksheet contains a sequence of stories that work together to convey information
3. A dashboard is a collection of views from multiple worksheets
A.
1 Only
B.
3 Only
C.
2 & 3 Only
D.
1 & 2 Only
A published solution is not available for this question yet.
Provided below is a snapshot of the dataset which consists of movie reviews and respective labels.
To compute the sentiment scores the Azure Machine Learning add-in requires input and output
values. In the figure provided below the input and output cells need to be populated with
appropriate values to obtain sentiment scores.
Choose the most appropriate option that enables you to predict sentiment scores using the Excel
Azure Machine Learning add-in.
A.B.
A published solution is not available for this question yet.
You decided to perform analysis of the IPL teams year on year. You downloaded the teams
standings table which got downloaded as a PDF. You wish to convert to a csv file for further
analysis in Excel. The following method in ‘tabula’ can be used for the same:
A.
convert_into
B.
convert_file
C.
convert_all
D.
convert_csv
A published solution is not available for this question yet.
From the converted csv file in previous question, you realize that the team ‘Delhi Daredevil’ has
changed its name to ‘Delhi Capital’. Using excel, you wish to replace the old name with a new
name. It can be done in Excel using
A.
Find and Replace
B.
Finding and Replacing
C.
Replace and Find
D.
Search and Replace
**BDM**
**Section Id :** 64065341311
**Section Number :** 8
**Section type :** Online
**Mandatory or Optional :** Mandatory
**Number of Questions :** 15
**Number of Questions to be attempted :** 15
**Section Marks :** 40
**Display Number Panel :** Yes
A published solution is not available for this question yet.