Question about Microsoft Office Standard for PC

# Numerical method Can you help us to make a program for linear regression using microsoft excel? to be specific, a 2nd order polynomial regression.

Posted by on

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

Go to this site

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

OK?

Posted on Jan 01, 2008

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Interpolation mannual in fx-4800P - Fixya

www.fixya.com/support/t22818601-interpolation_mannual_in_fx_4800p
Jan 11, 2014 - interpolation mannual in fx-4800P - Casio Rare Vintage Scientific question. ... SOURCE: how can we do linear interpolation in casio fx-991ES ...

### interpolate how can interpolate linear regression by casio ...

www.fixya.com/support/t22818666-interpolate
Jan 11, 2014 - interpolate how can interpolate linear regression by casio fx-4800P -Casio ... SOURCE: how can we do linear interpolation in casio fx-991ES ...

### how to perform linear interpolation manually and on casio fx ...

? 6:39
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

### Linear Regression on a Casio calculator - YouTube

? 6:25
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

### How to model real life data?

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)
.

Dec 11, 2013 | Sentry CA 756 Calculator

### Linear Regression - Error DATA TYPE

I had the same problem. Try this:
-Press [2ND] and then [+] (Memory menu)
-Then select ClrAllLists (4)

Worked for me

Apr 01, 2012 | Office Equipment & Supplies

### How to solve polynomials

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.

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

### My r correlation doesn't show when I'm in linear regression?

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.

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

### What is excel

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.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

### Do i have only one type of exponencial regression o my 9850gb plus?

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
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

### How do I use stat plot to graph a set of points?

Hello,
1.Press [MODE], scroll to set Function 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.

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

### How do I run a regression analysis in Excel

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

May 13, 2008 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

69 people viewed this question

Level 3 Expert

Level 3 Expert