MG1016 Seminar 2nd Week Seminar PDF

MG1016 Seminar MG1016: Managing information with Technology  Types of Data Brunel University London 2  Types of variable Interval/ratio > regular distances between all categories in range Ordinal > categories can be ranked, but unequal distances bet...

MG1016 Seminar MG1016: Managing information with Technology  Types of Data Brunel University London 2  Types of variable Interval/ratio > regular distances between all categories in range Ordinal > categories can be ranked, but unequal distances between them Nominal > qualitatively different categories - cannot be ranked Dichotomous > only two categories (e.g. gender) Brunel University London  Deciding how to categorize a variable Brunel University London Types of Data Population: All elements of interest Sample: Subset of the population > Random sampling - A sampling method to gather a representative sample of the population data. Quantitative data: Data on which numeric and arithmetic operations, such as addition, subtraction, multiplication, and division, can be performed. Categorical data: Data on which arithmetic operations cannot be performed. Brunel University London 5 Types of Data Cross-sectional data: Data collected from several entities at the same, or approximately the same, point in time. (e.g., Survey) Time series data: Data collected over several time periods. > Graphs of time series data are frequently found in business and economic publications. > Help analysts understand what happened in the past, identify trends over time, and project future levels for the time series. Brunel University London 6  Excel function Brunel University London 7  Working with excel function - Relative and absolute addresses Basic functions - Date, Time Functions: Dates and Times, Today, Now, Year, Month, Day, Weekday, DATE, DATEVALUE Brunel University London Presentation Title 8  Basic summarising functions - SUM, AVERAGE, PRODUCT - COUNT, COUNTA, COUNTBLANK - COUNTIF, SUMIF, AVERAGEIF - COUNTIFS, SUMIFS, AVERAGEIFS - SUMPRODUCT Open the excel file, then practice. Brunel University London Presentation Title 9  Essential functions - IF, VLOOKUP Math Functions - INT, ROUND - ABS, SQRT, SUMSQ - LN,EXP Open the excel file, then - RAND, RANDBETWEEN practice. Text functions - concatenating, parsing with Text to Columns - Parsing with Text Functions, Flash fill Brunel University London Presentation Title 10