please I need help with the R program code with output and explanation for the following questions.

Question 1

Data Pair Income Expenditure

1 56 147

2 42 125

3 72 160

4 36 118

5 63 149

6 47 128

7 55 150

8 49 145

9 38 115

10 42 140

11 68 152

12 60 155

The following dataset "under question 2 by save in excel document" shows the income in thousands of Dolar per (Predictor) and Expenditure in thousands of Dolar per year (Response) of 12 persons, selected at random. Answer the following questions:

a)Construct a simple linear regression equation for the data. State the regression equation.

b)Interpret the estimated regression equation.

c)Interpret the coefficient of determination for the regression equation.

Question 2

X1 X2 Y X4 X5 X6 X7

44 89.47 44.609 11.37 62 178 182

40 75.07 45.313 10.07 62 185 185

44 85.84 54.297 8.65 45 156 168

42 68.15 59.571 8.17 40 166 172

38 89.02 49.874 9.22 55 178 180

47 77.45 44.811 11.63 58 176 176

40 75.98 45.681 11.95 70 176 180

43 81.19 49.091 10.85 64 162 170

44 81.42 39.442 13.08 63 174 176

38 81.87 60.055 8.63 48 170 186

44 73.03 50.541 10.13 45 168 168

45 87.66 37.388 14.03 56 186 192

45 66.45 44.754 11.12 51 176 176

47 79.15 47.273 10.6 47 162 164

54 83.12 51.855 10.33 50 166 170

49 81.42 49.156 8.95 44 180 185

51 69.63 40.836 10.95 57 168 172

51 77.91 46.672 10 48 162 168

48 91.63 46.774 10.25 48 162 164

49 73.37 50.388 10.08 67 168 168

57 73.37 39.407 12.63 58 174 176

54 79.38 46.08 11.17 62 156 165

52 76.32 45.441 9.63 48 164 166

50 70.87 54.625 8.92 48 146 155

51 67.25 45.118 11.08 48 172 172

54 91.63 39.203 12.88 44 168 172

51 73.71 45.79 10.47 59 186 188

57 59.08 50.545 9.93 49 148 155

49 76.32 48.673 9.4 56 186 188

48 61.24 47.92 11.5 52 170 176

52 82.78 47.467 10.5 53 170 172

Use the dataset under question 2 by save it in an excel document. This dataset relates to aerobatic exercises. It was measured by the ability to consume oxygen. The reason for their investigation was in order to develop an equation to predict fitness based on the exercise tests rather than excessive and expensive tests.

Variables Description

X1 age in years

X7 maximum heart rate

Y oxygen consumption

X5 heart rate while resting

X6 heart rate while running

X4 minutes to run 1.5 miles

X2 weight in kg

a)Construct a multiple regression model, include all the predictor variables and provide the estimated multiple regression equation and interpret the R-Square statistic.

b)Create the code to conduct a constancy of error variance (Breusch Pagan) using Oxygen as your Y variable and the rest of the variables as your independent variables.

c)Discuss the results of the Homoscedascity Test using the appropriate hypothesis and provide a conclusion based on error variance.