The provided Excel image shows a dataset consisting of ten Explanatory values stored within the cell range of A2 through A11, and ten corresponding Response values stored within the cell range of B2 through B11. Compute a least-squares linear regression model for this dataset. Using the model: What is the percentage value, of the Coefficient of Determination? Round to two digits past the decimal point, and include a percentage symbol after your answer (with no spaces). ________________________________________ Using the model: What Response value is predicted to result from an Explanatory value of 74? (Round to two digits past the decimal point) __________________________________________ Hint: Coefficient of Determination: Remember this is the value which results when we square the correlation Remember to give your answer in percentage format Remember to include a percentage symbol after your answer (with no spaces) Remember we can tell Excel to show this value directly on the picture of the scatterplot and regression line Remember to round to two digits past the decimal point Predicting a Response value from an Explanatory value: Your answer for this question is just a decimal value answer, and not a percentage Remember, this can be calculated using the TREND function in Excel Remember to round to two digits past the decimal point
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.
The provided Excel image shows a dataset consisting of ten Explanatory values stored within the cell
Compute a least-squares linear regression model for this dataset.
Using the model: What is the percentage value, of the Coefficient of Determination?
Round to two digits past the decimal point, and include a percentage symbol after your answer (with no spaces).
Using the model: What Response value is predicted to result from an Explanatory value of 74?
(Round to two digits past the decimal point)
Coefficient of Determination:
- Remember this is the value which results when we square the
correlation - Remember to give your answer in percentage format
- Remember to include a percentage symbol after your answer (with no spaces)
- Remember we can tell Excel to show this value directly on the picture of the
scatterplot and regression line - Remember to round to two digits past the decimal point
Predicting a Response value from an Explanatory value:
- Your answer for this question is just a decimal value answer, and not a percentage
- Remember, this can be calculated using the TREND
function in Excel - Remember to round to two digits past the decimal point
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
