Dati

Input Range: The reference of the range of the data to analyze.

Results to: The reference of the top left cell of the range where the results will be displayed.

Grupēts pēc

Select whether the input data has columns or rows layout.

Sampling

Descriptive Statistics

Analysis of Variance (ANOVA)

Correlation

Covariance

Exponential Smoothing

Moving Average

Regression Analysis

Paired t-test

F-test

Z-test

Chi-square test

Fourier Analysis

Example

Sekojošie dati tiks lietoti kā piemērs

A

B

C

1

Matemātika

Fizika

Bioloģija

2

47

67

33

3

36

68

42

4

40

65

44

5

39

64

60

6

38

43

7

47

84

62

8

29

80

51

9

27

49

40

10

57

49

12

11

56

33

60

12

57

13

26


Example

The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2.

A

B

1

1

0

2

0

0

3

0

1

4

0

0

5

0

0

6

0

0

7

0

0

8

0

0

9

0

0

10

0

0

11

0

0

12

0

0

13

0

0


Example

Sekojošai tabulai ir divas datu kopas.

A

B

1

28

19

2

26

13

3

31

12

4

23

5

5

20

34

6

27

31

7

28

31

8

14

12

9

4

24

10

0

23

11

2

19

12

8

10

13

9

33


Example

The following table has samples of a physical phenomenon taken in 1 second interval.

A

B

1

Time

Measurement

2

1

2.7

3

2

4.0

4

3

4.4

5

4

7.1

6

5

4.9

7

6

3.6

8

7

4.0

9

8

0.6

10

9

1.0

11

10

4.3


Group By Columns

TRUE

Polar

FALSE

Inverse

FALSE

Formula

{=FOURIER(B6:C40,B1,B2,B3,0)}

Source Array

Transformed Array

Real

Imaginary

Real

Imaginary

0.392555411592569

0

17.1775578743134

3.88635177703826E-015

1.20843701681219

0

3.428868795359

2.37164790000189

0.851477676762644

0

-6.80271615433369

-15.1345439297576

1.78534651907738

0

-1.605447356601

-5.08653060378972

1.77946506138316

0

0.395847917447356

-2.41926785527625

1.51890060220168

0

-1.49410383304833

-2.39148041275

1.04694666137238

0

0.87223579298981

-1.14394086206797

0.83110083951399

0

1.5332458505929

0.678159168870983

1.23006228455127

0

0.450563708411459

0.22911248792634

0.133409796396031

0

0.545106616940358

0.411028927740438

0.130471655802496

0

2.22685996425193

-2.43092236748302

0.386478761838145

0

-1.61522859107175

-2.41682657284899

-0.703398287742919

0

1.30245078290168

1.45443785733126

-0.899115309693977

0

1.57930628561185

-1.33862736591677

-0.124045510064504

0

-1.07572227365276

-0.921557968003809

-0.513553513012611

0

-0.0557824179238028

-1.81336029451831

-0.613559196487517

0

-0.577666040004067

1.38887243891951

0.32607259491689

0

-0.826878282157686

-0.186591000796403

0.0316297814625926

0

-0.826878282157715

0.186591000796416

0.52298725899815

0

-0.577666040004051

-1.38887243891954

0.436798031445888

0

-0.0557824179237846

1.81336029451832

0.846212627320418

0

-1.07572227365276

0.921557968003802

0.913061096906024

0

1.57930628561187

1.33862736591678

1.2666287534781

0

1.3024507829017

-1.45443785733125

1.6653650481107

0

-1.61522859107176

2.416826572849

1.36582636202864

0

2.22685996425191

2.43092236748304

1.46722190894756

0

0.545106616940365

-0.411028927740441

0.66120489728397

0

0.450563708411458

-0.229112487926344

0.701534531762234

0

1.53324585059292

-0.678159168870965

0.65869368245062

0

0.872235792989797

1.14394086206799

0.287522455580069

0

-1.49410383304834

2.39148041275001

-0.409911360506096

0

0.395847917447327

2.41926785527626

-0.583168875679498

0

-1.60544735660102

5.08653060378972

-0.799684083650078

0

-6.80271615433379

15.1345439297575

-0.621417306845244

0

3.42886879535907

-2.37164790000194


Please support us!