Mean and Standard Deviation Calculation

Question –

(a) Provide a descriptive analysis of the two varaiables(e.g.,mean, standard deviation, minimum and maximum).
(b). Develop a scatter diagram with retention rate as the independent variable. What does the scatter diagram indicate about the relationship between the two variables?
(c). Develop and estimate a regression equation that can be used to predict the graduation rate(%) given the retention rate(%).

(d). State the estimated regressio equation and interpret the meaning of the slope coefficient.
(e). Is there a statistically significant association between graduation rate (%) and retention rate (%). What is your conclusion?
(f). Did the regression equation provide a good fit? Explain.
(g). Suppose you were the president of South University. After reviewing the results, would you have any concerns about the performance of tour unicersity compared to other online universities?
(h) Suppose you were the president of the University of Phoenix. After reviewing the reults, would you have any converns about the performance of your university compared to other online universities?

Online schools or colleges are made to offer preparing to the understudies who can’t be show physically in the standard setting, for instance, classroom. It has a state of a generous scale canny investment and open get to through or through web and other framework developments. Shortly a day this system of learning or guideline is extending. The wide use of machines and web has made the approach of learning or guideline through online school faster and less requesting. These are advancing a full instructive program as same as an average school, yet starting late there is disaffirm between online school and the customary school. The internet preparing database is an independent affiliation whose mission is to develop a complete summary guarantees online colleges (Drennan, 2002). The inspiration driving Maintenance rate is to screen or see in attracting and holding understudies for the universities. Support rate is found out by net pay of the school less benefits confined by Net Pay or Income. Advancement Rate is the rate of augmentation of the amount of understudies of the universities. Shortly I am going to research between the upkeep rate and advancement rate of the online colleges in USA.

Recently understudies are picking online school as opposed to conventional school. So there is showing up a most noteworthy test in progressive training part has been late advancement of online universities. So we have to explore the improvement rate and upkeep rate of the online schools in USA. 

For this investigation we are making mean, greatest, least and standard deviation of the retention rate and development rate of the online colleges or universities of USA. Furthermore we are additionally utilizing regression mathematical statement through graduation rate and retention rate (McCraw, 2012). After that we are ascertaining the relapse co proficient and measurably find the centrality between graduation rate and retention rate.

As indicated by the giving information set or exceed expectations gave, we effectively disks or figure the conclusions or yields. The results or the yields are measured by the assistance of some clear investigation like mean, standard deviation, least or minimum and maximum utilizing some product like Microsoft Office (MS- Excel). The giving information set of the compositions and also its retention rate and graduation rate are in rate is indicated in beneath by the assistance of table. 

Scatter Chart Analysis

From the given data about the retention rate of online colleges or universities in USA we are going to make a disperse chart by accepting the maintenance rate and development rate as free variable. As indicated by the giving information set the maximum value, minimum value, standard deviation and mean are demonstrated in beneath by the assistance of the table.

The above table is measured or tackling by the assistance of Microsoft Excel or MS- Excel and its valuable equation or formula.

Where, mean estimation of the Retention Rate is equivalent to aggregate whole of the Retention Rate in rate (%) isolated by the aggregate no of online colleges like 57.414 and in addition mean estimation of the Graduation Rate is equivalent to aggregate entirety of the Graduation Rate in rate (%) separated by the aggregate no of online colleges like 41.759

Correspondingly, the standard deviation is measured by σ= √((σ (x-µ)^2)/(N-1)) orσ= √((Σ (x-µ)^2)/(N-1))

Where, σ = the standard deviation

x = each one estimation of the information set

µ = the mean quality

N = the quantity of qualities or size of the information set

By the assistance of the above equation or formula we will effectively measured or ascertain the standard deviation of the retention rate is 23.2402 and in addition the standard deviation of graduation rate is 9.8657

Presently are making a disperse graph by taking under thought of development rate and retention rate of the colleges or universities of USA.

From the disseminate outline or scatter diagram we can see that development rate and maintenance rate are entomb related. On the off chance that development rate will expand then maintenance rate will likewise build. The rate of both retention and development are upward climbing.

The procedure of common minimum square is giving ensure that gauge the relapse line which is additionally the best fitting line, has been drawn from the given information (Kerrigan Snyder, 2013). Here in the above disperse outline the plot does not appear to lie near to the line. So we can say that the relapse line or the best fitting line will fit in extremely well.

Presently we are making a rundown yield or outcomes of regression statistics by a presumption.

Presently we are making an expected regression mathematical expression statement and deciphering the coefficient slant or slope. To do this we have expect the qualities. In the followings we have assess relapse and remaining.

In the underneath table we are demonstrating the distinctive relapse and remaining of df, SS, MS, F and significance of F. we are additionally giving their aggregate.

In the followings there is a diagram of coefficients, standard error, t-Stat, P-value, lower and upper rates in percentage.

In the accompanying we are demonstrating the perceptions, predication 7 and residual in the underneath table from 1-28 separate variables or factors.

