Sheet1Luna, AnVenit mediu net (x1)Cursul valutar mediuRON/EUR (x2) Numarul de autoturisme vandute (y)Dec. 201418664.45916284Nov. 201417434.42896270Oct. 201417054.41526322Sep. 201416984.41006531Aug. 201416834.42496941Jul. 201417194.40977009Jun. 201416874.39517105May. 201416824.42456800Apr. 201417354.46206470Mar. 201417064.49316650Feb. 201416264.49066854Jan. 201416254.52197011Dec. 201317604.46336669Nov. 201316504.44486520Oct. 201316154.44626499Sep. 201316094.46276587Aug. 201316044.43536210Jul. 201316354.42575947Jun. 201316064.47655963May. 201316114.33755777Apr. 201316614.38025630Mar. 201316174.39155911Feb. 201315534.38486013Jan. 201315484.37935560Dec. 201216974.48955345Nov. 201215754.52555190Oct. 201215524.55835460Sep. 201215384.50075702Aug. 201215344.51636302Jul. 201215564.54846365Jun. 201215524.46036247May. 201215304.43816058Apr. 201215534.37606155Mar. 201215434.36525920Feb. 201214724.35065884Jan. 201214674.34285670Dec. 201116044.32675592Nov. 201114914.35365862Oct. 201114574.32386018Sep. 201114644.28206425Aug. 201114554.25016800Jul. 201114714.24056559Jun. 201114724.19297156May. 201114584.11207530Apr. 201114984.09927410Mar. 201114934.16467609Feb. 201114144.24727226Jan. 201114244.26227004

Sheet2SUMMARY OUTPUT

Regression StatisticsMultiple R0.5403199336R Square0.2919456306Adjusted R Square0.2604765475Standard Error508.0088561462Observations48ANOVAdfSSMSFSignificance FRegression24788400.343465642394200.171732829.27722075150.0004231542Residual4511613284.9065344258072.997922986Total4716401685.25

CoefficientsStandard Errort StatP-valueIntercept19177.0833030433062.652076276.26159381661.28E-07Venit mediu net (x1)1.68022702840.8824981491.9039439690.0633237056Cursul valutar mediuRON/EUR (x2)-3529.0587332124828.4878034474-4.2596387280.0001030108

Lower 95%Upper 95%13008.585377264625345.5812288213-0.09721548413.4576695409-5197.7188257822-1860.3986406427RESIDUAL OUTPUT

ObservationPredicted Numarul de autoturisme vandute (y)Residuals16575.9611407738-291.9611407738265852.6855756235-662.685575623526475.8707900234-205.8707900234275698.2872275209-238.287227520936460.3702675891-138.3702675891285878.0378321563-176.037832156346466.95978380364.040216197295816.2636078046485.736392195456389.1734032521551.8265967479305739.9458170933625.054182906766503.3032690194505.6967309806316044.1349833757202.865016624376501.0602616154603.9397383846326085.5150926282-27.515092628286388.904799717411.095200283336343.3148616139-188.314861613996345.6171297268124.3828702732346364.6264256486-444.6264256486106187.1368193003462.8631806997356296.8545641369-412.8545641369116061.5413038611792.4586961389366315.980087114-645.980087114125949.40153848321061.5984615168376602.9890356098-1010.9890356098136383.0350290837285.9649709163386318.1917014769-456.1917014769146263.4976425239256.5023574761396366.229932761-348.229932761156199.7490143033299.2509856967406525.5061770081-100.5061770081166131.4381830349455.5618169651416622.961107342177.038892658176219.7332571829-9.7332571829426683.7237036352-124.7237036352186305.6992589022-358.6992589022436853.3871263645302.6128736355196077.789362141-114.789362141447115.3647994838414.6352005162206576.6367904899-799.6367904899457227.745832405182.254167595216509.9573340018-879.9573340018466988.5442561109620.4557438891226396.1489810669-485.1489810669476564.3060695038661.6939304962236312.2591447616-299.2591447616486528.1724587896475.8275412104246323.2678326523-763.2678326523256184.7193874842-839.7193874842

Interpretare:

Regression statistics:

Multiple R: legatura dintre X1, X2 si Y este puternica

R square: 29% din variatia numarului de automobile vandute este explicata de valoarea cursului valutar mediu si valoarea venitului mediu net.

Adjusted R Square: are o valoare mai mica decat Multiple R; legatura dintre X1, X2 si Y este slaba.

ANOVA

Coeficientul = 19177.083303043 reprezinta numarul de automobile vandute care nu este determinat de cursul mediu valutar si venitul mediu net ci de alti factori cum ar fi de exemplu taxa de inmatriculare auto etc.

Parametrul este semnificativ deoarece probabilitatea cu care se accepta ipoteza H1 este de 99,99% > 95%.

Intervalul de incredere: 13008.5853772646 25345.5812288213

Parametrul 1 nu este semnificativ deoarece probabilitatea cu care se poate accepta H1 este de 100-6,3323706= 93,67% < 95%.

Intervalul de incredere: -0.0972154841311541 1 3.45766954093535

Parametrul 2 este semnificativ statistic deoarece probabilitatea cu care se poate accepta H1 (care sustinem ca este semnificativ) este de 100-0,0103011= 99,98% > 95%

Intervalul de incredere: -5197.71882578217 2 -1860.39864064266

Intre numarul de automobile vandute si venitul mediu net exista o legatura directa, adica cu cat venitul mediu net creste cu atat numarul de de automobile vandute creste. De cealalta parte, avem o legatura indirecta intre numarul de automobile vandute si cursul valutar mediu RON/EUR in sensul ca, daca cursul valutar creste, numarul de automovile vandute scade si invers.

Modelul de regresie este semnificativ statistic, se accepta H1 pentru o probabilitate de cel mult 100-0,0423154 = 99,9576846% > 95%