# data[].attributes.body
In this capstone project, your team (4 members) will work on environmental data analysis and prediction related to air quality. You will use real-world air quality data to perform data preprocessing, exploratory data analysis (EDA), and to predict air quality conditions.

For the capstone project challenge, the students are to be able to complete the following (On their own)

- Sourcing for a reliable Database

- Able to format and clean the data

- Able to use the excel visualization tools (charts）

- Able to Perform simple Linear Regression via scatterplots

- To do a final presentation to the class

# data[].attributes.body
Download the data set from this link - http://tiny.cc/excel5ra1

# data[].attributes.headline
Please upload your presentation in this section (indicate your group number)

# data[].attributes.subject
Please upload your presentation in this section (indicate your group number)

# data[].attributes.body
Download the data set from this link - https://tiny.cc/excel4a1

# data[].attributes.attachment_link.description
Access Google Forms with a personal Google account or Google Workspace account (for business use).

# data[].attributes.attachment_link.description
Access Google Forms with a personal Google account or Google Workspace account (for business use).

# data[].attributes.body
Download the data set from this link - http://tiny.cc/excel5ra2

# data[].attributes.body
Go to this link to view a picture of the data - http://tiny.cc/excel5a1

# data[].attributes.attachment_link.description
Lesson 5 Activity 1: Importing Data from Picture

# data[].attributes.body
or you can use ipad to take the picture from your workbook

# data[].attributes.body
https://www.canva.com/design/DAGoIRZzGTk/ITfxLUj_PQPWJeWgzqX7sg/edit?utm_content=DAGoIRZzGTk&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

# data[].attributes.attachment_link.description
Login to access and create your next design.

# data[].attributes.body
You can download the data again via this link – https://tiny.cc/excel4a1

# data[].attributes.body
Go to NEA’s official website (http://www.weather.gov.sg/climate-historical-daily/) to collect data.

Using the data you have, filter them. The remaining data will help you predict the weather for the next 30 days.

# data[].attributes.headline
challenge four clustered column Phoebe (27)

# data[].attributes.subject
challenge four clustered column Phoebe (27)

# data[].attributes.body
Fang xuan (28)

# data[].attributes.body
Fang xuan (28)

# data[].attributes.body
Alara (21)

# data[].attributes.body
Step 1: Google PSI Singapore & select the data (https://www.haze.gov.sg/resources/historical-readings)

Step 2: Copy data and do some preprocessing (formatting)

Step 3: Split the data sets into the 5 Sheets (N/S/E/W/C)

Step 4: Use Excel’s charting tools to create visualizations like scatter plots, histograms, and line charts (EDA)

Step 5: Perform simple linear regression via scatterplots

Step 6: Based on the trend, predict the PSI

# data[].attributes.body
Chloe Lyvia Clarissa Emma

https://www.canva.com/design/DAGnSyHdya0/gZtyNhjx55Qso7ghBYquFg/edit?utm_content=DAGnSyHdya0&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

# data[].attributes.body
https://docs.google.com/presentation/d/10zoEWf-4I-1QhPCZ2rG4girM-Sa3sN1NTfeudtrXb6w/edit?usp=drivesdk

# data[].attributes.body
https://www.canva.com/design/DAGnS94-wqQ/0osIMGkcU4iOcT-X1ur8CA/edit?utm_content=DAGnS94-wqQ&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

# data[].attributes.attachment_link.description
Login to access and create your next design.

# data[].attributes.body
https://docs.google.com/presentation/d/1-JILZkUXGsJ7Str5T1y9eqzCI2YM-ncVQx4tCSjDI48/edit?usp=drivesdk

# data[].attributes.body
https://www.canva.com/design/DAGnTH5h1LA/eYmJBq1PWzCtmGy-wYVMug/edit?utm_content=DAGnTH5h1LA&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

# data[].attributes.body
https://www.canva.com/design/DAGnTNoT6ME/_TvJVh1gy0FPXrsAiJjKNw/view?utm_content=DAGnTNoT6ME&utm_campaign=designshare&utm_medium=link2&utm_source=uniquelinks&utlId=h7e7fecbc6f

# data[].attributes.body
https://www.canva.com/design/DAGoIJS18G8/kibFOFHOMA2yRa84OMcvIg/edit?utm_content=DAGoIJS18G8&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

# data[].attributes.attachment_link.title
Blue and White Cute Aesthetic Group Project Presentation