nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I calculate a field using data from Excel

jamesluscher

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?

Najděte více příspěvků označených jako

Accepted answers

All comments

DavidPike

You could add the xls as a gdb table then use search and update cursors to do the calculations.

jamesluscher

Thank you. I am not well steeped in Python.

DavidPike

If you send some pictures of the tables and a comprehensive explanation of what you want to achieve, I can write it out.

jamesluscher

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.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.