Assignment 2 Predictive Analytics Full Marks 35 [ XXXXXXXXXX = 35] 1.Refer tostartup.xlsxfile which provides the profit for 50 startups along with expenses (in USD) in different heads...

Assignment 2 Predictive Analytics Full Marks 35 [15+10+10 = 35]

1.








Refer to







startup.xlsx








file which provides the profit for 50 startups along with expenses (in USD) in different heads and some other specifications. Using Python programming language develop a linear multiple regression model and interpret the results. Write the regression equation and predict the profit for a startup in Florida with a woman entrepreneur whose age is 45. Company’s annual expenditures under different heads are 150000 USD (Advertisement), 130000 USD (Administration), 350000 USD (Marketing). The company is a small one. Use dummy variables as necessary.

2.








Refer to







Churn_Modelling.xlsx








which provides some details of customers and their churn rate. Using Python programming language develop a logistic regression model to predict the churn possibility. Calculate the model accuracy. What percentage of positive cases were correctly predicted? Also find the churn out possibility of a 45-year-old woman residing in France with credit score of 550, with a tenure of 4 years, balance 150000 USD, number of products 2. She possesses credit card and is known to be an active member. Her estimated salary is 125755 USD.

3.








Use the same data set as in problem 2 and develop a decision tree model. Calculate the model accuracy and compare with the same found in problem 2.