Welcome to �MAT240: Applied Statistics

Introduction, Expectations, and Excel Overview

�Syllabus Highlights

Dr. Gilbert

Email: a.gilbert1@snhu.edu

Office: Robert Frost Hall, Room 311

Office Hours:

Wednesdays 9:00am – noon

Fridays 11:00am – 1:00pm

Grade Items and Grading Scheme

​

​

​

​

*Homework graded 50% completion and 50% correctness

�Additional Syllabus Items

• Our textbook is freely available
• Homework due before every class
• Access via the course webpage
• Submit 30 minutes before class, using Google Form from BrightSpace
• Optional Extra Practice at MyOpenMath
• CourseID: 331159�EnrollmentKey: SNHUmat240
• Use of Excel is required
• Access via Office 365
• Log in with SNHU credentials

• Walk-In Tutoring
• Available on the second floor of the library (room 205), no additional cost
• I’ll post a link to the schedule on BrightSpace
• AI Use
• We’ll discuss in class
• Generally limited to help with Excel

�Projects in MAT240

You’ll have a project to complete in MAT240. That project will be broken into three components, and you’ll be able to choose the context and data set you work in. I’ll provide a variety of pre-approved data sets from a variety of contexts.

The components of the project will be:

• Describing and Exploring a Data Set (5pts, tentatively due on Friday, January 31)
• Summarizing and Visualizing Data (10pts, tentatively due on Friday, February 28)
• Statistical Inference (10pts, tentatively due on Friday, April 11)

�Being Successful in MAT240: Expectations

• MAT240 involves math, reading, and writing
• Nearly everything is a word problem
• Take your time and read carefully – working slowly is working quickly
• Identify the difference between productive struggle and frustration
• Take a break and ask for help when you hit frustration
• Don’t expect to get everything done in one sitting
• Attend office hours and tutoring as soon as you become uncertain
• Build these opportunities into your weekly schedule
• You can do this; I will help you! (but I won’t drag you along)

​

�Roadmap of Topics

1. Sampling, Data, and Ethics
• Strategies for Collecting Data
• Organization and Tabular Data
2. Descriptive Statistics
• Summary Statistics for Numerical Data
• Summary Statistics for Categorical Data
• Data Visualization
3. The Probability We’ll Need

4. Inferential Statistics
• Estimating Population Parameters
• Confidence Intervals
• Testing Claims on Population Parameters
• Hypothesis Tests

�Integration of Excel

• Excel is used as a tool for data analysis and calculations throughout this course
• I’ll assume no background in Excel use
• You’ll learn to…
• use Excel for basic arithmetic calculations
• preserve the integrity of your raw data
• use Excel functionality to summarize and analyze data
• conduct an organized analysis using spreadsheets

�A First Look at Excel

Let’s open Excel and poke around

• What is a spreadsheet?
• Manual data entry
• Navigating the Excel ribbon
• Calculating in a cell

Exit Ticket

Navigate to our MAT240 Exit Ticket Form, answer the questions, and complete the task below.

Note. Today’s discussion is listed as 1. Introduction and What to Expect

Task: Tell me one interesting thing about you. Additionally, please share any questions, comments, or concerns you have as we embark on our MAT240 journey together. You should know that I’m looking forward to working with you and getting to know you!

�Next Time…

• What we’ll be doing…
• Probability and Statistics terminology, Experimental Design, and Ethics
• Homework: Complete the Topic 1 – An Introduction to Data interactive prep-work activity and submit the hash code using the Google Form in our Weekly Announcement

​

Optional Extra Practice: Sign up for MyOpenMath and enroll in our course

CourseID: 331159�EnrollmentKey: SNHUmat240

​