Skip to main content

Faster way to test possible points-to-plane-fitting identity?


Summary: I want to confirm the three sum-defined quantities in https://github.com/barrycarter/bcapps/blob/master/STACK/planetest.m (also below) are identically zero for all values of n>=3.


While attempting to solve https://stats.stackexchange.com/questions/196655 (fitting points to a plane), I came up with these (probably either wrong or previously derived by someone else) formulas for a,b,c such that z=a*x+b*y+c is a best fit for n points x[i], y[i], and z[i]:



a =
-((Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]^2*Sum[x[i]*z[i], {i, 1, n}] +

n*Sum[y[i]^2, {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]))

b =
-((-(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}]) +

Sum[x[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]^2*Sum[y[i]*z[i], {i, 1, n}] +
n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]))


c =
(Sum[x[i]*y[i], {i, 1, n}]^2*Sum[z[i], {i, 1, n}] -
Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] +
Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*

Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}])

To confirm these values, I'd compute the sum of the differences squared. Each term would look like this:


diff[i_] = (z[i]-(a*x[i]+b*y[i]+c))^2


Treating the sum as a function of a,b,c, I would take partials with respect to these three variables and set equal to 0.


Since derivatives add, I would be adding the sum of the derivatives of each term:



derva[i_] = -2*x[i]*(-c - a*x[i] - b*y[i] + z[i])
dervb[i_] = -2*y[i]*(-c - a*x[i] - b*y[i] + z[i])
dervc[i_] = -2*(-c - a*x[i] - b*y[i] + z[i])


and setting each sum equal to 0.


Mathematica won't solve that for arbitrary n (which I sort of expected):



Solve[{
Sum[derva[i],{i,1,n}] == 0,
Sum[dervb[i],{i,1,n}] == 0,
Sum[dervc[i],{i,1,n}] == 0
}, {a,b,c}]


Out[74] = {}

and Reduce doesn't help either. Keeping the derivative outside the sum doesn't work either, albeit with a different error message (the standard Solve::nsmet: This system cannot be solved with the methods available to Solve.).


Mathematica will solve for a,b,c for specific values of n, which led me to the guess above.


To test my guess, I need to confirm that each partial derivative is zero. In other words, I need to confirm:



Sum[-2*x[i]*(-c - a*x[i] - b*y[i] + z[i]),{i,1,n}] == 0
Sum[-2*y[i]*(-c - a*x[i] - b*y[i] + z[i]),{i,1,n}] == 0
Sum[-2*(-c - a*x[i] - b*y[i] + z[i]),{i,1,n}] == 0


are identically zero for all values of x[i], y[i], z[i], and n, when I put in my guesses above.


In other words (these are the big ugly equations which I'm intentionally giving in "full" form for those who don't want to read the rest of this question)...:



atest[n_] :=

Sum[-2*x[i]*(-((Sum[x[i]*y[i], {i, 1, n}]^2*Sum[z[i], {i, 1, n}] -
Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*
Sum[x[i]*z[i], {i, 1, n}] + Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*
Sum[x[i]*z[i], {i, 1, n}] + Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*

Sum[y[i]*z[i], {i, 1, n}] - Sum[x[i], {i, 1, n}]*
Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 - 2*Sum[x[i], {i, 1, n}]*
Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}])) +
((Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]^2*Sum[x[i]*z[i], {i, 1, n}] +

n*Sum[y[i]^2, {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])*x[i])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}]) +
((-(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}]) +
Sum[x[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] +

Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]^2*Sum[y[i]*z[i], {i, 1, n}] +
n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])*y[i])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}]) + z[i]), {i, 1, n}];


btest[n_] :=

Sum[-2*y[i]*(-((Sum[x[i]*y[i], {i, 1, n}]^2*Sum[z[i], {i, 1, n}] -
Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*
Sum[x[i]*z[i], {i, 1, n}] + Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*
Sum[x[i]*z[i], {i, 1, n}] + Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*
Sum[y[i]*z[i], {i, 1, n}] - Sum[x[i], {i, 1, n}]*
Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 - 2*Sum[x[i], {i, 1, n}]*

Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}])) +
((Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]^2*Sum[x[i]*z[i], {i, 1, n}] +
n*Sum[y[i]^2, {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])*x[i])/

(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}]) +
((-(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}]) +
Sum[x[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]^2*Sum[y[i]*z[i], {i, 1, n}] +

n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])*y[i])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}]) + z[i]), {i, 1, n}];

ctest[n_] :=

