The Process Phase

Question 1

Refers to the accuracy, completeness, consistency and trustworthiness of data?

Answer 1

Data Integrity

Question 2

Process of storing data in multiple locations?

Answer 2

Data Replication

Question 3

The process of copying data from a storage device memory to another?

Answer 3

Data Transfer

Question 4

Process that involves changing the data to make it more organized and easier to read?

Answer 4

Data Manipulation

Question 5

It is the degree to which conforms to the actual entity being measured?

Answer 5

Accuracy

Question 6

The degree which the data contains all the desired components?

Answer 6

Completeness

Question 7

The degree to which the data is repeatable from different points?

Answer 7

Consistency

Question 8

The entire group you are interested in for your study?

Answer 8

Population

Question 9

A subset of your population?

Answer 9

Sample

Question 10

It is the difference between the sample’s result from what the result would have been if you had surveyed the entire population?

Answer 10

Margin of Error

Question 11

Refers to how confident you are in the survey results?

Answer 11

Confidence Level

Question 12

It is the range of possible values that the population’s result would be at the confidence level of the study?

Answer 12

Confidence Interval

Question 13

The determination whether your results could be due to random chance or not?

Answer 13

Statistical Significance

Question 14

Fill in the Blanks

When theres a greater sample size, there’s a _______ confidence level, ____ in margin of error and ____ statistical significance.

Answer 14

1. Higher
2. Decrease
3. Greater

Question 15

When a sample does not represent the population as a whole

Answer 15

Sampling Bias

Question 16

It is a sampling technique in which every participants in a population has an equal chance of being chosen?

Answer 16

Random Sampling

Question 17

When the data is incomplete, incorrect, or irrelevant?

Answer 17

It’s Dirty or Dirty Data

Question 18

Opposite of Dirty Data

Answer 18

Of course it’s Clean💅✨

Question 19

It is any data record that shows up more than once?

Answer 19

Duplicated Data

-Caused by manual data entry, data imports and data migration

Question 20

Any data that is old?

Answer 20

Outdated Data
- people changing roles/companies/softwares/system becoming absolete

Question 21

Any Data that is missing in important fields?

Answer 21

Incomplete data
- probably due to improper data collection

Question 22

Any data that is complete but inaccurate?

Answer 22

Incorrect/Inaccurate Data
- human error

Question 23

Any data that uses different format to represent the same thing?

Answer 23

Inconsistent Data

Question 24

A group of characters within a cell, often composed of letters, numbers, or both?

Answer 24

Test String

Question 25

A tool that divides a text string using a delimiter?

Answer 25

SPLIT Function
=SPLIT(cell, “delimiter”)

Question 26

A function that tells you the length of a text string?

Answer 26

LEN

Question 27

A function that joins multiple text strings into a single string?

Answer 27

CONCATENATE Funtion

Question 28

A function that removes a leading, trailing, and repeated spaces in data?

Answer 28

TRIM Function

Question 29

The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize.

Answer 29

Sorting

Question 30

Showing only the data that meets a specific area while hiding the rest?

Answer 30

Filtering

Question 31

A function that creates a hyperlink inside the cell?

Answer 31

HYPERLINK Function
=HYPERLINK(url, [linklabel])