POST
|
There is one tracts table and one OLS table. there are 10,000 rows in the tracts table.
... View more
02-17-2020
03:10 PM
|
0
|
1
|
117
|
POST
|
There is one OLS table for the whole "tracts" table. It is a one-to-many relationship.
... View more
02-17-2020
02:45 PM
|
0
|
3
|
717
|
POST
|
When I run the Ordinary Least Squares tool the result is a regression that is reported in OLS_Coefficients. The regression is based on home sales with a known sales price. I am trying to take the Coefficient of each variable and apply it to homes that we don't have sales data on. We have the same Variable but just don't know the price.
... View more
02-17-2020
12:15 PM
|
0
|
5
|
717
|
POST
|
I am trying to calculate the tracts.Value field by using the below equation. I can do it once but, as soon as I run a different regression, I have to change all of the coefficients for each Variable. Furthermore, I have 20+ variables to use and, therefore, the number of variables can fluctuate.
... View more
02-17-2020
11:28 AM
|
0
|
7
|
717
|
POST
|
Ran Ordinary Least Squares and the output table is in Excel. I am using the data from the 5 variables to predict the value in another data set with the same variables. I was hoping to have a calculated field where I could multiply the coefficient times the whole column for all 5 variables. Coefficient 1 times Variable 1, Coefficient 2 times variable 2, etc. Does anyone have any experience doing this?
... View more
02-14-2020
01:24 PM
|
0
|
11
|
956
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|