Regression Analysis Essay Example | Topics and Well Written Essays - 1000 words

Regression Analysis - Essay ExampleLastly, throwback digest testament be performed on statistically crucial pairs of variables and regression line comparability(s) of best fit will be written.Using Excels Data Analysis-Sampling, random chip for data for country was generated (Figure 1) and be records were taken from population. Table 1 in appendix shows the sample for correlation and regression analysis.Figure 3 shows the scatterplot of the GNP per item and the physique of commercial vehicles. The relationship between the GNP per head and the number of commercial vehicles appears to be moderate (correlation, r = 0.556).Table 2 shows the correlation matrix for variables GNP per head, Cars per head and number of Commercial vehicles. The correlation for the GNP per head and the cars per head and the GNP per head and the number of commercial vehicles is significant at level of significance, = .01.Since, the correlation for GNP per head with the cars per head and the number of c ommercial vehicles is significant thitherfore, there is strong possibility that GNP per head can be used to predict the cars per head and the number of commercial vehicles in any country.Table 3 shows the regression analysis output for the GNP per head and the cars per head using Excel. The higher value of F statistic suggests that regression is significant. GNP per head explains about 80% of variation in the cars per head.GNP per head (US $) significantly predict the cars per head, = 0.00005,t(28) = 10.54,pThe slope of the regression equation suggest that each US $ increase in GNP per head adds an average of 0.00005 cars per head. The intercept is not meaningful as zero GNP per head implies negative value for the cars per head that is not possible. The regression equation can be used for predicting the cars per head of any developing