Question 100)
Professional basketball has truly become a sport that generates interest among fans around the world. More and more players come from outside the United States to play in the National Basketball Association (NBA). You want to develop a regression model to predict the number of wins achieved by each NBA team, based on field goal (shots made) percentage and three-point field goal percentage.
1) Estimate the following multiple regression model (copy and paste the results from either Minitab
Wini=b0+b1FieldGoali+b2Threepoint+ei
2) Interpret the meanings of the coefficients of the regression model.
3) Predict the mean number of wins for a team that has a field goal percentage of 45% and a three-point field goal percentage of 35%.
4) Perform a residual analysis on your results and determine whether the regression assumptions are valid.
5) Using t-test, show if the field goal percent or the three point field goal percent are significant at the 0.05 level of significance using the following hypothesis? (Use the p-values to explain without using t-table)
a. Ho: β1=0, Ha:β1≠0
b. Ho: β2=0, Ha:β2≠0
7) Interpret the meaning of the coefficient of multiple determination (r2) in this problem.
8) Show how to calculate the adjusted r2. Explain the difference between r2 and adjusted r2.
9) At the 0.05 level of significance, perform a F test to determine whether the regression model has any significant variable. Setup your hypothesis and perform the test using p-value to explain.
10) Show how to compute the 95% confidence interval of the estimated coefficients and explain their meanings.
AS THE QUESTION WAS GETTING TOO LONG TO POST, PLEASE FIND A COPYABLE TABLE POSTED UNDER THE NAME "QUESTION 100"
A required regression model to predict the number of wins achieved by each NBA team, based on field goal (shots made) percentage and three-point field goal percentage is given as below:
Regression Statistics |
||||||
Multiple R |
0.692945243 |
|||||
R Square |
0.48017311 |
|||||
Adjusted R Square |
0.441667414 |
|||||
Standard Error |
9.132542725 |
|||||
Observations |
30 |
|||||
ANOVA |
||||||
df |
SS |
MS |
F |
Significance F |
||
Regression |
2 |
2080.109911 |
1040.054956 |
12.47018402 |
0.000145913 |
|
Residual |
27 |
2251.890089 |
83.40333662 |
|||
Total |
29 |
4332 |
||||
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
Intercept |
-263.4928464 |
63.09278893 |
-4.176275147 |
0.000277207 |
-392.9485546 |
-134.0371381 |
Field Goal % |
4.409542804 |
1.242684914 |
3.548399723 |
0.001442028 |
1.859764005 |
6.959321604 |
Three-Point Field Goal % |
2.806937603 |
1.656982407 |
1.694005676 |
0.101771186 |
-0.592909427 |
6.206784632 |
5)
p-value of Fied Goal (b1) = 0.00144 < alpha
hence it is significant
whereas p-value of Three-point fireld goal(b2) is 0.1018 >
alpha
hence it is not significant
7)
r^2 = 0.4802
this means 48.02 % of variation in the number of wins can be explained by this model
8)
adjusted R^2 = 0.4417
= 1 - (1-R^2)(n-1)/(n-k-1)
= 1 - (1- 0.480173)*29/27
= 0.441667
r^2 always increases when we increase more independent
variables
but adjusted r^2 penalizes for adding more independent
variables
hence for multiple regression, adjusted r^2 is more useful
9)
From this regression model, the p-value or overall model is
given as 0.0001459 which is very less than alpha value 0.05,
so we reject the null hypothesis that the given regression model is
not statistically significant.
There is sufficient evidence to conclude that this regression model
is statistically significant for prediction of the wins for a
team.
Please rate if helpful
By HomeworkLib answering guidelines, we have to answer only first 4 sub-parts in multiple sub-parts
Please post rest questions again if left
Question 100) Professional basketball has truly become a sport that generates interest among fans around the...
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...
gold ($/oz) Y copper (cents/lb) X1 silver ($/oz) X2 Aluminum (cents/lb) X3 161.1 64.2 4.4 39.8 308 93.3 11.1 61 613 101.3 20.6 71.6 460 84.2 10.5 76 376 72.8 8 76 424 76.5 11.4 77.8 361 66.8 8.1 81 318 67 6.1 81 368 66.1 5.5 81 448 82.5 7 72.3 438 120.5 6.5 110.1 382.6 130.9 5.5 87.8 Statistics 11 Homework 9 Due Wednesday, Nov. 20 Metals.jmp lists the yearly average price of gold, copper, silver, and aluminum....
The director of a training program for a large insurance company has the business objective of determining which training method is best for training underwriters. The three methods to be evaluated are classroom, online, and courseware app. The 30 trainees are divided into three randomly assigned groups of 10. Before the start of the training, each trainee is given a proficiency exam that measures mathematics and computer skills. At the end of the training, all students take the same endof-...
The National Basketball Association (NBA) records a variety of statistics for each team. Five of these statistics are he percentage of games won (Win %), the percentage of field goals made (FG%), the percentage of three-point shots made (3P%), the percentage of the free throws made (FT%), the average number of offensive rebounds per game (RBOff), and the average number of defensive rebounds per game (RBDef). The data given in the table below show the values of these statistics for...
Q3. 47 ptsSuppose the weight (y) of babies depends on their height (xi) and age (x2). The following table presents the data for a sample of 5 babies and some results of analysis of the data are also given below. 2 | 4 | 5 | 7|8| Given that (XX) xi | 1.5 | 2 | 2.5 | 3.5 | 3 | [16.4286-14.2857 4.428571 Corr matrix 1.00 0.985 0.985 1.000 0.8285 X2 1 35 7 614.2857 13.25714.285710.3142 3) 0.7142 4.42857-4.2857...
A movie analyst wants to predict revenue ("revenue") in $millions using the length of the movie in minutes ("runtime") and the budget of the film ("budget") in millions of dollars. A multiple linear regression model, where Y = revenue, X1 = runtime, and X2 = budget, has been fit. The output, with some missing values shaded, is displayed below. Regression Statistics Multiple R 0.682240936 R Square Adjusted R Square 0.461124376 Standard Error 63.95889146 Observations 250 ANOVA df Significance F 2.54853E-34...
Another researcher was interested in examining academic performance among teenage students. However, based on her literature review, she expected that ethnicity, parental support, and stress level would predict academic performance. Further, her study was based in New York. Therefore, she collected data from one hundred and fifty (150) students from a school in New York. She hypothesized that parental support would positively predict academic performance, while stress would negatively predict academic performance. She also hypothesized that ethnicity would predict academic...
1. One Price Realty Company wants to develop a model to estimate the value of houses in its inventory The office manager has decided to develop a multiple regression model to help explain the variation in house values. (25 points) The office manager has chosen the following variables to develop the model: X1 square feet X2- age in years x3- dummy variable for house style (1 if ranch, 0 if not) X4-2d dummy variable for house style (I if split...
PLEASE SHOW ALL EXCEL FORMULAS USED FOR EACH CALCULATIONS. A STEP BY STEP WALKTHROUGH OF HOW TO DO THE PROBLEM. Thank you so much for your help! Hours Feet Elevator Elevator code 24.00 545 Yes 1 13.50 400 Yes 1 26.25 562 No 0 25.00 540 No 0 9.00 220 Yes 1 20.00 344 Yes 1 22.00 569 Yes 1 11.25 340 Yes 1 50.00 900 Yes 1 12.00 285 Yes 1 38.75 865 Yes 1 40.00 831 Yes 1...
Question 1 Which of the following choices best describes the scatterplot shown below? Group of answer choices Linear, negative, strong No form, weak Linear, positive, strong Curved, weak Question 2 Which of the following choices is most likely to be the correlation of the data in the scatterplot shown below? Group of answer choices -0.14 1.04 0.86 -0.92 Question 3 Most roller coasters get their speed by dropping down a steep initial incline, so it makes sense that we can...