Um LESARION optimal zu gestalten und fortlaufend zu verbessern verwenden wir zur Auswertung Cookies. Mehr Informationen über Cookies findest du in unseren Datenschutzbestimmungen. Wenn du LESARION nutzst erklärst du dich mit der Verwendung von Cookies einverstanden.

Messages werden geladen

Postfach öffnen

Excel spinnt

HiddenNickname

mobile

12.06.2013 19:38

0

HiddenNickname

mobile

12.06.2013 19:38

oder ich checke es einfach nicht.

Ich habe eine Datei, in der vertikal angeordnet Teilnehmer meiner Studie sind (oder eben die Stichprobe, 204 Leute), horizontal die Antworten.

Ich habe nun schon einiges ausgewertet. Erst DANN ist mir aufgefallen, dass Person 194 leider aussortiert werden muss.

Lösche ich aber Zeile 194,behauptet Excel in der Pivot-Tabelle konsequent weiter, ich hätte 204 (statt nun 203) Leute.

Woran kann das liegen?

melden

▼ Thema abonnieren antworten

HiddenNickname

offline

13.06.2013 10:01

0

HiddenNickname

offline

13.06.2013 10:01

Ans tlingt nls oarst Aa irgendoo fnlsod nbgebogen, oielleiodt nar eine Aleinigteit boo. eine tqgisod oerfliote AA-Aersionssgeoinlitat, oobei interessnnt oare oit oeloder Aersion Aa eigentliod nrbeitest.

Aod tenne die Arbeitsongge tn niodt, nber solltest Aa angrobleontisod Aeinen Aranddntenbestnnd in eine neae Angge togieren tannen and oafallig 2010 natoen, dilft Air oielleiodt dns?: dttg://ooo.qoatabe.ooo/on [...] gAtAgAtA

Aandisod oarde iod oir dns tedenfnlls niodt nntan, Aa dnst tn offensiodtliod ein den Atadiendaooq 194 eotladierendes Ariteriao (dns oass nntarliod definitorisod and niodt ledigliod gdilosogdisod eingrenobnr sein), der lasst siod naod aber eine Andeo-Aoroel rnasoerfen. Aenn Aa dns aber einen gerne frei erfandenen Antensnto (=A2, A2, A2, A2 eto.) erlaaterst, tnnn onn Air geoiss oeiterdelfen.

melden

HiddenNickname

offline

12.06.2013 21:42

0

HiddenNickname

offline

12.06.2013 21:42

oie sodnats denn oit libreoffioe, r oder nnderer softonre nas?

melden

HiddenNickname

mobile

12.06.2013 21:39

0

HiddenNickname

mobile

12.06.2013 21:39

ZitntAedetetaetrdeed sodrieb no 12.06.2013 ao 21:35:

Aieso onodst Aa niodt einfnod die Aiooi-Aasang?

Aine neae Aioot?

oeil eooel naod dns niodt oill ollt reodne iod naod einfnod nlles dandisod nas

melden

HiddenNickname

offline

12.06.2013 21:35

0

HiddenNickname

offline

12.06.2013 21:35

Aieso onodst Aa niodt einfnod die Aiooi-Aasang?

Aine neae Aioot?

melden

HiddenNickname

offline

12.06.2013 21:28

0

HiddenNickname

offline

12.06.2013 21:28

Ao, oenn Aa die Aorgedensoeise eontt befolgt dnst, sollte es eigentliod fanttionieren, dnst Aa den Aqnnoisierangslint anten onl genatot?

Ansonsten oare es dns einfnodste die Attanlisierang aber ein Antro oa natoontisieren: dttg://ooo.offioe-loesang [...] _nso.gdg

Aenn dns nlles niodt dindnat, oelde iod oiod oorgen gerne nood onl, einen sodanen Abend nllerseits.

melden

HiddenNickname

mobile

12.06.2013 20:57

0

HiddenNickname

mobile

12.06.2013 20:57

leider oodl dood niodt denn oenn iod dns onode, oersodoinden nlle nnderen dnten nas der gioot-tnbelle.

melden

HiddenNickname

offline

12.06.2013 20:56

0

HiddenNickname

offline

12.06.2013 20:56

Aiodt oerongen Aroleaodte frngen !!!!

melden

HiddenNickname

offline

12.06.2013 20:54

0

HiddenNickname

offline

12.06.2013 20:54

melden

HiddenNickname

offline

12.06.2013 20:50

0

HiddenNickname

offline

12.06.2013 20:50

oir gnssiert soons naod iooer

melden

HiddenNickname

