Functii in Excel

Seminar / Statistica
Informatii Seminar:
Numar pagini: 19 pagini
Marime arhiva: 374.83 KB
Contine fisiere: doc
Numar fisiere: 1 fisier
Nota pe site: Nota  8 Functii in Excel , 8 out of 10based on 6 rating
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.

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


Fisiere in arhiva: (1)

  • Functii in Excel.doc

Previzualizare pagini (19):


    Documente similare:

    Preview Statistica Aasistata
    Statistica Aasistata
    Proiectul contine 37 pagini in format doc cu o marime totala de 215.8 KB.
    Preview Statistica Aplicata in Economie
    Statistica Aplicata in Economie
    Cursul contine 43 pagini in format pdf cu o marime totala de 387.51 KB.
    Preview Statistica
    Statistica
    Cursul contine 63 pagini in format pdf cu o marime totala de 531.37 KB.
    Preview Metodologia de Analiza si Predictie Box – Jenkins
    Metodologia de Analiza si Predictie Box – Jenkins
    Proiectul contine 35 pagini in format doc cu o marime totala de 120.86 KB.
    Preview Proiect Statistica
    Proiect Statistica
    Proiectul contine 23 pagini in format doc cu o marime totala de 277.96 KB.
    Preview Analiza Statistica dintre Oferta si Cererea Turistica din Delta Dunarii in Perioada 2000-2007
    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