1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
/* xlsx.js (C) 2013-present SheetJS -- http://sheetjs.com *//*global module, require, XLSX:true */if(typeof require !== 'undefined' && typeof XLSX === 'undefined') XLSX = require('xlsx');
function generate_random_file(n) {	if(!n) n = 100;	var aoo = [];	var x_ = 0, y_ = 0, xx = 0, xy = 0;	for(var i = 0; i < n; ++i) {		var y = Math.fround(2 * i + Math.random());		aoo.push({x:i, y:y});		x_ += i / n; y_ += y / n; xx += i*i; xy += i * y;	}	var m = Math.fround((xy - n * x_ * y_)/(xx - n * x_ * x_));	console.log(m, Math.fround(y_ - m * x_), "JS Pre");	var ws = XLSX.utils.json_to_sheet(aoo);	var wb = XLSX.utils.book_new();	XLSX.utils.book_append_sheet(wb, ws, "Sheet1");	ws = XLSX.utils.aoa_to_sheet([[2, 0]]);	XLSX.utils.sheet_set_array_formula(ws, "A1:B1", "LINEST(Sheet1!B2:B101,Sheet1!A2:A101)");	XLSX.utils.book_append_sheet(wb, ws, "Sheet2");
	XLSX.writeFile(wb, "linreg.xlsx");}if(typeof module !== 'undefined') module.exports = {	generate_random_file: generate_random_file};