2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line.

X-Bar	2	4	5	6
Y-Bar	7	11	13	20

Solutions

Expert Solution

Solution:

Here, we have to find the regression line for the prediction of the dependent variable y based on the independent variable x. The regression output by using excel is given as below:

Regression Statistics
Multiple R	0.941978738
R Square	0.887323944
Adjusted R Square	0.830985915
Standard Error	2.236067977
Observations	4

ANOVA
	df	SS	MS	F	Significance F
Regression	1	78.75	78.75	15.75	0.058021262
Residual	2	10	5
Total	3	88.75

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	0	3.401680257	0	1	-14.63624884	14.63624884
x	3	0.755928946	3.968626967	0.058021262	-0.252499743	6.252499743

The required regression equation is given as below:

ŷ = 0 + 3*x

ŷ = 3x

orchestra answered 1 year ago

Next > < Previous

Related Solutions

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

Use the data below to solve the following problem using excel: 1 a) Import the data...

Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...

Find the regression equation using the following set of data with y as the response variable....

Find the regression equation using the following set of data with y as the response variable. x y 40.2 82.2 54.2 111.8 43 84.3 30.7 68.5 33 90.8 42.8 78.5 30.9 71.7 28.6 69.8 36.6 83.1 41.1 93.9 26.6 63.9 45.5 95.5 What is the correlation coefficient? use three decimal places. r = What is the regression line equation. Use each value to three decimal places. ˆyy^ = + x What is the predicted value of the response variable, when using a...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...

Using the data in the Excel file under the tab Problem1, develop a regression equation for...

Using the data in the Excel file under the tab Problem1, develop a regression equation for a country’s lung cancer death rate based on cigarette consumption. Is this a good regression model? Why or why not? If Cigarette Consumption was 725, what would you predict the Lung Cancer Death Rate to be? Using your regression model, what is the Residual Value for Finland? Do you think there are any outliers in the model? If so, what would you do with them? Country...

Use the given data to find the equation of the regression line. Examine the scatterplot and...

Use the given data to find the equation of the regression line. Examine the scatterplot and identify a characteristic of the data that is ignored by the regression line. x 44 1212 99 77 33 1111 1010 88 55 1313 66 y 3.643.64 8.448.44 9.309.30 8.108.10 1.441.44 9.089.08 9.369.36 8.888.88 5.485.48 7.447.44 6.966.96

Use the given data to find the equation of the regression line. Examine the scatterplot and...

Use the given data to find the equation of the regression line. Examine the scatterplot and identify a characteristic of the data that is ignored by the regression line. x y 9 7.7 7 6.58 13 13.22 10 6.93 12 7.56 14 9.01 7 6.28 4 5.18 11 8.46 8 6.68 5 5.48

Use the given data to find the equation of the regression line. Examine the scatterplot and...

Use the given data to find the equation of the regression line. Examine the scatterplot and identify a characteristic of the data that is ignored by the regression line. x 66 5 10 9 7 11 8 12 14 15 13 y 4.19 2.42 8.22 7.67 5.66 8.47 6.81 8.41 7.39 6.42 8.06 y with caret =__+__x (Round to two decimal places as needed.) Create a scatterplot of the data. Choose the correct graph below. Identify a characteristic of the...

Use the given data to find the equation of the regression line. Examine the scatterplot and...

Use the given data to find the equation of the regression line. Examine the scatterplot and identify a characteristic of the data that is ignored by the regression line. x y 12 18.26 7 13.01 8 14.67 13 18.39 4 6.22 6 11.06 5 8.79 14 18.22 11 17.81 9 16.02 10 17.07 y= Create a scatterplot of the data. Choose the correct graph Identify a characteristic of the data that is ignored by the regression line.

Use the given data to find the equation of the regression line. Examine the scatterplot and...

Use the given data to find the equation of the regression line. Examine the scatterplot and identify a characteristic of the data that is ignored by the regression line. x 8 10 12 11 6 4 3 13 7 5 9 y 14.75 16.69 17.31 17.17 11.49 6.91 4.13 17.13 13.28 9.37 15.88 Modifying Above y with caret equals nothing plus nothing x

Subjects