# What is the ideal coefficient of variation?

## What is the ideal coefficient of variation?

Basically CVgood, 10-20 is good, 20-30 is acceptable, and CV>30 is not acceptable.

## How do you interpret the coefficient of a dummy variable?

The coefficient on a dummy variable with a log-transformed Y variable is interpreted as the percentage change in Y associated with having the dummy variable characteristic relative to the omitted category, with all other included X variables held fixed.

## How do you know if a correlation coefficient is significant?

Compare r to the appropriate critical value in the table. If r is not between the positive and negative critical values, then the correlation coefficient is significant. If r is significant, then you may want to use the line for prediction. Suppose you computed r=0.801 using n=10 data points.

## What is a good correlation coefficient?

The correlation coefficient is a statistical measure of the strength of the relationship between the relative movements of two variables. The values range between -1.0 and 1.0. A correlation of -1.0 shows a perfect negative correlation, while a correlation of 1.0 shows a perfect positive correlation.

## What does R Squared mean in Excel?

What is r squared in excel? The R-Squired of a data set tells how well a data fits the regression line. It is used to tell the goodness of fit of data point on regression line. It is the squared value of correlation coefficient. This is often used in regression analysis, ANOVA etc.