- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Statistical analysis using MS EXCEL 2400-EXCEL-OG
Detailed list of topics:
• time series data,
• summary statistics,
• correlation measures,
• statistical graphs - histograms, boxplot, etc.,
• statistical hypotheses,
• regression models,
• operational research - optimization (Solver),
• operational research - simulation (Monte Carlo method),
• examples of statistics applications in Excel.
Note 1: classes are held in the form of e-learning on the platform: https://elearning.wne.uw.edu.pl (no live classes).
Note 2: The software version in the course is Microsoft Office 2019 or 365 (language version: English, operating system: Windows). Using an earlier version is possible, but it may cause some difficulties. The Polish language version is not a major problem, but the course a different operating system is (e.g. MacOS) due to the limitations of the Office suite (possible lack of necessary software components). The University of Warsaw does not provide participants with the necessary computer hardware or software.
Type of course
Prerequisites (description)
Course coordinators
Learning outcomes
After completing the course the student obtains the ability to statistical analysis in Excel, including: time series data, summary statistics, correlation measures, statistical graphs (histograms, boxplot, etc.), statistical hypotheses, regression models, optimization (Solver), simulation (Monte Carlo method).
Assessment criteria
The final evaluation consists of:
• Homework (60 pts.): two cumulative homework each scored 30 points.
• Questions and answers on the Discussion Forums: maximum 3 points for each
Scoring:
Points Mark
(0-30) 2
(30-36) 3
(36-42) 3,5
(42-48) 4
(48-54) 4,5
(54-60) 5
60 + 5!
Bibliography
• Materiały własne
• Walkenbach J, 2020, Excel 2019 PL. Formuły, Helion, Warszawa
• Walkenbach J, 2014, Excel 2013. 101 porad i sztuczek które oszczędzą Twój czas, Helion, Warszawa
• Brand S., 2002, Analiza danych, Wydawnictwo Naukowe PWN, Warszawa
• Masłowski K., 2004, Excel 2003 PL - 161 praktycznych porad, Helion, Gliwice
• Koronacki J., Mielniczuk J., 2001, Statystyka dla studentów kierunków technicznych i przyrodniczych, Wydawnictwa Naukowo-Techniczne, Warszawa
• Ferguson G., Takane Y., 1999, Analiza statystyczna w psychologii i pedagogice, Wydawnictwo Naukowe PWN, Warszawa
• Red. Szapiro T., 2000, Decyzje menedżerskie z Excelem, Polskie Wydawnictwo Ekonomiczne, Warszawa
• Lapin L., 1987, Statistics for modern business decision, Harcourt Brace Jovanovich
Additional information
Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes:
- Inter-faculty Studies in Bioinformatics and Systems Biology
- Bachelor's degree, first cycle programme, Computer Science
- Bachelor's degree, first cycle programme, Mathematics
- Master's degree, second cycle programme, Bioinformatics and Systems Biology
- Master's degree, second cycle programme, Computer Science
- Master's degree, second cycle programme, Mathematics
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: