The goal of this project is to construct a spreadsheet model that will allow an analyst to predict the graduation rate of a college or university depending upon several factors:
• Whether the institution is a liberal arts college or university;
• Median SAT score of students at the institution;
• Acceptance rate of the college or university;
• Expenditures per student;
• Percentage of students in the top 10% of their high school class.
Part 1:
Perform regression analysis by constructing a model to predict the graduation rate of a college or university. Complete the following steps:
a. Assess the data using descriptive statistics. Include various descriptive measures (mean, max, mode, median, min, standard deviation, etc.) Use histograms, if appropriate, and analyze any outliers you find in the data. Record what you learn.
b. Plot the data. Analyze and record what you learn from the various scatter plots.
c. Determine the correlation between the dependent variable and the various independent variables by creating a correlation matrix. Assess for multicollinearity between the independent variables.
d. Assess the predictive capability of this data using both simple and multiple linear regression, including the use of a dummy (categorical independent) variable of whether the student attended a college or university. Run the regressions, perform statistical inference in each case, and record what you learn. Use a 0.05 level of significance. If you assess that there is not a relationship between any two variables of data, redo the regression equation and assessments showing only the data points with linear relationships. If you find multicollinearity, remove it by redoing your model without one of the variables causing multicollinearity, then try it with the other variable removed and pick the best option.
e. Based on the prior steps, determine and record the best linear regression equation for this data. Discuss the meaning of the model fit and regression coefficients.
f. Assess the possibility of a better curvilinear regression line. If your findings warrant this, run the curvilinear regression and discuss the meaning of the model fit and the regression coefficients.
g. Pick the best regression equation and document it.
h. Using your best regression equation, what is your graduation rate prediction for a university whose student median SAT score is 1210, acceptance rate is 23%, expenditures per student are $25,500, and the percentage of students in the top ten percent of their graduating HS class is 79%?
i. Remove any extreme outliers in the data and rerun the regression analysis. Is your best model after completing this step better?
j. What other independent variables (not cited in the data) may be important in improving this model?
Hi, I'm a statistical analyst and have almost 5 years of experience in analytics using excel, SPSS, R etc. I think I can help you in this project and provide you all the insights as well as the interpretation of the results.
feel free to contact me for further discussion.
$155 USD in 3 days
4.8 (37 reviews)
5.1
5.1
24 freelancers are bidding on average $143 USD for this job
Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data.
Relevant Skills and Experience
I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour
Proposed Milestones
$250 USD - a
I can do advanced level analysis in SPSS, R, WEKA, TABLEAU and excel tools
Expert in Ms excel and statistics. Have done many research projects in Excel using statistics
Linear regression analysis, Can complete the report and analysis as well as per the given guidelines.
Relevant Skills and Experience
Expert in academic writing and reports. Experienced MBA Finance as well.
Proposed Milestones
$155 USD - Linear Regression in Excel
linear regression in excel
Relevant Skills and Experience
using data analysis in excel would findout, R square, adjusted R2, stnd error etc. also will observe the outliers creating a box plot, removing the outliers creating another regression
Proposed Milestones
$111 USD - as per the requirement
Hello, how are you? I have read the details provided, but please contact me so that we can discuss more on the project. I don't outsource like most people do ensuring quality work on time
Relevant Skills and Experience
Excel, Finite Element Analysis, Statistical Analysis
Proposed Milestones
$126 USD - .
regression model for prediction using excel - i have experience in multi-variable regression for both linear or nonlinear.
Relevant Skills and Experience
excel, math
Proposed Milestones
$111 USD - final deliverable
Assignment will be completed with reliability by experienced specialized professional.
looking forward to hear from you.
thank you
Relevant Skills and Experience
Analysis, Excel etc
Proposed Milestones
$222 USD - a
I have read your project details and would like to work on your project
Kindly visit the below mentioned link to have a glance at our portfolio
https://www.freelancer.com/u/Moh6335.html
Thanks
Relevant Skills and Experience
Regression analysis, Spreadsheet excel, Statistics
Proposed Milestones
$110 USD - Excel
i can do your project :
Project Description
The goal of this project is to construct a spreadsheet model that will allow an analyst to predict the graduation rate of a college or university depending upon several factors:
• Whether the institution is a liberal arts college or university;
• Median SAT score of students at the institution;
• Acceptance rate of the college or university;
• Expenditures per student;
• Percentage of students in the top 10% of their high school class.
in a time within budget
Hi hiring manager
I read all details about your project and i am ready for work i am hard worker and i will give you full satisfaction in less to less charge
Stay tuned, I'm still working on this proposal.
i needed a project in m.s word
Relevant Skills and Experience
typing master
Proposed Milestones
$155 USD - typing
Additional Services Offered
$6 USD - typing
i neded a job home typing and i will my best so please