Morrisville State College

Dr. Walid H. Shayya
School of Agriculture and Natural Resouces

Course Outline for AGSC 137

Agricultural Statistics


Spring 2017

Blackboard Access of Course Material On-line (for students enrolled in the course)


Dr. Walid H. Shayya

Instructor Contact Information


AGSC 137 involves the application of procedures and techniques for collecting, analyzing, and interpreting agricultural data. The course encompasses an introduction to statistical methods using examples and applications to which students can easily relate.  The course also focuses on teaching students basic statistical analysis using the MS Excel spreadsheet program and other pertinent computer tools.  Students enrolled in AGSC 137, which is part of the laptop curriculum, will be introduced to these important concepts through lectures and exercises that they may complete on their laptops.  Emphasis will be placed on providing the student with problem-solving skills and the ability to interpret the results of basic agricultural statistical analysis.  Following a brief introduction to statistics and statistical inference, students enrolled in AGSC 137 are introduced to common measures of central tendency and dispersion used in summarizing agricultural data followed by an introduction to the main concepts of probability and probability distributions and their potential applications in agricultural sciences.  Additional topics to be covered include correlation analysis and linear regression (simple and multiple).

2 credits* (3 lecture hours, first 10 weeks), spring semester


At the successful completion of AGSC 137, the student is expected to have developed the skill to:

  1. Analyze and evaluate problems that involve descriptive statistics, probability distributions, correlation analysis, and linear regression as related to agricultural science.

  2. Understand the types of problems in agriculture that can be analyzed statistically.

  3. Utilize statistical concepts to interpret agricultural data.

  4. Use MS Excel effectively to analyze data and solve problems.


The instructor has the following designated office hours per week:

If necessary, students are also encouraged to make appointments to see the instructor at other times.


AGSC 137 is a two-credit hour course.  It includes three contact hours per week for 10 weeks.  One section of the course is offered during the 2017 Spring semester.  The schedule of the offered section is as follows:


Caldwell, S. 2013. Statistics Unplugged. Wadsworth, Belmont, California (ISBN: 978-0-8400-2943-0).

Shayya, W.H. 2014. Using MS Excel 2013 to Analyze Data: An Introductory Tutorial (on-line tutorial). 

Shayya, W.H. 2011. Using MS Excel 2010 to Analyze Data: An Introductory Tutorial (on-line tutorial). 

Shayya, W.H. 2008. Using MS Excel 2007 to Analyze Data: An Introductory Tutorial (on-line tutorial).

Shayya, W.H. 2003. Using MS Excel 2003 to Analyze Data: An Introductory Tutorial (on-line tutorial). 


Any student who feels s/he may need an accommodation based on the impact of a disability should contact the Disability Services (DS) office immediately to register for services and receive a Notification of Disabilities form. Once you have this form, we will meet privately, to discuss your specific needs.   Although you may register for services at any time, please attempt to make arrangements within the first two weeks of the semester so all appropriate academic accommodations can be set. 



Evaluation is a shared responsibility between the teacher and the student. The purpose of the evaluation is to demonstrate how well the professor has taught and the student has learned specific course materials, the principles, concepts, and terms relevant to the covered topics.  Evaluation is also intended to assess the student's ability to utlize the acquired knowledge and how s/he can use this knowledge in problem-solving.

The breakdown of grading in this course will be as follows:

The distribution of grades in this course will be based on the A-F College grading scheme. The letter grades correspond to the following percentage scale: A (90-100%), A- (87-89.9%), B+ (83-86.9%), B (80-82.9%), B- (77-79.9%), C+ (73-76.9%), C (70-72.9%), C- (67-69.9%), D+ (63-66.9%), D (60-62.9%), and F (<60%).




Lecture Topic*

Textbook/On-line Resources Homework Assignment
1 (1) Jan. 16 - Introduction to AGSC137    
2 (1) Jan. 18 - Introduction to agricultural statistics
- Variables and summation
Chapter 1 #1, Problem Set on Summations
3 (2) Jan. 23 - Different forms of presenting data Chapter 2  
4 (2) Jan. 25 - Measuring central tendency of ungrouped data
- Measures of dispersion of ungrouped data
Chapter 2 #2, Problem Set on Summarizing Data 
5 (3) Jan. 30 - Data properties of importance Chapter 2  
6 (3) Feb. 1 - Introduction to MS Excel Handout #3, Excel On-line Introductory Tutorial
7 (4) Feb. 6 - Introduction to summarizing data using MS Excel
- Hands-on exercise 1 on summarizing ungrouped data
- Hands-on exercise 2 on summarizing ungrouped data
On-Line Handout on Common Excel Functions  
8 (4) Feb. 8 - Measuring central tendency of grouped data using MS Excel Handouts #4, Problem Set on Summarizing Data Using MS Excel 
9 (5) Feb. 13 - Measures of dispersion of grouped data using MS Excel Handouts  
10 (5) Feb. 15 - Sample exercise on analyzing data using MS Excel Handouts #5, Problem Set on Summarizing Grouped Data Using MS Excel 
11 (6) Feb. 20 - Finalize discussion on summarizing data
- First exam study guide

12 (6) Feb. 22

Progress Examination 1

13 (7) Feb. 27 - First exam review
- Data sets and set operations

14 (7) Mar. 1 - Probability
- Rules of probability

Sample problems
#6, Problem Set on Probability
Week 8 - Spring Break (No classes)
15 (9) March 13 - Probability distributions Chapters 3 and 4
Sample Problems
16 (9) March 15 - Probability distribution functions in MS Excel Handouts #7, Problem Set on Probability Distributions
17 (10) March 20 - Correlation analysis
- Simple linear regression
Chapter 12  
18 (10) March 22 - Using MS Excel to solve correlation and linear regression problems On-line Handout on Correlation and Regression Analysis Using Excel
19 (11) March 27 - Multiple linear regression
- Using MS Excel to solve multiple linear regression problems
Handouts #8, Problem Set on Correlation Analysis and Linear Regression
20 (11) March 29 - Finalize discussion of linear regression
- Final exam study guide
(12) April 3 Final Examination (comprehensive)

*The topics listed in the table above are tentative and may be subject to change during the semester.