Data Analysis Assignment Example | Topics and Well Written Essays - 250 words

Data Analysis - subsidisation ExampleManually (but randomly) select n (20 n 25) countries (do not use any random excerption mechanism) to construct the selective information set. Enter the observations on each of the four unsettleds corresponding to each country you confine selected into a Stata data file and save this file. Your Stata data editor should now show a data matrix with dimensions (n X 4) where the value of n is elect by you as per the requirement.i Select any one independent variable from the three in your dataset and denote it by X. Denote the dependent variable IN by Y. Use a calculator/software and your sample to calculate X, Y, XY and X2. Use these set to write down the pair of normal equations the solutions of which give the constant term and the slope of the Ordinary least Squares line. (15 marks)iv Construct the multiple regression model by denoting the dependent and the selected independent variables using the roman print characters Y, X2, X3 and X4, res pectively. For example, if you choose Urban population, Literacy Rate and GDP then you should define the model asRun a Stata regression of the dependent variable Y values on the three explanatory variables you have chosen and a constant. Use the regression output to explain why and how the F-statistic was calculated by the software and how it potbelly be used to test for the overall relevance of the regression model. (30