Questions tagged [regression]
Regression in this sense refers to regression analysis.
16
questions
0
votes
2
answers
94
views
Formula for a bit of a non-linear curve
I have data that looks something like this:
I need an Excel formula that given the dollars on the left would produce the quantities on the right.
It's not a linear regression. The slight curve it ...
0
votes
2
answers
7k
views
Excel use dates as x axis, but numbers to fit regression equation
I have some data that fits a linear trend over time. When I fit a regression line, I get a formula that has a negative 42000 in it. When presenting, this number may cause confusion. I would still like ...
0
votes
3
answers
2k
views
How to get coefficient from logarithmic regression in Excel
Suppose that I have two columns of data, C1:C5 as inputs and D1:D5 as responses, and I set a logarithmic trendline on the resulting scatterplot. As an example, set C1:C5 to 1, 2, 3, 4, 5; and D1:D5 as ...
0
votes
1
answer
73
views
How to plot two different sets of scatter points against number of months and calculate regression line?
Say I have the following table:
Month
X
April 2015
2
May 2015
6
June 2015
16
July 2015
August 2015
I also have another table:
Month
Y
April 2015
19
May 2015
20
June 2015
18
July 2015
...
1
vote
1
answer
2k
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
1
answer
108
views
Factoring business growth into linear regression
I am looking to run a pretty basic linear regression in excel with the products price as the Independent Variable and QTY sold as the Dependent variable. I have 5 years of sales data with each row ...
1
vote
1
answer
667
views
How to fit a polynomial trendline such that only the leading two coefficients are non-zero in Excel?
I have data on the displacement of an object over time and a cubic trendline fits it very well.
I know that the initial displacement is 0 so I can tick the "set intercept" box.
However, I also know ...
0
votes
1
answer
31
views
Non-linear regression between two series with mismatched X axes
I have two data series. I wish to find the linear regression to take a value from series 1 (raw sensor data) and calculate the closest point from series 2 (calibration data) inside my device. However, ...
0
votes
0
answers
70
views
Very High Correlations In Forex Data
I have a regression problem where I'm working on predicting future close price value change of a certain forex pair, mainly USDJPY, so I did the following:
Get the forex historical data of USDJPY ...
2
votes
1
answer
428
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 ...
0
votes
0
answers
43
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:
+-------------+------------+-----------...
0
votes
0
answers
1k
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 ...
0
votes
2
answers
468
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
275
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
647
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 when ...
2
votes
3
answers
4k
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 ...