click below
click below
Normal Size Small Size show me how
Mike C. CH3 VIDS
| Question | Answer |
|---|---|
| 2 types of statistics | 1)descriptive statistics 2) inferentia statistics |
| Inferential statistics | draws conclusions from our data by making generalizations and predictions |
| descriptive statistics | describes data by summarizing it and providing us with visible features |
| Descriptive statistics is also known as | summary statistics |
| Measures of central tendency | summarize data using a single value that identifies the center of the dataset |
| 3 measures of central tendencies | mean, median, mode |
| Mean | mathematical average |
| Median | value in the middle of a sorted (smallest to greatest/ viceversa) data set |
| Mode | most common value in the dataset |
| Measures of dispersion | describes how the data is spread out around the center |
| 3 different measures of dispersion | 1) find min&max, 2)Distribution, 3) nonparametric data |
| Distribution | describes the frequency at which each value appears in the dataset |
| Histogram’s show | the distribution of datasets |
| Nonparametric data | does not fit any statistical distribution type |
| Measures of dispersion | 1) variance, 2) standard deviation |
| Population | data for every possible member of the dataset |
| Sample | data for a representative chunk of the population |
| Standard deviation | squareroot of the variance |
| Zscore | describes how many standard deviations a measurement is from the mean |
| Variance of population symbol | σ² |
| Analyze the values of X shown > {2,2,5,6,7} What is the range of these values? | 5 |
| You are measuring how much a child has grown over the past year and would like to express that using a percentage. What calculation is most appropriate? | percent change |
| Analyzing a data point, you find that the point is 1 standard deviation above the mean. What is the z-score for this datapoint? | 1 |
| Confidence intervals | estimate how close a sample eman is to the actual population mean |
| Disproving your hypothesis works by providing a valid counter example(t/f) | t |
| Alternative hypothesis (Ha) | statement we are trying to prove correct (the question) |
| Null Hypothesis(H0) | opposite of our alternative hypothesis (idea that there has been no change or difference) |
| Level of significance | probability the testing will reject the null hypothesis when it is true (type 1 error) |
| Type 1 Error | Reject Null Hypothesis while its true |
| Type 2 Error | Accept null hypothesis while its False |
| P-value | probability that test results are not statistically significant |
| If P <=a then we | reject the null hypothesis (what we are trying to prove is correct) |
| If p>a then we | accept the null Hypothesis (we do not have evidence to support our hypothesis) |
| Data Definition Language (DDL) | used to define structure of the database |
| Data Manipulation Language (DML) | Used t add, remove, retrieve, and change data in the database |
| Create (SQL DDL command) | creates new table and databases |
| Alter (SQL DDL command) | changes the structure of existing databases and tables |
| Drop(SQL DDL command) | deletes entire table and databases |
| Select (DML Command) | retrieves information from a database |
| Insert(DML Command) | adds information to a database |
| Update (DML Command) | changes info in a database |
| Delete(DML Command) | deletes records from a database |