Gravity Infosolutions Data Analyst Interview Questions and Answers for Experienced

Assumptions of linear regression model

• Linearity: relationship between independent and dependent variables is linear

• Independence: residuals are independent of each other

• Homoscedasticity: variance of residuals is constant across all levels of predictor variable

• Normality: residuals are normally distributed

• No multicollinearity: independent variables are not highly correlated with each other

The order of filter operations in Tableau is important for accurate results.

• Tableau applies filters in the order they are listed in the Filters shelf.

• Filters are applied before calculations, so the order can affect the results of calculations.

• The order can be changed by dragging and dropping filters in the Filters shelf.

• Context filters are applied before other filters, so they can affect the order of operations.

Bins and groups are both methods of categorizing data, but bins are used for continuous data while groups are used for categorical data.

• Bins are used to group continuous data into intervals or ranges.

• Groups are used to categorize data based on a specific attribute or characteristic.

• Bins are commonly used in histograms and frequency distributions.

• Groups are commonly used in cross-tabulations and contingency tables.

• Bins ...read more