An analyst is interested to understand the factors impacting the sales from export of manufacturing organizations in a geography. Based on his research he got indications that sales from exports may be positively impacted by % international ownership in the company, and % foreign purchase. He collected data for 100 manufacturing organizations as given in the excel file. Answer the following questions based on the above and the given data. You are free to use any software to answer this question. Take only important part of the outputs in answer sheet to justify your description. No need to copy the input data or complete statistical output in answer sheet. Take your judgement call how detailed you like to explain in above questions based on the marks. (Approximate time needed to answer about 45 minutes analysis, 45 minutes writing in copy)

1. Can sales from exports be predicted using the % international ownership, and % foreign purchase. Researcher also believes that the size of the organization in terms of employee strength may have variations in sales from exports, and therefore would like to control for it? Show your detailed working in your answer sheet and discuss the results from statistical point of view. (10)
2. The analyst would like to develop a confidence interval of 96% for a difference in population means of sales from exports of organizations with low versus high % foreign purchase. The organizations with % foreign purchase low. Conduct the analysis, and describe in your answer sheet. (assuming equal variance of the two populations). (10)
3. The analyst would like to conduct a two independent populations T test for zero difference in population means (assuming equal variance of the two populations) between low versus high % foreign purchase organizations. The organizations with % foreign purchase (10)
4. Explain your understanding about the relationship among the correlation between % foreign purchase, sales from exports, beta coefficient of % foreign purchase from part (a), and statistical result in part (b, and c). (10)

Compare and contrast if the findings in part a) consistent for small versus large size organizations at alpha 5%, and at alpha 1%? Assume the organization with employee strength A B D E F H Sales from Exports (Million USD) - Year 2019 Org_Num_ID 1 2 3 4 5 6 7 8 9 No. of Employees 500 161 60 50 181 55 173 111 50 112 211 135 812 109 % Foreign Purchase - Year 2019 90 10 35 28 89 30 34 Sales (Million USD) - Year 2018 80 5 40 40 100 0 10 0 30 65 40 10 11 12 13 0 41 30 10 14 15 16 17 Org ID F001 FOO2 FOO3 F004 F005 F006 FOO7 F008 F009 F010 F011 F012 FO13 F014 F015 F016 F017 F018 F019 FO20 FO21 FO22 FO23 FO24 FO25 FO26 FO27 FO28 FO29 FO30 FO31 FO32 65 25 750 400 209 27 73 65 1% International Ownership - Year 2019 80 20 34 45 79 10 57 57 55 50 10 0 0 45 20 0 0 0 0 73 0 30 0 30 80 92 0 98 0 50 6 5 34 50 43 0 28 0 60 18 19 20 21 22 23 24 25 26 27 28 29 30 0 60 75 20 30 10 50 5 30 30 15 10 90 0 30 20 96 6 44.4 46 117 0 12 ol 69 87 23.6 33 11.3 56 5.6 35.7 35.4 17.85 11 99 22 0 33.3 22.2 5.9 23.4 22.6 29.75 ol 6.6 12 5.85 11.3 44.8 11.2 44.8 11.2 35.1 22.4 78.4 16.8 10 30 70 20 80 23 0 70 30 0 30 21 45 60 80 91 30 30 44 30 20 0 11 70 14 21 100 34 310 1200 25 195 36 118 30 33 33 214 180 150 144 31 32 33 FO33 FO34 5 20 20 25 0 6 10 5 10 40 10 40 10 30 20 70 15 15 2 10 34 35 36 37 38 39 40 41 FO35 FO36 FO37 FO38 FO39 F040 F041 F042 F043 103 281 125 191 20 60 80 10 22 30 50 42 43 17.55 2.28 11.9 1 A B D E F H Sales from Exports (Million USD) - Year 2019 Org_Num_ID 1 2 3 4 5 6 7 8 9 No. of Employees 500 161 60 50 181 55 173 111 50 112 211 135 812 109 % Foreign Purchase - Year 2019 90 10 35 28 89 30 34 Sales (Million USD) - Year 2018 80 5 40 40 100 0 10 0 30 65 40 10 11 12 13 0 41 30 10 14 15 16 17 Org ID F001 FOO2 FOO3 F004 F005 F006 FOO7 F008 F009 F010 F011 F012 FO13 F014 F015 F016 F017 F018 F019 FO20 FO21 FO22 FO23 FO24 FO25 FO26 FO27 FO28 FO29 FO30 FO31 FO32 65 25 750 400 209 27 73 65 1% International Ownership - Year 2019 80 20 34 45 79 10 57 57 55 50 10 0 0 45 20 0 0 0 0 73 0 30 0 30 80 92 0 98 0 50 6 5 34 50 43 0 28 0 60 18 19 20 21 22 23 24 25 26 27 28 29 30 0 60 75 20 30 10 50 5 30 30 15 10 90 0 30 20 96 6 44.4 46 117 0 12 ol 69 87 23.6 33 11.3 56 5.6 35.7 35.4 17.85 11 99 22 0 33.3 22.2 5.9 23.4 22.6 29.75 ol 6.6 12 5.85 11.3 44.8 11.2 44.8 11.2 35.1 22.4 78.4 16.8 10 30 70 20 80 23 0 70 30 0 30 21 45 60 80 91 30 30 44 30 20 0 11 70 14 21 100 34 310 1200 25 195 36 118 30 33 33 214 180 150 144 31 32 33 FO33 FO34 5 20 20 25 0 6 10 5 10 40 10 40 10 30 20 70 15 15 2 10 34 35 36 37 38 39 40 41 FO35 FO36 FO37 FO38 FO39 F040 F041 F042 F043 103 281 125 191 20 60 80 10 22 30 50 42 43 17.55 2.28 11.9 1