Data 4 Security Flashcards
Access control
Features such as password protection, user permissions, and encryption that are used to protect a spreadsheet
Access control
Features such as password protection, user permissions, and encryption that are used to protect a spreadsheet
Regular expression (regex) patterns
Values must match a prescribed patternA phone number must match ###-###-#### (no other
Cross-field validation
Certain conditions for multiple fields must be satisfied
Values are percentages and values from multiple fields must add up to 100%
Cross-field validation
Certain conditions for multiple fields must be satisfied
Values are percentages and values from multiple fields must add up to 100%
Dated if
Calculates the time between 2 dates
Confidence interval
How confident you are in the survey results. For example, a 95% confidence level means that if you were to run the same survey 100 times, you would get similar results 95 of those 100 times. Confidence level is targeted before you start your study because it will affect how big your margin of error is at the end of your study.
Margin of error
Since a sample is used to represent a population, the sample’s results are expected to differ from what the result would have been if you had surveyed the entire population. This difference is called the margin of error. The smaller the margin of error, the closer the results of the sample are to what the result would have been if you had surveyed the entire population.
Confidence interval
Confidence interval
The range of possible values that the population’s result would be at the confidence level of the study. This range is the sample result +/- the margin of error.
Statistical significance
The determination of whether your result could be due to random chance or not. The greater the significance, the less due to chance.
Choosing sample size
For a higher confidence level, use a larger sample size
To decrease the margin of error, use a larger sample size
For greater statistical significance, use a larger sample size
Choosing sample size
For a higher confidence level, use a larger sample size
To decrease the margin of error, use a larger sample size
For greater statistical significance, use a larger sample size
Sample minimum of 30
Central Limit Theorem (CLT) in the field of probability and statistics. As sample size increases, the results more closely resemble the normal (bell-shaped) distribution from a large number of samples. A sample of 30 is the smallest sample size for which the CLT is still valid. Researchers who rely on regression analysis – statistical methods to determine the relationships between controlled and dependent variables – also prefer a minimum sample of 30.
Sample size calculator
Confidence level: The probability that your sample size accurately reflects the greater population.
Margin of error: The maximum amount that the sample results are expected to differ from those of the actual population.
Population: This is the total number you hope to pull your sample from.
Sample: A part of a population that is representative of the population.
Estimated response rate: If you are running a survey of individuals, this is the percentage of people you expect will complete your survey out of those who received the survey.
Margin of error
is the maximum amount that the sample results are expected to differ from those of the actual population. More technically, the margin of error defines a range of values below and above the average result for the sample. The average result for the entire population is expected to be within that range. We can better understand margin of error by using some examples below.
