Question about Microsoft Computers & Internet

1 Answer

If a calculation made in exel, 2003 work book, which command should be use to forward the value of result in other sheet?

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Expert
  • 93 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I get my answer to stay displayed as I type the next input?


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.

Dec 03, 2015 | Casio FX-115ES Scientific Calculator

1 Answer

Create a scatter plot of the data


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
  1. Press [2nd][+] (MEM) to open the memory management screen.
  2. Press [4:ClrAllLists]
  3. The command echoes on main screen, press [ENTER] to run it.
  4. Calculator displays Done.
B. RUN the SETUP EDITOR Command
  1. Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.
C. TURN DIAGNOSTICSON option (optional)

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
  1. You press [2nd] [0] (CATALOG)
  2. While the list of commands is displayed, press [X^-1] (D)
  3. Cursor jumps to first command that starts with D, dayOfWk(
  4. Press the DownArrow 9 times to reach DIAGNOSTICSON
  5. Select it and press [ENTER]
  6. Command echoes on main calculator screen with blinking cursor
  7. Press [ENTER] to set the option
  8. Calculator displays Done.
From now on, if a correlation coefficient has meaning for a regression model, it will be calculated along with the other statistical results. If it has no meaning to the model it will not be calculated.

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.
894afd6.jpg

TO OBTAIN statistical RESULTS (optional)
  1. After you finish entering the data, press [2nd][Quit] to exit StatEditor.
  2. Press [STAT] and highlight Menu (CALC)
  3. In the list select [2:2-Var Stats]
  4. Command echoes on main screen.
  5. Press [ENTER] to calculate the stats
Here is what you get (THESE~ARE NOT YOUR RESULTS). Your results will be different.
f2d3743.jpg
Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.
ab847d7.jpg
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.
37fb2ba.jpg
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
  1. Press [STAT] , highlight [CALC]
  2. In the list of regression models select [0:ExpReg]
  3. The command ExpReg echoes on main calculator screen.
  4. 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.
  5. While ExpReg command is still in command line, press the [VARS] key.
  6. Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
  7. In the Y function variable list select [1:Y1]
  8. At the command line, you have ExpReg Y1.
  9. Press [ENTER] to save the equation of best fit in Y1.
Here are your results. (These are your actual results)
f07d40f.jpg
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.
  1. Press [2nd][Y=] (STATPLOT)
  2. Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
  3. Use arrow to highlight On and press ENTER
  4. Use the Down Arrow to move cursor to the line Type.
  5. 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 is the configuration screen
b3dea28.jpg
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.
d6e8e98.jpg

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

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

1 Answer

Whenever i enter coordinates for a scatter plot or best fit line the point do not show up neither does the line i can trace the points and the calculator tell the coordinates but they are not visible


Two possibilities:
  1. 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].
  2. To mark the points you may have select the dot and your calculator screen is too dim.
To help you setup your calculator To perform regression analysis I am inserting here a copy of a more detailed post of mine where I show the complete procedure applied to a quadratic regression.

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

A. TO CLEAR OLD DATA
  1. Press [2nd][ ] (MEM) to open the memory management screen.
  2. Press [4:ClrAllLists]
  3. The command echoes on main screen, press [ENTER] to run it.
  4. Calculator displays Done.
B. RUN the SETUP EDITOR Command
  1. Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.
