Over the years, UNICEF has supported countries in collecting data related to children and women through an international household survey program. The survey responses on sanitation and hygiene from 70 countries in 2015 are constructed into a dataset on handwashing. You can download the CSV file from OA 4.3. Use the dataset to answer the … Read more
For the following exercise, use the data on availability of essential medicines in 38 countries from the World Health Organization (WHO). You can find the dataset in OA 4.4. Download the filtered data as a CSV table and use it to answer the following questions. 1. Between 2007 and 2013, which country had the lowest … Read more
You are given a dataset named boston (OA 5.7). This dataset contains information collected by the US Census Service concerning housing in the area of Boston, Mass. The dataset is small in size, with only 506 cases. The data was originally published by Harrison, D., & Rubinfeld, D.L. (1978). Hedonic prices and the demand for … Read more
For this exercise, you need to work with the breast cancer Coimbra dataset. First download the dataset from OA 5.8 and load the data. The dataset has 10 features including the class labels (1 or 2). Next, you need to round off the Leptin feature values to two decimal places. Having done that, use the … Read more
You are given a data file containing observations for dating (see OA 6.6). Someone who dated 1000 people (!) recorded data about how much that person travels (Miles), plays games (Games), and eats ice cream (Icecream). With this, the decision about that person (Like) is also noted. Use this data to answer the following questions … Read more
answer the following questions using the “world” database, available for download from OA 7.2. Present your SQL queries and/or processes that you used to derive the answers. a. How many countries became independent in the twentieth century? b. How many people in the world are expected to live for 75 years or more? c. List … Read more
For the following exercise, first download the AIS Dynamic Data available from OA 7.4. This data is collected by a Naval Academy receiver and is available from “Heterogeneous integrated dataset for maritime intelligence, surveillance, and reconnaissance.” Using the dataset, answer the following questions: a. How many unique vessels are available in the dataset? b. List … Read more
A popular restaurant review website has released the dataset you can download from OA 8.3. Here each row represents an average rating of a restaurant’s different aspects as provided by previous customers. The dataset contains records for the restaurants usingthe following attributes: ambience, food, service, and overall rating. The first three attributes are predictor variables … Read more
For the next exercise, you are going to use the Airline Costs dataset available to download from OA 8.4. The dataset has the following attributes, among others: i. Airline name ii. Length of flight in miles iii. Speed of plane in miles per hour iv. Daily flight time per plane in hours v. Customers served … Read more
Download data from OA 8.5, which was obtained from BP Research (image analysis by Ronit Katz, University of Oxford). This dataset contains measurements on 48 rock samples from a petroleum reservoir. Here 12 core samples from petroleum reservoirs were sampled in four cross-sections. Each core sample was measured for permeability, and each crosssection has total … Read more
