Question

In: Statistics and Probability

For the attached data set, create a simple linear regression equation defining the relationship between height...

For the attached data set, create a simple linear regression equation defining the relationship between height and weight.

Use the regression equation to predict the weight for a given height of 5.75 inches

PLEASE PROVIDE EXCEL STEP CALCULATIONS

Height (in feet) X Weight   (in pounds) Y
4.8228348 115.1032102
4.92126 117.1094144
4.9868768 120.1076976
5.085302 123.1059808
5.1509188 126.104264
5.249344 129.1245934
5.3477692 132.1228766
5.413386 135.1211598
5.5118112 139.1335682
5.577428 142.1318514
5.6758532 146.1222136
5.74147 150.134622
5.8398952 154.1470304
5.905512 159.1515178
6.0039372 164.1560052

Solutions

Expert Solution

Path

Data---->>> Data analysis ---->>>Regression ---->>> Ok --->>

Select input y range

Select input x range

Give output range

Then hit on ok.

The regression equation is

Predict weight = -78.5632597 + 39.68227137 Height


Related Solutions

1. A simple linear regression model is an equation that describes the straight-line relationship between a...
1. A simple linear regression model is an equation that describes the straight-line relationship between a dependent variable and an independent variable. T or F 2. The residual is the difference between the observed value of the dependent variable and the predicted value of the dependent variable. T or F 3. The experimental region is the range of the previously observed values of the dependent variable. T or F
A paper suggests that the simple linear regression model is reasonable for describing the relationship between...
A paper suggests that the simple linear regression model is reasonable for describing the relationship between y = eggshell  thickness (in micrometers, µm) and x = egg length (mm) for quail eggs. Suppose that the population regression line is y = 0.115 + 0.007x and that σe = 0.005. Then, for a fixed x value, y has a normal distribution with mean 0.115 + 0.007x  and standard deviation 0.005. Approximately what proportion of quail eggs of length 14 mm have a shell...
.  Draw a plot of the following set of data and determine the linear regression equation.  What is...
.  Draw a plot of the following set of data and determine the linear regression equation.  What is the      value of the slope and intercept?   What is r and R2?  Are there any outlier values?   (15 points)                                 Age (X):     20  25  36  29  41  35  56  43  66  50  59  67  51  75  75  81  54  66  52  48            Total Body Water (Y):     61  57  52  59  53  58  48  51  37  44  42  41  48  38  41  39  47  42  51  50  
Interpretation of the Simple Linear Regression equation. 300 words
Interpretation of the Simple Linear Regression equation. 300 words
What is the difference between a linear relationship and a curvilinear relationship in linear regression?
What is the difference between a linear relationship and a curvilinear relationship in linear regression?
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary...
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary...
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           
Simple linear regression is used to analyse the relationship between company sales and company profit. The...
Simple linear regression is used to analyse the relationship between company sales and company profit. The following tables are multiple linear regression output. Is there a linear relationship between company sales and company profit at the significance level of 0.05? Give your evidence. Click or tap here to enter text. What percentage of variance (Coefficient of Determination) of company profit is explained by company sales? Click or tap here to enter text. Give the value of the slope and intercept...
What is the difference between simple linear regression and multiple linear regression? What is the difference...
What is the difference between simple linear regression and multiple linear regression? What is the difference between multiple linear regression and logistic regression? Why should you use adjusted R-squared to choose between models instead of R- squared? Use SPSS to: Height (Xi) Diameter (Yi) 70 8.3 72 10.5 75 11.0 76 11.4 85 12.9 78 14.0 77 16.3 80 18.0 Create a scatterplot of the data above. Without conducting a statistical test, does it look like there is a linear...
Number 1 Say that you want to use simple linear regression to model the relationship between...
Number 1 Say that you want to use simple linear regression to model the relationship between the explanatory variable x= the number of alcoholic drinks consumed per week, and the response variable y= number of hours of exercise per week. You collect data on n=52 people, and find the regression line ŷ=10-0.3x. (2 pts) What is the theoretical model underlying your regression analysis? (4 pts) Say that Lorenzo has six alcoholic drinks a week. Predict how many hours he will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT