Blood Type, Temperature, Multivariate - Lab 1 | GEOG 247, Lab Reports of Geography

Download Blood Type, Temperature, Multivariate - Lab 1 | GEOG 247 and more Lab Reports Geography in PDF only on Docsity! The University of Wisconsin- Milwaukee Geography 247 - Quantitative Analysis in Geography Lab 1 - Fall 2008 1. In an Excel workbook named “geog247lab1” create three different worksheets named “Blood Type”, “Temperature” and “Multivariate” and save it in the “Desktop” of your computer for further use. 2. Enter the following data into the worksheet “Blood Type”. The data should be entered exactly into 5 rows and 5 columns as shown above. After entering the data answer the following questions. • What is the range of your entered data set? (1 point) • What is the cell address of the circled blood types in the above data? (1 point) • Rearrange the data under column “G” in the same worksheet by copy-paste method and name the column as “Blood Type”. (1 point) • Copy all the data from column “G” and paste it in column “H”. By using “AutoFilter” tool to column “H” filter only the blood type “A”. (1 point) • Find out the frequency of each blood type? (1 point) 3. Enter the following data into the worksheet “Temperature”. Enter all the temperature (0F) data into one column and name the column as “Temperature”. Sort the data in descending order and find out the total number of records. (2 points)