0% found this document useful (0 votes)
22 views4 pages

Statistical Packages and Data Analysis

The document provides an overview of various statistical packages such as SPSS, SAS, STATA, MINITAB, Excel, and JASP, highlighting their functionalities and applications in data analysis. It also discusses the history and development of statistics, the importance and limitations of statistical methods, and the processes involved in data collection and presentation. Key concepts include types of variables, measurement scales, and steps in data gathering, emphasizing the significance of accurate data handling for valid conclusions.

Uploaded by

aaaaimprint
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
22 views4 pages

Statistical Packages and Data Analysis

The document provides an overview of various statistical packages such as SPSS, SAS, STATA, MINITAB, Excel, and JASP, highlighting their functionalities and applications in data analysis. It also discusses the history and development of statistics, the importance and limitations of statistical methods, and the processes involved in data collection and presentation. Key concepts include types of variables, measurement scales, and steps in data gathering, emphasizing the significance of accurate data handling for valid conclusions.

Uploaded by

aaaaimprint
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

INTRODUCTION TO STATISTICAL PACKAGES AND DESCRIPTIVE STATISTICS

1. Statistical Package for the Social Sciences (SPSS)


● For complex and robust statistical analysis (ANOVA, regression, and multivariate
analysis).
● User-friendly with both menu-driven and syntax options.
2. Statistical Analysis System (SAS)
● Advanced analytics and is used for data management, statistical analysis, and
predictive modeling.
● For finance, insurance, health care, and education.
● Particularly strong in handling large data sets.
3. STATA (Statistics and Data)
● For data manipulation, visualization (for medicine and economic field), and
statistical analysis.
● Often used in research and academic settings but also valuable in accounting for
its comprehensive statistical tools.
4. MINITAB
● Offers a range of statistical tools for quality improvement and data analysis
● for an accountant focusing on quality control and process improvement.
5. EXCEL
● Analysis ToolPak add-in provides basic statistical analysis tools like regression,
ANOVA, and descriptive statistics.
● Widely used in accounting for accessibility and versatility. Allow user to perform
mathematical functions.
6. Jeffreys’s Amazing Statistics Program (JASP)
● In recognition of Bayesian pioneer Sir Harold Jeffreys
● Free and open-source statistics program for statistical analysis supported by the
University of Amsterdam.
● Designed to be easy to use and familiar to users of SPSS. Offers standard
analysis in classical and Bayesian form.

HISTORY OF STATISTICS
● Latin = ‘status’, Italian = ‘statista’, German = ‘statistic, which all means political state.
● In India even more than 2000 years ago there was already an existing efficient system of
collecting statistics (reign of Chandra Gupta Maurya, 324 - 300 B.C.)
● From Kautilya’s Arthshastra - before 300 B.C. there is a system of collecting Vital
statistics and registration of births and deaths
● During Akbar's reign - Raja Todarmal maintained land and agricultural statistics.
● In England, statistics were the outcome of the Napoleonic Wars. Assess Revenue,
Expenses and Levy Taxes to meet the cost of war.
● John Graunt of London
❖ (Father of Vital Statistics) first to study statistics of births and deaths. - 17th century
❖ Mortality Table and Life expectancy calculation.
● Caspar Neumann, Sir William Petty, James Dodson, Dr. Price - founded the first life
insurance institution in London in 1698.
● Modern Statistics came during the mid-17th Century with the introduction of Theory of
Probability and Theory of games and chance.
● French mathematician Pascal and Fermat solved the Problem of Points.
● Treatise on Theory of Probability - James Bernoulli (1653 - 1705)
● Monumental work on the Theory of Probability - Pierre Simon Laplace.
● Doctrine of Chances - Abraham De Moivre
● Least Squares and Normal Law of Errors - Karl Friedrich Gauss
● Statistical Method in Biometry - Francis Galton
● Origin and Development of Statistics
● Statistics as Science -Karl Pearson
❖ For correlational Analysis - “Chi-square test”, first modern tests of significance.
● T-Distribution (1908) - William Sealy Gosset
● Father of Statistics - Ronald A. Fisher
❖ Applied statistics in genetics, biometry, education, and agriculture.
❖ Introduced Point Estimation.
❖ Fiducial Inference
❖ Exact Sampling Distributions
❖ Pioneered Analysis of Variance and Design of Experiments.

