One of the theories regarding initial public offering (IPO) pricing is that the initial return y (the percentage change from offer to open price) on an IPO depends on the price revision x (the percentage change from pre-offer to offer price). Another factor that may influence the initial return is a high-tech dummy variable that equals 1 for high-tech firms and 0 otherwise. The following table shows a portion of the data on 264 IPO firms from January 2001 through September 2004. Initial Price Return Revision High-Tech 38.33 4.27 8. 81 -33.58 2.94 -23.57 Expicture Click here for the Excel Data File a-1. Estimate y = Po + 81x + 82d + : where the dummy variable d equals 1 for firms that are high-tech. (Round your answers to 2 decimal places.) Initial Return Price Revision + High-Tech a-2. Use the estimated model to predict the initial return of a high-tech firm with a 10% price revision. (Round coefficient estimates to at least 4 decimal places and final answer to 2 decimal places.) Predicted return of a high-tech firm a-3. Find the corresponding predicted return of a firm that is not high-tech. (Round coefficient estimates to at least 4 decimal places and final answer to 2 decimal places.) Predicted return of a non high-tech firmb-1. Estimate y = Bo + Bix + 82d + = where the dummy variable d equals 1 for firms that are not high-tech. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal place.) Initial Return Price Revision + High-Tech b-2. Use the estimated model to predict the initial return of a high-tech firm with a 10% price revision. (Round coefficient estimates to at least 4 decimal places and final answer to 2 decimal places.) Predicted the initial return of a high-tech firm b-3. Find the corresponding predicted return of a firm that is not high-tech. (Round coefficient estimates to at least 4 decimal places and final answer to 2 decimal places.) Predicted return of a non high-tech firmInitial Return Price Revision High-tech 38.33 4.27 8.81 -33.58 -6.54 -10.39 0 13.7 45.43 1 -8.59 5.97 1 19.79 0 1 -27.87 -10.33 -1.75 0 -21.05 -9.02 4.53 8.22 0 -5.83 4.17 12.46 10.08 1 -7.66 -30.12 1 23.49 40.16 1 -1.86 3.99 1 11.83 54.63 1.18 -17.22 13.65 11.98 35.69 -7.06 -5.53 11.63 0 21.48 52.55 14.81 0.3 0 4.84 4.28 4.31 -39.41 1.96 16.72 -34.48 0 11.96 18.57 0 11.44 2.65 0 0 14.87 5.92 1 16.32 -25.51 6.44 -3.93 0 7.49 -23.3 1 1.66 12.84 1 0.55 3.96 52.26 24.93 57.36 0.35 2.23 11.49 1 -12.19 13.7 -19.3 18.35 -23.9 0 5.74 2.43 7.33 4.55 23.45 6.72 0 25.56 24.18 0 -22.91 -3.99 -33.85 -14.57 -15.22 24.45 -8.69 1 5.97 0 3.92 -8.92 0 -16.55 0 2.37 5.37 31.1 20.86 0 11.48 22.37 0 2.66 -4.83 1 19.08 -37.68 1 -2.64 0-3.38 -7.53 8.73 9.54 0 17.99 43.47 1 -2.64 35.51 1 18.59 -10.3 0 7.18 21.59 3.28 12.42 8.85 1 12.21 -24.66 0 -7.17 23.76 23.32 1 -27.52 4.92 20.63 1 8.93 0.33 1 -14.16 -15.9 -1.65 0 4.4 21.36 21.41 2.39 37.05 32.21 8.25 40.66 48.48 5.52 0 -7.06 -61.7 0.38 -15.78 0 -15.57 0 0 0 25.73 0 8.04 -14.95 35.98 8.86 -0.31 0 -8.36 36.22 0 17.7 29.71 34.91 16.54 0 18.42 0 0 33.63 35.66 1 0 8.85 1 15.2 -13.59 -24.68 0 11.11 5.15 14.27 -19.99 0 16.05 D.76 3.91 -27.16 1 0.89 2.35 9.54 29.08 1 4.19 0.27 1 -10.75 -15.05 38.36 -3.29 0 0.43 2.24 3.77 6.93 0.39 -1.83 9.23 2.54 6.04 8.31 D 0 0 24.35 1.1 -18.5 36.09 24.09 0 34.66 0 29.74 10.98 13.62 28.64 0 35.23 16.53 -5.66 -13.02 0 55.2 11.96 25 26.5 0 0.91 1.28 0 0.12 0-8.65 -7.04 48.77 5.11 0 -17.82 0 3 -23.48 1 7.07 -22.36 1 4.01 -16.63 1 -2.7 46.98 -52.3 1 13.75 14.93 1 0 -14.55 -1.11 5.38 20.81 1.01 0 -2.12 18.26 -4.96 5.61 1 -5.68 3.56 -4.22 -23.89 4.37 -10.92 0 4.94 9.17 1 -3.86 -52.03 1 9.5 0 23.83 2.23 40.15 0 -1.68 45.64 5.99 40.55 1 -2.7 10.5 46.59 26.88 -3.14 0 -7.66 -1.41 1 13.73 -34.1 -2.84 -1.75 0 11.77 0 11.05 1.17 0 5.32 -14.85 0 8.71 11.89 1 21.08 12.82 19.38 6.48 1 0 -21.26 1 12.87 14.56 1 16.85 36.08 0 11.69 12.18 D.67 0 -3.97 6.41 0 -0.28 1.54 1 33.52 33.88 1 -3.12 -28.74 1 25.7 13.28 1 1.21 -22.64 1 7.78 47.25 3.1 34.07 2.47 4.26 1.49 10.26 16.43 -21.5 0 12.34 -29.43 0 3.27 6.44 0 0 15.57 0 D.17 16.94 0 22.49 1.18 2.54 0 27.27 4.15 0 2.91 2.24 7.29 1.01 17.29 1.01 10.95 -2.65 -13.73 1 3.65 26.31 1 7.52 0 23.91 -10.93 1 0.8 8.89 0 40.8 7.8 -26.71 0 3.71 -23.64 3.27 7.31 0 8.11 0 18.65 0 2.28 0.91 13.55 13.55 4.95 42.35 2.22 4.85 117.8 10.86 1.42 -9.79 13.23 -13.81 1.56 -1.97 -20.1 0 -3.77 10.03 0 -5.35 -23.72 0 28.6 4.94 -17.86 0.09 2.34 0 36.5 28.46 10.58 0 24.08 20.97 0 4.28 -83.67 0 34.05 -17 0 6.08 1 2.73 1.39 0.23 -20.1 -32.88 1 27.76 15.47 1 10.49 2.89 25.23 0 9.74 8.88 21.41 1 4.69 -25.5 1.78 12.1 1 -24.54 -11.67 23.56 -26.02 14.86 17.19 -3.29 2.81 0 1.75 23.86 7.31 -29.57 8.35 39.11 5.57 18.62 0 28.6 0 7.75 2.56 -3.37 6.02 23.77 -39.06 14.74 0 0 5.3 0 13.64 5.73 14.12 -41.56 20.39 23.7 020.39 23.7 13.4 -4.99 -1.67 -5.54 6.45 0 18.71 13.98 13.96 -7.03 -24.31 0 45.5 9.31 -54.83 11.93 -36.46 5.73 -9.16 23.42 19.83 -22.3 27.76 2.25 2.94 -23.57 H