Find Jobs
Hire Freelancers

Linear Regression in Excel Project

$30-250 USD

Completed
Posted over 6 years ago

$30-250 USD

Paid on delivery
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?
Project ID: 15367085

About the project

24 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
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
$250 USD in 3 days
4.8 (51 reviews)
5.9
5.9
User Avatar
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
$155 USD in 3 days
4.8 (41 reviews)
5.0
5.0
User Avatar
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
$111 USD in 3 days
4.9 (31 reviews)
4.5
4.5
User Avatar
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 - .
$126 USD in 3 days
4.8 (7 reviews)
4.3
4.3
User Avatar
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
$111 USD in 3 days
4.9 (19 reviews)
4.0
4.0
User Avatar
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
$222 USD in 4 days
4.7 (9 reviews)
2.4
2.4
User Avatar
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
$110 USD in 3 days
3.6 (1 review)
1.6
1.6
User Avatar
excel project Relevant Skills and Experience excel Proposed Milestones $130 USD - perfect
$130 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a math teacher with experience in working excel, Spss, R and mathematica. I have a posgraduates sudies in Satistics area.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
kindly consider my application for the task
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am very familiar with this kind regards f projects. Contact me over chat for more details.
$150 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Does this have to be a model in excel or can it be programmed?
$244 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lawrence, United States
4.8
1
Payment method verified
Member since Oct 10, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.