# Tagged Questions

Regression in this sense refers to regression analysis.

32 views

### Get function of Table of values in Excel

I'm working with this table: https://docs.google.com/spreadsheets/d/1OTJX3DDwl3iAr6L-ABBI9QYzl1rvoUAMi4ZkPIWbKls/edit?usp=sharing Here's an excerpt of the data: +-------------+------------+-----------...
231 views

### Excel LINEST returns #REF error when using non-rectangular array

I'm trying to use the LINEST() function on a named range. The function seems to work fine when the named ranges are typical rectangular arrays. However, if the named arrays are irregularly shaped, the ...
777 views

### [Minitab 16]Regression: How we can Ignore Outliers in a regression analyses?

I want to draw a simple linear regression chart in Minitab and I want to find The regression equation. I use two column of data and this path: Stat>>Regression>>Regression... Minitab shows me outliers ...
401 views

### Can I do a Multiple Regression with Excel?

I have performance data for 3 years for about 50K employees. Each employee has 3 ratings associated with them. I would like to create an equation that will predict (or try to predict) the future ...
419 views

### How can I regress a downward trending number series in Excel?

I'd like to use these data to derive an equation using Excel. 300 13 310 12.6 320 12.2 330 11.8 340 11.4 350 11 360 10.8 370 10.6 380 10.4 As x goes up, y goes down. Seems straightforward. But ...
380 views

### Excel regression output - funky p-value

Anybody know what it means when the p-value for X in an Excel regression output isn't something like ".0263," but instead is "3.9081E-86"? By the way, this is for one independent and one dependent ...