Quiz Space

Tools in Data Science · End Term · 30 Apr 2023 · January 2023 term · Set QPD1-S2

Question 22: We are interested in analyzing the effect of money spent…

Question 22

+1 markOne correct option

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?

  1. A

    STDEV.P()

  2. B

    STDEV.S()

  3. C

    SLOPE()

  4. D

    EXACT()

Show answer

Correct answer

  • C

    SLOPE()

See the whole paperTake it as a mock test

Question 22 of 62 in the IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 30 Apr 2023, in the January 2023 term (IIT M DIPLOMA ET1 EXAM QPD1 S2 30 Apr 2023). It carries 1 mark.

This question was also asked in

More questions from this paper

  1. Q1The analysis metric slope can be observed through which of the following ways?
  2. Q2Quill provides the option to turn on/off, for displaying the individual comments from the narrative generation process?
  3. Q3We are analyzing how much the use of fertilizers affects the agricultural yield of the farmers. Which Excel function wo…
  4. Q4Subjectivity score in TextBlob ranges from _.
  5. Q5Flourish cannot be used to create animated bar charts.
  6. Q6A very large Matrix A has a lot of zero entries in it. Which function from the scipy library is useful in efficient sto…
  7. Q7Kumu is a tool that allows you to (select the most appropriate answer):
  8. Q8Which of the following Python libraries has functions and tools that are useful in the analysis of large graphs?
  9. Q9Which of the following Python libraries has functions extensively written to perform numerical operations?
  10. Q10You developed a sudden interest in English Premier League. Post the TDS course, you wanted to perform an analysis on al…
  11. Q11Assume you have data with a column “Direction” which takes the values “Left”, “Right”. If you had used one hot encoding…
  12. Q12One of quick ways to generate a descriptive stats file for variables along with correlation is to use
  13. Q13You decide to use keras to classify images into one of the following categories: cat, dog, bull. Which of the following…
  14. Q14Logical calculations in tableau helps to determine if a certain condition is true or false. Is the following expression…
  15. Q15The dataset consists of geographic, demographic information about countries and their respective GDPs. You would like t…
  16. Q16What are the two outputs provided by the Excel Azure Machine Learning plugin?
  17. Q17The final output from the BBC Weather Location Service API is in CSV format:
  18. Q18Which among the following properties are returned by the sentiment function of the TextBlob library?
  19. Q19Subjectivity score ranges between -1 to +1.
  20. Q20A subjectivity score of 0.4 means that the text statement:
  21. Q21A polarity score of 0.1 means that the text statement:
  22. Q23You are working on a piece of code that classifies different vehicles into its respective class (car, LCV, truck, earth…
  23. Q24Tableau automatically divides the data fields into two categories. What are they..?
  24. Q25Which Extension in Tableau transforms visualizations into narratives.?
  25. Q26If you want to create comical characters while building business stories, which tool would be helpful.?
  26. Q27Which of the following is used to build and host web applications?
  27. Q28Which among the following excel charts is the most suitable for detecting outliers in the data?
  28. Q29Which of the following libraries is used to construct API urls?
  29. Q30Which of the following tabs is used to identify API calls in the Inspect element in any browser?
  30. Q31Google Studio is a tool that allows you to
  31. Q32csr_matrix from the scipy library:
  32. Q33classification_report function from the sklearn.metrics module
  33. Q34pycaret is a
  34. Q35We are interested in fitting an ARIMA model to our time series data. Specifically, we are interested in a moving averag…
  35. Q36Scikit-learn has a DecisionTreeClassifier module that is useful in building decision tree classifiers. Suppose, our dat…
  36. Q37The data consists of prices of three shares in the stock market over a period of six months. To compute the correlation…
  37. Q38Assume the data provided to you has a column that consists of sales dates. You would want to extract the week number fr…
  38. Q39Which among the following features in excel enables you to scrape data from websites?
  39. Q40Which of the following statements about the k-means clustering algorithm is false?
  40. Q41Which of the following is NOT a method of the Beautiful Soup object?
  41. Q42What is ComicGen?
  42. Q43Network tab in Chrome Devtools (Inspect) tracks all api calls that happen in a website.
  43. Q44Flourish is a web-based:
  44. Q45Which of the tools below are used for data storytelling?
  45. Q46data consists of any value within the finite or infinite intervals. _ data displayed as green icons in the data window …
  46. Q47From the below options identify the statement that is False
  47. Q48Which of the following statements about Heroku is true?
  48. Q49Which data type is not available in the ARX tool while you input data for anonymizing?
  49. Q50Your model is performing well in your training dataset but is not performing well in test dataset. It means:
  50. Q51The following function in excel helps in removing extra spaces:
  51. Q52For categorical variables, missing data can be replaced by:
  52. Q53The given piece of code extract details of all Bollywood movies that were released in Jan – March 2009 and later prints…
  53. Q54Identify which of the following statements is/are TRUE\ A story contains a single view along with shelves, cards, legen…
  54. Q55Figure question
  55. Q56Figure question
  56. Q57Provided below is a snapshot of the dataset which consists of movie reviews and respective labels. To compute the senti…
  57. Q58Figure question
  58. Q59Comicgen is a useful tool in narrating data stories using comics. Which of the following are capabilities of comicgen?
  59. Q60scikit-network package contains functions for (select all correct sentences):
  60. Q61You wish to convert to a csv file for further analysis in Excel. The following method in ‘tabula’ can be used for the s…
  61. Q62From the converted csv file in previous question , you realize that the team ‘Delhi Daredevil’ has changed its name to …