Regression in this sense refers to regression analysis.

**0**

votes

**0**answers

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

**2**

votes

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**2**answers

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

**3**

votes

**1**answer

179 views

### How do you do multiple regresson in Excel (to show Mediation)?

Does anyone know how to use Excel to do multiple regession to show full and partial mediation using Baron and Kenny's method and alternatively Preacher and Hayes. I've been looking around for ...

**3**

votes

**2**answers

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

**2**

votes

**3**answers

2k views

### Use regression equation in excel formula

I have a spreadsheet with a number of graphs on, and I have displayed the trend-lines / regression lines on these graphs. These are not simple linear regression lines, but are high order polynomial ...