From the given information we have ascertained the regression mathematical statement. Interpretation or Translation of Coefficient as a change of rate of Y is set up of as a change in the restrictive mean of Y. There is no need of taking certainty interims for coefficients into records. When we assess or deciphered a regression coefficient effectively as a rate of progress of a restrictive mean which is as opposed to a change in given two variables. It is all that much essential to take into under thought the vulnerability in the estimation of the regression coefficient. According to this technique I have ascertained the relapse mathematical statement line. Which are y= 1.860x + 29.51 and y= 1.143x + 24.60. Then again I have taken a 95% certainty interim for the slant or slope. The rate of progress of the restrictive mean of Y concerning x is assessed to be somewhere around 1.860 and 1.143 is normally desirable over saying; the rate of progress of the contingent mean of Y regarding x is close around 2 or more. The understanding of the coefficient of which is not factually huge. This sort of translations is regularly made shockingly (Welfens and Walther-Klaus, 2007). On the off chance that the regression coefficient of t test is not measurably critical, this won’t be the suitable to decipher or assess the coefficient. There is no factually huge direct which reliance of the mean of Y on x was recognized. In the interpretation or translation of coefficients in the numerous regressions with the same dialect or variable is fundamentally utilized as a part of single direct regression.

Regression Statistics

As indicated by the giving information set or excel sheet the retention rate estimation of the South University is much higher than appreciation of the graduation rate esteem. The retention rate esteem in rate of the South University is 51% and the graduation rate estimation of the South University is just 25%. Consequently, the retention rate estimation of the South University is 26% more than the graduation rate esteem. This is demonstrated that the development of the college, which is additionally connected to the development of the university and also when the retention rate quality is expansion than the relapse rate estimation of the South University is likewise increment. We unmistakably said that the retention rate estimation of the South University is additionally specifically relative to the regression rate esteem. Henceforth the relapse comparison of the South University is great fit and also the development rate and the development of the South University is increment. Along these lines, the quantities of the understudies are likewise increments and additionally the college is likewise offered some new stream or learning project for some new understudies (Levy, 2009). Subsequently it is obviously said that the retention rate esteem when increment than the plan of action is in benefit.

As per the giving information set or excel sheet the maintenance rate estimation of the University of Phoenix is much lower than admiration of the graduation rate esteem. The retention rate esteem in rate of the University of Phoenix is just 04% and in addition the graduation rate estimation of the University of Phoenix is 28%. Accordingly, the graduation rate estimation of the University of Phoenix is 24% more than the retention rate esteem. The retention rate worth is demonstrated that the development of the college, which is likewise connected to the development of the university and also when the retention rate quality is expansion than the regression rate estimation of the University of Phoenix is additionally increment however in University of Phoenix the graduation rate quality is expansions and more than the retention rate esteem. Consequently the regression comparison of the University of Phoenix is bad fit and additionally the development rate and the development of the University of Phoenix is abatement. Hence, the quantities of the understudies are likewise diminishes and also the college is carried out not offered some new stream or learning system for some new understudies. Accordingly it is unmistakably said that the graduation rate esteem when increment than the plan of action is in misfortune.

According to the above point by point investigation we will smoothly measure some unmistakable examination like mean, standard deviation, least and in addition most extreme qualities furthermore relapse estimations of some online universities, which are moreover discussed in above. The maintenance rate regard and the graduation rate estimation of the online schools are also given in rate (%). By the aid of the maintenance rate worth and graduation rate regard we will in like manner find or measures the backslide estimations of the online universities (Ryan and Others, 2010). The relapse estimations of the online schools are in like manner discusses in above. The relapse estimations of the online universities are moreover showed the improvement of the online schools like expansions of the understudies, growing the learning task and a couple of others, which is also identified with the net advantage of the universities or arrangement of activity. 

References

Anderson, K., Cockburn, J. and Martin, W. (2009). Would freeing up world trade reduce poverty and inequality?. Adelaide: Centre for International Economic Studies.

Canadian economy online. (2005). Choice Reviews Online, 42(12), pp.42Sup-0465-42Sup-0465.

Canadian economy online. (2006). Choice Reviews Online, 43(12), pp.43Sup-0519-43Sup-0519.

Drennan, M. (2002). The information economy and American cities. Baltimore: Johns Hopkins University Press.

Kerrigan Snyder, B. (2013). The unemployed college graduate’s survival guide. Avon, Mass.: Adams Media.

Levy, B. (2009). Town born. Philadelphia: University of Pennsylvania Press.

McCraw, T. (2012). The Founders and Finance. Cambridge, Mass.: Belknap Press of Harvard University Press.

Miller, N. (2010). Botanical aspects of environment and economy at Gordion, Turkey. Philadelphia: University of Pennsylvania Museum of Archaeology and Anthropology.

Quarter, J., Mook, L. and Ryan, S. (2010). Researching the social economy. Toronto [Ont.]: University of Toronto Press.

The informal economy: underground economy, moonlighting, subcontracting, household economy, unorganized sector, barter, ghetto economy, second economy: a research guide. (1992). Choice Reviews Online, 29(07), pp.29-3647-29-3647.

The new economy. (2003). Choice Reviews Online, 41(04), pp.41-2279-41-2279.

Welfens, P. and Walther-Klaus, E. (2007). Digital excellence. Berlin: Springer.