- Видео 24
- Просмотров 6 590
Databrarian
Канада
Добавлен 28 июл 2023
How to calculate odds, odds ratios, relative risk, attributable risk & population attributable risk
In this video, we will cover how to create crosstab or contingency tables using several continuous dataseries and from there calculating odds, odds ratio, relative risk, attributable risk and population attributable risk.
For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics
Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technology-logo--stereoalex
For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics
Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technology-logo--stereoalex
Просмотров: 66
Видео
How to create crosstab tables in Excel
Просмотров 30514 дней назад
In this video, we will cover how to create cross tabulation (crosstab) tables using formulas and pivot tables. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technology-logo stereoalex
How to manipulate your data: Joining and separating strings
Просмотров 10521 день назад
In this video, we will cover how to manipulate strings by joining them and separating them given different scenarios and criteria. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technology-logo stereoalex
How to deal with missing values in Excel
Просмотров 14721 день назад
In this video, we will learn different ways of deal with missing values in our dataset as well as how to standardize our entries so that they are always consistent no matter who enters them. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technolog...
How to analyze your data to create confidence intervals for a sample mean
Просмотров 1572 месяца назад
In this video, we will discover various ways to calculate a confidence interval for a sample mean. To do so, we will use various Excel formulas such as AVERAGE, COUNT, T.INV, SQRT, VAR.S, STDEV.S, and CONFIDENCE.T. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.com/music/t...
How to create data visualizations (line charts, scatter plots, and column/bar charts)
Просмотров 7792 месяца назад
In this video, we will learn different ways to visualize our data from line charts to show changes over time to scatter plots which shows relationships between two variables, to column charts to visualize summary statistics. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.c...
How to create a table in APA style format
Просмотров 5263 месяца назад
In this video, we will learn how to properly format a table using the APA style guide format. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technology-logo stereoalex For more information on APA styled tables, you can refer to owl.purdue.edu/owl/...
How to create data visualizations (histograms, box plots, column/bar charts, and line charts)
Просмотров 1153 месяца назад
In this video, we will learn different ways to visualize our data from histograms to illustrate data distributions, to box plots to show us data variation within and between data series, to column charts to visualize summary statistics and line charts to show changes over time. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-ba...
Introduction to Excel for ARTS1014 students
Просмотров 663 месяца назад
Introduction to Excel for ARTS1014 students with little or no knowledge of this software program. In this video, we will cover the basic Excel environment as well as common terms used in the software; how to format and organize your data; how to calculate numbers and create basic formulas such as SUM, COUNT, AVERAGE, MAX and MIN. Finally we will also cover how to create charts, specifically col...
How to calculate measures of variation (variance, standard deviation, inter-quartile range)
Просмотров 2463 месяца назад
In this video, we will discover how to calculate various measures of variation including, minimum, maximum, range, inter-quartile range, variance and standard deviation. We will do this when presented with the raw data as well as when dealing with a frequency table. To do so, we will use various Excel formulas such as MIN, MAX, AVERAGE, COUNT, QUARTILE.INC, SQRT. VAR.S, and STDEV.S. For more in...
How to calculate the central tendency (mean, median, and mode)
Просмотров 1043 месяца назад
In this video, we will quickly discuss the three elements of the central tendency (mean, median, and mode) and then proceed to discover how to calculate them when presented with the raw data as well as when dealing with a frequency table. To do so, we will use various Excel formulas such as SUM, COUNT, AVERAGE, MEDIAN and MODE.MULT. For more information on basic Excel skills, see my Microsoft E...
How to clean your data: Altering text casings and removing trailing spaces
Просмотров 2124 месяца назад
In this video, we will cover how to clean your data using various text casing formulas (UPPER, LOWER, and PROPER) and how to deal with trailing or redundant spaces using the TRIM formula. We will also go over how to verify our results using the UNIQUE formula. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and out...
How to create a frequency table and calculate quartiles and percentiles
Просмотров 2234 месяца назад
In this video, we will cover how to create frequency tables of a data series using the SORT, UNIQUE and COUNTIF formulas as well as reviewing the difference between relative and absolute cell references. We will also go over how to calculate quartiles and percentiles of a data series using the QUARTILE.INC and PERCENTILE.INC formulas respectively. For more information on basic Excel skills, see...
Introduction to Excel for SOCI2022 students
Просмотров 1294 месяца назад
Introduction to Excel for SOCI2022 students with little or no knowledge of this software program. In this video, we will cover the basic Excel environment as well as common terms used in the software. We will also cover how to calculate numbers and create basic formulas such as SUM, COUNT, AVERAGE, MAX and MIN. To download Microsoft Office (UNB only): unbcloud.sharepoint.com/sites/ITSSelfServe ...
How to analyze your data to create a bar chart
Просмотров 4394 месяца назад
In this video, we will cover how to create charts, specifically column charts (and bar charts) and then optimize the chart to effectively communicate the underlying data. For more information on basic Excel skills, see my Microsoft Excel Basic Guide at lib.unb.ca/guides/microsoft-excel-basics Intro and outro music from Stereoalex at icons8.com/music/track/synthwave-technology-logo stereoalex
How to analyze your data to create a photosynthesis-irradiance (PI) curve
Просмотров 2914 месяца назад
How to analyze your data to create a photosynthesis-irradiance (PI) curve
How to analyze your data to create a dot plot with error bars
Просмотров 3924 месяца назад
How to analyze your data to create a dot plot with error bars
How to analyze your data to create a scatter plot with error bars
Просмотров 5564 месяца назад
How to analyze your data to create a scatter plot with error bars
How to analyze your data to create a line chart with error bars
Просмотров 8924 месяца назад
How to analyze your data to create a line chart with error bars
Introduction to Excel for BIOL1006 students
Просмотров 3674 месяца назад
Introduction to Excel for BIOL1006 students
Tutorial 3: Bar Charts and Histograms
Просмотров 8911 месяцев назад
Tutorial 3: Bar Charts and Histograms
Tutorial 2: Filters and Pivot Tables
Просмотров 9711 месяцев назад
Tutorial 2: Filters and Pivot Tables