Consider the National Football League data in Table B.1. a. Fit a multiple linear regression model...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the National Football League data in Table B.1. a. Fit a multiple linear regression model relating the number of games won to the team's passing yardage (x₂), the percentage of rushing plays (x7), and the opponents' yards rushing (xs). b. Construct the analysis-of-variance table and test for significance of regression. c. Calculate t statistics for testing the hypotheses Ho: B₂ = 0, Ho: B₁ = 0, and Ho: Ps= = 0. What conclusions can you draw about the roles the variables x2, X7, and xs play in the model? d. Calculate R² and Råd for this model. Adj e. Using the partial F test, determine the contribution of x7 to the model. How is this partial F statistic related to the t test for B, calculated in part c above? TABLE B.1 National Football League 1976 Team Performance Team y X1 X3 X₂ Washington 10 2113 Minnesota 11 2003 New 1985 38.9 2855 38.8 64.7 61.3 60.0 +14 X4 Xs X6 X7 X8 +4 868 59.7 2205 1917 +3 615 55.0 2096 1575 11 2957 1737 40.1 914 65.6 1847 2175 England Oakland 13 2285 2905 41.6 45.3 -4 957 61.4 1903 2476 Pittsburgh 10 2971 1666 39.2 53.8 +15 836 66.1 1457 1866 Baltimore 11 2309 2927 39.7 74.1 +8 786 61.0 1848 2339 Los Angeles 10 2528 2341 38.1 65.4 +12 754 66.1 1564 2092 Dallas 11 2147 2737 37.0 78.3 -1 761 58.0 1821 1909 Atlanta 4 1689 1414 42.1 47.6 714 57.0 2577 2001 Buffalo 2 2566 1838 42.3 54.2 -1 797 58.9 2476 2254 Chicago 7 2363 1480 37.3 48.0 984 67.5 1984 2217 Cincinnati 10 2109 2191 39.5 51.9 700 57.2 1917 1758 Cleveland 9 2295 2229 37.4 53.6 1037 58.8 1761 2032 Denver 9 1932 2204 35.1 71.4 986 58.6 1709 2025 Detroit 6 2213 2140 38.8 58.3 819 59.2 1901 1686 5 1722 1730 36.6 52.6 -19 791 54.4 2288 1835 Green Bay Houston Kansas City 5 1498 2072 35.3 59.3 776 49.6 2072 1914 5 1873 2929 41.1 55.3 789 54.3 2861 2496 6 2118 2268 38.2 69.6 582 58.7 2411 2670 Miami New 4 1775 1983 39.3 78.3 901 51.7 2289 2202 Orleans 3 1904 1792 39.7 38.1 -9 734 61.9 2203 1988 New York Giants New York 3 1929 1606 39.7 68.8 -21 627 52.7 2592 2324 2080 68.8 -8 57.8 2053 2550 Jets Philadelphia St. Louis San Diego San 1492 35.5 2835 35.3 722 683 59.7 10 2301 74.1 +2 1979 2110 2040 2416 38.7 50.0 0 576 54.9 2048 2628 8 2447 1638 39.9 57.1 -8 848 65.3 1786 1776 Francisco Seattle 2 1416 37.4 56.3 -22 43.8 2876 2524 2649 1503 39.3 47.0 684 -9 875 53.5 Tampa Bay 0 1503 2560 2241 y: Games won (per 14-game season) 1₁: Rushing yards (season) X₂: Passing yards (season) x: Punting average (yards/punt) x: Field goal percentage (FGs made/FGs attempted 2season) Xs: Turnover differential (turnovers acquired-turnovers lost) x: Penalty yards (season) x: Percent rushing (rushing plays/total plays) x₂: Opponents' rushing yards (season) X: Opponents' passing yards (season) 4066 7477487345 +19 +6 -5 +3 +6 -5 +10 +6 Consider the National Football League data in Table B.1. a. Fit a multiple linear regression model relating the number of games won to the team's passing yardage (x₂), the percentage of rushing plays (x7), and the opponents' yards rushing (xs). b. Construct the analysis-of-variance table and test for significance of regression. c. Calculate t statistics for testing the hypotheses Ho: B₂ = 0, Ho: B₁ = 0, and Ho: Ps= = 0. What conclusions can you draw about the roles the variables x2, X7, and xs play in the model? d. Calculate R² and Råd for this model. Adj e. Using the partial F test, determine the contribution of x7 to the model. How is this partial F statistic related to the t test for B, calculated in part c above? TABLE B.1 National Football League 1976 Team Performance Team y X1 X3 X₂ Washington 10 2113 Minnesota 11 2003 New 1985 38.9 2855 38.8 64.7 61.3 60.0 +14 X4 Xs X6 X7 X8 +4 868 59.7 2205 1917 +3 615 55.0 2096 1575 11 2957 1737 40.1 914 65.6 1847 2175 England Oakland 13 2285 2905 41.6 45.3 -4 957 61.4 1903 2476 Pittsburgh 10 2971 1666 39.2 53.8 +15 836 66.1 1457 1866 Baltimore 11 2309 2927 39.7 74.1 +8 786 61.0 1848 2339 Los Angeles 10 2528 2341 38.1 65.4 +12 754 66.1 1564 2092 Dallas 11 2147 2737 37.0 78.3 -1 761 58.0 1821 1909 Atlanta 4 1689 1414 42.1 47.6 714 57.0 2577 2001 Buffalo 2 2566 1838 42.3 54.2 -1 797 58.9 2476 2254 Chicago 7 2363 1480 37.3 48.0 984 67.5 1984 2217 Cincinnati 10 2109 2191 39.5 51.9 700 57.2 1917 1758 Cleveland 9 2295 2229 37.4 53.6 1037 58.8 1761 2032 Denver 9 1932 2204 35.1 71.4 986 58.6 1709 2025 Detroit 6 2213 2140 38.8 58.3 819 59.2 1901 1686 5 1722 1730 36.6 52.6 -19 791 54.4 2288 1835 Green Bay Houston Kansas City 5 1498 2072 35.3 59.3 776 49.6 2072 1914 5 1873 2929 41.1 55.3 789 54.3 2861 2496 6 2118 2268 38.2 69.6 582 58.7 2411 2670 Miami New 4 1775 1983 39.3 78.3 901 51.7 2289 2202 Orleans 3 1904 1792 39.7 38.1 -9 734 61.9 2203 1988 New York Giants New York 3 1929 1606 39.7 68.8 -21 627 52.7 2592 2324 2080 68.8 -8 57.8 2053 2550 Jets Philadelphia St. Louis San Diego San 1492 35.5 2835 35.3 722 683 59.7 10 2301 74.1 +2 1979 2110 2040 2416 38.7 50.0 0 576 54.9 2048 2628 8 2447 1638 39.9 57.1 -8 848 65.3 1786 1776 Francisco Seattle 2 1416 37.4 56.3 -22 43.8 2876 2524 2649 1503 39.3 47.0 684 -9 875 53.5 Tampa Bay 0 1503 2560 2241 y: Games won (per 14-game season) 1₁: Rushing yards (season) X₂: Passing yards (season) x: Punting average (yards/punt) x: Field goal percentage (FGs made/FGs attempted 2season) Xs: Turnover differential (turnovers acquired-turnovers lost) x: Penalty yards (season) x: Percent rushing (rushing plays/total plays) x₂: Opponents' rushing yards (season) X: Opponents' passing yards (season) 4066 7477487345 +19 +6 -5 +3 +6 -5 +10 +6
Expert Answer:
Answer rating: 100% (QA)
Here Used Excel and solve Here y Is response variable and x2x7 and x8 is pre... View the full answer
Related Book For
Operations Management Managing Global Supply Chains
ISBN: 978-1506302935
1st edition
Authors: Ray R. Venkataraman, Jeffrey K. Pinto
Posted Date:
Students also viewed these accounting questions
-
Adams Manufacturing allocates overhead to production on the basis of direct labor costs At the beginning of the year Adams estimated total overhead of 396000 materials of 410000 and direct labor of...
-
Indusco Inc. is a Canadian Controlled Private Corporation (Company). Its taxation year ends on December 31 of every year. The Companys condensed income statement is given below. Revenue 2846000...
-
In a multiple linear regression model with two independent variables, how would you interpret the regression coefficients b 1 and b 2 ?
-
2. LIMIT COMPARISON TEST: SPECIAL CASES The Limit Comparison Test is most often used when the limit L= lim ak lies in the interval (0, oo). In the case where L is zero or infinity, we can still...
-
A small coffee shop has a single barista. Because the shop is small, there are no tables or chairs. Consequently, customers wait in a single line to order and receive their coffee and leave the shop...
-
The U.S. savings rate fell from an annual rate of around 13% in the mid-1970s to 6% at the end of 2018. What are the consequences of a declining savings rate for economic growth?
-
Indicate by letters which of the following control activities match with the following descriptions: Separation of duties (SD) Restricted access (RA) Proper authorization (PA) Adequate documents and...
-
The condensed financial statements of Murawski Company for the years 2014 and 2015 are presented shown below. (Amounts in thousands.) Compute the following ratios for 2015 and 2014. (a) Current...
-
Several of JJJ Company's important ratios are given here for the years 2018, 2019 and 2020 with the industry ratios for 2020. The company is considering borrowing more funds for expansion. JJJ...
-
Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its...
-
Mehmed is saving for retirement in 13 years. He wishes to have $270,000.00 and is expecting an APR of 7.30%. How much must he invest each month if the first of his 156 contributions will be on...
-
Sam was charged with a Part III Offence. She was served with a summons to appear in court on November 09, 2023. She retained Ari from PR LLP, a boutique Paralegal firm that runs and carries on...
-
Find solutions of + 2 == -6 x-1 x+2x+x=2
-
What is the return on investment? Assume a company reported the following results: Sales Variable expenses Contribution margin Fixed expenses Net operating income Average operating assets $ 400,000...
-
The claimant is a 23-year-old woman who fears discrimination and harassment in her country of origin. She alleges that she is a member of a minority group that is treated badly in her country and...
-
A firm makes three types of wooden cabinets A, B, C with profit margins of $35, $30 ad $24 per unit respectively Process +++ (11) (111) Time in hrs per cabinet B 5 3 A Preparation 2 Assembly 2 C 4 2...
-
b) The first analyte had a retention time of 7.0 min and a width at the base of 0.30 ml. Further experiments revealed that a non-retained compound had a retention time of 1.9 min. The volumetric flow...
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
Refer to Table 8.2 as a basis for this problem. This months master production schedule calls for the production of 180 sandals, 120 dress shoes, and 80 sneakers per eight hour shift. 1. What is the...
-
The following diagram illustrates a production system with four work stations arranged in sequence along with their number units each can produce per hour: 1. Which work station is the bottleneck? 2....
-
Jonathan Trott, the manager of the driver license center in Problem C.3, has decided to open another service counter to improve the license renewal processing service. The time to process a license...
-
The following case deals with the problem of measuring the DTA and the related valuation allowance for year 4. The assumptions are as follows: Required Measure the deferred tax accounts and any...
-
The assumptions are as follows: The company has \($3,176\) of taxable income and \($100\) of tax credits for the current year. The \($84\) DTA for \($400\) of operating loss carryforwards was...
-
The following case deals with the recognition of a DTA, a DTL, and the determination of whether a valuation allowance is needed. The basic assumptions and facts are as follows: Required Complete the...
Study smarter with the SolutionInn App