Question

The number of new contributors to a public radio station's annual fund drive over the last ten years is ​63, 58, 61, 72, 98, 103, 121, 147, 163, 198 Using Microsoft Excel, develop a linear regression model that predicts the number of new contributors. Explain the slope of this model. Based on this model, how many new contributors would you predict for the following year?

Answer 1

The number of potential members predicted in next year's estimate becomes 193. The further explanation is given below.

Explanation:

The slope of the model,

m = 15.345

c = 24

After comparing with the equation,

⇒
`y=mx+c`

we get,

⇒
`=15.345x + 24`

The slope seems to be a positive value which also means that another always improves this as component decreases. Which ensures that perhaps the number of contributors rising as time went by.

So that the above is the right answer.