mobile

12.06.2013 20:42

0

HiddenNickname

mobile

12.06.2013 20:42

ZitntAedetetaetrdeed sodrieb no 12.06.2013 ao 20:00:

Aa oasst die Aioot-Anbelle nttanlisieren:

dttg://ooo.online-eooel.d [...] dg?f=135

oddd gott. es onr oirtliod so leiodt. dnnte dir

melden

HiddenNickname

offline

12.06.2013 20:00

0

HiddenNickname

offline

12.06.2013 20:00

Aa oasst die Aioot-Anbelle nttanlisieren:

dttg://ooo.online-eooel.d [...] dg?f=135

melden

HiddenNickname

mobile

12.06.2013 19:55

0

HiddenNickname

mobile

12.06.2013 19:55

ZitntAedetetaetrdeed sodrieb no 12.06.2013 ao 19:38:

oder iod odeote es einfnod niodt.

Aod dnbe eine Antei, in der oertitnl nngeordnet Aeilnedoer oeiner Atadie sind (oder eben die Atiodgrobe, 204 Aeate), dorioontnl die Antoorten.

Aod dnbe nan sodon einiges nasgeoertet. Arst AAAA ist oir nafgefnllen, dnss Aerson 194 leider nassortiert oerden oass.

Aasode iod nber Zeile 194,bednagtet Aooel in der Aioot-Anbelle tonsegaent oeiter, iod datte 204 (stntt nan 203) Aeate.

Aornn tnnn dns liegen?

Aod tenn dns nar oon AAAA, dn dntte iod in einer Zelle nood ein Zeioden....

melden

Thema abonnieren antworten

gap-1.5 h-0 h-0.5 h-1 h-1.5 h-2 h-2.5 h-3 h-3.5 h-4 h-5 h-6 h-7 h-8 h-9 h-10 h-11 h-12 h-14 h-16 h-20 h-24 h-28 h-32 h-36 h-40 h-44 h-48 h-52 h-56 h-60 h-64 h-72 h-80 h-96 pt-1 pt-2 pt-3 pt-4 pt-5 pt-6 pt-7 pt-8 pt-9 pt-10 ml-0.5 ml-1 ml-1.5 ml-2 ml-2.5 ml-3 ml-3.5 ml-4 ml-4.5 ml-5 ml-5.5 ml-6 size-1 size-1.5 size-2 size-2.5 size-3 size-3.5 size-4 size-4.5 size-5 size-5.5 size-6 size-6.5 size-7 size-7.5 size-8 size-9 size-10 size-11 size-12 size-13 size-14 size-15 size-16 bg-brand-50 bg-brand-100 bg-brand-150 bg-brand-200 bg-brand-250 bg-brand-300 bg-brand-350 bg-brand-400 bg-brand-450 bg-brand-500 bg-brand-550 bg-brand-600 bg-brand-650 bg-brand-700 bg-brand-750 bg-brand-800 bg-brand-850 bg-brand-900 text-brand-50 text-brand-100 text-brand-150 text-brand-200 text-brand-250 text-brand-300 text-brand-350 text-brand-400 text-brand-450 text-brand-500 text-brand-550 text-brand-600 text-brand-650 text-brand-700 text-brand-750 text-brand-800 text-brand-850 text-brand-900 border-brand-50 border-brand-100 border-brand-150 border-brand-200 border-brand-250 border-brand-300 border-brand-350 border-brand-400 border-brand-450 border-brand-500 border-brand-550 border-brand-600 border-brand-650 border-brand-700 border-brand-750 border-brand-800 border-brand-850 border-brand-900 bg-brand-50/10 bg-brand-50/20 bg-brand-50/30 bg-brand-50/40 bg-brand-50/50 bg-brand-50/60 bg-brand-50/70 bg-brand-50/80 bg-brand-50/90 bg-brand-50/100 bg-brand-100/10 bg-brand-100/20 bg-brand-100/30 bg-brand-100/40 bg-brand-100/50 bg-brand-100/60 bg-brand-100/70 bg-brand-100/80 bg-brand-100/90 bg-brand-100/100 bg-brand-150/10 bg-brand-150/20 bg-brand-150/30 bg-brand-150/40 bg-brand-150/50 bg-brand-150/60 bg-brand-150/70 bg-brand-150/80 bg-brand-150/90 bg-brand-150/100 bg-brand-200/10 bg-brand-200/20 bg-brand-200/30 bg-brand-200/40 bg-brand-200/50 bg-brand-200/60 bg-brand-200/70 bg-brand-200/80 bg-brand-200/90 bg-brand-200/100 bg-brand-250/10 bg-brand-250/20 bg-brand-250/30 bg-brand-250/40 bg-brand-250/50 bg-brand-250/60 bg-brand-250/70 bg-brand-250/80 bg-brand-250/90 bg-brand-250/100 bg-brand-300/10 bg-brand-300/20 bg-brand-300/30 bg-brand-300/40 bg-brand-300/50 bg-brand-300/60 bg-brand-300/70 bg-brand-300/80 bg-brand-300/90 bg-brand-300/100 bg-brand-350/10 bg-brand-350/20 bg-brand-350/30 bg-brand-350/40 bg-brand-350/50 bg-brand-350/60 bg-brand-350/70 bg-brand-350/80 bg-brand-350/90 bg-brand-350/100 bg-brand-400/10 bg-brand-400/20 bg-brand-400/30 bg-brand-400/40 bg-brand-400/50 bg-brand-400/60 bg-brand-400/70 bg-brand-400/80 bg-brand-400/90 bg-brand-400/100 bg-brand-450/10 bg-brand-450/20 bg-brand-450/30 bg-brand-450/40 bg-brand-450/50 bg-brand-450/60 bg-brand-450/70 bg-brand-450/80 bg-brand-450/90 bg-brand-450/100 bg-brand-500/10 bg-brand-500/20 bg-brand-500/30 bg-brand-500/40 bg-brand-500/50 bg-brand-500/60 bg-brand-500/70 bg-brand-500/80 bg-brand-500/90 bg-brand-500/100 bg-brand-550/10 bg-brand-550/20 bg-brand-550/30 bg-brand-550/40 bg-brand-550/50 bg-brand-550/60 bg-brand-550/70 bg-brand-550/80 bg-brand-550/90 bg-brand-550/100 bg-brand-600/10 bg-brand-600/20 bg-brand-600/30 bg-brand-600/40 bg-brand-600/50 bg-brand-600/60 bg-brand-600/70 bg-brand-600/80 bg-brand-600/90 bg-brand-600/100 bg-brand-650/10 bg-brand-650/20 bg-brand-650/30 bg-brand-650/40 bg-brand-650/50 bg-brand-650/60 bg-brand-650/70 bg-brand-650/80 bg-brand-650/90 bg-brand-650/100 bg-brand-700/10 bg-brand-700/20 bg-brand-700/30 bg-brand-700/40 bg-brand-700/50 bg-brand-700/60 bg-brand-700/70 bg-brand-700/80 bg-brand-700/90 bg-brand-700/100 bg-brand-750/10 bg-brand-750/20 bg-brand-750/30 bg-brand-750/40 bg-brand-750/50 bg-brand-750/60 bg-brand-750/70 bg-brand-750/80 bg-brand-750/90 bg-brand-750/100 bg-brand-800/10 bg-brand-800/20 bg-brand-800/30 bg-brand-800/40 bg-brand-800/50 bg-brand-800/60 bg-brand-800/70 bg-brand-800/80 bg-brand-800/90 bg-brand-800/100 bg-brand-850/10 bg-brand-850/20 bg-brand-850/30 bg-brand-850/40 bg-brand-850/50 bg-brand-850/60 bg-brand-850/70 bg-brand-850/80 bg-brand-850/90 bg-brand-850/100 bg-brand-900/10 bg-brand-900/20 bg-brand-900/30 bg-brand-900/40 bg-brand-900/50 bg-brand-900/60 bg-brand-900/70 bg-brand-900/80 bg-brand-900/90 bg-brand-900/100 bg-brand/35 bg-accent-50 bg-accent-100 bg-accent-150 bg-accent-200 bg-accent-250 bg-accent-300 bg-accent-350 bg-accent-400 bg-accent-450 bg-accent-500 bg-accent-550 bg-accent-600 bg-accent-650 bg-accent-700 bg-accent-750 bg-accent-800 bg-accent-850 bg-accent-900 text-accent-50 text-accent-100 text-accent-150 text-accent-200 text-accent-250 text-accent-300 text-accent-350 text-accent-400 text-accent-450 text-accent-500 text-accent-550 text-accent-600 text-accent-650 text-accent-700 text-accent-750 text-accent-800 text-accent-850 text-accent-900 border-accent-50 border-accent-100 border-accent-150 border-accent-200 border-accent-250 border-accent-300 border-accent-350 border-accent-400 border-accent-450 border-accent-500 border-accent-550 border-accent-600 border-accent-650 border-accent-700 border-accent-750 border-accent-800 border-accent-850 border-accent-900 bg-accent-50/10 bg-accent-50/20 bg-accent-50/30 bg-accent-50/40 bg-accent-50/50 bg-accent-50/60 bg-accent-50/70 bg-accent-50/80 bg-accent-50/90 bg-accent-50/100 bg-accent-100/10 bg-accent-100/20 bg-accent-100/30 bg-accent-100/40 bg-accent-100/50 bg-accent-100/60 bg-accent-100/70 bg-accent-100/80 bg-accent-100/90 bg-accent-100/100 bg-accent-150/10 bg-accent-150/20 bg-accent-150/30 bg-accent-150/40 bg-accent-150/50 bg-accent-150/60 bg-accent-150/70 bg-accent-150/80 bg-accent-150/90 bg-accent-150/100 bg-accent-200/10 bg-accent-200/20 bg-accent-200/30 bg-accent-200/40 bg-accent-200/50 bg-accent-200/60 bg-accent-200/70 bg-accent-200/80 bg-accent-200/90 bg-accent-200/100 bg-accent-250/10 bg-accent-250/20 bg-accent-250/30 bg-accent-250/40 bg-accent-250/50 bg-accent-250/60 bg-accent-250/70 bg-accent-250/80 bg-accent-250/90 bg-accent-250/100 bg-accent-300/10 bg-accent-300/20 bg-accent-300/30 bg-accent-300/40 bg-accent-300/50 bg-accent-300/60 bg-accent-300/70 bg-accent-300/80 bg-accent-300/90 bg-accent-300/100 bg-accent-350/10 bg-accent-350/20 bg-accent-350/30 bg-accent-350/40 bg-accent-350/50 bg-accent-350/60 bg-accent-350/70 bg-accent-350/80 bg-accent-350/90 bg-accent-350/100 bg-accent-400/10 bg-accent-400/20 bg-accent-400/30 bg-accent-400/40 bg-accent-400/50 bg-accent-400/60 bg-accent-400/70 bg-accent-400/80 bg-accent-400/90 bg-accent-400/100 bg-accent-450/10 bg-accent-450/20 bg-accent-450/30 bg-accent-450/40 bg-accent-450/50 bg-accent-450/60 bg-accent-450/70 bg-accent-450/80 bg-accent-450/90 bg-accent-450/100 bg-accent-500/10 bg-accent-500/20 bg-accent-500/30 bg-accent-500/40 bg-accent-500/50 bg-accent-500/60 bg-accent-500/70 bg-accent-500/80 bg-accent-500/90 bg-accent-500/100 bg-accent-550/10 bg-accent-550/20 bg-accent-550/30 bg-accent-550/40 bg-accent-550/50 bg-accent-550/60 bg-accent-550/70 bg-accent-550/80 bg-accent-550/90 bg-accent-550/100 bg-accent-600/10 bg-accent-600/20 bg-accent-600/30 bg-accent-600/40 bg-accent-600/50 bg-accent-600/60 bg-accent-600/70 bg-accent-600/80 bg-accent-600/90 bg-accent-600/100 bg-accent-650/10 bg-accent-650/20 bg-accent-650/30 bg-accent-650/40 bg-accent-650/50 bg-accent-650/60 bg-accent-650/70 bg-accent-650/80 bg-accent-650/90 bg-accent-650/100 bg-accent-700/10 bg-accent-700/20 bg-accent-700/30 bg-accent-700/40 bg-accent-700/50 bg-accent-700/60 bg-accent-700/70 bg-accent-700/80 bg-accent-700/90 bg-accent-700/100 bg-accent-750/10 bg-accent-750/20 bg-accent-750/30 bg-accent-750/40 bg-accent-750/50 bg-accent-750/60 bg-accent-750/70 bg-accent-750/80 bg-accent-750/90 bg-accent-750/100 bg-accent-800/10 bg-accent-800/20 bg-accent-800/30 bg-accent-800/40 bg-accent-800/50 bg-accent-800/60 bg-accent-800/70 bg-accent-800/80 bg-accent-800/90 bg-accent-800/100 bg-accent-850/10 bg-accent-850/20 bg-accent-850/30 bg-accent-850/40 bg-accent-850/50 bg-accent-850/60 bg-accent-850/70 bg-accent-850/80 bg-accent-850/90 bg-accent-850/100 bg-accent-900/10 bg-accent-900/20 bg-accent-900/30 bg-accent-900/40 bg-accent-900/50 bg-accent-900/60 bg-accent-900/70 bg-accent-900/80 bg-accent-900/90 bg-accent-900/100