C. TURN DIAGNOSTICSON option (optional)

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
  1. You press [2nd] [0] (CATALOG)
  2. While the list of commands is displayed, press [X^-1] (D)
  3. Cursor jumps to first command that starts with D, dayOfWk(
  4. Press the DownArrow 9 times to reach DIAGNOSTICSON
  5. Select it and press [ENTER]
  6. Command echoes on main calculator screen with blinking cursor
  7. Press [ENTER] to set the option
  8. Calculator displays Done.
From now on, if a correlation coefficient has meaning for a regression model, it will be calculated along with the other statistical results. If it has no meaning to the model it will not be calculated.

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.
894afd6.jpg

TO OBTAIN statistical RESULTS (optional)
  1. After you finish entering the data, press [2nd][Quit] to exit StatEditor.
  2. Press [STAT] and highlight Menu (CALC)
  3. In the list select [2:2-Var Stats]
  4. Command echoes on main screen.
  5. Press [ENTER] to calculate the stats
Here is what one gets with the data above.

f2d3743.jpg
Notice the Down Arrow next to n=7. That means the results screen has more values. Press the Down Arrow to display.
ab847d7.jpg
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.
37fb2ba.jpg
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
  1. Press [STAT] , highlight [CALC]
  2. In the list of regression models select [0:ExpReg]
  3. The command ExpReg echoes on main calculator screen.
  4. 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.
  5. While ExpReg command is still in command line, press the [VARS] key.
  6. Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
  7. In the Y function variable list select [1:Y1]
  8. At the command line, you have ExpReg Y1.
  9. Press [ENTER] to save the equation of best fit in Y1.
Here are your results. (These are your actual results)
f07d40f.jpg
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.
  1. Press [2nd][Y=] (STATPLOT)
  2. Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
  3. Use arrow to highlight On and press ENTER
  4. Use the Down Arrow to move cursor to the line Type.
  5. 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 is the configuration screen
b3dea28.jpg
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.
d6e8e98.jpg
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

1 Answer

I need to find the equation for some points with my calculator but they are for an exponential regession. How do I do this?


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

A. TO CLEAR OLD DATA
  1. Press [2nd][+] (MEM) to open the memory management screen.
  2. Press [4:ClrAllLists]
  3. The command echoes on main screen, press [ENTER] to run it.
  4. Calculator displays Done.
B. RUN the SETUP EDITOR Command
  1. Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.
C. TURN DIAGNOSTICSON option (optional)

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
  1. You press [2nd] [0] (CATALOG)
  2. While the list of commands is displayed, press [X^-1] (D)
  3. Cursor jumps to first command that starts with D, dayOfWk(
  4. Press the DownArrow 9 times to reach DiagnosticsOn
  5. Select it and press [ENTER]
  6. Command echoes on main calculator screen with blinking cursor
  7. Press [ENTER] to set the option
  8. Calculator displays Done.
From now on, if a correlation coefficient has meaning for a regression model, it will be calculated along with the other statistical results. If it has no meaning to the model it will not be calculated.

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.
894afd6.jpg

TO OBTAIN THE STATISTICAL RESULTS (optional)
  1. After you finish entering the data, press [2nd][Quit] to exit StatEditor.
  2. Press [STAT] and highlight Menu (CALC)
  3. In the list select [2:2-Var Stats]
  4. Command echoes on main screen.
  5. Press [ENTER] to calculate the stats
Here is what you get (THESE~ARE NOT YOUR RESULTS). Your results will be different.
f2d3743.jpg
Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.
ab847d7.jpg
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.
37fb2ba.jpg
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.
  1. Press [STAT] , highlight [CALC]
  2. In the list of regression models select [0:ExpReg]
  3. The command ExpReg echoes on main calculator screen.
  4. 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.
  5. While ExpReg command is still in command line, press the [VARS] key.
  6. Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
  7. In the Y function variable list select [1:Y1]
  8. At the command line, you have ExpReg Y1.
  9. Press [ENTER] to save the equation of best fit in Y1.
Here are your results. (These are your actual results)
f07d40f.jpg
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.
  1. Press [2nd][Y=] (STATPLOT)
  2. Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
  3. Use arrow to highlight On and press ENTER
  4. Use the down arrow to move cursor to the line Type.
  5. 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 is the configuration screen
b3dea28.jpg
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.
d6e8e98.jpg

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

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

1 Answer

I'm trying to calculate r values on my TI-83 for Statistics. However, I keep getting the ERR:UNDEFINED message, despite an r value actually existing when I calculate it by hand.


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.

Apr 05, 2010 | Texas Instruments TI-83 Plus Calculator

1 Answer

TI-83 Texas calculator, exponential regression. How to input data in calculator? I have D list (time/days list of 1,2,3,4,5,6,7) and N list (6,10,13,27,42,65,120)- how do I input into calculator and draw a...


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
  1. Press [2nd][+] (MEM) to open the memory management screen.
  2. Press [4:ClrAllLists]
  3. The command echoes on main screen, press [ENTER] to run it.
  4. Calculator displays Done.
B. RUN the SETUP EDITOR Command
  1. Press [STAT][5:SetUpEditor] [ENTER] ; calculator displays Done.
C. TURN DIAGNOSTICSON option (optional)

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
  1. You press [2nd] [0] (CATALOG)
  2. While the list of commands is displayed, press [X^-1] (D)
  3. Cursor jumps to first command that starts with D, dayOfWk(
  4. Press the DownArrow 9 times to reach DiagnosticsOn
  5. Select it and press [ENTER]
  6. Command echoes on main calculator screen with blinking cursor
  7. Press [ENTER] to set the option
  8. Calculator displays Done.
From now on, if a correlation coefficient has meaning for a regression model, it will be calculated along with the other statistical results. If it has no meaning to the model it will not be calculated.

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.
894afd6.jpg

TO OBTAIN THE STATISTICAL RESULTS (optional)
  1. After you finish entering the data, press [2nd][Quit] to exit StatEditor.
  2. Press [STAT] and highlight Menu (CALC)
  3. In the list select [2:2-Var Stats]
  4. Command echoes on main screen.
  5. Press [ENTER] to calculate the stats
Here is what you get (THESE~ARE NOT YOUR RESULTS). Your results will be different.
f2d3743.jpg
Notice the down arrow next to n=7. That means the results screen has more values. Press the down arrow to display.
ab847d7.jpg
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.
37fb2ba.jpg
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.
  1. Press [STAT] , highlight [CALC]
  2. In the list of regression models select [0:ExpReg]
  3. The command ExpReg echoes on main calculator screen.
  4. 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.
  5. While ExpReg command is still in command line, press the [VARS] key.
  6. Highlight the [Y-VARS] menu and select [1:Function], then press [ENTER].
  7. In the Y function variable list select [1:Y1]
  8. At the command line, you have ExpReg Y1.
  9. Press [ENTER] to save the equation of best fit in Y1.
Here are your results. (These are your actual results)
f07d40f.jpg
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.
  1. Press [2nd][Y=] (STATPLOT)
  2. Select [1:Plot1...Off] and press ENTER to open plot1 configuration screen
  3. Use arrow to highlight On and press ENTER
  4. Use the down arrow to move cursor to the line Type.
  5. 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 is the configuration screen
b3dea28.jpg
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.
d6e8e98.jpg

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

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

1 Answer

I can't find this button on my calculator / this


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.



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

1 Answer

How to find area between 2 curves


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
  1. Draw the curves
  2. 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.
  3. Press [2nd][QUIT] to go to main calculator screen.
  4. Store the Ans result in say A: [2nd][Ans][STO->][ALPHA] A
  5. Return to the graph by pressing [GRAPH].
  6. Find a second intersection point. Result is stored in Ans memory.
  7. Press [2nd][Quit] to return to main calculator screen
  8. Press [2nd][Ans][STO->][ALPHA] B to store the X value of the second intersection point in B.
  9. Use the CATALOG to paste the fnInt( command to calculate the integral : [2nd][CATALOG][[APLHA] F and scroll to select fnInt( and press [ENTER]
  10. 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]
  11. The command should appear as fnInt( Y2-Y1,A,B)
  12. Press [ENTER] to obtain your value.
Hope it helps.
Thank you for using FixYa.
Do not forget to rate the solution.



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

1 Answer

Explain brief about Goak Seek Command, Solver, Sceanerios


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.

Nov 17, 2008 | Microsoft Computers & Internet

1 Answer

Exel 2003


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.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. 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.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

52 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2775 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...