{"id":179233,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/fin-anything-over-10-ppm-of-mercury-is-polluted-2"},"modified":"2018-10-24T09:11:44","modified_gmt":"2018-10-24T09:11:44","slug":"fin-anything-over-10-ppm-of-mercury-is-polluted-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/fin-anything-over-10-ppm-of-mercury-is-polluted-2\/","title":{"rendered":"FIN \u2013 Anything over 10 PPM of Mercury is &#038; Polluted"},"content":{"rendered":"<p><a class=\"fin-anything-10-ppm-mercury-polluted\/\"><\/a> <\/p>\n<fieldset>\n 1 Anything over 10 PPM of Mercury is &amp; Polluted<br \/>\n <br \/> Use an IF function to return the answer &amp;quot;Polluted&amp;quot; or &amp;quot;Not Polluted&amp;quot; in column D<br \/>\n <br \/> Lake<br \/>\n <br \/> Superior<br \/>\n <br \/> Huron<br \/>\n <br \/> Michigan<br \/>\n <br \/> Erie<br \/>\n <br \/> Ontario<\/p>\n<p>Mercury PPM<\/p>\n<p>Status<br \/> 9 Not Polluted<br \/> 17 Polluted<br \/> 3 Not Polluted<br \/> 14 Polluted<br \/> 10 Polluted<\/p>\n<p>2 A Q Rating over 50 is Popular. Use a function to return a value of &amp;quot;Popular&amp;quot; or &amp;quot;Not Popular&amp;quot; in Column D.<br \/> (2 pts)<br \/> TV Star<br \/> Jim Belushi<br \/> Tina Fey<br \/> Tyler Perry<br \/> Alec Baldwin<\/p>\n<p>Q Rating<br \/> 31<br \/> 86<br \/> 74<br \/> 49<\/p>\n<p>Popular?<br \/> Not Popular<br \/> Popular<br \/> Popular<br \/> Not Popular<\/p>\n<p>3 Average Temperatures over 70 make the climate &amp;quot;Tropical&amp;quot; and under 70 is &amp;quot;Moderate.&amp;quot; Fill in column D with a function.<br \/> (2 pts)<br \/> Location<br \/> Philadelphia<br \/> LA<br \/> NY<br \/> Minneapolis<br \/> (3 pts)<\/p>\n<p>31<br \/> 32<br \/> 33<br \/> 34<br \/> 35<br \/> 36<br \/> 37<br \/> 38<br \/> 39<br \/> 40<br \/> 41<br \/> 42<br \/> 43<br \/> 44 (3 pts)<br \/> 45<br \/> 46<br \/> 47<br \/> 48<br \/> 49<br \/> 50<br \/> 51<br \/> 52<br \/> 53<br \/> 54 (3 pts)<br \/> 55<br \/> 56<br \/> 57<br \/> 58<br \/> 59<br \/> 60<br \/> 61<br \/> 62<br \/> 63<br \/> 64<br \/> 65<br \/> 66<br \/> 67<br \/> 68 (5 pts)<\/p>\n<p>Avg Temp<br \/> 67<br \/> 78<br \/> 72<br \/> 43<\/p>\n<p>Climate<\/p>\n<p>4 Standard letter grades are assumed to be anything 90 and above is an A, anything in the 80s is B, etc.<br \/> Create a vlookup function to return the appropriate letter grade in Cloumn D.<br \/> Then use the &amp;quot;IF&amp;quot; function to determine pass or fail in column E. (Anything 60 or over is passing.)<br \/> Letter<br \/> Name<br \/> Score<br \/> Grade<br \/> Pass\/Fail<br \/> Bob<br \/> 72<br \/> Sara<br \/> 95<br \/> Chris<br \/> 49<br \/> Tina<br \/> 56<br \/> LaToya<br \/> 88<br \/> Vikram<br \/> 93<br \/> Jose<br \/> 85<br \/> Chantal<br \/> 82<br \/> Joe<br \/> 68<br \/> Rachel<br \/> 90<br \/> 5 As we know, sites may install a lot of tracking programs on our computer. Set up a vlookup function to rate the following sites<br \/> based on a scale where up to 20 trackers are &amp;quot;low,&amp;quot; 21 to 50 are &amp;quot;moderate,&amp;quot; 51 to 70 are &amp;quot;warning&amp;quot; and over 70 are &amp;quot;terrible.&amp;quot;<br \/> Site<\/p>\n<p>Salon.com<br \/> Fox.com<br \/> ESPN.com<br \/> WSJ.com<br \/> Toyota.com<\/p>\n<p># Trackers<\/p>\n<p>Rating<\/p>\n<p>18<br \/> 70<br \/> 58<br \/> 114<br \/> 71<\/p>\n<p>6 Use a vlookup to calculate each person\u2019s school tax bill, based on the assumption that a house assessed at more than $1,000,000 pays<br \/> 20,000\/year; one assessed from $750,000 to 999,999 pays 17,000\/year; one assessed at $500,000 to 749,000 pays $12,000\/year; and<br \/> properties assessed at less than $500,000 pay $7,000 per year.<br \/> Name<br \/> Jones<br \/> Johnson<br \/> Nguyen<br \/> Ramirez<br \/> O\u2019Brien<br \/> Patel<br \/> Cohen<br \/> Wilson<\/p>\n<p>Assessment School Tax<br \/> $565,000<br \/> $250,000<br \/> $1,250,000<br \/> $789,000<br \/> $723,000<br \/> $2,234,000<br \/> $512,000<br \/> $129,000<\/p>\n<p>7 Graph the data from problem 5 so that it looks like the one in the assignments area, and display it below:<\/p>\n<\/fieldset>\n<p><i><\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1 Anything over 10 PPM of Mercury is &amp; Polluted Use an IF function to return the answer &amp;quot;Polluted&amp;quot; or &amp;quot;Not Polluted&amp;quot; in column D Lake Superior Huron Michigan Erie Ontario Mercury PPM Status 9 Not Polluted 17 Polluted 3 <a href=\"https:\/\/www.benedictsol.com\/blogs\/fin-anything-over-10-ppm-of-mercury-is-polluted-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-179233","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/179233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=179233"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/179233\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=179233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=179233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=179233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}