Lab $1$: Excel $-$ Analyzing and Reporting Data In this lab, we will use Microsoft Excel to manipulate, transform, and analyze data. Please note that Microsoft Excel MUST be used to complete this lab. If you do not have a copy of Excel, you can find a link on the Software page to the UBC software for students page that will allow you to install this on your own machine $($online version may not support all the functionality required for this lab$).$ This lab is to be completed in a group of two. Objectives Load CSV data into Excel and convert into a spreadsheet for processing. Perform simple data cleaning $($missing$,$ incorrect$)$ values, data type conversion, and cell formatting. Understand and use Excel cell addressing including absolute addresses. Create formulas including string and date functions, aggregate functions, and formulas with decisions. Analysis Problem and Goals This scenario involves analyzing data collected by sensors and applies to a variety of real$-$world applications including environmental monitoring $($temperature$,$ precipitation, wind, etc.$),$ industrial and production sensors$,$ and even monitoring of people using mobile devices and GPS$.$ There are multiple monitoring sites. Each site has one or more sensors that take a reading in a given interval. Typically, readings are either an integer or floating$-$point value. In this lab, each reading will consist of: timestamp $-$ when the reading occurred siteid $-$ an integer identifying a site uniquely sensorid $-$ an integer identifying a sensor at a particular site uniquely value $-$ an integer reading between $0$ and $100,$ although data may be missing or incorrect Sensor readings are done every $15$ minutes but may be missed $($no data$)$ or contain incorrect values out of range $($less than $0$ and above $100)$ or values that indicate error conditions $($not at a number at all$).$ Click here to download the dataset Download Click here to download the dataset that consists of $4$ sites each with $3$ sensors that take readings every $15$ minutes for $2$ days. Ensure that you download the file to your local machine. When working with the data, we want to use Excel and it's functionally to process and manipulate the data $($ie automate using the functionality of Excel, instead of manually processing each element$).$ Ensure you use Excel formulas when answer the questions $($and not just typing in the values directly$).$