Question

Find the Exponential Regression using the table. Write the initial amount, common ratio, and equation for the table.

Answer 1

Initial amount;

2110.6

Common ratio;

0.0201

Equation;

`y=2110.6e^(0.0201x)`

Explanation:

In this scenario, the month represents the independent variable x while the membership amount represents the dependent variable y.

The analysis is performed in Ms. Excel. The first step is to obtain a scatter plot of the data then finally inserting an exponential trend line to obtain the required equation.

The Ms. Excel output is shown in the attachment below. To obtain the initial amount we substitute x = 0 in the equation. On the other hand, the common ratio is the exponent in the equation.