Courses/Computer Science/CPSC 203/CPSC 203 Template/Labs Template/TA Examples for Spreadsheets/Navneet: Week 1 - Lab 1

Navneet: Week 1 - Lab 1
EXAMPLE. The spreadsheet below contains fish length data for two populations, Aquarium and Coral Reef. Download the spreadsheet and complete the following tasks, as well as answer the following questions:
 * Tasks:
 * Sort the data of the two populations in ascending order
 * Calculate the min, max, count, average, median, mode, and standard deviation of each population
 * Questions:
 * What is the relation between the averages of the two populations?
 * What is the standard deviation of each population?
 * What is the range (min and max) and median of each population, and what is the relation of these values to the standard deviation of the their respective population?
 * What is the mode of each population?
 * How does Excel handle the case when there is more than one solution (hint: look at the ascending order of the data)?
 * Create an example data set with no repeating numbers. When calculating the mode in this scenario what does Excel return?



[[Media: Navneet_-_Spreadsheet_Example_1_-_Fish_Lengths.xls]]