The unit price varies depending on the specified quantity, and your goal is to write a formula in cell B9 that calculates the total price for any amount of items input in a specific cell (in this case, cell B8) 1 Unit Quantity 2 1 to 10 3 11 to 19 4 20 to 49 5 50 to 100 6 Over 100 7 8 Quantity 9 Total Cost Price Per Unit 20.00 28.00 16.00 13.00 12.00 Write a nested IF function based on the above criteria to display the total cost of an order in cell B9 for any given ordered quantity B8 IF(B8>-101, 12, IF(B8 50, 13, IF(B8>-20, 16, IF( B8> 11, 18, IF(B8> 1, 20, " "))) OB8 IF(B8>101, 12, IF(B8<50, 13, IF(B8<20, 16, IF( B8<11, 18, IF(B8>1, 20, " ) B8 IF(B8-100, 12, IF(B8 50, 13, IF(B8-20, 16, IF B811, 18, IF(B8>-1, 20, "") -B8 IF(B8 100, 12, IF(B8>50, 13, IF(B8>20, 16, IF( B8 11, 18, IF(B8>1, 20, ) For a particular month, the worksheet below shows the inventory of cel phones in stock at the beginning of the month. It also shows the number of cell phones of each type that have been sold during the month. When there are less than 10 phones in the inventory, it is time to replenish the stock. Write a statement for cell D2 to be copied for column D that will display the text, "Order" if more cell phones need to be ordered, yet leave the cell blank if more cell phones do not need to be ordered 1Smartphone Model 2 Nokia 6500 Classic 3 Samsung SGH-E250 4 LG Shine Quantity in Stock Quantity Sold Order More? 51 52 60 45 37 Apple Iphone 6 LG Viewty HTC Touch 8 Palm Centro 72 51 30 46 Order IF((C2-B2)<= 10, "Order") IF(B2-C2)<10, Order"," ") -IFIABS(B2-C2) 10,"Order", " ") IFIABS(B2-C2)<10,"Order"," ")

Answer this question only if you know the 30 points and

Which of the functions below could have created this graph?

In january 2010, you began a one-year study of tuberculosis (tb) in a subsidized housing community in the lower east side of new york city. you enrolled 500 residents in your study and checked on their tb status on a monthly basis. at the start of your study on january 1st, you screened all 500 residents. upon screening, you found that 30 of the healthy residents had been vaccinated for tb and therefore were not at risk. another 20 residents already had existing cases of tb on january 1st. on february 1st, 5 residents developed tb. on april 1st, 10 more residents developed tb. on june 1st, 10 healthy residents moved away from new york city and were lost to follow-up. on july 1st, 10 of the residents who had existing tb on january 1st died from their disease. the study ended on december 31, 2010. assume that once a person gets tb, they have it for the duration of the study, and assume that all remaining residents stayed healthy and were not lost to follow-up. is the subsidized housing community in the lower east side of new york city a dynamic or fixed population? briefly explain the rationale for your answer. dynamic population it can changeable people can move out and move in into the population of a subsidized housing what was the prevalence of tb in the screened community on january 1st? prevalence = 30/500 0.06= 6% what was the prevalence of tb on june 30th? prevalence= 40/450=0.08= 8.88% what was the cumulative incidence of tb over the year? cumulative incidence = number of new cases/number in candidate population)over specified time period 10/450 = 2.2% suppose that you wanted to calculate the incidence rate of tb in the study population. calculate the amount of person-time that would go in the denominator of this incidence rate. be sure to show your work.