Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Business Mathematics With Canadian Applications

Authors: Ali R. Hassanlou, S. A. Hummelbrunner, Kelly Halliday

12th Edition

0135285011, 978-0135285015

More Books

Students also viewed these Mathematics questions

Question

What is a manufacturing system?

Answered: 1 week ago