# Use the excel file attached below to answer those questions questions.Methods: discuss your modelling approachWhat are the independent variables (co-variates)?What is the dependent...

Use the excel file attached below to answer those questions questions.

1. What are the independent variables (co-variates)?

1. What is the dependent variable?

1. Provide as much detail about the various models you have in your study.

1. Did you need to transform any variables?

1. How well do the variables fit the model?

1. How well do the variables describe the model?

Important : I added the whole project description file as well that might help you to understand more what the project is about

Answered 3 days AfterApr 13, 2023

## Answer To: Use the excel file attached below to answer those questions questions.Methods: discuss your...

Banasree answered on Apr 16 2023
1.Ans.
1. Regression: The goal of regression would be to predict sales based on the other variables. In this case, the independent variables would be
SQFT, INVENTORY, ADVERTISING, FAMILIES, STORES, and SCHOOL (which would need to be converted to a dummy variable).
2. Classification: The goal of classification would be to predict whether a store is successful (i.e. has high sales) or not based on the other variables. In this case, the independent variables would be SQFT, INVENTORY, ADVERTISING, FAMILIES, STORES, and SCHOOL (which would need to be converted to a dummy variable).
3. Clustering: The goal of clustering would be to group stores based on their characteristics. In this case, all the variables except for SALES would be considered independent variables.
2.Ans.
The dependent variable is not explicitly given in the data. However, based on the context and information provided, it can be inferred that the dependent variable is likely to be the SALES column, which represents the sales figures of various stores.
3.Ans.
1. Regression Models: Regression models can be used to analyze the relationship between the independent variables (sales, square footage, inventory, advertising, families, stores, school code) and the dependent variable (school). Linear regression models, logistic regression models, and Poisson regression models can be used based on the nature of the dependent variable.
2. Decision Trees: Decision trees can be used to create a decision-making model based on the...
SOLUTION.PDF