Thank you Charles.I’ll read more on time series. Then a one sample Hotelling’s T-square test (a simple version of MANOVA) could be used against the scores of 8 zeros to see whether there is a significant difference between sample and a neutral rating of a vector with 8 zeros.
EXCEL LINEAR REGRESSION WITH DATES CODE
assuming each respondent gives 8 scores and factor analysis is not used, we can code the 5 point Likert scale as -2, -1, 0, 1, 2 where the negative values favor country X and the positive scores favor country Y. Whether you have 8 factors or a lower number after using Factor Analysis, you can use some version of MANOVA for statistical testing. Assuming the scores are based on some questionnaire, you can use Cronbach’s alpha to determine reliability.ģ. In this case the approach using Factor Analysis may make sense to find the latent factors (thereby reducing 8 initial factors to a lesser number). Assuming the latter, I understand that each respondent gives 8 scores.
![excel linear regression with dates excel linear regression with dates](https://i.ytimg.com/vi/8tREFTiFXdk/maxresdefault.jpg)
Does each respondent give a score in the 5 point Likert scale to country X and another score for country Y? Or does each respondent give one score which compares the two countries (for each of the 8 levels)?Ģ.
EXCEL LINEAR REGRESSION WITH DATES HOW TO
We show how to apply the techniques of multiple linear regression to polynomial models and to the analysis of variables (ANOVA).
![excel linear regression with dates excel linear regression with dates](https://www.online-tech-tips.com/wp-content/uploads/2020/11/linear-regression-trendline-9.png)
We explore how to find the coefficients for these multiple linear regression models using the method of least squares, how to determine whether independent variables are making a significant contribution to the model and the impact of interactions between variables on the model. In this part of the website, we extend the concepts from Linear Regression to models that use more than one independent variable.