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 |
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