5.) Assume the following table lists campaign spending, in thousands of dollars,

Question

5.) Assume the following table lists campaign spending, in thousands of dollars, by candidates for statewide office and the percentage of the popular vote they received in their respective districts Spending 12.550.5 17.9 Percentage 34.4 20.5 77.9 14.1 76.4 49.9 12.7 5.2 61.213.1 50.2 Does a strong linear correlation exist between campaign spending and percentage of votes received? How do you know? If a strong linear correlation exists, answer the following: a.) Find a regression model for percentage of votes received as a function of campaign spending. b.) If a politician spent $60,000 on a campaign, what percentage of the vote should she expect to receive? c.) If a politician received a quarter of the votes, what would you expect the campaign to have spent?

Explanation / Answer

Sol:

In excel find correlation as

Data>Data analysis>Correlation>

Enter the data range

Press ok

we get

r=corrrelation coefficient =-0.23249

There exists a weak negative relationship between Spending and Percentage.

There is no strong linear correlation exists.

Solutiona:

We can find regression in excel as

Data >Dataanalysis>Regression

Regression eq is

perentage=48.99389-0.21702(spending)

slope=-0.21702

y intercept=48.99389

solutionb

for x=60

percentage=

48.99389-0.21702(60)

percentage=35.97269

percentage=35.97%

Solutionc:

quarter=1/4=25%

percentage=48.99389-0.21702(spending)

25=48.99389-0.21702(spending)

spending=48.99389-25/0.21702

Spending=110.56

Spending Percentage 12.5 34.4 50.5 12.7 17.9 61.2 5.2 50.2 13.1 77.9 20.5 14.1 76.4 49.9

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.