Question about Microsoft Office Standard for PC

1 Answer

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

Ad

1 Answer

  • 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
  • 48 Answers

Go to this site

this will help you

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


OK?

Posted on Jan 01, 2008

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

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 to do interpolation in Casio f2f-4800p?


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

Linear Regression on a Casio calculator - YouTube

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

What is excel


What is Excel blankxl_250.jpg
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

1 Answer

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

1 Answer

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

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

Press [ZOOM][9:ZoomStat]
30b32c1.jpg
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)]

ccb85ed.jpg

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]

68a28f1.jpgENTER
ff52832.jpg
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.
aafb6d8.jpg

Hope it helps.


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

1 Answer

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

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

69 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2992 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...