STATISTICS
● Scientific methods for collecting, organizing, summarizing, presenting, analyzing data as
well as with drawing valid conclusions and making reasonable decisions.
● 2 Major Fields
❖ Applied Statistics - concerned with procedures and techniques in the collection,
presentation, organization, analysis and interpretation of data. To select and
properly implement the most appropriate statistical methods to solve research
problems.
❖ Mathematical Statistics - concerned on development of mathematical foundation
of methods used in applied mathematics. To understand the rationale behind
statistical methods we used in analysis and established new [Link] validate
the usage or modification of current methods.
● Not only collecting numerical data but also developing sound techniques to handle and
analyze those to come up with inferences.

Importance Of Statistics
1. Planning - in order to be successful it must be based soundly on correct analysis of
data.
2. Economics - statistics facilitated the development of economic theory. New disciplines
have been developed such as Economic Statistics and Econometrics.
3. Business - Forecasting and analysis of consumer needs.
4. Industry - For quality control
5. Mathematics - statistical techniques are the outcome of application of advanced
mathematics. Simply,statistics is a branch of mathematics.
6. Biology - whole ‘theory of heredity’ rests on statistical basis.
7. Astronomy - Gaussian ‘Normal Law of Errors’ for the study of movement of stars is
developed by using the Principle of Least Squares.
8. Medical Science - analysis of facts relating to diseases and drugs. The efficacy of
drugs or injection is tested by significance tests.
9. Psychology and Education - Factors Analysis
10. War - ‘Decision Functions’ for maximum destruction with minimum effort.

Limitation of Statistics
1. Not suited for qualitative phenomena - but can be indirectly applied, like by
reducing qualitative information to precise quantitative terms.
2. Not study individuals - because it’s for observation of a particular aggregate
group and comparison.
3. Statistical laws are not exact - only approximation.
4. Liable to be misused - if misused can cause fallacious conclusions.

COLLECTION AND PRESENTATION OF DATA


1. Identify the research objective - questions must be detailed so that it identifies a
group that is to be studied.
Universal - set of all entities under study
Population - totality of observation which we are concerned
Sample - subset of population
Individual - member of a population
2. Collect the information needed to answer the questions - data gathering can be
costly, thus we use only the sample in order to reduce cost, time, limit the scope,
and other considerations.
3. Organize and summarize the information (Descriptive statistics) -describe the
quantitative information in order to provide overview.
Common tools
1. Measures of central tendency
2. Measures of variability.
4. Draw conclusions from the information (Inferential Statistics) - Inferential
statistics is the use of methods to take results obtained from samples.
Common tools
1. Hypothesis Testing
2. Parametric and Non Parametric Test

Variables - characteristics of the individual within the population

Qualitative vs. Quantitative Variables


● Qualitative Variables - yield categorical responses. It is a word or a code that represents
a class or category.
● Quantitative Variables - numerical values representing an amount or quantity.

Discrete Variable and Continuous Variable


● Discrete - finite; countable.
● Continuous - infinite; Not countable.
Dependent and Independent Variables
● Dependent Variables - being tested or measured. This may change according to
independent variables.
● Independent Variables - variables that can be controlled. It is assumed to have a direct
effect on the dependent variable.

MEASUREMENT SCALES
● Measurement is the process of assigning value to a variable.
a. Categorical - Nominal (can be named without order) and Ordinal (Describe
ranking or order)
b. Numerical - Interval (order and difference can be known ; No True Zero) and
Ratio (same properties of interval but has true zero)

DATA COLLECTION
● Process of gathering and measuring information
● Consequences of Improperly collected data - inaccurate results which can mislead future
researchers, inability to validate the study, wasted resources, can cause harm to
subjects, and can compromise public policy decisions.

STEPS IN DATA GATHERING


