# Data Analytics

*label*Business

*timer*Asked: Nov 15th, 2016

**Question description**

Part I - Continuous Variable

- Identify a data set with continuous variables. You are welcome to reuse a previous dataset but must
**analyze**a different model. The sample size must be greater than 35 data points. - Clean and organize the data set.
- Compute descriptive analysis - show the median, mean and mode (sort the data set in ascending order).
- Compute correlation scores and highlight the significant values (> 0.40).
- Present a visual model showing the cause and effect relationship.
- Test for multiple regression models (simple, quadratic, polynomial)
- Identify the best model - all coefficients must be significant, that is, p-values must be less than 0.05
- Interpret the regression equation - show the difference between the predicted and actual values.

Part II - Dichotomous variable

- Identify a data set with at least one categorical variable. You are welcome to reuse a previous dataset but must
**analyze**a different model. The sample size must be greater than 35 data points. - Clean and organize the data set.
- Compute the dummy variable, explain the coding criteria.
- Compute correlation scores and highlight the significant values (> 0.40).
- Present a visual model showing the cause and effect relationship.
- Test for multiple regression models (simple,interactions)
- Identify the best model - all coefficients must be significant, that is, p-values must be less than 0.05
- Interpret the regression equation - show the difference between the predicted and actual values.

You will do the presentation using Microsoft Excel make sure the graphs and findings are **clearly organized. **