Reference no: EM132228177
LINEAR REGRESSION REPORT
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
In this section, the purpose of the report need to be clearly and concisely stated.
Background
In this section, write an overview of the association between retention and graduation. Why would economists be interested in this particular issue?
Method
In this section, provide a brief overview of the data and empirical approach used to examine the association between retention and graduation.
Results
a) Provide a descriptive analysis of the two variables (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) Estimate a regression equation that can be used to predict the graduation rate (%) given the retention rate (%)
d) State the estimated regression equation and interpret the meaning of the slope coefficient
e) Is there a statistically significant association between graduation rate (%) and retention rate (%). Explain
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 your university compared to other online universities?
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?
Discussion
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
In this section, you should present three well-considered recommendations.
Attachment:- Linear regression report.rar
|
Add a Web API to an existing Application
: DSED-07 Web Development ASP.net Core - Advanced Web Development - Vision college new zealand - Diploma in Software and Design
|
|
Calculate the payment amount for the loan
: You have decided to purchase a new car. You plan to take out a loan to pay for the car. Calculate the payment amount for the loan in cell C15
|
|
Calculate the wildhorse preferred dividends
: During 2020, Wildhorse earned total revenues of $2,040,000 and incurred total expenses of $1,200,000. Calculate the Wildhorse's 2020 preferred dividends
|
|
Calculate the wildhorse net income
: Wildhorse Corporation has outstanding at December 31, 2020, 45,000 shares of $18 par value, Calculate the Wildhorse's 2020 net income
|
|
State the estimated regression equation
: Develop a scatter diagram with retention rate as the independent variable. What does the scatter diagram indicate about the relationship between
|
|
Should we mount a massive effort to restore ecosystems
: Should we mount a massive effort to restore ecosystems that we have degraded even though this will be quite costly? For this weeks environmental controversy.
|
|
What you have learned from the water privatization debate
: Using what you have learned from the water privatization debate, take the following steps to cast a vote on your stance on the topic of water privatization.
|
|
Which sources of finance are appropriate and why
: You will assess your understanding of which sources of finance are appropriate and why - You will need to make judgments and support those judgements
|
|
Discuss about the ground water pollution
: Justify if the term represents an obstacle to that goal, or perhaps a technique or technology that might promote it. Suggest two specific actions we can take.
|