Based on the supplied table, can I get some assistance with section 2? There are also a set of requirements for this assignment
Section 2: Demand for older Nintendo Switches (25points) Suppose that the demand and price for a cheaper and older model Nintendo Switch are related by p = D{q) = 16 1.25q, where p is the price (in dollars) and q is the quantity demanded (in hundreds). Using Google Sheetstxcel or other graphing software, create the demand table. Create a graph of the demand curve and address the following questions: o Create a table that lists the demand quantity and price at each level of demand in the following list. Show your calculations by using functions within Google Sheets or other graphing software. - 0 Nintendo Switches - 400 Nintendo Switches - 800 Nintendo Switches 0 Explain what the quantity,r demanded for the Nintendo Switches would be for each price listed below. Show your calculations by using functions within Google Sheets or other graphing software. - $8 ' $10 ' $12 0 Graph the demand curve that depicts p = 16 1.251;]. Question 2: Nintendo collected information on the demand and supply for the Nintendo Switch in Los Angeles where the quantities of Nintendo Switches are measured in thousands. The following table displays the listing the price, quantity demanded (Qd) and quantity supplied (Qs). (25points) Price Qd Qs $144 32 16 $154 28 20 $184 22 22 $224 13 28 $282 44Requirements - Re-creation of the demand and supply table and graph the demand and supply curve using Google Sheets or Excel - Explanation of Nintendo Switch equilibrium price; supported by graph - Explanation of the law of supply and demand - Explanation of shortagefsurplus; supported by graph - Creation of demand table and curve using Google Sheets or Excel that addresses the key levels of demand and pricing - Creation of supply table and curve using Google Sheets or Excel that addresses the key levels of supply and pricing - Explanation of demand and supply equilibrium quantity and price; supported by calculations and a graph