(Optional) Setting up spreadsheet software to do your own analysis

Loading...

Из курса от партнера University of Cape Town

Understanding Clinical Research: Behind the Statistics

790 оценки

University of Cape Town

Understanding Clinical Research: Behind the Statistics

790 оценки

If you’ve ever skipped over`the results section of a medical paper because terms like “confidence interval” or “p-value” go over your head, then you’re in the right place. You may be a clinical practitioner reading research articles to keep up-to-date with developments in your field or a medical student wondering how to approach your own research. Greater confidence in understanding statistical analysis and the results can benefit both working professionals and those undertaking research themselves. If you are simply interested in properly understanding the published literature or if you are embarking on conducting your own research, this course is your first step. It offers an easy entry into interpreting common statistical concepts without getting into nitty-gritty mathematical formulae. To be able to interpret and understand these concepts is the best way to start your journey into the world of clinical literature. That’s where this course comes in - so let’s get started! The course is free to enroll and take. You will be offered the option of purchasing a certificate of completion which you become eligible for, if you successfully complete the course requirements. This can be an excellent way of staying motivated! Financial Aid is also available.

Из урока

Describing your data

With the next topics, we finally get started with the statistics. Have you ever looked at the methods and results section of any healthcare research publication and noted the variety of statistical tests used? You would have come across terms like t-test, Mann-Whitney-U test, Wilcoxon test, Fisher’s exact test and the ubiquitous chi-squared test. Why so many tests you might wonder? It’s all about types of data. In this week, I am going to tackle the differences in data which determine what type of statistical test we can use in making sense of our data.

Introduction1:17

Measures of central tendency5:06

Measures of dispersion6:30

(Optional) Setting up spreadsheet software to do your own analysis3:20

(Optional) Descriptive statistics using spreadsheet software9:29

Познакомьтесь с преподавателями

Juan H Klopper
Dr
Department of Surgery

If you want to do some of your own analysis,

the easiest way to get into it is to use normal spreadsheet software.

It's not as powerful as proper statistical software or

computer languages such as Python, Julia, R, but you can get quite a bit done.

Now, the most famous of the spreadsheet software is probably Microsoft Excel.

It's a commercial product, you'll have to buy it, pay for it.

And there's a variety of options,

you can buy a box set or you can buy a subscription.

Here we have Microsoft Excel on the Mac OS.

It's going to look slightly different in the Microsoft Windows version.

To do any kind of statistical analysis though,

you'll have to install a bit of software that is usually not pre-installed.

And when you open Excel you would want to go to Tools, and

then down to Excel Add-ins.

So, this is on the Mac OS.

And when you hit the Excel Add-ins, you're going to see these two pop up.

For you, perhaps they will not be checked.

The analysis tool pack.

And if you would like to resolve as well, click both.

And once you've installed those, you can go to Data.

And right on side of the ribbon we'll see Data Analysis,

which will appear now that we've installed those two add-ons.

And you can see the variety of analysis tools that are available.

We can draw histograms.

We can do linear regression.

And we can do a variety of t-tests in this software.

So, be sure to do the following, to go to Tools,

go down to Excel Add-ins, and add that.

In the Windows version, also look for

the Excel's Add-in, and you will find the data analysis toolpack there,

which means we can do some basic statistical analysis using this software.

Now, I'm just going to drag across LibreOffice to this screen here.

Let me increase that.

This is LibreOffice.

If you want to install that, here we go.

It is on the website libreoffice.com.

It's a full Office Suite, free of charge.

It's going to have word processor.

It's going to have spreadsheet software.

It's going to have presentation, slide show software.

Just as any or at least as the leading commercial product, but

this is free of charge.

And if we go to LibreOffice, we'll see that there is

already a data statistics package already installed.

You don't have to install anything.

And again, we can do some sampling, descriptive statistics, innovas and

correlation, regression.

We see t-tests, and even the chi square test, all available in LibreOffice.

So, if you want to get your hands dirty with some data, work on your own data,

do a few of these tests, start off with spreadsheet software.

Ознакомьтесь с нашим каталогом

Присоединяйтесь бесплатно и получайте персонализированные рекомендации, обновления и предложения.

Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.

© Coursera Inc., 2018 Все права защищены.

Загрузить из App Store

Загрузить в Google Play