Understanding general tendencies is helpful, but you need to get a clearer picture of each market's response to price. One way to do that is to try out different prices in test markets to establish the relationship between price and demand for our product. If that is not an option, you may be able to use historical data to predict what demand will be at a particular price. For questions 3 and 4, you will use the following sample data, which shows 5 periods of prices and unit sales. Period Price Units Sold $90.00 100,000 $110.00 70,000 CO $70.00 110,000 $80.00 120,000 LO $80.00 130,000 3. You will need Excel to complete this problem. Use Excel to draw a scatterplot using the data from the table. Fit a trendline that estimates the consumer response to price. How many units would you expect to sell if you set the price at $85