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

Question

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

Methods: discuss your modelling approach

What are the independent variables (co-variates)?

What is the dependent variable?

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

Did you need to transform any variables?

How well do the variables fit the model?

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

franchises-2-1-xfzolkmy.xlsx project-description-ssbycpcr-xy0f44zs.pdf

Banasree · Accepted Answer

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:

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

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment