School of Agriculture and Natural Resources

 


AGSC 135
COMPUTER APPLICATIONS IN RESEARCH I

Spring 2002

Instructor:  Dr. Walid Shayya

Homework Assignment #4
Due Date: March 20, 2001


Solve the following two problems using Excel and submit an electronic copy of your completed Excel file to the instructor via e-mail.  Forward your file (as an attachment) to the instructor at the following e-mail address: shayyaw@morrisville.edu.  It is also preferable (although not required) that you make a printout of each of the completed worksheets and submit a copy to the instructor during the class period of the assignment's due date (i.e., March 20, 2001). An Excel workbook file that is comprised of two worksheets (one for problem 1 and the other for problem 2) was forwarded to you via e-mail. Use this Excel file to get started with your assignment (please inform the instructor if, for whatever reason, you did not receive or could not open the Excel file after checking your e-mail account). Please remember to re-name your completed Excel file using your last name and "Ex4" before forwarding it to the instructor via e-mail. If the instructor were to submit the assignment, the Excel file will have the following name: "ShayyaEx4.xls". Please note that you must use cell references and functions (whenever shown in the workbook) to perform calculations.

  1. The following beginning salaries were offered to sixteen agriculture graduates:
    $26,500 $19,900 $31,200 $31,400
    $20,400 $21,400 $21,800 $25,500
    $24,600 $22,600 $24,800 $27,000
    $23,600 $28,400 $23,400 $29,100

    Compute the arithmetic mean, minimum, maximum, range, midrange, median, mode, and standard deviation (the latter using the approaches described in the provided Excel worksheet).

  2. Given the following frequency distribution of the amount of calories in milk with 4% butterfat for a sample of 100 cows:
Calories Frequency
90 up to 100 12
100 up to 110 55
110 up to 120 25
120 up to 130 8

Total

 100
 

[Return][Home] [Web Links of Interest - Dr. Shayya] [Dr. Walid H. Shayya - Education] [NATR 142 Course Outline] [NATR213/213_OS01.htm] [An Introduction to WebCT] [Recent School Photos] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [Dr. Walid H. Shayya] [AGRO105/105_OS01.htm] [Recent School Photos] [School Photos] [School Photos] [AGSC130/130_OF00.htm] [RREN 421 Course Outline] [AGEN 151 Course Outline] [Agsc135/135_OS01.htm] [AGSC 137 Course Outline] [Introduction to ArcView GIS 3.2] [AGSC140/140_OF00.htm] [AGSC 140 Course Outline - Special] [AGSC 135 Course Outline] [Agsc132/132_OF04.htm] [AGEN 135 Course Outline] [AGEN 135 Course Outline] [AGSC 145 Course Outline] [RREN 303 Course Outline] [Recent School Photos] [More School Photos] [RREN 303 Course Outline]
[School Web Site][Ag. Engineering Dept. Web Site][Ag. Science Dept. Web Site]
[Environmental Science Dept. Web Site][MSC Home Page]


Web site developed and maintained by Dr. Walid Shayya, Professor, Morrisville State College.
Last modified on March 28, 2012.