Question: Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of

Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak The National Football League (NFL) records a variety of performance data for individuals and teams. To investigate the importance of passing on the percentage of games won by a team, the data in the Excel Online file below show the conference (Conf), average number of passing yards per attempt (Yds/Att), the number of interceptions thrown per attempt (Int/Att), and the percentage of games won (Win%) for a random sample of 16 NFL teams for a season. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. Develop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt (to 1 decimal). Win%=bo+b Yds/Att bo = -57.3 b =16.3 b. Develop the estimated regression equation that could be used to predict the percentage of games won given the number of interceptions thrown per attempt (to 1 decimal). Win%=bo+b Int/Att bo 95.8 b 1536.5 c. Develop the estimated regression equation that could be used to predict the percentage of games won given the average number of passing yards per attempt and the number of interceptions thrown per attempt (to 1 decimal). Win% bo+b Yds/Att + b Int/Att bo = -6.3 b = 12.7 b -988.8 d. The average number of passing yards per attempt for the Kansas City Chiefs was 6.2 and the number of interceptions thrown per attempt was 0.036. Use the estimated regression equation developed in part (c) to predict the percentage of games won by the Kansas City Chiefs. (Note: For this season the Kansas City Chiefs' record was 7 wins and 9 losses.) Compare your prediction to the actual percentage of games won by the Kansas City Chiefs (to whole number). Predicted percentage 37 Actual percentage 44

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Major League Baseball (MLB) consists of teams that play in the American League and the National League. MLB collects a wide variety of team and player statistics. Some of the statistics often used to...

An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression...

All information (question & data from spreadsheet to solve) are posted below. Thank you in advance for your help! tivity 2 - Multiple Regression, F-Test for Overall Significance, t-Test for Variable...

All information is provided below. Complete problem and data that needs to be used in order to solve. The International League of Triple-A minor league baseball consists of 14 teams organized into...

An important application of regression analysis in accounting is in the estimation of cost, By collecting data on volume and cost and using the least squares method to develop an estimated regression...

I need help with problem b. I can't figure out the mean price per share has increase between ________% and 21.0% over the three-month period (to 1 decimal. The price per share of stock for a sample...

1 Let A = {{a,{a}},a,}. Then: EA- True False 2 Let A = {{a,{a}},a,}, then {a,{a}}CA. True False

Using the information in P11-3B, compute the overhead controllable variance and the overhead volume variance. Data From P11-3B, Zimmerman Clothiers manufactures womens business suits. The company...

Risk assessment procedures are performed by the auditor to assess the risk of material misstatement in the financial statements. Below are four types of further audit procedures the auditor should...

Classify the following environmental activities as prevention costs, detection costs, internal failure costs, or external failure costs. For external failure costs, classify the costs as societal or...

Hazzid Realty sold lots for $15 120 per 1000 square metre. What is the total sales value if the lot sizes, in 1000 square metre, were 5 14, 6 13, 4 38, and 3 56?

Javier Company has sales of $8 million and quality costs of $1,600,000. The company is embarking on a major quality improvement program. During the next three years, Javier intends to attack failure...

The following items were gathered from Rindt Industries general ledger: Sale of marketable securities............ $14,000 Depreciation and amortization expense........ 24,262 Payment of cash...

Terry Holden's stepmother, Rosie, was diagnosed with amyotrophic lateral sclerosis (ALS), and Terry's wife, Susan, became Rosie's primary caregiver. Rosie executed a durable power of attorney...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Compute Present Value of Tax Shield: The Financial Press Co. plans to acquire desktop publishing equipment at a cost of $200,000 that will be depreciated for tax purposes as follows: Year 1 ,...

Effects of Inflation on Cash Flows: Refer to exercise 15-18. Would your answer be different if you had used real (no- inflation) cash flows and discount rate instead of the nominal amounts in 15-18?

Present Value of Depreciation Tax Shield under Inflation: Refer to the data in exercise 15-20. Required: a. Using the accelerated tax depreciation deductions in exercise 15-20, what is the present...