1. Set the objectives for collecting data.
2. Determine the data needed based on objectives.
3. Determine methods to be used in gathering and define the comprehensive data
collection points.
4. Design the data gathering forms.
5. Collect.
6. Organize, summarize, and consolidate.
7. Analyze using tools and techniques.
8. Compare the result with the standard, target, and customer requirements.
9. Decide what action to take based on the gathered info.

Common questions

Powered by AI

The history of statistics illustrates the evolution of data analysis from basic record-keeping to the development of sophisticated statistical methods. In ancient India, during Chandra Gupta Maurya's reign (324 - 300 B.C.), there was already an efficient system for collecting vital statistics and recording births and deaths, as noted in Kautilya’s Arthshastra. These early practices laid the groundwork for statistical documentation. During Akbar's era, land and agricultural statistics were maintained, showcasing early applied statistics in governance. In the 17th century, John Graunt introduced the study of vital statistics, such as births and deaths, leading to mortality tables and life expectancy calculations. The rise of probability theory with mathematicians like Pascal, Fermat, and Bernoulli further advanced statistical methodologies. In the 19th and 20th centuries, figures like Karl Gauss, Francis Galton, and Ronald Fisher introduced advanced theories such as the Normal Law of Errors, statistical biometry, and innovations in experimental design, correlational analysis, and tests of significance. This evolution reflects the growing complexity and application scope of statistical methods, from simple record-keeping to sophisticated analytical tools used across various fields today .

Data collection and organization are fundamental to ensuring the accuracy and validity of statistical analysis. Proper data collection involves identifying the research objective, determining the necessary data, planning the method of collection, and collecting the data effectively and ethically. Organization of data involves summarizing and presenting the data logically facilitating accurate analysis. Improperly collected data can lead to several pitfalls, including inaccurate results, which can mislead researchers and decision-makers and waste resources. This can lead to incorrect inferences, potentially adversely affecting policy decisions or academic research outcomes. Additionally, improperly organized data can result in misinterpretation and unreliable conclusions. Therefore, meticulous planning and careful execution of data collection and organization processes are critical for achieving dependable results in statistical analysis .

Statistical methods have significantly transformed biology and economics by providing rigorous frameworks for analyzing complex data and drawing meaningful inferences. In biology, the 'theory of heredity' relies on statistical methods to analyze genetic data, allowing for predictions about heredity patterns and evolutionary biology. Statistics enables the testing of hypotheses about biological data, helping establish significant relationships, such as those found in ecological and cellular studies. In economics, statistics facilitated the development of economic theory and gave rise to fields like econometrics, where statistical methods are used to model economic phenomena, forecast trends, and analyze consumer behavior effectively. These methods help validate economic models and lend empirical support to theoretical propositions, thus transforming theoretical concepts into actionable insights. Overall, statistics have provided critical tools for not only validating theories in these disciplines but also for practical decision-making and policy formulation .

Statistical methods contribute significantly to medical science by providing tools for analyzing data related to diseases, treatments, and outcomes, thereby improving research accuracy and reliability. One key contribution is through the application of significance tests, which help determine the efficacy of new drugs or treatments by assessing if observed effects are genuine or due to chance. By employing these methods, researchers can derive important insights about disease causation, treatment effects, and patient outcomes. Additionally, the use of statistical models enables the analysis of complex data sets from clinical trials and observational studies, facilitating the identification of risk factors and the development of predictive models for patient outcomes. These methods enhance the reliability of medical research and result in better-informed clinical decisions, contributing to improved healthcare delivery and patient safety .

The development of probability theory significantly contributed to modern statistics by providing a mathematical framework for quantifying uncertainty and risk. In the mid-17th century, French mathematicians Blaise Pascal and Pierre de Fermat laid the groundwork for probability theory through their solution to the Problem of Points, stimulating interest in the mathematical study of chance and games. Jacob Bernoulli's 'Treatise on the Theory of Probability' and Abraham De Moivre's 'Doctrine of Chances' further formalized these concepts. Pierre Simon Laplace expanded probability theory's applications to astronomy and physics, while Karl Friedrich Gauss applied it to develop the Normal Law of Errors and the method of least squares, pivotal for regression analysis and predicting outcomes. These developments furnished statisticians with tools for inferential statistics, allowing for the derivation of generalizations from sample data, and paved the way for advancements in multiple scientific domains, reinforcing the analytical and predictive capabilities of modern statistics .