Sum[-2*(-((Sum[x[i]*y[i], {i, 1, n}]^2*Sum[z[i], {i, 1, n}] -

Sum[x[i]^2, {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*
Sum[x[i]*z[i], {i, 1, n}] + Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*
Sum[x[i]*z[i], {i, 1, n}] + Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*
Sum[y[i]*z[i], {i, 1, n}] - Sum[x[i], {i, 1, n}]*
Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 - 2*Sum[x[i], {i, 1, n}]*
Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*

Sum[y[i]^2, {i, 1, n}])) +
((Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]*Sum[y[i]^2, {i, 1, n}]*Sum[z[i], {i, 1, n}] -
Sum[y[i], {i, 1, n}]^2*Sum[x[i]*z[i], {i, 1, n}] +
n*Sum[y[i]^2, {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])*x[i])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +
n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*

Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}]) +
((-(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}]) +
Sum[x[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}]*Sum[z[i], {i, 1, n}] +
Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
n*Sum[x[i]*y[i], {i, 1, n}]*Sum[x[i]*z[i], {i, 1, n}] -
Sum[x[i], {i, 1, n}]^2*Sum[y[i]*z[i], {i, 1, n}] +
n*Sum[x[i]^2, {i, 1, n}]*Sum[y[i]*z[i], {i, 1, n}])*y[i])/
(Sum[x[i]^2, {i, 1, n}]*Sum[y[i], {i, 1, n}]^2 -
2*Sum[x[i], {i, 1, n}]*Sum[y[i], {i, 1, n}]*Sum[x[i]*y[i], {i, 1, n}] +

n*Sum[x[i]*y[i], {i, 1, n}]^2 + Sum[x[i], {i, 1, n}]^2*
Sum[y[i]^2, {i, 1, n}] - n*Sum[x[i]^2, {i, 1, n}]*
Sum[y[i]^2, {i, 1, n}]) + z[i]), {i, 1, n}];

I'm claiming atest[n], btest[n], ctest[n] are identially 0 for all values of n>=3.


How far I've gotten on my own:




t = Table[Simplify[{atest[i], btest[i], ctest[i]}], {i,3,6}]


Out[1]= {{0, 0, 0}, {0, 0, 0}, {0, 0, 0}, {0, 0, 0}}


However, Simplify[atest[7]] just hangs. Even if I waited for it, I suspect Simplifying atest, btest, and ctest for larger numbers would take even longer.


I realize I'm asking Mathematica to do a lot, especially since I'm using symbols instead of actual numbers, but is there a good way to verify this identity for all n>=3 (or prove its false, of course).


For anyone interested, https://github.com/barrycarter/bcapps/blob/master/STACK/bc-solve-stats-196655.m has some notes re how I 'derived' this.



Answer



Here is my take at generating the identities you are trying to test; I will confess that I am not completely sure of what testing you need to carry out, so I hope that you will be able to compare the expressions obtained below with those you already have.


To set up the 3D linear regression problem I will use generic 3D points {x[i], y[i], z[i]}, and parameters $(a,b,c)$.


(* Generate the sum of squares to be minimized *)

Sum[Expand[(a x[i] + b y[i] + c - z[i])^2], {i, 1, n}]

sum of squares


(* Calculate the derivatives *)
Grad[%, {a, b, c}] // TableForm

gradient


(* Use linearity of sums *)
Distribute /@ % // TableForm


distributed form


At this point, you will want to pull out the numerical and parameter constants from the summations to simplify the problem. Below is a set of very handy replacement rules that will help you do that, courtesy of Peltio who originally used them with Integrate, but they work with Sum right out of the box after swapping the right function name in:


outrules = {
Sum[f_ + g_, it : {x_Symbol, __}] :> Sum[f, it] + Sum[g, it],
Sum[c_ f_, it : {x_Symbol, __}] :> c Sum[f, it] /; FreeQ[c, x],
Sum[c_, it : {x_Symbol, __}] :> c Sum[1, it] /; FreeQ[c, x]
};

These must be applied repeatedly using ReplaceRepeated (//.) until the result doesn't change anymore:


(* Pull out any constants from summations *)

% //. outrules // TableForm

sum of squares in separated form


Now it's just a matter of setting the derivatives to zero to generate a system of three linear equations:


(* Set the derivatives equal to zero to generate the system of equations *)
Simplify[Thread[% == 0]] // TableForm

simplified equations


Now is a good time to simplify the notation a bit by introducing names for the summation results that act as constants in this system:


% //. {

Sum[x[i], {i, 1, n}] -> sumX, Sum[y[i], {i, 1, n}] -> sumY, Sum[z[i], {i, 1, n}] -> sumZ,

Sum[x[i]*y[i], {i, 1, n}] -> sumXY,
Sum[y[i]*z[i], {i, 1, n}] -> sumYZ,
Sum[x[i]*z[i], {i, 1, n}] -> sumXZ,

Sum[x[i]^2, {i, 1, n}] -> sumX2, Sum[y[i]^2, {i, 1, n}] -> sumY2
} // TableForm

