Q1 Collect sufficient data about any two quantitative variables (logically correlated) using reasonable sets of values (At least 20 values). Use Microsoft Excel and answer the following: First: Determine the independent variable and the dependent variable. Second: Make the correlation analysis, determine the correlation coefficient, and interpret it. Third: Conduct the regression analysis and answer the following questions: What is the type of regression in your example? Write the sample size. Find the degrees of freedom.
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
Q1
Collect sufficient data about any two quantitative variables (logically correlated) using reasonable sets of values (At least 20 values).
Use Microsoft Excel and answer the following:
First: Determine the independent variable and the dependent variable.
Second: Make the
Third: Conduct the
- What is the type of regression in your example?
- Write the
sample size . - Find the degrees of freedom.
- Find the value of the coefficient of determination, and interpret it.
- Is your model valid? Why?
- Is the independent variable having a significant effect on the dependent variable? Why?
- Write down the regression line equation.
- Estimate the value of ŷ at any value of X.
Step by step
Solved in 4 steps with 2 images
