{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","z test (1 sample)","1 sample t-test"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":2,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Average"]
["Student01",12.3]
["Student02",14.8]
["Student03",15.3]
["Student04",9.5]
["Student05",8.6999999999999993]
["Student06",6.5]
["Student07",17.3]
["Student08",11.4]
["Student09",11.2]
["Student10",10.1]
["Student11",10.6]
["Student12",11.2]
["Student13",14.8]
["Student14",8.6999999999999993]
["Student15",9.6]
["Student16",9.9]
["Student17",4.2]
["Student18",7.3]
["Student19",12.5]
["Student20",14.2]
["Student21",16.3]
["Student22",11.1]
["Student23",17.8]
["Student24",12.2]
["Student25",9.6999999999999993]
["Student26",10.3]
["Student27",10]
["Student28",9]
["Student29",7]
["Student30",2.5]
["Student31",16.7]
["Student32",11.8]
["Student33",12.5]

{"sheet":"z test (1 sample)","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[28,1,29,9]]}
[null,"XLSTAT 2018.4.12345 - One-sample t-test and z-test - Start time: 01/06/2018 at 22:56:35 / End time: 01/06/2018 at 22:56:36 / Microsoft Excel 16.09330"]
[null,"Data: Workbook = demo01_t_test_EN.xlsm / Sheet = Data / Range = 'Data'!$B:$B / 33 rows and 1 column"]
[null,"Theoretical mean: 11,5"]
[null,"Significance level (%): 5"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Average",33,0,33,2.5,17.8,11.121212121212119,3.5563989490562622]
[]
[]
[null,"One-sample z-test / Lower-tailed test:"]
[]
[null,"95% confidence interval on the difference between the means:"]
[null,"] -Inf ;",11.278694866285589]
[]
[null,"Difference",-0.3787878787878789]
[null,"z (Observed value)",-3.9563103626294973]
[null,"z (Critical value)",-1.6448536269514726]
[null,"p-value (one-tailed)","< 0,0001"]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The difference between the means is equal to 0."]
[null,"Ha: The difference between the means is lower than 0."]
[null,"As the computed p-value is lower than the significance level alpha=0,05, one should reject the null hypothesis H0, and accept the alternative hypothesis Ha."]
[]
[null,"The risk to reject the null hypothesis H0 while it is true is lower than 0,01%."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"1 sample t-test","index":2,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[29,1,30,9]]}
[null,"XLSTAT 2018.4.12345 - One-sample t-test and z-test - Start time: 01/06/2018 at 22:56:17 / End time: 01/06/2018 at 22:56:18 / Microsoft Excel 16.09330"]
[null,"Data: Workbook = demo01_t_test_EN.xlsm / Sheet = Data / Range = 'Data'!$B:$B / 33 rows and 1 column"]
[null,"Theoretical mean: 11,5"]
[null,"Significance level (%): 5"]
[]
[]
[]
[]
[null,"Summary statistics:"]
[]
[null,"Variable","Observations","Obs. with missing data","Obs. without missing data","Minimum","Maximum","Mean","Std. deviation"]
[null,"Average",33,0,33,2.5,17.8,11.121212121212119,3.5563989490562622]
[]
[]
[null,"One-sample t-test / Lower-tailed test:"]
[]
[null,"95% confidence interval on the difference between the means:"]
[null,"] -Inf ;",12.16988101651517]
[]
[null,"Difference",-0.3787878787878789]
[null,"t (Observed value)",-0.61184662649381516]
[null,"t (Critical value)",-1.6938887483764378]
[null,"DF",32]
[null,"p-value (one-tailed)",0.27248111591329544]
[null,"alpha",0.05]
[]
[null,"Test interpretation:"]
[null,"H0: The difference between the means is equal to 0."]
[null,"Ha: The difference between the means is lower than 0."]
[null,"As the computed p-value is greater than the significance level alpha=0,05, one cannot reject the null hypothesis H0."]
[]
[null,"The risk to reject the null hypothesis H0 while it is true is 27,25%."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]