simplified equations with named constants



Finally we can Solve this linear equation for $(a,b,c)$:


Solve[%, {a, b, c}]

explicit solutions


Comments

Popular posts from this blog

plotting - How to draw lines between specified dots on ListPlot?

I would like to create a plot where I have unconnected dots and some connected. So far, I have figured out how to draw the dots. My code is the following: ListPlot[{{1, 1}, {2, 2}, {3, 3}, {4, 4}, {1, 4}, {2, 5}, {3, 6}, {4, 7}, {1, 7}, {2, 8}, {3, 9}, {4, 10}, {1, 10}, {2, 11}, {3, 12}, {4,13}, {2.5, 7}}, Ticks -> {{1, 2, 3, 4}, None}, AxesStyle -> Thin, TicksStyle -> Directive[Black, Bold, 12], Mesh -> Full] I have thought using ListLinePlot command, but I don't know how to specify to the command to draw only selected lines between the dots. Do have any suggestions/hints on how to do that? Thank you. Answer One possibility would be to use Epilog with Line : ListPlot[ {{1, 1}, {2, 2}, {3, 3}, {4, 4}, {1, 4}, {2, 5}, {3, 6}, {4, 7}, {1, 7}, {2, 8}, {3, 9}, {4, 10}, {1, 10}, {2, 11}, {3, 12}, {4, 13}, {2.5, 7}}, Ticks -> {{1, 2, 3, 4}, None}, AxesStyle -> Thin, TicksStyle -> Directive[Black, Bold, 12], Mesh -> Full, Epilog -> { Line[ ...

calculus and analysis - Integral of the Sinc product

Let us consider the following integral $$ B_n = \int_0^\infty \prod_{k=1,3,5,\dots}^n\frac{\sin (x/k)}{x/k}dx $$ By definition, Sinc[x] == Sin[x]/x , therefore B[n_?OddQ] := Integrate[Product[Sinc[x/k], {k, 1, n, 2}], {x, 0, Infinity}] B /@ Range[1, 13, 2] {Pi/2, Pi/2, Pi/2, Pi/2, Pi/2, Pi/2, Pi/2} OK, everything is fine. But... B[15] 467807924713440738696537864469 Pi/935615849440640907310521750000 What's going on? Answer As Eckhard wrote in comments B[n] is the n-th Borwein integral . (The letter B was not accidental :) ) This funny properties of Borwein integrals is related to the Fourier transform of Sinc function FourierTransform[Sinc[x], x, k] 1/2 Sqrt[Pi/2] (Sign[1 - k] + Sign[1 + k]) Plot[%, {k, -2, 2}, Filling -> 0] which is the box function. The result is $\pi/2$ while the sum $$ 1/3+1/5+\dots+1/n $$ B_n = \frac{\pi}{2} - \pi \bigg(\sum_{k=3,5,\ldots}^n\frac{1}{k} -1\biggr)^\frac{n-1}{2}\prod_{k=3,5,\dots}^n\frac{k}{k-1}. $$ For $n=15$ it is equal to $$ \frac{46780...

list manipulation - Selecting multiple columns from a matrix?

Sample data: data = { {{2013, 1, 1}, 24.13, 167.67, 231.82}, {{2013, 1, 2}, 32.15, 170.92, 225.99}, {{2013, 1, 3}, 35.43, 172.68, 221.67}, {{2013, 1, 4}, 36.73, 173.05, 218.32}, {{2013, 1, 5}, 58.19, 165.96, 197.05}, {{2013, 1, 6}, 69.99, 163.50, 187.52}, {{2013, 1, 7}, 71.37, 154.21, 175.58}, {{2013, 1, 8}, 72.51, 149.66, 163.25}}; I want a DateListPlot with three graphs, so for a matrix formed by columns 1 and 2, one for columns 1 and 3, and 1 for columns 1 and 4. At the moment I'm using this code: data2 = Transpose[{data[[All, 1]], data[[All, 2]]}]; data3 = Transpose[{data[[All, 1]], data[[All, 3]]}]; data4 = Transpose[{data[[All, 1]], data[[All, 4]]}]; DateListPlot[{data2, data3, data4}, Joined -> True, Filling -> {3 -> {1}}] but I have a hunch that this can be done more efficiently. I don't like the Transpose s in particular. Any ideas? edit (for extra credit) What if I need to multiply the second column by 2, which in my solution is simp...