ECONOMICS AND QUANTITATIVE ANALYSIS LINEAR REGRESSION REPORT DUE DATE: 11 February 2019 WORD LIMIT: 1200 words WEIGHTING: 40% Instructions Background One of the biggest challenges in the higher...

1 answer below »
Please find the attachment that I have submmited.



ECONOMICS AND QUANTITATIVE ANALYSIS LINEAR REGRESSION REPORT DUE DATE: 11 February 2019 WORD LIMIT: 1200 words WEIGHTING: 40% Instructions Background One of the biggest challenges in the higher education sector has been the recent growth of online universities. The Online Education Database is an independent organisation whose mission is to build a comprehensive list of accredited online colleges. The Excel spreadsheet (OnlineEdu.xlsx) contains data on the retention rate (%) and the graduation rate (%) for 29 online colleges in the United States. Instructions Conduct a simple linear regression analysis to examine the association between the ‘retention rate’ (the independent variable) and the ‘graduation rate’ (the dependent variable). Using the Excel data file, prepare a 1200 word repot using the following structure. Purpose (2 marks) In this section, the purpose of the report need to be clearly and concisely stated. Background (4 marks) In this section, write an overview of the association between retention and graduation. Why would economists be interested in this particular issue? Method (4 marks) In this section, provide a brief overview of the data and empirical approach used to examine the association between retention and graduation. Results (20 marks) a) Provide a descriptive analysis of the two variables (e.g., mean standard deviation, minimum and maximum). (2 marks). 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? (3 marks). c) Estimate a regression equation that can be used to predict the graduation rate (%) given the retention rate (%) (2 marks). d) State the estimated regression equation and interpret the meaning of the slope coefficient (2 marks). e) Is there a statistically significant association between graduation rate (%) and retention rate (%). Explain (2 marks). f) Did the regression equation provide a good fit? Explain (3 marks). g) Suppose you were the president of South University. After reviewing the results, would you have any concerns about the performance of your university compared to other online universities? (3 marks). h) Suppose you were the president of the University of Phoenix. After reviewing the results, would you have any concerns about the performance of your university compared to other online universities? (3 marks) Discussion (5 marks) In this section, provide a brief overview of the key results. What are the key strengths and limitations of this analysis? (e.g., data, method, etc.). How do the results from this analysis compare with other studies? (e.g., are the findings consistent?). Do these findings have clear policy implications? Recommendations (5 marks) In this section, you should present three well-considered recommendations. Please ensure your report is submitted as a single file.
Answered Same DayFeb 07, 2021

Answer To: ECONOMICS AND QUANTITATIVE ANALYSIS LINEAR REGRESSION REPORT DUE DATE: 11 February 2019 WORD LIMIT:...

Soumi answered on Feb 09 2021
143 Votes
ECONOMICS AND QUANTITATIVE ANALYSIS
LINEAR REGRESSION REPORT
Table of Contents
Purpose    3
Background    3
Method    3
Results    3
a) Descriptive Analysis    3
b) Scatter diagram    5
c) Regression equation    5
d) Interpretation of meaning of Slope coefficient    5
e) Statistically significant
association    6
f) Fit of the regression equation    6
g) Concerns about performance of South University    6
h) Concerns about performance of University of Phoenix    6
Discussion    6
Recommendation    7
References    8
Purpose
The purpose of this assignment is to identify the association between the dependent and the independent variable, which will help in assessing the quality of education in a university.
Background
There is a 44% impact of the independent variable on the dependent variable. This indicates that a change of 1 unit in the independent variable will lead to a 0.44 unit change in the dependent variable. The independent variable is retention rate and the dependent variable is the graduation rate. There is an increase in the number of online universities across the globe. Therefore, the economist would be interested in determining the proportion of students retained by a university and graduating from such university. The same can indicate the quality of education in the universities. The same can help the economists in understanding the requirement for changes in the current online education system.
Method
The data provided in the given scenario related to the percentage of student retained by 29 colleges in the United States and the percentage of students graduating from the same. There are two metric variables, which are retention rate and the graduation rate. According to the views of Cheng et al. (2018), there are various tools, which can be used for analysis of the data. In the given scenario, Microsoft excel has been used for analysis of the given data. Regression analysis has been used to find the association between the dependent and the independent variable. Regression equation has been developed to assess the impact of one variable on the other variable. According to McNamara (2018), regression is one of the best tools to analyze data.
Results
a) Descriptive Analysis
    Particulars
    RR (%)
    GR (%)
    Mean
    57.4137931
    41.75862069
    Standard Error
    4.315602704
    1.832018976
    Median
    60
    39
    Mode
    51
    36
    Standard Deviation
    23.24023181
    9.865724115
    Sample Variance
    540.1083744
    97.33251232
    Kurtosis
    0.461757455
    -0.882399313
    Skewness
    -0.309920645
    0.176364432
    Range
    96
    36
    Minimum
    4
    25
    Maximum
    100
    61
    Sum
    1665
    1211
    Count
    29
    29
    Confidence Level (95.0%)
    8.840111401
    3.752720754
The data provided pertains to the retention and graduation rate of 29 universities in USA. The mean of the retention rate is 54.413 and the standard error is 4.3156....
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here