How to use Microsoft Excel: regression analysis Quadratic functions

[Pages:10]How to use Microsoft Excel: regression analysis Quadratic functions

Physics 23 Lab

Missouri University of Science and Technology

Physics 23 Lab (MS&T)

How to use Excel

regression 1 / 10

Data tab

Physics 23 Lab (MS&T)

How to use Excel

regression 2 / 10

Data analysis

Physics 23 Lab (MS&T)

How to use Excel

regression 3 / 10

Regression

Physics 23 Lab (MS&T)

How to use Excel

regression 4 / 10

Regression x, y: select x input range

Physics 23 Lab (MS&T)

How to use Excel

regression 5 / 10

Select columns of x and x2

Physics 23 Lab (MS&T)

How to use Excel

regression 6 / 10

For "input y range" select y column

Physics 23 Lab (MS&T)

How to use Excel

regression 7 / 10

Regression output range

Physics 23 Lab (MS&T)

How to use Excel

regression 8 / 10

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download