Please note:

$$ Though I have mentioned all the Data Mining steps below, you are only required

to answer Step $4$: Data Modeling and Step $5$: Data Evaluation.

$$ I prefer that you use Python for the project. Excel is fine too.

Where to Submit: Blackboard

What to submit?

$1.(35$ points$)$ Model $($Step $4$ of the Datamining Process$).$ Look for more detailed

instructions below in Step $4$

$2.(15$ points$)$ Model Evaluation $($Step $5$ of the Datamining Process$).$ Look for more

detailed instructions below in Step $5$

Step $1$: Business Understanding$/$Problem:

Is there any indicator they predict the average SAT score of school and can we use the

learnings to help schools improve their students SAT score?

Set $2$: Data Understanding:

You are provided with AP and SAT data. In the CSV file AP$\_$SAT$\_$Data.csv$,$ there are

$3$ independent variables$/$attributes

$1.$ No$\_$AP$\_$TestTakers

$2.$ Total$\_$Exam$\_$Taken

$3.$ No$\_$Exam$\_$Passed

$1$ Dependent variable$/$ Target

$1.$ SAT$\_$Math$\_$Score

Step $3$: Data Preparation:

For this Project, I took care of it$.$ I performed the following exercise

$1.$ Exclude categorical attributes that are difficult to transform to Numeric ones

$2.$ Add dummy values for some missing one

$3.$ Deleted rows which more than few missing attributes values

Step $4$: Modeling $($Linear Regression$)$

Use Excel or Python $($preferred$)$ to perform modeling. Use the $$AP$\_$SAT$\_$Data.csv$$ file

create the models.

Model $1$: Use the following $2$ independent variables to build a predictive model for the

target variable SAT$\_$Math$\_$Score

$1.$ No$\_$AP$\_$TestTakers

$2.$ Total$\_$Exam$\_$Taken

Model $2$: Use the all $3$ independent variables to build a predictive model for the target

variable SAT$\_$Math$\_$Score

Submit the following:

$1.$ The work $(10$ points for each model. Total $20$ points$)$

a$.$ If you used Excel, submit the regression output in excel for both the

models

b$.$ If you used Python, submit the Jupyter notebook. The code has to run.

$2.(10$ points$)$ What is the regression equation for both these models?

$3.(5$ points$)$ Compare the $2$ models you created. Which one is the better model

based on MSE? Provide the MSE.

Set $5$: Evaluation:

I have also provided $$testing$.$csv$.$ Use the data in this file to evaluate your models.

Submit the following:

$(15$ points$)$ Test your two model from Step $4$ using the test data. Which one is the better

model now $($use MSE$)?$ Has your answer changed from Step $4\mathrm{.}2?$

Set $6$: Deployment:

Think through how you would use the model findings.

Are there important ethical considerations? Nothing to submit.