Question about Microsoft Office Standard for PC

Ad

Go to this site

this will help you

http://oncampus.richmond.edu/~cstevens/301/Excel4.html

OK?

Posted on Jan 01, 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.

Good luck!

Posted on Jan 02, 2017

Ad

https://www.youtube.com/watch?v=rCVM6RWMjQ4

Jan 7, 2015 - Uploaded by Yabets Jab

In this video you can simply understand how to find a value of a given missing number in a table on Casio fx ...Missing: 4800p

https://www.youtube.com/watch?v=OGmHagjZPjg

Oct 31, 2012 - Uploaded by cpobyrne1

How to perform a linear regression on a Casio scientific calculator. Example uses a ... A Casio fx-83WA calculator is used for the demonstration. .... Lagrange Interpolation Easily Explained on Casio fx-991ES Calculator!Missing: 4800p

Jan 05, 2016 | Casio Office Equipment & Supplies

What is the question?

Put your calculator in STAT mode (2-var statistics or regression )

Enter your data in two lists, preferably sorted according to the x-value

Choose a regression model from the ones available and get the calculator to give you the best fit.

However to see which regression model best fits you data you need a graphing calculator to draw the scatter plot, then superpose on the scatter plot the curve of best fit given by the regression model.

Once you accept a model as the most suited one, you can use the equation of the curve to predict a y-value given an x-value (what ever REAL LIFE meaning they might have)

.

Put your calculator in STAT mode (2-var statistics or regression )

Enter your data in two lists, preferably sorted according to the x-value

Choose a regression model from the ones available and get the calculator to give you the best fit.

However to see which regression model best fits you data you need a graphing calculator to draw the scatter plot, then superpose on the scatter plot the curve of best fit given by the regression model.

Once you accept a model as the most suited one, you can use the equation of the curve to predict a y-value given an x-value (what ever REAL LIFE meaning they might have)

.

Dec 11, 2013 | Sentry CA 756 Calculator

I had the same problem. Try this:

-Press [2ND] and then [+] (Memory menu)

-Then select ClrAllLists (4)

Worked for me

-Press [2ND] and then [+] (Memory menu)

-Then select ClrAllLists (4)

Worked for me

Apr 01, 2012 | Office Equipment & Supplies

That depends on the order of the polynomial. If the polynomial is of second order, the quadratic formula will give you its roots. There are similar formulae for third, fourth, and fifth order polynomials, and it has been proven that no such formulae exist for higher-order polynomials.

Some TI calculators have a numerical solver which can produce numerical solutions to arbitrary polynomials. Since you declined to specify the model of your calculator, I'm afraid I can't tell you whether yours has one or not.

If you need further assistance, please reply to this post and be sure to specify the model of your calculator.

Some TI calculators have a numerical solver which can produce numerical solutions to arbitrary polynomials. Since you declined to specify the model of your calculator, I'm afraid I can't tell you whether yours has one or not.

If you need further assistance, please reply to this post and be sure to specify the model of your calculator.

Feb 12, 2012 | Texas Instruments Office Equipment &...

