155k views
2 votes
What is the exponential regression equation for the data set x 3,4,7,11,12,16,19 y .3,.5,.9,1.2,1.7,1.7,1.9

User Nictrix
by
4.7k points

2 Answers

6 votes

Answer:

y=0.33 times 1.11 tothe powerr of x

Explanation:

i hope you can see whatit says I took the quiz

User Amod Pandey
by
5.6k points
5 votes

Answer:

The exponential regression equation for the data set is;


y=0.3258e^(0.1074x)

Explanation:

Exponential regression can easily be carried out in Ms. Excel. The first step is to enter the data in any two adjacent columns with the headers x and y in order to differentiate the response from the predictor variable.

The next step is to highlight the data, click the insert ribbon and choose the scatter-plot feature. This step will create an x, y scatter-plot for the data. The next step we click on the Add-Chart Element feature and add an exponential trend line to the scatter-plot while ensuring the Display Equation on chart is checked.

Ms. Excel provides the following exponential regression equation that models the data;


y=0.3258e^(0.1074x)

What is the exponential regression equation for the data set x 3,4,7,11,12,16,19 y-example-1
User Yosher
by
4.8k points