Question about Microsoft Computers & Internet

Ad

Write "=" in any cell of the new sheet, and then write ..
eg. if in sheet 1 result is in B8 and you have to transfer the result in sheet2 in any cell.
just write "=Sheet1!B8" in any cell of sheet2.

enjoy !!
thank you for using fixya !!!

Posted on Nov 11, 2010

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

You can use the replay button to display the last command entered, then move cursor to the end of the command line and append the part you want to add. But it must be a part of the same command line, with correct syntax.

As to the last result calculated, it is stored in ANS memory. It will be overwritten by the new calculated value.

As to the last result calculated, it is stored in ANS memory. It will be overwritten by the new calculated value.

Dec 03, 2015 | Casio FX-115ES Scientific 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 (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

Press [2nd][0] to access the (CaTALOG) of commands.

Press the [X^-1] key (D) to jump to first command that starts with the letter D. From there, use down arrow to point to DiagnosticOn and press [ENTER] twice.

From now on (unless you reset the calculator), the correlation coefficients R and R^2 will ne displayed along with the regression results for all models where R and R^2 are meaningful.

You used "r-values" as if what you mean should be clear to everyone, but it is not. And there is a possibility I might have misread your mind. If that be the case, ignore the answer I gave and refrain from rating it. Post a comment instead, spelling out what you need the calculator to compute.

Press the [X^-1] key (D) to jump to first command that starts with the letter D. From there, use down arrow to point to DiagnosticOn and press [ENTER] twice.

From now on (unless you reset the calculator), the correlation coefficients R and R^2 will ne displayed along with the regression results for all models where R and R^2 are meaningful.

You used "r-values" as if what you mean should be clear to everyone, but it is not. And there is a possibility I might have misread your mind. If that be the case, ignore the answer I gave and refrain from rating it. Post a comment instead, spelling out what you need the calculator to compute.

Apr 05, 2010 | Texas Instruments TI-83 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.

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

A fraction is in fact a ratio of two number: a division of a numerator by a denominator. The key used for the division operation is the one above the multiplication sign and below the caret [^], and in thee rightmost column of keys.

Beware that this calculator converts any ratio of two numbers into a decimal value. To keep a fraction in a fraction form you must use the [|=>Frac] or [ToFrac] command. To convert a decimal result to a fraction, use the [|=>Dec] command.

These commands are accessible through the CATALOG or more easily by pressing [MATH] (under the ALPHA key) and selecting [1:|=>Frac], or [2:|=>Dec]

Ex: to keep 27/48 in fraction form you enter

27 [/] 48 [MATH][1:|=>Frac] [ENTER]. Result is 9/16

You will notice that the resulting fraction is reduced to its simplest form.

To convert the above result from fraction to decimal press [MATH][2:|=>Dec]

A fraction can always be approximated by a decimal value but the converse is not always possible.

Beware that this calculator converts any ratio of two numbers into a decimal value. To keep a fraction in a fraction form you must use the [|=>Frac] or [ToFrac] command. To convert a decimal result to a fraction, use the [|=>Dec] command.

These commands are accessible through the CATALOG or more easily by pressing [MATH] (under the ALPHA key) and selecting [1:|=>Frac], or [2:|=>Dec]

Ex: to keep 27/48 in fraction form you enter

27 [/] 48 [MATH][1:|=>Frac] [ENTER]. Result is 9/16

You will notice that the resulting fraction is reduced to its simplest form.

To convert the above result from fraction to decimal press [MATH][2:|=>Dec]

A fraction can always be approximated by a decimal value but the converse is not always possible.

Jan 23, 2010 | Texas Instruments TI-84 Plus Calculator

Hi,

The TI84Plus has a Shade( function which allows you to represent the area you want to calculate.

The simplest syntax of the command is

**Shade( lower_function, upper_function, Xleft, Xright, pattern, patern_resol)**
where Xleft is the left limit, Xright is the right limit, pattern is
the shading pattern and pattern_resol is the resolution of the shading.
Only the area where lower_function is less than upper_function is
shaded. Unfortunately this command does give the value of the shaded
area.

To find the area between two curves

Thank you for using FixYa.

Do not forget to rate the solution.

The TI84Plus has a Shade( function which allows you to represent the area you want to calculate.

The simplest syntax of the command is

To find the area between two curves

- Draw the curves
- Find the left intersection point using [2nd][CALC][5:intersect]. Sorry I will not describe the procedure. The X value of the intersection point is stored in Ans memory.
- Press [2nd][QUIT] to go to main calculator screen.
- Store the Ans result in say A: [2nd][Ans][STO->][ALPHA] A
- Return to the graph by pressing [GRAPH].
- Find a second intersection point. Result is stored in Ans memory.
- Press [2nd][Quit] to return to main calculator screen
- Press [2nd][Ans][STO->][ALPHA] B to store the X value of the second intersection point in B.
- Use the CATALOG to paste the
**fnInt(**command to calculate the integral : [2nd][CATALOG][[APLHA] F and scroll to select fnInt( and press [ENTER] - To complete the command you need the identifiers Y1 and Y2.. You access the identifiers Y1 and Y2 by pressing [VARS][Y-VARS][1:Function][1:Y1] and [VARS][Y-VARS][1:Function][2:Y2]
- The command should appear as
**fnInt( Y2-Y1,A,B)** - Press [ENTER] to obtain your value
**.**

Thank you for using FixYa.

Do not forget to rate the solution.

Dec 03, 2009 | Texas Instruments TI-83 Plus Calculator

Goal Seek Solver and Sceanerios are a Part of What if Data Analysis Tools.

Goal Seek find the Expected Change in terms of value to a calculated Items.

For Example if you have a sales data for the year 2007 where Profit is 350000 and you want to make it 500000 for the year 2008 so what changes you will do in Product cost or Product Price this you will find with Goal Seek. It is also known as Back calculation. It has some restrictions which is overcome by Solver. But before doing this type of calculation use Sceanerios to store different Calculated values using Goal Seek and Solver. You dont have to add these values in different sheets all the values stored as a sceanerios. so You can show different Predections to the customers without moving around the Sheets.

Goal Seek find the Expected Change in terms of value to a calculated Items.

For Example if you have a sales data for the year 2007 where Profit is 350000 and you want to make it 500000 for the year 2008 so what changes you will do in Product cost or Product Price this you will find with Goal Seek. It is also known as Back calculation. It has some restrictions which is overcome by Solver. But before doing this type of calculation use Sceanerios to store different Calculated values using Goal Seek and Solver. You dont have to add these values in different sheets all the values stored as a sceanerios. so You can show different Predections to the customers without moving around the Sheets.

Nov 17, 2008 | Microsoft Computers & Internet

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (**!**)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

- Click the cell in which you want to enter the formula.
- In the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or
formula stored in the active cell.)
, type
**=**(equal sign). - Click the tab for the worksheet to be referenced.
- Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Oct 19, 2017 | Microsoft Computers & Internet

Oct 04, 2017 | Microsoft Computers & Internet

Sep 13, 2017 | Microsoft Computers & Internet

52 people viewed this question

Usually answered in minutes!

×