Select from donationformlist order by zipcode to create the...

SELECT * FROM Donation_Form_List ORDER BY zip_code; To create the Postcard_List, you will need to calculate the distance between each city and Rock Springs using the Haversine formula. Once you have the distances, you can then separate the data into the Postcard_List based on the calculated distances. After aligning and separating the data, you can then proceed with coordinating donation efforts and outreach campaigns based on the specific needs and locations of the people in your database. This will ensure that your efforts are targeted and effective in addressing food justice issues in Wyoming.

Transcript

00:01 Right, so the table below lists the area in square miles of all 23 counties in wyoming, and i put them into a spreadsheet for us to more easily do the calculations we're asked to do.

00:13 And we need to find the median, the interquotile range, and the mean, and we're going to round everything to the nearest square mile.

00:25 And consider the dad to be the full population, and that's going to be important for the standard deviation.

00:30 So i ordered the data because that's going to put the median.

00:36 I ordered them from the smallest to largest, and i got 4 ,08 is the median.

00:42 And for the inner quartile range, we need to take the difference of q3, the third quartile and earth quartile.

00:54 Let's say we calculate that.

00:59 And so we need to find basically the median of the.

01:09 Lower half and the median of the upper half.

01:12 And so here we have the, there's 11 above and below the mean because there's 11 here.

01:21 We have to account for the median, which is one, and then 11 below it.

01:25 And the reason that's useful is because then there's an exact middle value here for the lower median and the upper, upper values, because then the first quartile is the median of the lower half.

01:43 That's 2398.

01:45 And then the third quartile, which is the median of the upper half, is 4 ,882.

01:57 And the inter quartile range is the difference of those.

02:04 There's that.

02:04 There's also a way you can calculate it as like the exact position.

02:10 And that's if you use the quartile function for the data.

02:19 And you want to say the first quartile, it will give you, slightly different value than what we got.

02:32 Third quartile, third core tile...