Homework Answers
| Point Differential(y) | Assist (xl) | Rebounds(x2) | Turnovers(x3) | Personal FoulsL(x4) | |||
| 1.00 | 10.00 | 18.00 | 17.00 | 26.00 | |||
| 12.00 | 16.00 | 12.00 | 17.00 | 15.00 | |||
| 23.00 | 14.00 | 30.00 | 13.00 | 15.00 | |||
| -7.00 | 8.00 | 12.00 | 18.00 | 22.00 | |||
| 13.00 | 16.00 | 12.00 | 13.00 | 12.00 | |||
| 5.00 | 8.00 | 14.00 | 12.00 | 17.00 | |||
| 2.00 | 4.00 | 20.00 | 20.00 | 20.00 | |||
| 17.00 | 13.00 | 30.00 | 15.00 | 26.00 | |||
| -5.00 | 8.00 | 12.00 | 15.00 | 21.00 | |||
| 9.00 | 9.00 | 17.00 | 11.00 | 19.00 | |||
| SUMMARY OUTPUT | |||||||
| Regression Statistics | |||||||
| Multiple R | 0.973513241 | ||||||
| R Square | 0.947728031 | ||||||
| Adjusted R Square | 0.905910456 | ||||||
| Standard Error | 2.938593082 | ||||||
| Observations | 10 | ||||||
| ANOVA | |||||||
| df | SS | MS | F | Significance F | |||
| Regression | 4 | 782.8233535 | 195.7058384 | 22.66339031 | 0.002104817 | ||
| Residual | 5 | 43.1766465 | 8.635329299 | ||||
| Total | 9 | 826 | |||||
| Coefficients | Standard Error | t Stat | P-value | Lower 90.0% | Upper 90.0% | ||
| Intercept | 0.737987697 | 8.134576792 | 0.090722322 | 0.931235556 | -15.65357804 | 17.12955343 | |
| Assist (xl) | 0.990377725 | 0.291836708 | 3.39360231 | 0.019385267 | 0.402312642 | 1.578442808 | |
| Rebounds(x2) | 0.929484754 | 0.153401136 | 6.059177757 | 0.001766728 | 0.620374043 | 1.238595464 | |
| Turnovers(x3) | -0.399408391 | 0.382229043 | -1.044945169 | 0.343911799 | -1.169618402 | 0.370801619 | |
| Personal FoulsL(x4) | -0.759419949 | 0.269283053 | -2.820155006 | 0.037101857 | -1.302038326 | -0.216801572 | |
| (a) | Regression model | y= 0.738+0.990x1 +0.929x2 -0.3999x3-0.759x4 | |||||
| (b) | H0 : There is no relationship between the X (x1,x2,x3,x4) variables and the y variable | ||||||
| H1 : There is a relationship between the X (x1,x2,x3,x4) variables and the y variable | |||||||
| ( c) | Test statistic for | ||||||
| t Stat = | |||||||
| Assist (xl) | 3.39 | ||||||
| Rebounds(x2) | 6.06 | ||||||
| Turnovers(x3) | -1.04 | ||||||
| Personal FoulsL(x4) | -2.82 | ||||||
| (d) | critical value of | ||||||
| t (0.10) and 9df = |
1.833 |
||||||
| ( e) | p value for |
Know the answer?
Add Answer to:
|
please show all the work. if you use excel please show the
screenshots. Thank you !
Question 5 (25pts) Suppose the athletic director at a university would like to develop a regression model to predict the point differential for games played by the men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of games,...
Game
Point_Differential Assists
Rebounds Turnovers Personal_Fouls
1 15 15 38
11 9
2 36 20 43
8 13
3 16 21 29
7 13
4 45 22 46
11 11
5 12 11 40
7 22
6 -10 10 31
13 26
7 11 19 45
11 7
8 12 16 32
16 14
9 3 16 27
18 15
10 19 9 34
17 17
11 40 16 41
9 17
12 44 12 29
9 22
13 16 ...
a) Construct a regression model using all four independent
variables. (Round to three decimal places as needed.)
b) Identify the general form of the null and alternative
hypotheses.
c) Find the test statistic for the coefficient of each
independent variable. (Round to two decimal places as needed.)
d) Determine the appropriate critical value(s) for α=0.10.
(Round to three decimal places as needed.)
e) Find the p-value for the coefficient of each independent
variable. (Round to three decimal places as needed.)...
please show work, attached is the data
Question 4 (25pts) A hospital would like to develop a regression model to predict the total hospital bill for a patient based on the age of the patient (x1), his or her length of stay (x2), and the number of days in the hospital's intensive care unit (ICU) (x3). Data for these variables can be found in Q4data.xlsx. Complete parts a through e below. a) Construct a regression model using all three independent...
The data show the number of viewers for television stars with certain salaries. Find the regression equation, letting the first variable be the independent (x) variable. Find the best predicted number of viewers for a television star with a salary of $6 million. Use a significance level of 0.05. Salary (millions of $) 98 7 13 12 3 13 10 2 Viewers (millions) 3.5 6.8 6.3 10.2 8.5 4.4 1.8 2.7 Click the icon to view the critical values of...
#3
#5
#6
#7
please help me!
Suppose IQ scores were obtained for 20 randomly selected sels of siblings. The 20 pairs of measurements yield x=98.82, y = 101.15, r=0.907, P-value = 0.000, and = -4.91 + 1.07x, where x represents the IQ score of the younger child. Find the best predicted value of ý given that the younger child has an IQ of 106? Use a significance level of 0.05. Click the icon to view the critical values of...
The data shown below for the dependent variable, y, and the independent variable, x, have been collected using simple random sampling. X 10 15 11 19 18 17 5 17 18 y 9070 30 8020 30 5060 40 40 a. Develop a simple linear regression equation for these data. b. Calculate the sum of squared residuals, the total sum of squares, and the coefficient of determination c. Calculate the standard error of the estimate. d. Calculate the standard error for...
0 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 9 9 12 9 12 13 6 4 11 6 6 6.99 12.56 6.96 8.03 8.99 5.89 5.39 853 621 5.98 Create a scatterplot of the data. Choose the correct graph below y 7.45 ОА OB oc OD. Ay 25 20 20 15 10 5 26 20- 15 10...
Wins Data B C A Three-Point Field Goal % Field Goal % 1 Wins 38.9 56 45.3 2 43.2 33.8 3 43 32.4 49 45.5 4 30.6 42.5 34 47 36.5 44.7 47 36.1 44.8 8 70 47.9 39,7 42 42.8 33.5 10 51 44.5 35.6 11 65 47.2 38.3 12 43.6 34.6 44 13 41 42.7 34,9 14 60 46.3 36.5 15 39 43.2 34.7 16 54 45.1 33.5 17 63 46.9 34.1 18 51 45.2 35.2 19 56...
Use the given data to find the equation of the regression ine. Examine the scatterplot and identity a characteristic of the data that is ignored by the regression ine. 10 8 13 10 12 13 5 4 11 8 6 y 7.44 6.64 12.51 6.86 7.57 8.69 6.19 5.14 8.5 6.63 5.7 Create a soutterplot of the data. Choose the correct graph below. OA ов. Oc. OD. 25+ 20 a 20 151 10 15 10 15 10 10 G G...