Skip to content

Latest commit

 

History

History
76 lines (64 loc) · 8.1 KB

StatsWithExcel_OI.md

File metadata and controls

76 lines (64 loc) · 8.1 KB
title Applied Statistics
description This is a homepage for MAT240, Applied Statistics, with Dr. Gilbert at Southern New Hampshire University. This course covers an introduction to data, exploratory data analyses and data visualization, one- and two-sample inference via confidence intervals and hypothesis testing for both proportions and means, chi-squared tests for goodness of fit and independence, ANOVA for comparisons of multiple group means, and introduces linear regression. The course also provides an introduction to Excel, the use of which is embedded throughout the semester.
<style> body { font-size: 16px; } table { font-size: 14px; margin-left: auto; margin-right: auto; } th { font-size: 14px; } td { padding: 8px; } </style>

{% include google-analytics.html %}

MAT 240 - Applied Statistics

<script> MathJax = { tex: { inlineMath: [['$', '$'], ['\\(', '\\)']] }, svg: { fontCache: 'global' } }; </script> <script type="text/javascript" id="MathJax-script" async src="https://cdn.jsdelivr.net/npm/mathjax@3/es5/tex-svg.js"> </script>

Syllabus (Spring 2027)

Course Description: This is a fundamental course in the application of statistics. In this course, students learn how to apply statistical techniques to a variety of applications in business and the social sciences. Students learn how to solve statistical problems by hand and through the use of computer software. Topics include probability distribution functions, sampling distributions, estimation, hypothesis testing, and linear regression.

Note to Instructors About Online Homework: I have a freely available online homework shell at MyOpenMath which is available for copy. Contact me for the instructions and required information.

Course Timeline

Below is a tentative timeline for our course. For each meeting day, it includes a description of the topic covered, suggested reading, notes (sometimes), and assignments you are prepared to complete.

Class Meeting Topic Before Class Additional Notes Optional Extra Practice
1 Introduction and What to Expect
Excel Basics
Day 1, Overview
2 Probability and Statistics Terminology
Experimental Design
Ethics in Statistics and Data Analysis
Intro to Data Day 2, Terminology and Background HW 1
3 Excel Fundamentals for Data Analysis Introduction to Spreadsheets Day 3, Unlocking Excel
4 Organizing and Summarizing Data
Summary Statistics and Visualization in Excel
Descriptive Statistics with Spreadsheets Day 4, Summary Statistics and Data Viz HW 2
5 Discrete Probability Discrete Probability and the Binomial Distribution Day 5, Discrete Probability HW 3
6 The Normal Distribution Probability and the Normal Distribution Day 6, Normal Distribution HW 4
7 Probability Workshop Probability Workshop Problems
8 Group Exam I
9 Fundamentals Exam I (No Tech)
10 Applications Exam I
11 The Central Limit Theorem and the Sampling Distribution Foundations for Inference Day 11, CLT and Sampling Distributions HW 5
12 An Overview of Statistical Inference Day 12, Foundations for Inference
13 Inference for a Single Proportion Inference for a Proportion Day 13, Inference for a Single Proportion
14 Inference on One and Two Proportions Practice Inference for Proportions Day 14, Inference with One and Two Proportions HW 6
15 Practice with Inference on Proportions Practice Inference Problems
16 Inference for One and Two Means Inference on Means Day 16, Inference on Means HW 8, HW 9 (1 - 3)
17 Mixed Inference Practice, Part I Mixed Inference Practice A Practice Inference Problems
Exit Ticket
18 Mixed Inference Practice, Part II Mixed Inference Practice B Exit Ticket
19 Mixed Inference Practice, Part III Mixed Inference Practice C Exit Ticket
20 Group Exam II
21 Fundamentals Exam II (No Tech)
22 Applications Exam II
23 Inference with Raw Data Inference with Raw Data
24 ANOVA ANalysis Of VAriance HW 9 (4 - 9)
25 Linear Regression HW 10
26 Review
27 Final Exam, Part A
28 Final Exam, Part B (Optional)

Back to Homepage