Answered step by step
Verified Expert Solution
Question
1 Approved Answer
GRIMM Wind, Rain and TSP data Jan 1 2022 to March 31 2022. DATUM/Zeit MOHAWK W.Speed m/s MOHAWK Rain Vol l/m2 MOHAWK TSP ug/m3 1-1-22
GRIMM Wind, Rain and TSP data Jan 1 2022 to March 31 2022. DATUM/Zeit MOHAWK W.Speed m/s MOHAWK Rain Vol l/m2 MOHAWK TSP ug/m3 1-1-22 0:00 2.15203 0 48.0736 2-1-22 0:00 2.52082 0 17.1024 3-1-22 0:00 1.27649 0 14.8826 4-1-22 0:00 2.56906 0 9.6128 5-1-22 0:00 3.53281 0.0133333 12.5722 6-1-22 0:00 2.63903 0 16.7486 7-1-22 0:00 1.37396 0 13.1531 8-1-22 0:00 1.54219 0.000416667 9.22153 9-1-22 0:00 2.68579 0.00333333 8.48229 10-1-22 0:00 1.94329 0.00125 30.3333 11-1-22 0:00 1.73507 0 19.5326 12-1-22 0:00 2.53594 0 16.4847 13-1-22 0:00 0.781684 0 24.3403 14-1-22 0:00 3.43628 0 22.376 15-1-22 0:00 2.61608 0 34.9288 16-1-22 0:00 0.786165 0 34.7348 17-1-22 0:00 2.79982 0.129167 9.88213 18-1-22 0:00 1.29179 0 6.72048 19-1-22 0:00 3.2865 0 16.9121 20-1-22 0:00 2.00626 0 12.7528 21-1-22 0:00 1.02604 0 32.5792 22-1-22 0:00 2.6101 0.00208333 45.33 23-1-22 0:00 1.68221 0 15.191 24-1-22 0:00 1.507 0.000416667 30.7976 25-1-22 0:00 1.12885 0 11.7458 26-1-22 0:00 1.2093 0 15.6892 27-1-22 0:00 2.99388 0 23.6747 28-1-22 0:00 2.62608 0 31.7528 29-1-22 0:00 1.60091 0 19.5403 30-1-22 0:00 1.4308 0 13.6326 31-1-22 0:00 1.1253 0 28.8469 1-2-22 0:00 2.29498 0.000416667 21.3149 2-2-22 0:00 2.02015 0.0141667 8.31875 3-2-22 0:00 3.63221 0.005 8.2365 4-2-22 0:00 2.11826 0.00125 37.45 5-2-22 0:00 1.20646 0 8.4868 6-2-22 0:00 2.54755 0 11.8219 7-2-22 0:00 1.92154 0 14.7675 8-2-22 0:00 1.49694 0 11.0156 9-2-22 0:00 2.58701 0 11.6694 10-2-22 0:00 2.38819 0 8.62778 11-2-22 0:00 3.21872 0.101667 7.24514 12-2-22 0:00 2.1621 0 5.25868 13-2-22 0:00 1.17621 0 15.3986 14-2-22 0:00 1.12999 0 24.9858 15-2-22 0:00 1.74272 0 17.7743 16-2-22 0:00 2.70785 0 17.9424 17-2-22 0:00 2.57129 0.236667 15.3628 18-2-22 0:00 2.604 0.00208333 3.2365 19-2-22 0:00 2.89915 0.00375 32.336 22-2-22 0:00 1.57947 0.0116667 22.5694 23-2-22 0:00 2.19364 0 0.00347222 25-2-22 0:00 1.99449 0.0141667 41.23 26-2-22 0:00 2.88863 0 8.48577 27-2-22 0:00 2.88704 0 9.4875 28-2-22 0:00 1.40001 0 14.3934 1-3-22 0:00 1.62792 0 14.184 2-3-22 0:00 1.57225 0 8.64202 3-3-22 0:00 2.00046 0 18.9868 4-3-22 0:00 1.93555 0 11.8274 5-3-22 0:00 1.03431 0 17.046 6-3-22 0:00 3.22096 0.0866667 8.97153 7-3-22 0:00 1.41938 0.00916667 2.49271 18-3-22 0:00 1.16095 0 34.7532 19-3-22 0:00 2.25025 0 32.2483 20-3-22 0:00 1.5568 0 1.2809 21-3-22 0:00 1.1648 0 4.2559 22-3-22 0:00 1.26606 0 22.3032 23-3-22 0:00 1.81019 0.487917 7.74516 24-3-22 0:00 2.61671 0 9.77882 25-3-22 0:00 2.14196 0 4.43664 26-3-22 0:00 1.91472 0 4.58757 27-3-22 0:00 2.2104 0 7.256 28-3-22 0:00 2.19665 0.00125 11.236 29-3-22 0:00 1.19317 0 6.77262 30-3-22 0:00 0.980136 0.00541667 11.0471 31-3-22 0:00 3.30674 0 8.7756
GRIMM Wind, Rain and TSP data Jan 1 2022 to March 31 2022. | |||
DATUM/Zeit | MOHAWK W.Speed m/s | MOHAWK Rain Vol l/m2 | MOHAWK TSP ug/m3 |
1-1-22 0:00 | 2.15203 | 0 | 48.0736 |
2-1-22 0:00 | 2.52082 | 0 | 17.1024 |
3-1-22 0:00 | 1.27649 | 0 | 14.8826 |
4-1-22 0:00 | 2.56906 | 0 | 9.6128 |
5-1-22 0:00 | 3.53281 | 0.0133333 | 12.5722 |
6-1-22 0:00 | 2.63903 | 0 | 16.7486 |
7-1-22 0:00 | 1.37396 | 0 | 13.1531 |
8-1-22 0:00 | 1.54219 | 0.000416667 | 9.22153 |
9-1-22 0:00 | 2.68579 | 0.00333333 | 8.48229 |
10-1-22 0:00 | 1.94329 | 0.00125 | 30.3333 |
11-1-22 0:00 | 1.73507 | 0 | 19.5326 |
12-1-22 0:00 | 2.53594 | 0 | 16.4847 |
13-1-22 0:00 | 0.781684 | 0 | 24.3403 |
14-1-22 0:00 | 3.43628 | 0 | 22.376 |
15-1-22 0:00 | 2.61608 | 0 | 34.9288 |
16-1-22 0:00 | 0.786165 | 0 | 34.7348 |
17-1-22 0:00 | 2.79982 | 0.129167 | 9.88213 |
18-1-22 0:00 | 1.29179 | 0 | 6.72048 |
19-1-22 0:00 | 3.2865 | 0 | 16.9121 |
20-1-22 0:00 | 2.00626 | 0 | 12.7528 |
21-1-22 0:00 | 1.02604 | 0 | 32.5792 |
22-1-22 0:00 | 2.6101 | 0.00208333 | 45.33 |
23-1-22 0:00 | 1.68221 | 0 | 15.191 |
24-1-22 0:00 | 1.507 | 0.000416667 | 30.7976 |
25-1-22 0:00 | 1.12885 | 0 | 11.7458 |
26-1-22 0:00 | 1.2093 | 0 | 15.6892 |
27-1-22 0:00 | 2.99388 | 0 | 23.6747 |
28-1-22 0:00 | 2.62608 | 0 | 31.7528 |
29-1-22 0:00 | 1.60091 | 0 | 19.5403 |
30-1-22 0:00 | 1.4308 | 0 | 13.6326 |
31-1-22 0:00 | 1.1253 | 0 | 28.8469 |
1-2-22 0:00 | 2.29498 | 0.000416667 | 21.3149 |
2-2-22 0:00 | 2.02015 | 0.0141667 | 8.31875 |
3-2-22 0:00 | 3.63221 | 0.005 | 8.2365 |
4-2-22 0:00 | 2.11826 | 0.00125 | 37.45 |
5-2-22 0:00 | 1.20646 | 0 | 8.4868 |
6-2-22 0:00 | 2.54755 | 0 | 11.8219 |
7-2-22 0:00 | 1.92154 | 0 | 14.7675 |
8-2-22 0:00 | 1.49694 | 0 | 11.0156 |
9-2-22 0:00 | 2.58701 | 0 | 11.6694 |
10-2-22 0:00 | 2.38819 | 0 | 8.62778 |
11-2-22 0:00 | 3.21872 | 0.101667 | 7.24514 |
12-2-22 0:00 | 2.1621 | 0 | 5.25868 |
13-2-22 0:00 | 1.17621 | 0 | 15.3986 |
14-2-22 0:00 | 1.12999 | 0 | 24.9858 |
15-2-22 0:00 | 1.74272 | 0 | 17.7743 |
16-2-22 0:00 | 2.70785 | 0 | 17.9424 |
17-2-22 0:00 | 2.57129 | 0.236667 | 15.3628 |
18-2-22 0:00 | 2.604 | 0.00208333 | 3.2365 |
19-2-22 0:00 | 2.89915 | 0.00375 | 32.336 |
22-2-22 0:00 | 1.57947 | 0.0116667 | 22.5694 |
23-2-22 0:00 | 2.19364 | 0 | 0.00347222 |
25-2-22 0:00 | 1.99449 | 0.0141667 | 41.23 |
26-2-22 0:00 | 2.88863 | 0 | 8.48577 |
27-2-22 0:00 | 2.88704 | 0 | 9.4875 |
28-2-22 0:00 | 1.40001 | 0 | 14.3934 |
1-3-22 0:00 | 1.62792 | 0 | 14.184 |
2-3-22 0:00 | 1.57225 | 0 | 8.64202 |
3-3-22 0:00 | 2.00046 | 0 | 18.9868 |
4-3-22 0:00 | 1.93555 | 0 | 11.8274 |
5-3-22 0:00 | 1.03431 | 0 | 17.046 |
6-3-22 0:00 | 3.22096 | 0.0866667 | 8.97153 |
7-3-22 0:00 | 1.41938 | 0.00916667 | 2.49271 |
18-3-22 0:00 | 1.16095 | 0 | 34.7532 |
19-3-22 0:00 | 2.25025 | 0 | 32.2483 |
20-3-22 0:00 | 1.5568 | 0 | 1.2809 |
21-3-22 0:00 | 1.1648 | 0 | 4.2559 |
22-3-22 0:00 | 1.26606 | 0 | 22.3032 |
23-3-22 0:00 | 1.81019 | 0.487917 | 7.74516 |
24-3-22 0:00 | 2.61671 | 0 | 9.77882 |
25-3-22 0:00 | 2.14196 | 0 | 4.43664 |
26-3-22 0:00 | 1.91472 | 0 | 4.58757 |
27-3-22 0:00 | 2.2104 | 0 | 7.256 |
28-3-22 0:00 | 2.19665 | 0.00125 | 11.236 |
29-3-22 0:00 | 1.19317 | 0 | 6.77262 |
30-3-22 0:00 | 0.980136 | 0.00541667 | 11.0471 |
31-3-22 0:00 | 3.30674 | 0 | 8.7756 |
Convert the TSP value to a rounded , whole number using the ROUND function and be sure to save this as a value, not a formula. For this data set, calculate the mean, median, mode, sample & population variance and standard deviation.
Generate a histogram (bar) graph here that depicts the frequencey of adjusted TSP values in intervals of 5 ug/m3
Generate a Normal Distribution Curve here based on the adjusted TSP concentrations converted to whole numbers.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started