Boaru Ioana Alexandra CIG 636
-
Upload
maya-ioana -
Category
Documents
-
view
213 -
download
0
description
Transcript of Boaru Ioana Alexandra CIG 636
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%