I am needing help with Q4 on the attached document. I must show the formula on how I got the own price elasticity of demand. I can also be done in excel if it is possible.

Qty 9.89 12.07 13.08 13.9 8.93 8.05 3.98 3.18 15.07 11.86 13.1 13.87 12.02 10.19 9.88 11.94 10.93 11.99 10 8.12 9.18 9.86 11 11.91 13.12 10.02 8.91 7.96 7.89 4.96 PRPIZZA PRSOFT Tuition 97.3 98.8 17.92 101.2 95.2 26.36 91 110.8 14.57 95 91.9 7.7 109.6 100 14.56 126.4 100.8 9 126.4 122.9 17.48 149.4 149.1 20.46 78.8 102.4 29.26 75.7 87.8 13.96 91.9 80.2 12.17 103.4 75.2 3.76 101.6 99.6 18.72 113 123.5 20.69 121.7 131.2 17.63 112.6 79.2 20.71 150.1 88.5 21.91 100.3 94.1 17.97 151.4 101.6 18 145.3 90 18.71 150.5 94.3 25.01 129.7 98.4 18.44 123 95 24.15 104.5 99.8 22.87 82 100.9 18.75 100.3 112.1 18.63 109.4 124.3 6.35 128.1 90.2 13.99 155.1 80.5 8.83 148.7 97.1 13.83 1 Write the theoretical demand equation using the appropriate variable names you created when you prepared data for analysis. The variable names should be very short and must be in capital letters. For instance, QTY for Y, PRPIZZA for X1, PRSDRK for X3. For example, if you used QTY for quantity, use QTY in the estimating demand equation rather than Y. Remember to use the exact same variable names you used in the data. In other word, do NOT use Y and X1, X2, X3, and so on, as done in the textbook. 2 After estimating the pizza demand, write the estimated demand equation. Make sure you use the estimated coefficients you obtained from the regression output. 3 Is the estimated coefficient of the price of pizza statistically significant at the 5% level? You can use either the t-test or the P-value, not both since both gives the same results (read my lecture note on testing hypothesis). What does it mean when you reject the null hypothesis? 4 Compute the own price elasticity of demand. In regression analysis, you must use the point elasticity of demand, not the average price elasticity of demand as you have done on the exam. You should have learned of this when you took Business Calculus such as Y/X. When computing the own price elasticity of demand, use the average price, the average tuition, and the average soft drinks price. 5 What is the R-square? Explain the meaning the number you got