Go to All Charts tab – Pick X Y (Scatter) chart – Choose Scatter chart – Pick the appropriate Scatter chart from the provided options.Īnd clicking OK will give us the Scatter chart to calculate nonlinear regression in Excel and perform the required analysis.]Īnd then, click the Chart Elements option – Enable the Trendline option to confirm the nonlinear relation between the two variables. And then, select the Insert tab – Pick Recommended Charts option. [Alternatively, we can click on a cell in the table of dependent and independent variables’ data or select the entire table range. And then, select the Insert tab – Pick the Scatter (X, Y) or Bubble Chart option – Choose the Scatter chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |