Formatting issue with excel

_k

this is all of my data i am turning into tables with except i have an issue when it comes to putting a trend line to the graphs i am making. The first two data sets will only let me put a linear line to the graph while the third allows an exponential as well as linear. Then the last data set allows for whatever trend line i would like to place. I have to place a linear, exponential, and power line to all sets of data.

<table x:str="" style="border-collapse: collapse; width: 449pt;" border="0" cellpadding="0" cellspacing="0" width="599"><col style="width: 48pt;" span="5" width="64"> <col style="width: 65pt;" width="87"> <col style="width: 48pt;" span="3" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" height="17" width="64">Table A</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">Table B</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">Table C</td> <td style="width: 65pt;" width="87">
</td> <td style="width: 48pt;" width="64">
</td> <td colspan="2" style="width: 96pt;" width="128">Your Group</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">x</td> <td>y</td> <td>x</td> <td>y</td> <td>x</td> <td>y</td> <td>
</td> <td>Mass(g)</td> <td>Length(m)</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">-5</td> <td x:num="" align="right">-11</td> <td x:num="" align="right">-5</td> <td x:num="" align="right">5000</td> <td x:num="" align="right">-5</td> <td x:num="1.52951E-6" align="right">1.52951E-06</td> <td>
</td> <td x:num="" align="right">50</td> <td x:num="0.42499999999999999" align="right">0.425</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">-4</td> <td x:num="" align="right">-7</td> <td x:num="" align="right">-4</td> <td x:num="" align="right">2048</td> <td x:num="" align="right">-4</td> <td x:num="3.07211E-5" align="right">3.07211E-05</td> <td>
</td> <td x:num="" align="right">70</td> <td x:num="" align="right">0.43</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">-3</td> <td x:num="" align="right">-3</td> <td x:num="" align="right">-3</td> <td x:num="" align="right">648</td> <td x:num="" align="right">-3</td> <td x:num="6.1704900000000005E-4" align="right">0.000617049</td> <td>
</td> <td x:num="" align="right">90</td> <td x:num="" align="right">0.44</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">-2</td> <td x:num="" align="right">1</td> <td x:num="" align="right">-2</td> <td x:num="" align="right">128</td> <td x:num="" align="right">-2</td> <td x:num="1.2393761E-2" align="right">0.012393761</td> <td>
</td> <td x:num="" align="right">110</td> <td x:num="0.44600000000000001" align="right">0.446</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">-1</td> <td x:num="" align="right">5</td> <td x:num="" align="right">-1</td> <td x:num="" align="right">8</td> <td x:num="" align="right">-1</td> <td x:num="0.248935342" align="right">0.248935342</td> <td>
</td> <td x:num="" align="right">120</td> <td x:num="0.44900000000000001" align="right">0.449</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">0</td> <td x:num="" align="right">9</td> <td x:num="" align="right">0</td> <td x:num="" align="right">0</td> <td x:num="" align="right">0</td> <td x:num="" align="right">5</td> <td>
</td> <td x:num="" align="right">140</td> <td x:num="0.45600000000000002" align="right">0.456</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">1</td> <td x:num="" align="right">13</td> <td x:num="" align="right">1</td> <td x:num="" align="right">8</td> <td x:num="" align="right">1</td> <td x:num="100.42768460000001" align="right">100.4276846</td> <td>
</td> <td x:num="" align="right">160</td> <td x:num="0.46400000000000002" align="right">0.464</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">2</td> <td x:num="" align="right">17</td> <td x:num="" align="right">2</td> <td x:num="" align="right">128</td> <td x:num="" align="right">2</td> <td x:num="2017.143967" align="right">2017.143967</td> <td>
</td> <td x:num="" align="right">180</td> <td x:num="0.47199999999999998" align="right">0.472</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">3</td> <td x:num="" align="right">21</td> <td x:num="" align="right">3</td> <td x:num="" align="right">648</td> <td x:num="" align="right">3</td> <td x:num="40515.41964" align="right">40515.41964</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">4</td> <td x:num="" align="right">25</td> <td x:num="" align="right">4</td> <td x:num="" align="right">2048</td> <td x:num="" align="right">4</td> <td x:num="813773.9571" align="right">813773.9571</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">5</td> <td x:num="" align="right">29</td> <td x:num="" align="right">5</td> <td x:num="" align="right">5000</td> <td x:num="" align="right">5</td> <td x:num="16345086.859999999" align="right">16345086.86</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>

tmh88

Could you possibly post the excel file itself? I'll mess around with it and see what I can do.

pseudonym

I have a feeling that it might be excel not letting you do something and not a formatting issue. The first one simply is only a linear line so allowing for anything else is redundant/more complicated and excel isn't allowing it. I don't know if there is a way around it.

Here is a csv for anyone interested. Easier to import in than the other post..

x,Table A (y),x,Table B (y),x,Table C (y),Mass(g),Length(m)
-5,-11,-5,5000,-5,1.53E-06,50,0.425
-4,-7,-4,2048,-4,3.07E-05,70,0.43
-3,-3,-3,648,-3,0.000617049,90,0.44
-2,1,-2,128,-2,0.012393761,110,0.446
-1,5,-1,8,-1,0.248935342,120,0.449
0,9,0,0,0,5,140,0.456
1,13,1,8,1,100.4276846,160,0.464
2,17,2,128,2,2017.143967,180,0.472
3,21,3,648,3,40515.41964,,
4,25,4,2048,4,813773.9571,,
5,29,5,5000,5,16345086.86,,

_k

yeah i got it taken care of it thanks for the quick response though

Ryder

Please post what the problem was.. so other people can benefit

_k

you mean solution, I was trying to apply an exponential and power trend line to the data sets and all I had to do was apply log to one and ln to the other data points to be able to plot a linear regression on them and see what the R^2 value of that line was to see if it was the correct fit.