Biblioteca

Functii in Excel

Valoare:

Gratis

Marime:

374.83Kb

Pagini:

19

Nota:
8 Functii in Excel, 8 out of 10 based on 6 rating
Contine fisiere:

doc


Domenii:

Statistica



Orice document downloadat sau uploadat este adaugat in Biblioteca Mea

Fisiere arhiva: (1)

  • Functii in Excel.doc
Vezi informatii descarcari anterioare

Extras din document:

Fisiere help pentru functii si calcule de estimare in Excel (de probat functiile!)
Din Tools-Data Analysis- se vor studia aplicatiile: Regression, Correlation, Covariance, Exponential Smoothing;
Din functiile statistice se vor parcurge: Correlation, Covariance, Intercept, linest, logest, slope, trend, forecast, growth, RSQ, Pearson.
Mai jos sunt selectate helpurile aferente din Excel. Incercati sa faceti toate exemplele, chiar daca sunt mai mult economice, chiar incercati sa concepeti dupa acelasi model exemple cu calitatea si fiabilitatea!
RSQ
Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's. For more information, see PEARSON. The r-squared value can be interpreted as the proportion of the variance in y attributable to the variance in x.
Syntax
RSQ(known_y's,known_x's)
Known_y's is an array or range of data points.
Known_x's is an array or range of data points.
Remarks
. The arguments must be either numbers or names, arrays, or references that contain numbers.
. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
. If known_y's and known_x's are empty or have a different number of data points, RSQ returns the #N/A error value.
. The equation for the r value of the regression line is:
Example
RSQ({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) equals 0.05795
PEARSON
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
Syntax
PEARSON(array1,array2)
Array1 is a set of independent values.
Array2 is a set of dependent values.
Remarks
. The arguments must be either numbers or names, array constants, or references that contain numbers.
. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
. If array1 and array2 are empty or have a different number of data points, PEARSON returns the #N/A error value.
. The r value of the regression line is:
Example
PEARSON({9,7,5,3,1},{10,6,1,5,3}) equals 0.699379
CORREL
Returns the correlation coefficient of the array1 and array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location's average temperature and the use of air conditioners.
Syntax
CORREL(array1,array2)
Array1 is a cell range of values.
Array2 is a second cell range of values.
Remarks
. The arguments must be numbers, or names, arrays, or references that contain numbers.
. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
. If array1 and array2 have a different number of data points, CORREL returns the #N/A error value.
. If either array1 or array2 is empty, or if s (the standard deviation) of their values equals zero, CORREL returns the #DIV/0! error value.
. The equation for the correlation coefficient is:
Example
CORREL({3,2,4,5,6},{9,7,12,15,17}) equals 0.997054


    Documente similare:
    Preview document similar
    Statistica Aasistata
    Proiectul contine 37 pagini in format doc cu o marime totala de 215.8 KB.
    Preview document similar
    Ancheta Statistica privind Opiniile Elevilor din Anii Terminali...
    Referatul contine 14 pagini in format doc cu o marime totala de 33.36 KB.
    Preview document similar
    Statistica Aplicata in Economie
    Cursul contine 43 pagini in format pdf cu o marime totala de 387.51 KB.
    Preview document similar
    Statistica
    Cursul contine 63 pagini in format pdf cu o marime totala de 531.37 KB.
    Preview document similar
    Metodologia de Analiza si Predictie Box – Jenkins
    Proiectul contine 35 pagini in format doc cu o marime totala de 120.86 KB.
    Preview document similar
    Proiect Statistica
    Proiectul contine 23 pagini in format doc cu o marime totala de 277.96 KB.
    Carti recomandate:
    Alexandru A. Popovici
    Lucrarea de fata publicata la editura Niculescu expune principalele concepte si rezultate din teoria probabilitatilor si statistica matematica, precum si algoritmii de calcul, ce stau la baza aplicarii lor in economie si in tehnica, dar mai ales in abordarea econometrica, prin regresii si serii temporale. Teoria este insotita de probleme si de... citeste tot
    Liliana Duguleana
    Fiecare capitol al cartii de fata cuprinde elemente de teorie si pactica statistica, cu exemple rezolvate, probleme si exectitii propuse, respectiv lucrari statistice utilizand produsul informatic Excel, insotite de raspunsuri si explicatii. Lucrarea cuprinde indrumari privind utilizarea facilitatilor produsului Microsoft Excel in abordarea si... citeste tot
    Silvia Curteanu
    Excel este un program care pune la dispozitia utilizatorului diverse instrumente usor de manevrat. In principal, el este destinat calculului tabelar si construirii de diagrame, dar poate fi utilizat si in alte scopuri: gestionarea bazelor de date, aproximarea curbelor, analiza de date etc. Trasatura definitorie a acestei carti o constituie... citeste tot