MG-GY 6193 Statistics for Data Analysts Fall 2024Java

Java Python Department of Technology Management and Innovation

MG-GY 6193 Statistics for Data Analysts Fall 2024

Course Description: The course is an excellent introduction to statistical tools used in any aspect of business. It covers thoroughly key probability concepts and statistical techniques  used in the analysis of financial, economic and accounting data. In addition to descriptive statistics, probability, and hypothesis testing, this course also covers regression analysis and time series analysis with an emphasis on model formulation and interpretation of results. The use of spreadsheets (to facilitate most of the analysis in this class) will be introduced and developed as well through case studies based on real-world data and problems in business and economics, so you will have acquired a working knowledge of spreadsheets after this class. The focus is on understanding underlying concepts rather than on memorizing mathematical formulas while the lectures concentrate on statistical concepts and applications using spreadsheets rather than rigorous math proof for the entire semester.

Course Objectives

Upon completion of this course, you will:

●   Be an intelligent consumer of statistics

●   Be able to analyze data on your own, and reach evidence based conclusions

●   Record and organizedata, write formulas, and do basic calculations using Excel spreadsheets.

●   Calculate and interpret various statistics describing the distribution of variables.

●   Describe the properties of probabilities of independent and dependent random events.

●   Recall key properties of the uniform, normal, and other discrete and continuous distributions

●   Estimate and interpret regression parameters.

●   Use excel spreadsheets for Time Series modeling

●   While we cannot predict the future, we can make our best estimates given the data we know now

Course Structure

●   Lectures

●   In-Class Activities

●   Quizzes

●   Midterms

●   Final

●   Application Project

Readings:

Required Text(s):

The first required book for this course, Essentials of Modern Business Statistics with

Microsoft® Excel® by Camm, et. al., will be delivered to you digitally through the

MindTap platform. The cost of the book and platform is $137.00, which will be added as a “book charge” to your bursar bill.

If you choose to find your course materials elsewhere, you must login here to the student portal and opt out of the program by September 18th. If you do not opt out by this date, you will be charged.

Here is the URL link if you need to cut and paste:

https://includedcp.follett.com/2015

The second required book for this course will be provided on Brightspace, Huff, D. (1954). How to lie with statistics.  W. W. Norton & Co.:  New York.

Attendance - All students’ are responsible for coming to class each day prepared, to read all assigned materials and complete all in-class assignments during class time. Always be ready to discuss the assigned materials and ask questions to clarify any parts of the material that you do not understand.

●   There will be homework assignments after each class. The homework assignments will be done outside of class, and be open book using the MindTap program. The purpose of the homework is to spread out the testing/learning over the course of the semester to ensure students are attending class, keeping up with the reading and grasping the material. Homework must be completed before the next class lecture.

●   Midterm - The Midterm will cover the material discussed during class and in the

assignments readings. The Midterm will be done in Brightspace. It is an open book exam.

●   Final - the final will be cumulative and also done in Brightspace. It is also an open book exam.

●   Application project - students will be given a data set, and asked to do some analysis on the data, and report on it.

Course MG-GY 6193 Statistics for Data Analysts Fall 2024Java Assignments and Grading:

•    MindTap assignments will total 40% of grade

•    Midterm (25%) and Final (25%) will make up the other half of the grade

•    The Application Project will be worth 10% of your final grade

Course Topic Outline

Class Date	Topic	Readings, Assignments, & Exams
9/4/24	Discussion of Syllabus Chapt. 1 Data and Statistics	MindTap Assignment Read   - How to Lie   with Statistics
9/11/24	Chapt. 2 Descriptive Statistics Tabular and Graphical Displays	MindTap Assignment
9/18/24	Chapt. 3 Descriptive Stats - Numerical Measures	MindTap Assignment
9/25/24	Chapt. 4 Introduction to Probability	MindTap Assignment Finish   -   How   to   Lie with statistics complete
10/2/24	Chapt. 5 Discrete Probability Distributions	MindTap Assignment
10/9/24	Chapt. 6 Continuous Probability Distributions	MindTap Assignment
10/16/24	MidTerm	Online
10/23/24	Chapt. 7 Sampling and Sampling Distributions	MindTap Assignment
10/30/24	Chapt