ISLA IPGT 25037

Tools for Data Analysis

• ApresentaçãoPresentation

  The business world has lived through times of great instability and any decision that has to be taken can be crucial in differentiating between the success or failure of a company, in the market in which it operates. Data collection is the first stage of the empirical study. At a later stage, the treatment and analysis of the data are essential for carrying out an investigation related to a specific problem, as it allows researchers to obtain reasoned conclusions. Thus, in order to better sustain decisions, it is imperative to plan the investigation, collect, process and analyze the data, concluding this process with the sharing of the results obtained. The process of analyzing and interpreting data is a laborious and demanding task that makes it possible to achieve the main objective of a research project: the production of scientific knowledge!
• ProgramaProgramme

  Probability distributions of continuous variables Exponential distribution Normal distribution t-Student distribution Confidence intervals Confidence intervals for mean, difference of means, proportion, difference of proportions, variance, ratio of variances Hypothesis testing Test of the value of the mean, comparison of means, proportions, comparison of proportions, variance, comparison of variances Linear Regression Simple linear regression Scatter diagram Least squares method Standard error of estimate Coefficients of determination and correlation  Spreadsheets - Ms Excel Selecting, inserting, editing and working with cells Spreadsheets and basic operators Formatting, formulas and functions Outputs - spreadsheet configuration and printing Dynamic tables and graphs. Dashboards Power-BI
• ObjectivosObjectives

  Presentation of techniques for analysing and interpreting data commonly used in empirical research and in the world of work. To provide students with a set of statistical techniques and methods that facilitate the analysis and interpretation of information. Students should understand theoretical probability distributions and recognise their applicability in concrete cases; understand the meaning of confidence intervals, hypothesis tests and linear regression; develop the ability to use a set of statistical techniques and methods that facilitate the analysis and interpretation of information, using software such as Excel (with a focus on Pivot Tables) and Power-BI.
• BibliografiaBibliography

  Afonso, A., e Nunes, C. (2011). Probabilidades e Estatística: Aplicações e Soluções em SPSS. Lisboa, Portugal: Edições Sílabo. Guimarães, R. C., e Cabral, J. S. (2010). Estatística (2ª edição) . Lisboa, Portugal: Verlag Dashöfer Portugal. Murteira, B., Ribeiro, C. S., Silva, J. A., e Pimenta, C. (2015). Introdução à Estatística (3ª edição) . Lisboa, Portugal: Escolar Editora. Pestana, M. H., e Gageiro, J. N. (2014). Análise de Dados para Ciências Sociais - A Complementaridade do SPSS (6ª edição) . Lisboa, Portugal: Edições Sílabo Gomes, C. (2020). Material de Apoio à Unidade Curricular de Estatística. ISLA-Instituto Politécnico de Gestão e Tecnologia. Kazmier, L. (1982). Estatística Aplicada a Economia e Administração . Schaum McGraw-Hill. Reis, E. (2008). Estatística Descritiva (7ª ed.). Edições Sílabo.Estatística, Newman, J. (2021) The Microsoft Office 365 Handbook - Everything You Need To Know About Microsoft Office 365      
• MetodologiaMethodology

  Classes are of a theoretical and practical nature, where the theoretical exposition of the syllabus is accompanied by the presentation of practical examples and exercises. The evaluation is carried out taking into account the assessment regulation Regulamento Geral de Avaliação da Universidade Lusófona do Porto. Pedagogical innovation practices : Pedagogical practices will be mediated by Information and Communication Technologies, using computers and/or mobile devices. Students will be exposed to interactive educational resources, such as quizzes. Problem-based learning will be promoted, where the students, guided by the teacher, should identify problems and plan and carry out resolution paths. The aim is to improve the teaching and learning process, to provide students with the necessary skills for the challenges currently facing humanity, and to increase their motivation in relation to the course
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não
• AvaliaçãoEvaluation

  Avaliação Contínua	DATA	PESO
  1º Momento - Teste Teórico	23/3/2026	50%
  2º Momento - Trabalho + Defesa	18/5/2026	50%
  TAG	25/5/2024	100%

  Observações:

  a) Os alunos terão de optar entre a realização dos Testes intermédios ou a realização do Teste de Avaliação Global. Se o aluno tiver nota inferior a 7,5 valores no 1º Teste ou desistir, não pode comparecer ao 2º Teste. A aprovação na avaliação curricular implica nota final não inferior a 9,5 valores. Os alunos não podem ter nota inferior a 7,5 valores em cada um dos testes.

  b) Todos os alunos inscritos à unidade curricular podem realizar o exame final na época normal desde que não tenham realizado ou obtido aprovação na avaliação curricular