Modern IT-Technologies.d

Modern IT-Technologies.d — вариант 3

Просмотрите все вопросы и варианты бесплатно. Правильные ответы скрыты и открываются только после получения доступа.

10 вопросов Вариант 3 Доступ 7 дней
Содержание теста

Вопросы и варианты

Без отметок и подсказок к правильным ответам

Вопрос 1

After loading/installing the analysis toolpak in Excel, you can use it from the … tab?

  1. Data
  2. Developer
  3. ADD-INS
  4. View
Вопрос 2

In order to find the standard deviation of a set of data in excel, you need to use …

  1. correlation
  2. regression
  3. descriptive statistics
  4. histogram
Вопрос 3

To use normal distribution function in excel, you need to select … function from statistical functions

  1. NORM.INV
  2. NORM.DIS
  3. NORM.S.DIST
  4. normal-distribution
Вопрос 4

In order to find the lower and upper estimate of the mean in Excel, you need to use it from …

  1. developer Tab then click on mean
  2. descriptive statistics then select mean option
  3. descriptive statistics then click on confidence level for mean
  4. descriptive statistics then new worksheet
Вопрос 5

To test of hypothesis concerning the population Mean, we should have … hypothesis

  1. one
  2. two
  3. four
  4. three
Вопрос 6

In statistics, claim or statement about a property of a population is called …

  1. theory
  2. mean
  3. mode
  4. hypothesis
Вопрос 7

Alternative Hypothesis can be denoted by …

  1. H0
  2. H@
  3. Hb
  4. H1
Вопрос 8

… is a statistical technique that can show how strongly pairs of variables are related

  1. correlation
  2. regression
  3. segmentation
  4. sampling
Вопрос 9

… is a method that attempts to determine the strength of the relationship between dependent and independent variables.

  1. confidence for interval mean
  2. correlation
  3. regression
  4. histogram
Вопрос 10

Excel is used in statistics because it is …

  1. secure
  2. easy to troubleshoot
  3. takes short time to enter the data
  4. easy to learn