Oinsa Uza Add Ins Analysis Toolpak iha Excel

September 07, 20180 Comments



Analysis Toolpak maka instrumentu/ add ins ida iha MS. Excel ne'ebe uza hodi halo analiza dadus statistik hanesan: Analisis Regresi Excel, Uji F no Uji T, Z Test, T Paired Excel, Independen T Test Excel no seluk tan.
Iha materia ida ne'e, sei esplika uluk oinsa atu halo ativu add ins husi Analysis Toolpak, maka hanesan tuir mai :

  • Klik uluk lai iha Office Button | Klik Iha Excel Options
  • Klik iha Add-Ins | hili no Klik iha Analysis Toolpak | Klik Iha Go... 
  • Klik ho hili fali Analysis ToolPak | Klik OK 
  • Kuandu mosu no husu atu instala fila fali Add ins, hili Yes ka OK
  • Sei mosu Submenu foun ida iha Data ho naran Data Analysis
Tuir mai ita sei halo Sampel ida hodi koko Add Ins uza metodo Descriptive Statistics. Antes halo analiza, halo uluk tia lai tabela ba dadus nebe maka hakarak analiza:
  • Halo tabela dadus ba Tinan nian, labele uza dadus nebe uza textu no tenki uza formatu numeru
  • Klik no hili iha Data Analysis:
  • Klik no holi iha Descriptive Statistics | Klik OK 
  • Iha Input Range, Klik iha kaixa kiik nia laran, depois Blok dadus iha tabela Tinan nian (Blok deit maka nia tinan, Textu tinan labele Blok) 
  • Klik iha Summary Statistics 
  • Klik iha Confidence Level for Mean. nia pursentu bele troka bele mos lae. depende nesesidade analiza 
  • Klik OK 
  • Sei mosu Resultadu analiza uza Analiza Descriptive hanesan tuir mai : 
  • Resultadu iha leten, esplika klaru konaba dadus nebe analiza komesa husi nia Mean, Standard Error, Median, Mode, ect 
  • Analiza Statistika seluk mos bele halo uza Analysis Toolpak no bele tuir nia nesesidade.