Suppose the current price of a good is $195. At this price, the quantity supplied is 160 units, and the quantity demanded is 200 units. For every $1 increase in price, the quantity supplied increases by 3 units and the quantity demanded decreases by 5 units. At the current price, the quantity demanded is than the quantity supplied. This means that the market is currently experiencing a . In order to adjust, the market price will until the quantity demanded and quantity supplied are equal. The result is an equilibrium quantity of and an equilibrium price of $ .

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding