Biblioteca

Functii in Excel

Valoare:

Gratis *

Marime:

374,83 Kb

Pagini:

19

Nota:
8Functii 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
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
    Cursul contine 63 pagini in format pdf cu o marime totala de 531.37 KB.
    Preview document similar
    Statistica Afacerilor
    Cursul contine 105 pagini in format doc cu o marime totala de 215.67 KB.
    Preview document similar
    Proiect Statistica
    Proiectul contine 23 pagini in format doc cu o marime totala de 277.96 KB.
    Preview document similar
    Analiza Statistica dintre Oferta si Cererea Turistica din Delta ...
    Licenta contine 70 pagini in format doc cu o marime totala de 3.08 MB.
    Preview document similar
    Proiect Statistica
    Proiectul contine 13 pagini in format doc cu o marime totala de 1.36 MB.
    Preview document similar
    Metode de Prezentare a Datelor Statistice
    Proiectul contine 18 pagini in format doc cu o marime totala de 74.71 KB.
    Carti recomandate:
    Scrisa de 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
    Scrisa de 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
    Scrisa de 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