Statistical Software (FSI-0SS)

Academic year 2020/2021
Supervisor: doc. RNDr. Zdeněk Karpíšek, CSc.  
Supervising institute: ÚM all courses guaranted by this institute
Teaching language: Czech
Aims of the course unit:
The course objective is to make students acquainted with programs Statgraphics, Statistica and Excel, which serve as a tool for statistical and probability calculations. Students will learn how to use the software at the extent corresponding with the subject matter presented in the parallel course Mathematics IV so that they can carry out calculations needed for working out tasks assigned in this course.
Learning outcomes and competences:
Students will learn how to use statistical software Statgraphics and Statistica as well as how to use statistical analytic tools in common spreadsheets. They will understand better the subject matter of Matematics IV. They will also acquire implementation skills in a statistical data analysis.
Prerequisites:
Mastering basic methods of descriptive statistics, probability theory and mathematical statistics is assumed.
Course contents:
The course is principally intended as a computer support for students taking up course Mathematics IV. The main purpose of this course is to introduce statistics software Statgraphics and Statistica, and statistical functions of the Excel, which are used in lessons and research at faculty institutes and departments. The acquired pieces of knowledge can be used in semester and diploma projects.
Teaching methods and criteria:
The course is taught through exercises which are focused on practical topics presented in lectures.
Assesment methods and criteria linked to learning outcomes:
Course-unit credit requirements: Continuous active work at seminars.
Controlled participation in lessons:
Attendance at seminars is controlled and the teacher decides on the compensation for absences.
Type of course unit:
    Computer-assisted exercise  13 × 2 hrs. compulsory                  
Course curriculum:
    Computer-assisted exercise 1. Information about statistical software Statgraphics and Statistica.
2. Information about spreadsheet processor Excel.
3. Structure of data files. Display and data output.
4. Generation and editing data files.
5. Descriptive statistics. Results presentation.
6. Elaboration of the first parts of assignment.
7. Basic types of random variables distributions.
8. Generation of random numbers. Examples from the subject Mathematics IV.
9. Operations with variables. Operations with files. Data import and export.
10. Point and interval estimates.
11. Statistical hypotheses testing.
12. Exhibits of applications.
13. Finishing calculations for the semester assignment.
Literature - fundamental:
3. Anděl, J.: Statistické metody. Praha : Matfyzpress, 1993.
Literature - recommended:
1. Karpíšek, Z.: Matematika IV. Statistika a pravděpodobnost. Brno : FSI VUT v CERM, 2003.
2. Karpíšek, Z. - Popela, P. - Bednář, J.: Statistika a pravděpodobnost. Učební pomůcka - studijní opora pro kombinované studium. Brno : FSI VUT v CERM Brno, 2002.
3. StatSoft, Inc.: Electronic Statistics Textbook. http://www.statsoft.com/, 2005.
The study programmes with the given course:
Programme Study form Branch Spec. Final classification   Course-unit credits     Obligation     Level     Year     Semester  
B3A-P full-time study B-MET Mechatronics -- Cr 2 Elective 1 2 S
B3A-P full-time study B-MTI Materials Engineering -- Cr 2 Elective 1 3 S
B3A-P full-time study B-MAI Mathematical Engineering -- Cr 2 Elective 1 3 S
B-FIN-P full-time study --- no specialisation -- Cr 2 Elective 1 2 S
B3S-P full-time study B-STI Fundamentals of Mechanical Engineering -- Cr 2 Elective 1 2 S