Use the following information to answer the next five exercises. A random sample of ten professional athletes produced the following data where xis the number of endorsements the player has and is the amount of money made (in millions of dollars)

Use regression to find the equation for the line of best fit.

Short Answer

Expert verified

The equation for the line of best fit isy=2.23+1.98x

Step by step solution

01

Step-1 Given Information

Given in the question that, a random sample of ten professional athletes produced the following data where xis the number of endorsements the player has and yis the amount of money made.

02

Explanation 

To find the regression line in Excel, follow these steps:

Fill in the blanks in Excel as indicated below:


AB
1
x

y
202
338
427
513
6513
7512
849
939
1003
11410

Click on data Data AnalysisRegression.

Enter the input and output as shown below:

Click on OK. The output is:

03

Final Answer 

Therefore, the linear regression equation is:y=2.23+1.98xy=2.23+1.98x

Amount of money made =2.23+1.98×number of endorsements

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

The average number of people in a family that attended college for various years is given in Table 12.29.

a. Using “year” as the independent variable and “Number of Family Members Attending College” as the dependent variable, draw a scatter plot of the data.

b. Calculate the least-squares line. Put the equation in the form of: \(\hat{y}=a+bx\)

c. Find the correlation coefficient. Is it significant?

We are interested in whether or not the number of letters in a state name depends upon the year the state entered the Union.

a. Decide which variable should be the independent variable and which should be the dependent variable.

b. Draw a scatter plot of the data.

c. Does it appear from inspection that there is a relationship between the variables? Why or why not?

The following table shows economic development measured in per capita income PCINC.

a. What are the independent and dependent variables?

b. Draw a scatter plot.

c. Use regression to find the line of best fit and the correlation coefficient.

A vacation resort rents SCUBA equipment to certified divers. The resort charges an up-front fee of \(25and another fee of \)12.50an hour.

Graph the equation from Exercise 12.2.

The maximum discount value of the Entertainment® card for the “Fine Dining” section, Edition ten, for various pages is given in Table 12.21.

a. Decide which variable should be the independent variable and which should be the dependent variable.

b. Draw a scatter plot of the ordered pairs.

c. Calculate the least squares line. Put the equation in the form of: \(\hat{y}=a+bx\)

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free