SPSS is known for its user-friendly interface, offering both menu-driven and syntax-based options, which makes it particularly accessible for users who require complex statistical analyses such as ANOVA and regression without delving into programming. SPSS's strength lies in its ease of use and broad acceptance in social sciences for robust statistical analysis. In contrast, SAS is more suited for handling large data sets and advanced analytics across finance, healthcare, and education due to its powerful data management capabilities, making it a preferred choice for industries handling massive datasets. STATA is valuable in research and academic settings for its data manipulation and visualization tools, especially in economics and medicine. It is preferred when comprehensive analysis and visualization are required. MINITAB is aimed at quality control and process improvement, particularly useful in manufacturing and industry settings. Each of these tools has strengths tailored to specific needs, where SPSS excels in user-friendliness and general statistical analysis, SAS in handling large data and complex calculations, STATA in academic research applications, and MINITAB in quality and process improvements .

Descriptive statistics and inferential statistics serve different but complementary roles in data analysis. Descriptive statistics involve summarizing and organizing data to provide a clear and concise overview. Common tools of descriptive statistics include measures of central tendency, such as mean and median, and measures of variability, like range and standard deviation. These tools help describe the main features of a data set succinctly. Inferential statistics, on the other hand, involve use of methodological approaches to infer or predict population characteristics based on sample data. This includes hypothesis testing, estimation, and drawing conclusions that extend beyond the immediate data alone. By using descriptive statistics, researchers first encapsulate their data in a manageable form, and then apply inferential statistics to generalize findings or validate hypotheses within a broader context. Together, these two types of statistics enable comprehensive decision-making and understanding of data .

Qualitative variables, also known as categorical variables, yield categorical responses and represent different classes or categories without any inherent order. An example of a qualitative variable is 'marital status,' which can include categories such as single, married, divorced, and widowed. Quantitative variables, on the other hand, represent numerical values that signify an amount or quantity, allowing for the measurement of how much or how many. They can be further divided into discrete and continuous variables. Discrete variables are finite and countable, such as the number of children in a family. Continuous variables are infinite and not countable, such as height or weight, where measurements can take any value within a range. These distinctions are critical in choosing appropriate statistical methods and tools for analysis, as the type of data determines the suitable approaches for analysis and interpretation .

Ronald A. Fisher significantly impacted the field of statistics, often referred to as the Father of Modern Statistics. His major contributions include the introduction of the Analysis of Variance (ANOVA), which allows statisticians to determine if there are any statistically significant differences between the means of three or more independent groups. Fisher also pioneered the design of experiments and developed the concept of maximum likelihood estimation, which provides a method for estimating the parameters of a statistical model. Additionally, he introduced the idea of fiducial inference and made advancements in exact sampling distributions and point estimation, which have become foundational techniques in modern statistics. Fisher's contributions extended the application of statistical methods across genetics, biometry, and agriculture, helping statisticians and scientists to draw more accurate conclusions from experimental data .

The Statistical Analysis System (SAS) and Microsoft Excel differ significantly in their capabilities for handling large and complex data sets. SAS is specifically designed for high-performance analytics and data management tasks, making it suitable for processing and analyzing large-scale data sets in environments such as finance, insurance, and healthcare. It offers robust tools for predictive modeling, advanced statistical analysis, and data management, catering to industries that require comprehensive data handling and manipulation. SAS is equipped to deal with large volumes of data and perform complex statistical computations efficiently. On the other hand, Excel, with its Analysis ToolPak add-in, provides basic statistical functions such as regression and ANOVA, primarily focusing on accessibility and versatility for general use. While widely used for everyday data analysis tasks due to its ease of use and wide availability, Excel is less efficient for handling very large data sets or performing highly complex analyses, where SAS would be more appropriate .

You might also like