Alternative transcript:

is going to use it Has been collected by someone else Block F Takes a sample from a section of the population present at one particular place/time The researcher uses their judgement to choose a sample they think represents the population Population is split into groups. A certain number of people from each group are interviewed Dirty Data Data Cleaning Excel Uses of Excel Sum Proportion Pie Charts Block G Data that contains erroneous information eg. missing data, wrongly formatted data, incorrect data. Comparative Pie Charts The process of removing dirty data from within a dataset eg. removing duplicates, standardising format, filtering unwanted outliers. A spreadsheet. To allow calculations (such as summing), graphs, analysis to be done. Add the values. Shown as > Block I A part or number in comparative relation to a whole. Used to show how data is divided into categories. The size of each sector shows the proportion of the total data in that category. Good for showing qualitative data. Calculating Angle Angle (frequency / total of Sector frequency) x 360 Used to compare two data sets. The area of the comparative pie charts is used to compare. Systematic Sampling Ethical Confidentiality Questionnaire Open Question Closed Question Histogram Frequency Density The researcher chooses a random starting point and takes a sample at regular intervals. Block H Completed under fair and moral conditions. Keeping or being kept secret or private. A set of questions designed to obtain data. A question with no suggested answer eg, what are you planning to buy today at the supermarket? A question which gives answers to choose from eg, Do you like your meal? Yes or No. Block J Histograms are used to show continuous data from a grouped frequency table. Frequency Density = frequency / class width Frequency from a Frequency = frequency density x Histogram class width