As explained in case 3, bike-e is a fictional San Francisco-based start-up specialising in high-end electric bicycles, featuring great autonomy, an optional safety helmet and double suspension. The Excel file Case 3 Database.xlsx is a database containing fictitious results of 7 variables (V1-V7) obtained from a survey distributed to 68 imaginary students. 1. Compare the following pairs of variables. In each case, build a cross table, if possible, and/or any suitable bidimensional graph(s) to summarize the joint information, and answer the corresponding question: a. Distance (V1) according to Transport (V3). If we consider less than 10 km to be a reasonable distance to travel by electric bike, find the (approximate) proportion of students, both among those walking and among those taking public transport, which live within this distance from their university. (V1-V3) b. Shared high-end bike interest (V5) according to Residence (V2). Analyse the group of students that are not interested in using a shared highend bike among those that normally reside in Barcelona city and among those that live in a nearby town, and do the same with those that are at least somewhat interested. 2. Build the most suitable bidimensional graph to compare the Distance (V1) and the Acceptable monthly fee (V6), and comment on the results you obtain. Does this graph indicate a linear relationship between these two variables? Comment on the degree of that linear relationship by calculating a suitable numerical measure.

Database: https://docs.google.com/spreadsheets/d/18Tq0uCF4-hdxUnpx2aLVFcVe9viC2y4lBfkdg10gjUM/edit?usp=sharing