Skip to main content
Web Applications

Return to Question

Tweeted twitter.com/#!/StackWebApps/status/394505670084796416
added example
Source Link
emmby
emmby
  • 1.4k
  • 3
  • 14
  • 15

I have a column in a google spreadsheet that's calculated as a function of a few other variables (columns).

Is there a function that I can use to find which of the variables has the most influence over the column? For example, if the value of my column changes with the square of col B but only linearly with col C, the function would return col B.

So given a table like the one on the left, I'd like to find a function that can compute the answer in yellow on the right (assuming that col B is the dominating variable):

enter image description here

I have a column in a google spreadsheet that's calculated as a function of a few other variables (columns).

Is there a function that I can use to find which of the variables has the most influence over the column? For example, if the value of my column changes with the square of col B but only linearly with col C, the function would return col B.

I have a column in a google spreadsheet that's calculated as a function of a few other variables (columns).

Is there a function that I can use to find which of the variables has the most influence over the column? For example, if the value of my column changes with the square of col B but only linearly with col C, the function would return col B.

So given a table like the one on the left, I'd like to find a function that can compute the answer in yellow on the right (assuming that col B is the dominating variable):

enter image description here

Source Link
emmby
emmby
  • 1.4k
  • 3
  • 14
  • 15

Finding the most important contributor to a column in Google Spreadsheet

I have a column in a google spreadsheet that's calculated as a function of a few other variables (columns).

Is there a function that I can use to find which of the variables has the most influence over the column? For example, if the value of my column changes with the square of col B but only linearly with col C, the function would return col B.