answersLogoWhite

0


Best Answer

All you have to do is to select the values you want to have compared with Excel. Then click on Insert on the top, then Scatter, then Scatter with only markers. After this, you can give name to the axises, but then in the Layout section you have to select the regression type of the trendline as well.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you plot sine regression in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the regression line that is superimposed on the scatter plot?

trur


What is a regression line that is superimposed on the scatter plot?

trur


In a good regression model the residual plot shows?

a random pattern


What is a regression line that is superimposed on a scatter plot?

It guarantees that the slope and intercept are minimized.


Sine qua non used in a sentence?

Sacrifice, practice, and commitment are the sine qua nonof our band to excel in the international competition.


When using the Regression tools you cannot plot the points of your data and your model on the same graph?

False


What is used to plot categories in excel?

Gareth Hamilton


How do you get va box and whisker plot on excel?

carrots


What is a good idea for a scatter plot?

I like to use age and height in a scatter plot using male and female separate then together. It shows two lines of regression.


Points that represent data values are connected using line segments?

Not necessarily. In a scatter plot or regression they would not.


How can you find an equation for a trend line?

There are numerous ways to do this. I think the easiest is to put the data in excel and have excel show the trend line, equation, andcorrelation coefficient. Excel gives you several options to choose for the trend line analysis. The other way is if it is a linear relationship, you can do the linear regression analysis following the steps listed in the related link. If you are not familiar with regression analysis, it may not be easy for you to follow.


When dealing with Quadratic Regression what is one of the first things that needs to be done on the graphing calculator?

You must create a scatter plot