creating numerical equations to solve questions on excel

User Generated

nyanwqv

Business Finance

Description

Add a macro to extract the highest 25% of the concentration values with the associated date.
Copy that data to columns G and H.
Sort the copied data in date order. Add a button to run the macro.
Write a Visual Basic function to convert coordinates displayed as ddmmss.ss (DegreesMinutesSeconds.SecondFraction)
to decimal degrees dd.dddddd Name the function COOR()

Unformatted Attachment Preview

Add a macro to extract the highest 25% of the concentration values with the associated date. Copy that data to columns G and H. Sort the copied data in date order. Add a button to run the macro. Date Concentration (mcg/l) 1/1/2015 0.374 12/27/2015 13.677 11/2/2015 7.251 4/18/2015 1.237 1/29/2015 0.668 5/10/2015 1.321 12/23/2015 11.365 4/12/2015 1.331 3/9/2015 0.75 9/25/2015 7.001 2/9/2015 0.701 10/11/2015 7.017 2/3/2015 0.478 9/14/2015 6.272 6/2/2015 2.263 5/22/2015 1.986 6/6/2015 2.259 2/15/2015 0.602 4/30/2015 1.594 12/11/2015 15.75 9/5/2015 4.179 11/5/2015 6.593 3/24/2015 1.032 4/28/2015 1.595 1/20/2015 0.476 10/24/2015 9.161 7/17/2015 2.318 11/18/2015 12.514 8/3/2015 3.606 8/17/2015 3.851 1/14/2015 0.495 6/9/2015 2.477 5/20/2015 1.906 8/22/2015 4.568 5/1/2015 1.241 6/24/2015 2.302 7/13/2015 2.575 5/5/2015 1.082 5/16/2015 1.481 7/16/2015 2.223 2/12/2015 0.723 12/2/2015 12.955 6/20/2015 7/12/2015 6/5/2015 9/22/2015 7/8/2015 3/7/2015 7/15/2015 11/24/2015 4/5/2015 9/4/2015 2/23/2015 6/16/2015 1/24/2015 11/4/2015 12/30/2015 8/4/2015 6/17/2015 7/14/2015 6/7/2015 10/23/2015 5/18/2015 6/27/2015 8/10/2015 9/7/2015 4/4/2015 11/27/2015 12/21/2015 5/21/2015 1/8/2015 6/12/2015 2/5/2015 1/4/2015 8/16/2015 4/11/2015 8/28/2015 1/25/2015 6/23/2015 5/15/2015 4/1/2015 11/7/2015 10/22/2015 3/4/2015 5/14/2015 2/24/2015 11/3/2015 3/27/2015 10/9/2015 1.825 2.411 1.666 6.228 3.111 0.909 2.556 13.288 1.241 5.675 0.772 2.125 0.508 9.356 14.475 3.295 2.575 2.46 2.088 7.333 1.312 1.838 4.327 5.726 0.87 8.489 11.488 1.229 0.357 2.297 0.588 0.437 4.4 1.29 4.079 0.539 1.88 1.543 1.143 8.296 5.923 0.901 1.375 0.745 10.125 1.158 5.536 5/25/2015 7/22/2015 12/19/2015 6/8/2015 12/10/2015 12/14/2015 5/31/2015 10/12/2015 3/25/2015 9/18/2015 5/27/2015 3/28/2015 9/9/2015 1/16/2015 9/13/2015 8/12/2015 7/20/2015 4/14/2015 6/19/2015 6/22/2015 10/26/2015 8/7/2015 9/30/2015 1/22/2015 5/2/2015 3/31/2015 2/7/2015 1/2/2015 9/28/2015 8/20/2015 2/21/2015 6/11/2015 1/11/2015 5/3/2015 11/25/2015 4/23/2015 1/17/2015 5/9/2015 12/18/2015 3/8/2015 10/15/2015 2/4/2015 9/29/2015 3/11/2015 11/8/2015 10/31/2015 6/28/2015 1.577 3.35 15.015 1.912 11.851 14.282 2.218 8.644 0.903 4.352 2.131 1.17 4.599 0.352 4.657 2.818 2.388 0.849 1.971 1.749 6.761 3.038 4.753 0.424 1.253 0.836 0.57 0.5 7.064 4.783 0.824 1.971 0.402 1.026 8.59 1.053 0.427 1.199 15.879 0.586 7.304 0.44 6.224 0.665 9.964 9.616 2.815 9/2/2015 12/22/2015 10/27/2015 4/26/2015 8/6/2015 6/1/2015 2/8/2015 6/26/2015 1/31/2015 8/2/2015 7/27/2015 4/10/2015 11/1/2015 4/15/2015 5/26/2015 3/13/2015 2/22/2015 11/29/2015 12/31/2015 1/6/2015 5/7/2015 2/19/2015 8/18/2015 6/4/2015 12/13/2015 8/26/2015 2/1/2015 1/7/2015 10/10/2015 6/14/2015 4/21/2015 1/9/2015 5/19/2015 1/28/2015 4/6/2015 6/29/2015 9/1/2015 10/8/2015 5/4/2015 2/14/2015 3/22/2015 1/23/2015 11/20/2015 3/19/2015 8/8/2015 10/4/2015 12/20/2015 5.099 14.065 6.427 1.116 4.158 2.103 0.517 1.996 0.668 3.57 3.362 0.951 6.335 0.914 1.938 0.781 0.798 13.41 15.39 0.393 1.496 0.725 3.79 2.262 14.462 3.782 0.661 0.504 6.778 1.927 1.426 0.47 1.606 0.463 1.175 2.722 4.819 7.308 1.175 0.721 0.742 0.415 11.49 0.72 3.069 5.266 15.51 12/6/2015 9/11/2015 6/25/2015 8/27/2015 4/27/2015 4/24/2015 12/8/2015 3/16/2015 9/17/2015 4/22/2015 4/19/2015 2/13/2015 10/30/2015 7/1/2015 12/17/2015 6/21/2015 10/21/2015 2/18/2015 10/17/2015 3/30/2015 7/11/2015 10/14/2015 11/30/2015 3/3/2015 8/25/2015 1/21/2015 1/10/2015 2/25/2015 11/17/2015 8/15/2015 3/20/2015 6/15/2015 10/6/2015 5/29/2015 8/19/2015 11/23/2015 10/29/2015 7/25/2015 10/2/2015 7/5/2015 7/26/2015 1/30/2015 3/1/2015 11/21/2015 2/11/2015 2/10/2015 7/7/2015 11.686 4.184 2.906 4.365 1.257 1.313 9.171 1.037 4.712 1.287 1.457 0.73 6.83 2.716 10.369 2.01 6.81 0.588 8.178 1.023 2.251 7.937 9.312 0.911 4.6 0.53 0.387 0.543 9.416 4.259 0.925 2.367 7.164 1.42 4.836 9.209 8.197 2.981 6.413 2.184 3.011 0.405 0.838 8.769 0.639 0.542 2.818 8/23/2015 3/21/2015 8/13/2015 7/10/2015 7/4/2015 11/11/2015 10/1/2015 1/19/2015 2/6/2015 1/12/2015 5/24/2015 3/12/2015 11/26/2015 4/8/2015 7/29/2015 10/3/2015 9/8/2015 4/9/2015 9/20/2015 8/31/2015 12/24/2015 8/30/2015 8/11/2015 9/19/2015 4/3/2015 9/26/2015 11/22/2015 6/10/2015 10/25/2015 4/16/2015 10/20/2015 3/29/2015 12/5/2015 2/16/2015 10/18/2015 1/26/2015 7/24/2015 12/29/2015 2/27/2015 11/12/2015 2/28/2015 11/13/2015 1/13/2015 3/15/2015 11/28/2015 11/14/2015 7/2/2015 3.67 0.779 3.51 2.904 2.608 9.334 4.956 0.593 0.434 0.395 1.393 0.773 8.947 0.986 2.613 7.9 5.291 1.157 6.104 4.43 17.578 4.273 3.255 4.67 0.76 5.156 8.075 2.201 9.647 1.039 9.364 0.892 10.383 0.592 8.261 0.493 3.418 16.594 0.893 9.428 0.649 10.237 0.569 0.922 12.724 9.138 2.12 4/7/2015 7/28/2015 9/12/2015 7/31/2015 3/2/2015 12/9/2015 9/23/2015 3/6/2015 8/5/2015 5/12/2015 12/16/2015 4/2/2015 7/23/2015 3/10/2015 10/13/2015 11/15/2015 7/6/2015 3/14/2015 6/3/2015 11/19/2015 10/16/2015 11/6/2015 9/3/2015 9/24/2015 12/28/2015 2/20/2015 11/9/2015 5/13/2015 9/10/2015 5/8/2015 3/26/2015 5/6/2015 2/17/2015 12/4/2015 1/27/2015 11/16/2015 9/15/2015 8/21/2015 7/19/2015 12/26/2015 10/5/2015 3/23/2015 7/21/2015 5/23/2015 5/11/2015 2/2/2015 5/30/2015 0.871 2.991 5.251 3.666 0.571 15.13 5.719 0.862 4.379 1.685 12.253 0.778 3.461 0.638 8.731 8.501 2.725 0.789 1.633 9.353 6.478 8.657 3.863 7.22 16.802 0.699 9.607 1.815 4.645 1.475 1.17 1.199 0.695 13.217 0.576 11.776 6.599 4.522 3.695 16.103 6.931 0.863 2.261 1.755 1.853 0.459 1.837 10/28/2015 9/16/2015 8/24/2015 4/20/2015 1/15/2015 8/9/2015 6/13/2015 9/27/2015 8/1/2015 3/17/2015 8/29/2015 12/12/2015 12/3/2015 2/26/2015 12/7/2015 7/3/2015 6/18/2015 5/28/2015 11/10/2015 8/14/2015 4/13/2015 1/3/2015 4/29/2015 12/25/2015 9/6/2015 9/21/2015 7/9/2015 1/5/2015 10/7/2015 7/18/2015 1/18/2015 12/15/2015 12/1/2015 10/19/2015 4/25/2015 7/30/2015 5/17/2015 3/18/2015 3/5/2015 4/17/2015 6/30/2015 8.521 5.332 3.707 1.202 0.581 2.826 1.959 4.464 3.787 1.005 3.34 14.636 11.341 0.849 12.106 2.456 2.71 1.538 9.473 4.408 1.26 0.319 1.512 14.856 3.739 5.045 2.073 0.452 5.756 2.634 0.431 13.114 9.406 7.231 1.453 2.722 1.338 1.058 0.588 1.137 2.689 Write a Visual Basic function to convert coordinates displayed as ddmmss.ss (DegreesMinutesSeconds.SecondFraction) to decimal degrees dd.dddddd Name the function COOR() Example: 285612.33 represents 28 degrees, 56 minutes, 12.33 seconds Convert to: 28.936758 Example 2: Convert to: 52608.6 represents 5 degrees, 26 minutes, 8.6 seconds 5.435722 Seconds.SecondFraction) You have a company that sells widgets and you want to encourage large orders. Write a function that takes the selling price and number ordered and returns the total cost of the order using the table below Only apply the discount to numbers that fall within the listed ranges. For example, if 15 widgets that cost $13.25 each are ordered, the first 5 receive no discount and the next five get a 5% discou Widgets Ordered 1-5 6-10 11-15 16+ % Discount 0 5 10 15 nd the next five get a 5% discount and the last 5 get a 10% discount for a cost of $188.81 Write a VBA subroutine that fills the cells from B6 to B20 with the numbers 1 to 15 using a For loop. Write a VBA subroutine that fills the cells from D6 to D20 with the numbers 1 to 15 using a Do While loop. Write a VBA subroutine that fills the cells from F6 to F20 with the numbers 1 to 15 using a Do Until loop. Write a VBA subroutine that fills the cells from H6 to H20 with the numbers 1 to 15 using a Do/Loop Until. Do While loop. Do Until loop. Do/Loop Until. Write a subroutine (named LB_KILO) that takes the two weights in cells B7 and B8 in pounds and converts them to a range of x equally-spaced values in kilograms, where x is the number in cell B9. The conversion is kilograms = pounds / 2.2. This should work with any range of weights and any number of rows. Display both pounds and kilograms in columns G and H beginning in row 8. Add column headings 'Pounds' and 'Kilograms' in row 7. Begin Weight = End Weight = Number of rows = Example: Begin Weight = 10, End Weight = 20, Rows= 5. Pounds 10 12.5 15 17.5 20 Kilograms 4.54545455 5.68181818 6.81818182 7.95454545 9.09090909
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The soluti...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags