Tagged Questions

Regression in this sense refers to regression analysis.

400 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 ...
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: +-------------+------------+-----------...
221 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 ...
748 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 ...
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 ...
187 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 ...