You must turn the Diagnostics ON. Open the CATALOG of commands by pressing [2nd[0]. Press the key that has Letter D next to it. From that point in the catalog, scrool Down to get to DiagnosticsON. Highlight the command and press Enter. The calculator will echo the command in the Main screen. Press ENTER.

From now on the coefficient of determination ( the square of R) will be displayed along with other statistics.

From now on the coefficient of determination ( the square of R) will be displayed along with other statistics.

Feb 03, 2012 | Texas Instruments TI-84 Plus Calculator

Here is a great guide on how to do linear regression on the TI-84 :
http://www.mathstore.net/graphing-calculators/TI-84/how-to-linear-regression.php

May 12, 2011 | Texas Instruments TI-84 Plus Calculator

What is Excel

Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

Hello,

Th CFX-9850GB Plus is programmed to perform 10 types of regressions, namely

LinearReg: Linear y=ax+b

Med-Med also linear y=ax+b

QuadReg :Quadratic y= ax^2+bx+c

Cubic: y=ax^3+bx^2+cx+d

Quartic: y=ax^4+bx^3+cx^2+dx+e

LogReg, logarithmic: y=a+b*ln(x)

ExpReg, exponential y=a*e^(bx)

PowerReg, power: y= ax^b

SinReg, sinusoidal: y=a*sin(bx+c) +d

LogisticReg, logistic; y= c/(1+a*e^(-bx))

There may be more regression models appropriate for more advanced (specialized) statistics but the ones in the list are all the CFX-9850GB plus offers. However, since the calculator knows a programming language, you may want to implement a particular model.

Hope that helps.

Th CFX-9850GB Plus is programmed to perform 10 types of regressions, namely

LinearReg: Linear y=ax+b

Med-Med also linear y=ax+b

QuadReg :Quadratic y= ax^2+bx+c

Cubic: y=ax^3+bx^2+cx+d

Quartic: y=ax^4+bx^3+cx^2+dx+e

LogReg, logarithmic: y=a+b*ln(x)

ExpReg, exponential y=a*e^(bx)

PowerReg, power: y= ax^b

SinReg, sinusoidal: y=a*sin(bx+c) +d

LogisticReg, logistic; y= c/(1+a*e^(-bx))

There may be more regression models appropriate for more advanced (specialized) statistics but the ones in the list are all the CFX-9850GB plus offers. However, since the calculator knows a programming language, you may want to implement a particular model.

Hope that helps.

Oct 24, 2009 | Casio CFX 9850GB Plus Calculator

Hello,

1.Press [MODE], scroll to set**Func**tion graphing mode.

2.Press [STAT] [5:SetUpEditor], command is pasted in home screen. Press [ENTER]. Screen displays Done. This clears old values in lists

3. Press [STAT][1:Edit] to enter data.

Press [ENTER] after each number. Cursor moves to next row. After finishing the data of Listt L1, use arrow right and UP to the head of list L2. Enter the values in list L2. Press Enter after last element.

4. Press [Y=] to display Y= editor. Clear function Y1 and all functions or remove highlight from the = in Y2, Y3, etc.

5.Press [2nd][STATPLOT]1 to select 1:Plot1

The blinking cursor on ON means graph will be drawn. Type chosen is Scatter plot. Mark chosen is a dot.

Press [ZOOM][9:ZoomStat]

If you think that the curve look like a straight line you can try to do a linear regression.

Press [STAT] Arrow right to highlight [CALC]

Select [4: LinReg(ax+b)]

LinReg(ax+b) echoes on run screen. Press [2nd] L1 Press comma, Press [2nd] L2 press comma Press [VARS] Arrow right to select [Y:VARs][1:Function] [ENTER][1:Y1]

ENTER

That is the equation for the linear regression. As you see eqaution has been saved in Y1. Press [GRAPH] to get the data and the regression curve drawn on same graph.

Hope it helps.

1.Press [MODE], scroll to set

2.Press [STAT] [5:SetUpEditor], command is pasted in home screen. Press [ENTER]. Screen displays Done. This clears old values in lists

3. Press [STAT][1:Edit] to enter data.

Press [ENTER] after each number. Cursor moves to next row. After finishing the data of Listt L1, use arrow right and UP to the head of list L2. Enter the values in list L2. Press Enter after last element.

4. Press [Y=] to display Y= editor. Clear function Y1 and all functions or remove highlight from the = in Y2, Y3, etc.

5.Press [2nd][STATPLOT]1 to select 1:Plot1

The blinking cursor on ON means graph will be drawn. Type chosen is Scatter plot. Mark chosen is a dot.

Press [ZOOM][9:ZoomStat]

If you think that the curve look like a straight line you can try to do a linear regression.

Press [STAT] Arrow right to highlight [CALC]

Select [4: LinReg(ax+b)]

LinReg(ax+b) echoes on run screen. Press [2nd] L1 Press comma, Press [2nd] L2 press comma Press [VARS] Arrow right to select [Y:VARs][1:Function] [ENTER][1:Y1]

ENTER

That is the equation for the linear regression. As you see eqaution has been saved in Y1. Press [GRAPH] to get the data and the regression curve drawn on same graph.

Hope it helps.

Oct 04, 2009 | Texas Instruments TI-84 Plus Calculator

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

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

May 13, 2008 | Microsoft Excel for PC

Aug 20, 2013 | Microsoft Office Standard for PC

69 people viewed this question

Usually answered in minutes!

×