Firms are attached in second image while question (3) is in first image...!!!

The profit after tax (PAT) (? Million) of 30 selected Drugs and Pharmaceuticals firm in India for the financial year 2019-20 are given in Table 1. Figures in the Predicted values represent the predicted value of PAT using the following regression model. The detailed regression output (with some missing values) is also given. Using the available information, calculate the following. PAT; = Bo + B1 R&D Expenditure; + B2 Export_intensityi + B3 Age; + u (1) regress profitaftertax randd export_intensity age profitaftertax Coef. Std. Err. t P>It! [95% Conf. Interval] -.4414131 .5907206 0.30 -0.57 randd export_intensity age _cons -1.661849 -2.625382 1274.777 .2510627 2.901662 5.65188 239.8985 0.769 0.572 0.646 -14.24299 8.992222 5.31 3. The upper limit of 90% confidence interval of o i.e., constant Table 1: Profit after tax and its regression predicted values of selected Pharmaceuticals companies in India (2019-20) Predicted value of Sl. No Company name Profit after tax profit after tax 1 Caplin Point Laboratories Ltd. 1481.7 1056.532 2 Granules India Ltd. 1618.4 1227.801 3 Hetero Drugs Ltd. 1308.7 1134.424 4 Jubilant Generics Ltd. 1298 1338.138 5 FDC Ltd. 1715.4 1086.404 6 Zydus Healthcare Ltd. 1716 1193.689 7 Blue Cross Laboratories Pvt. Ltd. 1273.4 1170.8 8 Shilpa Medicare Ltd. 1241.1 1100.199 9 Biocon Biologics Ltd. 1792 1293.615 10 Concord Biotech Ltd. 1183.9 1193.082 11 JB Chemicals & Pharmaceuticals Ltd. 1820.6 1184.142 12 Strides Pharma Science Ltd. 1103.7 1146.514 13 Fermenta Biotech Ltd. 1103.5 1100.188 14 Glenmark Life Sciences Ltd. 1955.9 1256.188 15 Hikal Ltd. 1030.8 1223.889 16 Vasudha Pharma Chem Ltd. 995.6 1160.582 17 Bharat Serums & Vaccines Ltd. 967.1 1175.517 18 Laurus Labs Ltd. 949.9 1340.763 19 Bharat Biotech Intl. Ltd. 880.7 1211.955 20 Aarti Drugs Ltd. 872.6 1125.851 21 SBL Pvt. Ltd. 826.5 1167.39 22 BDR Pharmaceuticals Intl. Pvt. Ltd. 823.2 1233.411 23 Cadila Pharmaceuticals Ltd. 805.5 1206.532 24 Neon Laboratories Ltd. 753 1176.043 25 Harman Finochem Ltd. 748.5 1179.9 26 Bliss G V S Pharma Ltd. 744.3 1185.9 27 Sai Life Sciences Ltd. 729 1071.259 28 Wallace Pharmaceuticals Pvt. Ltd. 691.4 1132.073 29 IOL Chemicals & Pharmaceuticals Ltd. 2367 1189.807 30 Medley Pharmaceuticals Ltd. 604.6 1139.414 The profit after tax (PAT) (? Million) of 30 selected Drugs and Pharmaceuticals firm in India for the financial year 2019-20 are given in Table 1. Figures in the Predicted values represent the predicted value of PAT using the following regression model. The detailed regression output (with some missing values) is also given. Using the available information, calculate the following. PAT; = Bo + B1 R&D Expenditure; + B2 Export_intensityi + B3 Age; + u (1) regress profitaftertax randd export_intensity age profitaftertax Coef. Std. Err. t P>It! [95% Conf. Interval] -.4414131 .5907206 0.30 -0.57 randd export_intensity age _cons -1.661849 -2.625382 1274.777 .2510627 2.901662 5.65188 239.8985 0.769 0.572 0.646 -14.24299 8.992222 5.31 3. The upper limit of 90% confidence interval of o i.e., constant Table 1: Profit after tax and its regression predicted values of selected Pharmaceuticals companies in India (2019-20) Predicted value of Sl. No Company name Profit after tax profit after tax 1 Caplin Point Laboratories Ltd. 1481.7 1056.532 2 Granules India Ltd. 1618.4 1227.801 3 Hetero Drugs Ltd. 1308.7 1134.424 4 Jubilant Generics Ltd. 1298 1338.138 5 FDC Ltd. 1715.4 1086.404 6 Zydus Healthcare Ltd. 1716 1193.689 7 Blue Cross Laboratories Pvt. Ltd. 1273.4 1170.8 8 Shilpa Medicare Ltd. 1241.1 1100.199 9 Biocon Biologics Ltd. 1792 1293.615 10 Concord Biotech Ltd. 1183.9 1193.082 11 JB Chemicals & Pharmaceuticals Ltd. 1820.6 1184.142 12 Strides Pharma Science Ltd. 1103.7 1146.514 13 Fermenta Biotech Ltd. 1103.5 1100.188 14 Glenmark Life Sciences Ltd. 1955.9 1256.188 15 Hikal Ltd. 1030.8 1223.889 16 Vasudha Pharma Chem Ltd. 995.6 1160.582 17 Bharat Serums & Vaccines Ltd. 967.1 1175.517 18 Laurus Labs Ltd. 949.9 1340.763 19 Bharat Biotech Intl. Ltd. 880.7 1211.955 20 Aarti Drugs Ltd. 872.6 1125.851 21 SBL Pvt. Ltd. 826.5 1167.39 22 BDR Pharmaceuticals Intl. Pvt. Ltd. 823.2 1233.411 23 Cadila Pharmaceuticals Ltd. 805.5 1206.532 24 Neon Laboratories Ltd. 753 1176.043 25 Harman Finochem Ltd. 748.5 1179.9 26 Bliss G V S Pharma Ltd. 744.3 1185.9 27 Sai Life Sciences Ltd. 729 1071.259 28 Wallace Pharmaceuticals Pvt. Ltd. 691.4 1132.073 29 IOL Chemicals & Pharmaceuticals Ltd. 2367 1189.807 30 Medley Pharmaceuticals Ltd. 604.6 1139.414