Question

In: Statistics and Probability

Need Linear Regression Analysis done for the following data: Day BP Diastolic Ate Healthy and Exercised...

Need Linear Regression Analysis done for the following data:

Day

BP Diastolic

Ate Healthy and Exercised

1

85

N

2

109

N

3

96

N

4

92

N

5

99

N

6

98

N

7

102

Y

8

93

N

9

90

Y

10

84

N

11

90

N

12

86

N

13

81

N

14

77

Y

15

90

Y

16

86

Y

17

83

N

18

80

Y

19

78

N

20

74

Y

21

72

Y

22

79

Y

23

84

Y

24

91

Y

25

85

Y

26

77

Y

27

78

Y

28

81

N

29

88

Y

30

85

Y

31

77

Y

32

74

Y

33

72

Y

34

77

N

35

80

Y

36

81

Y

37

76

Y

38

78

Y

39

72

Y

40

73

Y

41

72

Y

42

79

Y

43

80

Y

44

84

Y

45

81

Y

46

78

Y

47

71

Y

48

73

Y

49

76

Y

50

75

Y

51

76

N

52

81

Y

53

78

N

54

75

Y

55

77

Y

56

76

Y

Solutions

Expert Solution

Let us consider BP Diastolic(Y) is dependent variable and Ate Healthy and Exercised(X) is independent varaible

Ate Healthy and Exercised(X) :

If X = 1, Ate Healthy and Exercised (Yes)

X = 0, Do not ate Healthy and Exercised (No)

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.44587202
R Square 0.198801858
Adjusted R Square 0.183964856
Standard Error 7.473174191
Observations 56
ANOVA
df SS MS F Significance F
Regression 1 748.3150452 748.3150452 13.39905798 0.000573317
Residual 54 3015.809955 55.8483325
Total 55 3764.125
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 87.41176471 1.812510974 48.22688854 4.43011E-46 83.777899 91.04563042 83.777899 91.04563042
Ate Healthy and Exercised(X) -7.950226244 2.171912649 -3.660472371 0.000573317 -12.30464893 -3.595803559 -12.30464893 -3.595803559

BP Diastolic(Y) = 87.4118 - 7.9502 * Ate Healthy and Exercised(X)

R^2 = 0.1988,

19.88% of variation in Y variable is explained by variation in X variable

If X = 1, Ate Healthy and Exercised (Yes)

BP Diastolic(Y) = 87.4118 - 7.9502 * 1 = 79.4616

X = 0, Do not ate Healthy and Exercised (No)

BP Diastolic(Y) = 87.4118 - 7.9502 * 0 = 87.4118


Related Solutions

You will need to use Excel Regression Data Analysis to estimate the following linear model of...
You will need to use Excel Regression Data Analysis to estimate the following linear model of Texas Natural Gas Utility Residential Demand: (1) QRES = α + β1*PRES + β2*RES + β3*INCOME where QRES = Quantity demand (mcfs) of residential customers PRES = Price per mcf, RES = number of residential customers, INCOME = per capita income, The data below are actual publicly available residential demand data for city/town natural gas distribution utilities in Texas. You can copy and paste...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are testing whether SAT scores are predictive of overall college GPA. Also, write out the regression equation. How would you interpret your results? SAT Score GPA 670 1.2 720 1.8 750 2.3 845 1.9 960 3.0 1,000 3.3 1,180 3.2 1,200 3.4 1,370 2.9 1,450 3.8 1,580 4.0 1,600 3.9
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 6. Is there a significant relationship? Clearly explain your reasoning using the regression results. Number of Promotions Total Sales 3 2554 2 1746 11 2755 14 1935 15 2461 4 2727 5 2231 14 2791 12 2557 4 1897 2 2022 7 2673 11 2947 11 1573 14 2980
A linear industry demand function of the form: Q=a+bP+cM+dPr was estimated using regression analysis. The results...
A linear industry demand function of the form: Q=a+bP+cM+dPr was estimated using regression analysis. The results of this estimation are as follows: Dependant Variable: Q R-Square F-Ratio P=Value on F Observations: 32 0.9419 151.32 0.0001 Variable Parameter Estimate Standard Error T-Ratio P-Value Intercept 11408.60 2256.32 5.06 0.0001 P -432.59 107.27 -4.03 0.0004 M -0.0885 0.02341 -3.78 0.0008 PR 126.35 71.77 1.76 0.0892 What do the estimated parameters for b, c and d imply about P (the product’s price), M (consumer...
Consider the following problem involving linear correlation and linear regression: How much should a healthy calf...
Consider the following problem involving linear correlation and linear regression: How much should a healthy calf weigh? The following are taken from The Merck Veterinary Manual.  x is the age in weeks and y is the weight of a normal, healthy calf in kilograms. x 1 3 10 16 26 36 y 42 50 75 100 150 200    Which of the following would be the correct equation of the regression line?  enter a capital letter, no space, no period         A.   y =...
I need a regression analysis done on the following numbers. IC Price Income Temp Lag-temp 0.386...
I need a regression analysis done on the following numbers. IC Price Income Temp Lag-temp 0.386 0.27 78 41 56 0.374 0.282 79 56 63 0.393 0.277 81 63 68 0.425 0.28 80 68 69 0.406 0.272 76 69 65 0.344 0.262 78 65 61 0.327 0.275 82 61 47 0.288 0.267 79 47 32 0.269 0.265 76 32 24 0.256 0.277 79 24 28 0.286 0.282 82 28 26 0.298 0.27 85 26 32 0.329 0.272 86 32 40...
A study was conducted with vegetarians to see if the number of grams of protein each ate per day was related to diastolic blood pressure
A study was conducted with vegetarians to see if the number of grams of protein each ate per day was related to diastolic blood pressure. The data is given below. Estimate the blood pressure if a vegetarian consumes 7.4 grams of protein per day grams protein --4-- 6.5-- 5-- 5.5-- 8-- 10-- 9-- 8.2-- 10.5dia. pressure-- 73-- 79-- 83-- 82-- 84- -92- 88- 86--- 95
Simple Linear Regression: Suppose a simple linear regression analysis provides the following results: b0 = 6.000,    b1...
Simple Linear Regression: Suppose a simple linear regression analysis provides the following results: b0 = 6.000,    b1 = 3.000,    sb0 = 0.750, sb1 = 0.500,  se = 1.364 and n = 24. Use this information to answer the following questions. (a) State the model equation. ŷ = β0 + β1x ŷ = β0 + β1x + β2sb1    ŷ = β0 + β1x1 + β2x2 ŷ = β0 + β1sb1 ŷ = β0 + β1sb1 x̂ = β0 + β1sb1 x̂ = β0 +...
Importance of linear regression in research analysis.
Importance of linear regression in research analysis.
In a simple linear regression analysis, will the estimate of the regression line be the same...
In a simple linear regression analysis, will the estimate of the regression line be the same if you exchange X and Y? Why or why not?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT