BTC Singapure Excel Questions

User Generated

ouhtencerean

Business Finance

A1 Business and Technical College

Description

Unformatted Attachment Preview

9:17 C4 х Instructions a) This project counts towards 20% of your final grade. b) The total mark of this project is 20. c) You shall produce a report for your findings to the questions below. Describe the key steps to make your working easy to follow, d) This is an individual project. You must work independently. e) You may use computational tools, eg. MATLAB and Microsoft Excel, to perform calculations and analyses. Tabulated raw data should be included in an appendix. g) Submit the softcopy on h) Late submissions will not be marked. 1) Hand-written reports will not be accepted. ) The project requires knowledges throughout the course. k) You are welcome to read beyond the course materials, but it is not necessary. D) You may start your project now. Task Singapore has a tropical climate, experiencing alternating scasons of monsoons (heavy rainfalls) and inter-monsoons (light rainfalls). In this project, you shall analyse the rainfall data for the first six months of 2019 and complete the following tasks. 1. Assuming the daily rainfall is a random variable, determine, separately for each month, () the mean daily rainfall with 95% confidence interval and (ii) the 95% prediction intervals of daily rainfall. The rainfall data can be access at: www.weather.gov.sg/climate-historical-daily. You may choose any observation station to perform your analysis. [10 marks] CH2010 Engineering Statisties AY 2019 2020 2. By formulating a suitable hypothesis test, to the nearest month, determine which months belong to monsoon and which ones fall under inter-monsoon. How conclusive are your answers? (5 marks) 3. Determine the correlation coefficient between daily mean temperature and daily total rainfall with 95% level of confidence. Comment on your results. The temperature data can be accessed at: www.weather.gov.sg/climate-historical-daily. Make sure the temperature data and rainfall data come from the same observation station. (5 marks)
Purchase answer to see full attachment
Explanation & Answer:
3 Questions
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Station
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi

Year

Month
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2

Moonsoon/inter_monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons

Day
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi

2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019

2
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
4
4
4

Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Monsoons
Monsoons
Monsoons

16
17
18
19
20
21
22
23
24
25
26
27
28
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3

Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi

2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019

4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5

Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons

4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi
Changi

2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019
2019

5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6

Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Inter_Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons
Monsoons

21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Daily Rainfall Total (mm)

Highest 30 Min Rainfall (mm)
0
0
0
0
0
0
0
0.6
0
0
5.8
0
0
0
0
0
16.2
38.2
0
0
1.4
0
0.2
0
0.4
0
0
0.6
0.2
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
0
0

Highest 60 Min Rainfall (mm)
0
0
0
0
0
0
0
0.6
0
0
3.2
0
0
0
0
0
8.8
7.8
0
0
1.4
0
0.2
0
0.4
0
0
0.4
0.2
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0.6
0
0
3.2
0
0
0
0
0
9.4
13.4
0
0
1.4
0
0.2
0
0.4
0
0
0.4
0.2
0
0
0
0.4
0
0
0
0
0
0
0
0
0
0
0
0
0

0
9.2
8.6
13.4
0
0
0
0
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
25.8
1.2
0
0
0
0
0
0
0
0
8.8
0
0
0
6.6
0.8
0
29
0
0
0
26
0
31

0
4.4
6
11.6
0
0
0
0
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
18.4
1
0
0
0
0
0
0
0
0
8.6
0
0
0
3
0.8
0
25.8
0
0
0
8.8
0
12

0
5
7.4
13.4
0
0
0
0
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
25.2
1
0
0
0
0
0
0
0
0
8.8
0
0
0
5
0.8
0
28.8
0
0
0
14.2
0
22.6

0
0
0
0
0
0
6
31.2
0
0
0
0.2
0
0
0
0
21.2
0
0
0
0
0
52.4
6.2
0.6
0
0
0
3.8
0
0.2
3.2
0
0
15.4
0
5.6
11
0
0
0.2
0.8
0
17.2
0
0.2
0

0
0
0
0
0
0
5.6
29.4
0
0
0
0.2
0
0
0
0
16
0
0
0
0
0
19.4
1.8
0.6
0
0
0
3.8
0
0.2
3.2
0
0
7.4
0
4
10.8
0
0
0.2
0.8
0
0.6
0
0.2
0

0
0
0
0
0
0
6
30.6
0
0
0
0.2
0
0
0
0
19
0
0
0
0
0
32
3
0.6
0
0
0
3.8
0
0.2
3.2
0
0
7.4
0
4
11
0
0
0.2
0.8
0
1
0
0.2
0

6
0
0
0
0
0
0
0
0
5
0.4
0
13.6
37.6
0
0
4
10.6
0.6
0.2
0
0
18.2
2.8
5
0
0
0
9.8
1.4
4.4
28
18.6
0
0.6
0
0
0
0
18.4
0

6
0
0
0
0
0
0
0
0
1.8
0.4
0
10.4
15.2
0
0
1
6
0.2
0.4
0
0
10.4
0.8
4
0
0
0
4.6
1.2
2.6
21.2
8.8
0
0.6
0
0
0
0
15.2
0

6
0
0
0
0
0
0
0
0
3.4
0.4
0
12.2
18.6
0
0
1.6
8.2
0.4
0.4
0
0
13.2
1.4
4.4
0
0
0
5
1.2
3.6
27.4
16.4
0
0.6
0
0
0
0
16.2
0

Highest 120 Min Rainfall (mm)

Daily Rainfall Total (mm)
0
0
0
0
0
0
0
0.6
0
0
3.4
0
0
0
0
0
9.4
23
0
0
1.4
0
0.2
0
0.4
0
0
0.4
0.2
0
0
0
0.4
0
0
0
0
0
0
0
0
0
0
0
0
0

Mean Temperature (°C)
0
0
0
0
0
0
0
0.6
0
0
5.8
0
0
0
0
0
16.2
38.2
0
0
1.4
0
0.2
0
0.4
0
0
0.6
0.2
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
0
0

28.2
29.1
29.6
29.7
28
28.6
28.9
28.2
28.5
28.6
27.9
28.1
28
27.9
28.3
28.1
26.9
25.8
27.2
28.1
27.8
27.6
28
27.6
27.2
27.4
27.9
26.8
27.8
27.8
27.6
28.1
28.2
28.4
28.7
28.2
27.7
28.1
28.7
28.8
28.5
27.7
28.3
28.8
28.5
27.9

0
7
7.6
13.4
0
0
0
0
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
25.8
1
0
0
0
0
0
0
0
0
8.8
0
0
0
6.6
0.8
0
29
0
0
0
21
0
27.4

0
9.2
8.6
13.4
0
0
0
0
0
0
0
0.2
0
0
0
0
0
0
0
0
0
0
0
25.8
1.2
0
0
0
0
0
0
0
0
8.8
0
0
0
6.6
0.8
0
29
0
0
0
26
0
31

28.2
27.2
26.8
28
28.2
28.6
28.6
28.3
28
28.6
28.7
28
28.3
28.5
28.4
27.9
28.1
28.8
28.5
29.4
29.3
29.2
29.2
27.4
28.2
28.9
28.9
28.8
28.7
28.8
28.7
28.9
29.3
28
28.7
29.3
29
28.6
29.6
30
27.9
28.8
27.6
28.4
27.2
28.1
26.7

0
0
0
0
0
0
6
30.6
0
0
0
0.2
0
0
0
0
19.2
0
0
0
0
0
45
3.8
0.6
0
0
0
3.8
0
0.2
3.2
0
0
9.8
0
4
11
0
0
0.2
0.8
0
1.4
0
0.2
0

0
0
0
0
0
0
6
31.2
0
0
0
0.2
0
0
0
0
21.2
0
0
0
0
0
52.4
6.2
0.6
0
0
0
3.8
0
0.2
3.2
0
0
15.4
0
5.6
11
0
0
0.2
0.8
0
17.2
0
0.2
0

28.5
28.9
28.6
28.8
29
29.3
28.2
27.4
28.5
29.2
28.8
29.1
29.9
30.1
30
29
27.7
29.7
29.2
28.7
28.9
29.2
26.3
27.6
29.1
29.5
28.2
29.4
28.9
29.4
29.2
29
30.7
30.3
27.4
30
29.5
28.7
29.6
29.4
29.5
29.5
29.2
28.3
29.1
28.2
29

6
0
0
0
0
0
0
0
0
4
0.4
0
13
28.6
0
0
2.6
9
0.4
0.4
0
0
14.6
2
4.4
0
0
0
5.4
1.2
4
28
17.4
0
0.6
0
0
0
0
16.8
0

6
0
0
0
0
0
0
0
0
5
0.4
0
13.6
37.6
0
0
4
10.6
0.6
0.2
0
0
18.2
2.8
5
0
0
0
9.8
1.4
4.4
28
18.6
0
0.6
0
0
0
0
18.4
0

28.4
28.4
29.6
30.1
29.5
29.9
29.7
30.1
29.9
28.2
29
28.3
28.6
26.9
28.3
29.4
27.1
26.1
27.4
28.9
30
29.9
27.2
28.7
28.9
28.7
29.3
29.2
27.1
27.9
28.6
27.8
26.8
28.6
28.9
29.5
28.3
29.2
29.6
28.6
28.8

Maximum Temperature (°C)

Minimum Temperature (°C)
33.4
33
32.9
33.4
31.9
31.9
32.6
31.5
32.2
32.3
32.1
32.2
32.4
31.6
32.2
32.3
32.6
28.4
31.1
32.2
31.9
31
31.4
31.1
30.2
30.4
31.3
28.4
31.8
31.6
31.6
32
32.4
32.9
33
32.4
32.3
33
33.8
34.1
32.9
32
33.3
32.9
33.6
32.9

Mean Wind Speed (km/h)
25.1
25.4
26.2
27
26.5
26.4
26.3
26
26.1
26
24.7
25
25.5
25.7
25.6
25.8
23.8
23.5
24.6
25.3
25.9
25.6
25.6
25.8
25
25.6
25.7
25.8
26
25.7
25.2
25.6
25.9
26.4
25.8
25.6
24.7
24.8
25.8
25.8
26
24.7
24.6
26.5
26.1
26

6.5
9
13
8.6
7.9
13
15.5
12.2
13.3
13
11.5
10.8
10.4
9.7
9
9.4
7.9
8.6
9.4
11.2
10.1
10.8
14.4
14.8
12.2
13.3
13.3
10.4
13.7
13.3
10.4
14
12.6
13.7
12.2
11.5
12.2
11.9
11.9
10.8
14
13.3
10.8
14.8
16.2
13

33.3
33.2
30.5
32.4
32.2
32.7
33.5
32.7
32.7
33.6
32.5
32.1
32.6
32.7
33
33
33.8
34.2
32.1
34.2
34.3
34
34.7
33
34.8
33...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags