Statistics using Excel, a data type based approach

A practical statistics course for medical students using Excel as the primary analytical tool. The course teaches data analysis through a data-type framework, progressing from categorical to ordered to numerical data. Each type builds upon the previous, adding more sophisticated analytical methods as data properties expand.

The course uses medical datasets throughout, teaching histogram creation, probability distributions, correlation analysis, and hypothesis testing. Students learn to avoid common statistical errors by understanding when each analysis method is appropriate for their data type.

Designed as both a learning course and reference guide, enabling students to return to specific sections for future analysis work.

• 1 Introduction: types of data
• 2 Categorical Data
  • 2.1 Probabilities and distributions
  • 2.2 Multiple variables and joint probabilities
  • 2.3 Testing Categorical Data
• 3 Ordered Data
  • 3.1 Cumulative probabilities
  • 3.2 Models and binary diagnosis
  • 3.3 Conditional probabilities and model evaluation
• 4 Numerical Data
  • 4.1 Numerical data
  • 4.2 Covariance, Correlation, Regression
  • 4.3 Normal Distribution and Testing
• 5 Extra
  • 5.1 Control
  • 5.2 Questions