What is the tool/steps to plot a regression curve/line against a set of points in excel? I have used this functionality many years back, but cant remember it now...

Ad

You probably want to use the LINEST function for straight lines or LOGEST for exponential curves.

In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.

The other tricks is one must hit Ctrl+Shift+Enter to display the results.

http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!

kpenguin

Posted on May 13, 2008

Ad

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)

click here to download the app (for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

Your data must be in two lists L1 (for x-values), and L2 (for y-values). This is the default setting. Open the STAT utility, go to the regression models. Select your model then press ENTER. The command echoes on the main screen. For example let the regression be something called **LinReg.**

On the main screen you see**LinReg**

Complete the command line as follows

**LinReg L1, L2, Y1, ENTER**

You see the statistics including the regression equation.

If you go to**Y= **Editor you will see that **Y1 **contains the regression equation.

If you have already drawn the**scatter plot** for your data, pressing GRAPH will superpose the scatter plot and the **regression curve**., and you will be able to judge the goodness of the fit.

On the main screen you see

Complete the command line as follows

You see the statistics including the regression equation.

If you go to

If you have already drawn the

Sep 28, 2013 | Texas Instruments TI-84 Plus Silver...

The drawing of the scatter plot proper is explained in the last part (Part F). You might want to jump right to it.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN statistical RESULTS (optional)

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. Select Regression model (Example Exponential, linear, sine, quadratic, etc.) Here I selected Exponential

You also have r and its square.

Since the equation is saved in the Y1 function it can be superposed on the scatter plot. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

F. DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearance of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

- Press [2nd][+] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DIAGNOSTICSON
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN statistical RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. Select Regression model (Example Exponential, linear, sine, quadratic, etc.) Here I selected Exponential

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- If you press [ENTER] you will get your equation but you will not be able to draw the curve on top of your data to verify the goodness (no it is not a swear word) of the fit. So you must save the equation as a function in Y1 variable.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square.

Since the equation is saved in the Y1 function it can be superposed on the scatter plot. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

F. DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the Down Arrow to move cursor to the line Type.
- Select the first icon for a scatter plot. NOTE: To navigate the 6 statistical stat plots on the line Type, use the right or left arrow (to backtrack), but not the Up or down arrows.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearance of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Nov 06, 2010 | Texas Instruments TI-84 Plus Calculator

Two possibilities:

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN statistical RESULTS (optional)

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimics the raw data best. Select Regression model ( exponential, linear, sine, quadratic, etc.) Here I selected Exponential

You also have r and its square.

Since the equation is saved in the Y1 function it can be superposed on the scatter plot. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

F. DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearance of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

The graph above represents a parabola and has nothing to do with the sample data entered. But it shows the raw data and the curve of best fit on the same screen.

- Graph is out of range (out of the window). If your data is positive set Xmin=0 and Ymin=0. Set Xmax a bit larger than the maximum x-value and YMAX a bit larger than the maximum y-value. You can also press [ZOOM] and select [9:ZoomStat].
- To mark the points you may have select the dot and your calculator screen is too dim.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

- Press [2nd][ ] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DIAGNOSTICSON
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN statistical RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimics the raw data best. Select Regression model ( exponential, linear, sine, quadratic, etc.) Here I selected Exponential

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- If you press [ENTER], you'll get your equation but you will not be able to draw the curve on top of your data to verify the goodness (no it is not a swear word) of the fit. So you must save the equation as a function in Y1 variable.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square.

Since the equation is saved in the Y1 function it can be superposed on the scatter plot. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

F. DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the Down Arrow to move cursor to the line Type.
- Select the first icon for a scatter plot. NOTE: To navigate the 6 statistical stat plots on the line Type, use the right or left arrow (to backtrack), but not the Up or down arrows.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearance of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

The graph above represents a parabola and has nothing to do with the sample data entered. But it shows the raw data and the curve of best fit on the same screen.

Sep 03, 2010 | Texas Instruments TI-83 Plus Calculator

Before
doing statistics, you have to prepare the calculator by clearing old
data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DiagnosticsOn option. To access the command

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN THE STATISTICAL RESULTS (optional)

Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the satistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have to perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked to obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the Xlist is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

A. TO CLEAR OLD DATA

- Press [2nd][+] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DiagnosticsOn option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DiagnosticsOn
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN THE STATISTICAL RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the satistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have to perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- If you press [ENTER] you will get you equation but you will not be able to draw the curve on top of your data to verify the goodness (no it is not a swear word) of the fit. So you must save the equation as a function in Y1 variable.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked to obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the down arrow to move cursor to the line Type.
- Select the first icon for a scatter plot. NOTE: To navigate the 6 statistical stat plots on the line Type, use the right or left arrow (to backtrack), but not the Up or down arrows.

Here plot1 is active (ON), it is scatter plot (first icon) the Xlist is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

May 13, 2010 | Texas Instruments TI-84 Plus Calculator

The drawing of the scatter plot proper is explained in the last part (Part F). You might want to jump right to it.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN statistical RESULTS (optional)

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. Select Regression model (Exeample Esponential, linear, sine, quadratic, etc.) Here I selected Exponential

You also have r and its square.

Since the equation is saved in the Y1 function it can be superposed on the scatter plot. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

F. DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearance of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Comments: Apr 19, 2010 - I tried to edit the post to address your particular need but after several crashes I decided to paste it as is.

The particular parts that are of concern to you are Part E (performing a regression analysis) and the following one where the best fit and the dcatter plot are superposed on the same display.

As you have guessed you must select QuadReg.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

- Press [2nd][+] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DIAGNOSTICSON
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN statistical RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. Select Regression model (Exeample Esponential, linear, sine, quadratic, etc.) Here I selected Exponential

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- If you press [ENTER] you will get you equation but you will not be able to draw the curve on top of your data to verify the goodness (no it is not a swear word) of the fit. So you must save the equation as a function in Y1 variable.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square.

Since the equation is saved in the Y1 function it can be superposed on the scatter plot. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

F. DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the Down Arrow to move cursor to the line Type.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearance of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Comments: Apr 19, 2010 - I tried to edit the post to address your particular need but after several crashes I decided to paste it as is.

The particular parts that are of concern to you are Part E (performing a regression analysis) and the following one where the best fit and the dcatter plot are superposed on the same display.

As you have guessed you must select QuadReg.

Apr 30, 2010 | Texas Instruments TI-84 Plus Calculator

Read this post. It answers all your questions and shows you HOW to do
find your equation of best fit, correlation coefficients, etc.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DiagnosticsOn option. To access the command

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN THE STATISTICAL RESULTS (optional)

Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the satistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have to perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked to obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the Xlist is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

- Press [2nd][+] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DiagnosticsOn option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DiagnosticsOn
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN THE STATISTICAL RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the satistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have to perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- If you press [ENTER] you will get you equation but you will not be able to draw the curve on top of your data to verify the goodness (no it is not a swear word) of the fit. So you must save the equation as a function in Y1 variable.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked to obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the down arrow to move cursor to the line Type.

Here plot1 is active (ON), it is scatter plot (first icon) the Xlist is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Apr 16, 2010 | Texas Instruments TI-84 Plus Silver...

Before
doing statistics, you have to prepare the calculator by clearing old
data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

D. ENTER THE DATA (ENTER your own data)

Press [STAT][1:Edit]

Type in your X values in L1 and the Y values in L2 (see picture 1).

TO OBTAIN the statistical RESULTS (optional)

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked To obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

A. TO CLEAR OLD DATA

- Press [2nd][+] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DIAGNOSTICSON option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DIAGNOSTICSON
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA (ENTER your own data)

Press [STAT][1:Edit]

Type in your X values in L1 and the Y values in L2 (see picture 1).

TO OBTAIN the statistical RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the statistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have To perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked To obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the Down Arrow to move cursor to the line Type.

Here plot1 is active (ON), it is scatter plot (first icon) the XLIST is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Mar 21, 2010 | Texas Instruments TI-84 Plus Calculator

Read this post. It answers all your questions and shows you HOW to do
find your equation of best fit, correlation coefficients, etc.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DiagnosticsOn option. To access the command

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN THE STATISTICAL RESULTS (optional)

Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the satistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have to perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked to obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

Here plot1 is active (ON), it is scatter plot (first icon) the Xlist is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Before doing statistics, you have to prepare the calculator by clearing old data that may generate errors.

A. TO CLEAR OLD DATA

- Press [2nd][+] (MEM) to open the memory management screen.
- Press [4:ClrAllLists]
- The command echoes on main screen, press [ENTER] to run it.
- Calculator displays Done.

- Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.

To obtain the correlation coefficient in a statistical analysis on the TI8xPlus family of calculators you must activate the DiagnosticsOn option. To access the command

- You press [2nd] [0] (CATALOG)
- While the list of commands is displayed, press [X^-1] (D)
- Cursor jumps to first command that starts with D, dayOfWk(
- Press the DownArrow 9 times to reach DiagnosticsOn
- Select it and press [ENTER]
- Command echoes on main calculator screen with blinking cursor
- Press [ENTER] to set the option
- Calculator displays Done.

D. ENTER THE DATA

Press [STAT][1:Edit]

Type in your D (X ) values in L1 and the N (Y) values in L2 (see picture 1). Sorry the picture does not have YOUR values.

TO OBTAIN THE STATISTICAL RESULTS (optional)

- After you finish entering the data, press [2nd][Quit] to exit StatEditor.
- Press [STAT] and highlight Menu (CALC)
- In the list select [2:2-Var Stats]
- Command echoes on main screen.
- Press [ENTER] to calculate the stats

Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.

You notice that the n=7 line now has an arrow pointing Up. Notice the Down Arrow on the bottom line (more data is coming). Here is the rest of the statistical results.

There is no arrow at the bottom of the picture. End of statistical results.

The screen captures with 2-Var Stats summarize all the satistics.

However there is no correlation coefficient, no line of best fit, etc. To obtain that you have to perform a regression analysis.

E. PERFORM A REGRESSION ANALYSIS

To perform a regression analysis, you must try several regression models and then find the one that mimicks the raw data best. In this particular case, you have already decided to do a linear regression, and that is good for me. I do not have the time to take you through all of them. In this step you must select the exponential regression model.

- Press [STAT] , highlight [CALC]
- In the list of regression models select [0:ExpReg]
- The command ExpReg echoes on main calculator screen.
- While ExpReg command is still in command line, press the [VARS] key.
- Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
- In the Y function variable list select [1:Y1]
- At the command line, you have ExpReg Y1.
- Press [ENTER] to save the equation of best fit in Y1.

You also have r and its square. You need to read your theory to know which of the two correlation coefficients you have been asked to obtain.

Since you saved the equation in the Y1 function you can draw it. You just have to press GRAPH and it will be drawn. But that will not tell how good the fit is, until you see the function drawn on top of the raw data.

DRAWING THE SCATTER PLOT AND BEST FIT CURVE ON SAME SCREEN

Regardless of the curve of best fit, you can draw a scatter plot as follows.

- Press [2nd][Y=] (STATPLOT)
- Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
- Use arrow to highlight On and press ENTER
- Use the down arrow to move cursor to the line Type.

Here plot1 is active (ON), it is scatter plot (first icon) the Xlist is L1 by default but you can change it to some other list. Notice the highlighted A cursor on XLIST line. It means that the [ALPHA] keyboard is active.

On the line Mark you can choose the appearnce of the raw data point.

And here are your two graphs: the raw data scatter plot and the line of best fit on the same screen. On the picture the ZoomStat option was used.

Now, it is up to you to accept this model or to try another model.

Mar 14, 2010 | Texas Instruments TI-83 Plus Calculator

Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)

2. Click on Add-Ins on the side pane of the Excel Options Window

3. Check to see if Analysis ToolPak is in Inactive application add-in list.

4. If is not, proceed to Step 7

5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"

6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK

7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)

2. Click on Add-Ins on the side pane of the Excel Options Window

3. Check to see if Analysis ToolPak is in Inactive application add-in list.

4. If is not, proceed to Step 7

5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"

6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK

7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

Step 1: Go to Msoft update and make sure you have all the latest Office service packs/issue fixes for Office 2007.

If that doesn't work, go on to:

Step 2: Are you using wizards to create the code to do this functionality and if so, what ones? Post here.

If that doesn't work, go on to:

Step 2: Are you using wizards to create the code to do this functionality and if so, what ones? Post here.

Mar 07, 2008 | Microsoft Office Professional 2007 Full...

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

1,860 people viewed this question

Usually answered in minutes!

thats that fancy thing with pivot charts correct?

im pretty sure i remember how to get the line, but ill have to check, its been a while since i took the course.

×