## Functii in Excel

Informatii Seminar:
Numar de pagini: 19
Marime arhiva: 374.83Kb
Contine fisiere: doc
Numar de fisiere: 1
Tip document: Seminar
Domeniu: Statistica
Nota pe site: 8 Functii in Excel, 8 out of 10 based on 6 rating
Valoare:
Gratis
Ce sunt punctele? Ce sunt punctele?

Punctele reprezinta moneda de schimb a site-lui.

Ai nevoie de ele ca sa downloadezi documente si le poti primi incarcand documente pe site.

Daca nu vrei sau nu poti face asta, punctele se pot cumpara foarte usor prin SMS, Card sau PayPal.

Click pentru mai multe detalii.

### Fisiere in arhiva: (1)

• Functii in Excel.doc

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

Previzualizare pagini: (19)

Documente similare:
Statistica Aasistata
Proiectul contine 37 pagini in format doc cu o marime totala de 215.8 KB.
Statistica Aplicata in Economie
Cursul contine 43 pagini in format pdf cu o marime totala de 387.51 KB.
Statistica
Cursul contine 63 pagini in format pdf cu o marime totala de 531.37 KB.
Metodologia de Analiza si Predictie Box – Jenkins
Proiectul contine 35 pagini in format doc cu o marime totala de 120.86 KB.
Proiect Statistica
Proiectul contine 23 pagini in format doc cu o marime totala de 277.96 KB.
Analiza Statistica dintre Oferta si Cererea...
Licenta contine 70 pagini in format doc cu o marime totala de 3.08 MB.
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