Trendline 1U TABELI SU PRIKAZANI PODACI O OBIMU PROIZVODNJE (Q) ,UKUPNOM PRIHODU (R) I UKUPNIM TROSKOVIMA (T).NACI PRELOMNU TACKU RENTABILNOSTI PROIZVODNJE.IZRACUNATI PROFIT ZA PROIZVODNJU Q=400 Q=500 I Q=600.OCENITI VARIJABILNE TROSKOVE PO JEDINICI PROIZVODA I UKUPNE FIKSNE TROSKOVE.QProfitProizvedena koliina QTrokovi TPrihod RabTacka rentabilnosti 430.1510401824400-21.16100350120T0.4982301.88Varijabilni troskovi0.498250049.02145380174R1.20Fiksni troskovi301.88600119.2180390216230415276270435324313450376355490426398499478440520528485540582525570630570585684610605732653630784695640834740670888780690936825710990865740103891075510929507751140

Trendline 2U TABELI SU PRIKAZANI PODACI O JEDININIM CENAMA, UKUPNOM PRIHODU I UKUPNIM TROKOVIMA U PREDUZEU.1. INTERPOLIRATI FUNKCIJU UKUPNOG PRIHODA KOJA POVEZUJE PRIHOD I PROIZVEDENU KOLIINU2. INTERPOLIRATI FUNKCIJU UKUPNIH TROKOVA3. ODREDITI PRELOMNE TAKE RENTABILNOSTIx2x4. ODREDITI OPTIMALNI OBIM PROIZVODNJEabcTaka rentabilnosti 1188.48188.48189tu je prelaz i faze nerentabilnosti u rentabilnostT7.75926284.6Taka rentabilnosti 2647.43647.43647tu je prelaz i faze nerentabilnosti u rentabilnostOBIM PROIZVODNJEPRIHOD RTROKOVI TR-0.051550.8090Kada radimo ovu drugu taku, moemo da kopiramo funkciju ali mora da se zakljuca sve i samo promenimo znak2679786.738232Profit-0.051543.05-6284.630710776.128567Celu kolonu profita smo dobiti kao razliku R i T iznadMax profit2711.930463211354.4311196Optimalni obim proizvodnje 418417.95922330170310328.73119577239952.781212459612142109942649949.09831741912311.82955867311068.7911403QProfit56312306.710709100-2494.6267610863.2411580101-2461.921746612213.49878102-2429.32647509115.3411992103-2396.834166910731.0911415104-2364.444844312671.79710105-2332.15857588761.6511893106-2299.97527738662.6512188107-2267.89497509047.1512020108-2235.917629510717.888637109-2204.04337599053.3712181110-2172.27250912513.6210364111-2140.60372088359.867830112-2109.038427810232.318343113-2077.576162311766.7110974114-2046.216844512527.989753115-2014.960536511744.139241116-1983.807236011552.839035117-1952.75697399350.2212242118-1921.809668510631.4511386119-1890.965346012506.729950120-1860.22463111276.7611244121-1829.585740112052.049586122-1799.05048774931.212854123-1768.618139311910.149174124-1738.28887099977.9111997125-1708.062538312135.399208126-1677.93927419493.5812183127-1647.91898117364.3112808128-1618.001629210328.688696129-1588.18732299104.458134130-1558.47629310291.528401131-1528.867748412425.5610068132-1499.362462811443.6910939133-1469.960170010096.8611690134-1440.660845812417.1110042135-1411.464571310023.311778136-1382.37127688565.5412066137-1353.38097379543.6311777138-1324.49362378951.398129139-1295.709329910546.828380140-1267.02868610468.6311672141-1238.44972499647.198021142-1209.97447389594.4512047143-1181.602162011931.2311348144-1153.332868710528.0211330145-1125.166546512427.559948146-1097.103266111087.2611588147-1069.14292539543.618332148-1041.285633811166.589094149-1013.53137429518.1112126150-985.881606811.047526151-958.3317152-930.8864153-903.5441154-876.3048155-849.1685156-822.1352157-795.2049158-768.3776159-741.6533160-715.032161-688.5137162-662.0984163-635.7861164-609.5768165-583.4705166-557.4672167-531.5669168-505.7696169-480.0753170-454.484171-428.9957172-403.6104173-378.3281174-353.1488175-328.0725176-303.0992177-278.2289178-253.4616179-228.7973180-204.236181-179.7777182-155.4224183-131.1701184-107.0208185-82.9745186-59.0312187-35.1909188-11.453618912.180719035.71219159.140319282.4656193105.6879194128.8072195151.8235196174.7368197197.5471198220.2544199242.8587200265.36201287.7583202310.0536203332.2459204354.3352205376.3215206398.2048207419.9851208441.6624209463.2367210484.708211506.0763212527.3416213548.5039214569.5632215590.5195216611.3728217632.1231218652.7704219673.3147220693.756221714.0943222734.3296223754.4619224774.4912225794.4175226814.2408227833.9611228853.5784229873.0927230892.504231911.8123232931.0176233950.1199234969.1192235988.01552361006.80882371025.49912381044.08642391062.57072401080.9522411099.23032421117.40562431135.47792441153.44722451171.31352461189.07682471206.73712481224.29442491241.74872501259.12511276.34832521293.49362531310.53592541327.47522551344.31152561361.04482571377.67512581394.20242591410.62672601426.9482611443.16632621459.28162631475.29392641491.20322651507.00952661522.71282671538.31312681553.81042691569.20472701584.4962711599.68432721614.76962731629.75192741644.63122751659.40752761674.08082771688.65112781703.11842791717.48272801731.7442811745.90232821759.95762831773.90992841787.75922851801.50552861815.14882871828.68912881842.12642891855.46072901868.6922911881.82032921894.84562931907.76792941920.58722951933.30352961945.91682971958.42712981970.83442991983.13873001995.343012007.43833022019.43363032031.32593042043.11523052054.80153062066.38483072077.86513082089.24243092100.51673102111.6883112122.75633122133.72163132144.58393142155.34323152165.99953162176.55283172187.00313182197.35043192207.59473202217.7363212227.77433222237.70963232247.54193242257.27123252266.89753262276.42083272285.84113282295.15843292304.37273302313.4843312322.49233322331.39763332340.19993342348.89923352357.49553362365.98883372374.37913382382.66643392390.85073402398.9323412406.91033422414.78563432422.55793442430.22723452437.79353462445.25683472452.61713482459.87443492467.02873502474.083512481.02833522487.87363532494.61593542501.25523552507.79153562514.22483572520.55513582526.78243592532.90673602538.9283612544.84633622550.66163632556.37393642561.98323652567.48953662572.89283672578.19313682583.39043692588.48473702593.4763712598.36433722603.14963732607.83193742612.41123752616.88753762621.26083772625.53113782629.69843792633.76273802637.7243812641.58233822645.33763832648.98993842652.53923852655.98553862659.32883872662.56913882665.70643892668.74073902671.6723912674.50033922677.22563932679.84793942682.36723952684.78353962687.09683972689.30713982691.41443992693.41874002695.324012697.11834022698.81364032700.40594042701.89524052703.28154062704.56484072705.74514082706.82244092707.79674102708.6684112709.43634122710.10164132710.66394142711.1232Nadjemo ga preko funkcije max4152711.4795i obeleimo u conditional formating da bismo je lakse nasli4162711.7328(idemo na equals i upisemo iznos)4172711.8831Optimalan obim proizvodnje4182711.93044192711.87474202711.7164212711.45434222711.08964232710.62194242710.05124252709.37754262708.60084272707.72114282706.73844292705.65274302704.4644312703.17234322701.77764332700.27994342698.67924352696.97554362695.16884372693.25914382691.24644392689.13074402686.9124412684.59034422682.16564432679.63794442677.00724452674.27354462671.43684472668.49714482665.45444492662.30874502659.064512655.70834522652.25364532648.69594542645.03524552641.27154562637.40484572633.43514582629.36244592625.18674602620.9084612616.52634622612.04164632607.45394642602.76324652597.96954662593.07284672588.07314682582.97044692577.76474702572.4564712567.04434722561.52964732555.91194742550.19124752544.36754762538.44084772532.41114782526.27844792520.04274802513.7044812507.26234822500.71764832494.06994842487.31924852480.46554862473.50884872466.44914882459.28644892452.02074902444.6524912437.18034922429.60564932421.92794942414.14724952406.26354962398.27684972390.18714982381.99444992373.69875002365.35012356.79835022348.19365032339.48595042330.67525052321.76155062312.74485072303.62515082294.40245092285.07675102275.6485112266.11635122256.48165132246.74395142236.90325152226.95955162216.91285172206.76315182196.51045192186.15475202175.6965212165.13435222154.46965232143.70195242132.83125252121.85755262110.78085272099.60115282088.31845292076.93275302065.4445312053.85235322042.15765332030.35995342018.45925352006.45555361994.34885371982.13915381969.82645391957.41075401944.8925411932.27035421919.54565431906.71795441893.78725451880.75355461867.61685471854.37715481841.03445491827.58875501814.045511800.38835521786.63365531772.77595541758.81525551744.75155561730.58485571716.31515581701.94245591687.46675601672.8885611658.20635621643.42165631628.53395641613.54325651598.44955661583.25285671567.95315681552.55045691537.04475701521.4365711505.72435721489.90965731473.99195741457.97125751441.84755761425.62085771409.29115781392.85845791376.32275801359.6845811342.94235821326.09765831309.14995841292.09925851274.94555861257.68885871240.32915881222.86645891205.30075901187.6325911169.86035921151.98565931134.00795941115.92725951097.74355961079.45685971061.06715981042.57445991023.97876001005.28601986.4783602967.5736603948.5659604929.4552605910.2415606890.9248607871.5051608851.9824609832.3567610812.628611792.7963612772.8616613752.8239614732.6832615712.4395616692.0928617671.6431618651.0904619630.4347620609.676621588.8143622567.8496623546.7819624525.6112625504.3375626482.9608627461.4811628439.8984629418.2127630396.424631374.5323632352.5376633330.4399634308.2392635285.9355636263.5288637241.0191638218.4064639195.6907640172.872641149.9503642126.9256643103.797964480.567264557.233564633.796864710.2571648-13.3856649-37.1313650-60.98651-84.9317652-108.9864653-133.1441654-157.4048655-181.7685656-206.2352657-230.8049658-255.4776659-280.2533660-305.132661-330.1137662-355.1984663-380.3861664-405.6768665-431.0705666-456.5672667-482.1669668-507.8696669-533.6753670-559.584671-585.5957672-611.7104673-637.9281674-664.2488675-690.6725676-717.1992677-743.8289678-770.5616679-797.3973680-824.336681-851.3777682-878.5224683-905.7701684-933.1208685-960.5745686-988.1312687-1015.7909688-1043.5536689-1071.4193690-1099.388691-1127.4597692-1155.6344693-1183.9121694-1212.2928695-1240.7765696-1269.3632697-1298.0529698-1326.8456699-1355.7413700-1384.74

Korelacija - osnovni pojmovi

PROBLEM: ZAVISNOST IZMEU PROMENLJIVIH VELIINA

ULAGANJE U REKLAMU - DOBITRAD, KAPITAL - PROIZVODNJAOBIM PROIZVODNJE - PRIHODOBIM PROIZVODNJE - TROAKOBIM PROIZVODNJE - DOBITCENA - TROKOVI TRANSPORTA (TA EMO SA KINESKOM ROBOM?)

NEZAVISNE PROMENLJIVE (X1, X2, ..., Xn) I ZAVISNA PROMENLJIVA Y

Y = f (X1, X2, ..., Xn)

LINEARNA ZAVISNOST

PRIMER 1Y = m1*X + b(JEDNOSTRUKA)

Y - DOBITX - ULAGANJE U REKLAMU

PRIMER 2Y =m2 * X2 + m1*X1 + b(DVOSTRUKA)

Y - PROMETX1 - ULAGANJE U UREENJE PROSTORAX2 - ULAGANJE U OBUKU KADROVA

PRIMER 2Y =m3 * X3 + m2 * X2 + m1*X1 + b(VIESTRUKA)

Y - PRODAJAX1 - ULAGANJE U REKLAME NA BILBORDIMAX2 - ULAGANJE U REKLAME NA TELEVIZIJIX3 - ULAGANJE U REKLAME U DNEVNIM NOVINAMA

DIJAGRAM RASTURANJA (RASIPANJA) UKAZUJE NA OBLIK ZAVISNOSTIKADA JE RE I JEDNOJ ZAVISNOJ PROMENLJIVOJKOEFICIJENT KORELACIJE R MERI STEPEN LINEARNE ZAVISNOSTICORREL

KOEFICIJENT DETERMINACIJE R^2 IZRAAVA ADEKVATNOST STATISTIKOG MODELA(ODSTUPANJA OD PROSENE VREDNOSTI)

REGRESIJA: FUNKCIJE LINEST I TREND

INTERPOLACIJA I EKSTRAPOLACIJA

Korelacija i jednostruka regres1U TABELI SU PRIKAZANI PODACI O PRIHODIMA I ULAGANJIMA U REKLAMU U BANKAMA "AIK","KOMERCIJALNA", "INTESA" I "UNIKREDIT"

TA SE MOE REI O UTICAJU REKLAME NA PROFIT U OVIM BANKAMA?UPOREDITI STVARNE I INTERPOLIRANE PODATKE.PREDVIDETI PRIHODE ZA TROKOVE NA NIVOU 50, 100, 930 I 1000.

"AIK"TROKOVI REKLAME TPRIHOD R1Jan-13895.00 3,163.33 2Feb-13104.00 2,136.05 3Mar-13986.00 3,280.74 4Apr-13978.00 3,272.06 5May-13300.00 2,389.53 6Jun-1368.00 2,089.76 7Jul-13983.00 3,276.68 8Aug-13706.00 2,918.41 9Sep-13155.00 2,201.19 10Oct-13258.00 2,334.15 11Nov-13832.00 3,082.24 12Dec-13751.00 2,976.64 13Jan-1440.00 2,055.18 14Feb-14120.00 2,155.33 15Mar-14865.00 3,123.87 16Apr-1444.00 2,055.83 17May-14405.00 2,526.44 18Jun-144.00 2,005.91 19Jul-14400.00 2,519.75 20Aug-14279.00 2,363.84 21Sep-14809.00 3,051.08 22Oct-14673.00 2,874.78 23Nov-14511.00 2,662.51 24Dec-14969.00 3,258.08 25Jan-15233.00 2,304.00 26Feb-15690.00 2,896.53 27Mar-15627.00 2,814.86 28Apr-15251.00 2,326.29 29May-15104.00 2,135.99 30Jun-15160.00 2,208.90

"KOMERCIJALNA"TROKOVI REKLAME TPRIHOD R1Jan-13843.00 3,269.14 2Feb-13389.00 2,555.66 3Mar-13982.00 3,576.72 4Apr-13629.00 2,445.56 5May-13719.00 2,861.61 6Jun-13875.00 2,739.87 7Jul-13303.00 2,641.02 8Aug-13806.00 3,221.02 9Sep-13787.00 3,140.82 10Oct-13597.00 2,638.52 11Nov-13344.00 2,461.05 12Dec-13478.00 1,974.45 13Jan-14960.00 3,470.66 14Feb-14240.00 1,790.28 15Mar-14184.00 2,362.32 16Apr-14248.00 2,302.82 17May-14589.00 2,761.33 18Jun-14646.00 3,164.01 19Jul-14786.00 3,034.41 20Aug-14662.00 2,899.30 21Sep-14365.00 2,634.04 22Oct-14478.00 2,889.02 23Nov-14490.00 2,688.53 24Dec-14262.00 2,064.03 25Jan-15188.00 2,101.61 26Feb-15764.00 3,195.68 27Mar-15178.00 1,972.94 28Apr-15627.00 2,893.13 29May-15670.00 2,618.52 30Jun-15647.00 2,817.63

"INTESA"TROKOVI REKLAME TPRIHOD R1Jan-13411.00 2,000.22 2Feb-13925.00 2,000.63 3Mar-13915.00 1,998.95 4Apr-13156.00 1,999.52 5May-13366.00 1,998.73 6Jun-13646.00 1,999.92 7Jul-13839.00 2,000.22 8Aug-13293.00 1,999.44 9Sep-13186.00 2,000.15 10Oct-13650.00 1,999.34 11Nov-13601.00 1,998.94 12Dec-13135.00 1,999.40 13Jan-14655.00 2,000.74 14Feb-1414.00 1,998.97 15Mar-14458.00 1,999.85 16Apr-14140.00 1,999.25 17May-14880.00 1,999.15 18Jun-14690.00 1,998.13 19Jul-14733.00 2,001.11 20Aug-1452.00 1,998.94 21Sep-14521.00 1,999.58 22Oct-14926.00 1,998.49 23Nov-14656.00 1,999.75 24Dec-14165.00 1,999.71 25Jan-15926.00 2,001.70 26Feb-15465.00 2,001.08 27Mar-15680.00 1,998.89 28Apr-15835.00 2,000.51 29May-1539.00 1,999.20 30Jun-15800.00 2,001.79

"UNIKREDIT"TROKOVI REKLAME TPRIHOD R1Jan-13728.00 3,109.13 2Feb-1310.00 1,111.55 3Mar-13545.00 895.32 4Apr-13281.00 1,531.01 5May-13238.00 1,567.77 6Jun-13344.00 2,292.28 7Jul-13919.00 3,176.10 8Aug-1374.00 2,737.12 9Sep-13641.00 3,086.58 10Oct-13118.00 2,284.97 11Nov-13794.00 3,269.49 12Dec-13808.00 1,972.13 13Jan-14780.00 2,680.69 14Feb-14337.00 2,151.37 15Mar-14127.00 2,346.70 16Apr-14855.00 3,381.03 17May-14604.00 2,235.67 18Jun-14168.00 1,593.72 19Jul-14240.00 1,897.43 20Aug-14726.00 2,085.31 21Sep-14568.00 2,655.74 22Oct-14546.00 2,150.23 23Nov-14373.00 3,254.38 24Dec-14348.00 1,702.94 25Jan-15275.00 2,136.94 26Feb-15800.00 3,056.27 27Mar-15187.00 2,971.85 28Apr-15527.00 2,731.12 29May-15107.00 2,146.53 30Jun-15825.00 2,951.50

2NACRTATI DIJAGRAME RASTURANJA I IZRACUNATI KOEFICIJENTE KORELACIJEIZRACUNATI KOEFICIJENTE LINEARNE REGRESIJE

KOLIKO DINAR ULOEN U REKLAMU DOPRINOSI PRODAJI?UPOREDITI STVARNE I INTERPOLIRANE PODATKE.

ATROKOVI REKLAME TPRIHOD R1Jan-13692.00 907.43 2Feb-13252.00 927.48 3Mar-13902.00 63.00 4Apr-1350.00 1,077.80 5May-13629.00 1,125.51 6Jun-13519.00 749.83 7Jul-13935.00 747.86 8Aug-13310.00 598.12 9Sep-13153.00 1,233.86 10Oct-13667.00 1,020.30 11Nov-13761.00 869.53 12Dec-130.00 1,116.70 13Jan-14922.00 1,509.34 14Feb-1433.00 1,184.58 15Mar-14635.00 1,459.29 16Apr-1436.00 1,105.84 17May-14623.00 1,170.97 18Jun-14494.00 846.78 19Jul-14190.00 1,575.95 20Aug-14647.00 1,455.26 21Sep-14185.00 807.57 22Oct-14260.00 978.56 23Nov-14936.00 1,126.05 24Dec-14298.00 516.06 25Jan-15477.00 1,115.15

PREDVIDETI NIVO PRODAJE AKO TROKOVI REKLAME U JANUARU 2002 BUDU 1000

BTROKOVI REKLAME TPRIHOD R1Jan-13480.00 1,820.76 2Feb-13960.00 2,324.74 3Mar-13340.00 63.00 4Apr-13882.00 2,947.93 5May-13244.00 2,406.35 6Jun-13642.00 2,608.25 7Jul-1320.00 2,318.75 8Aug-1352.00 2,146.56 9Sep-13726.00 3,272.13 10Oct-13940.00 3,142.45 11Nov-13312.00 2,228.55 12Dec-13973.00 2,826.53 13Jan-14692.00 2,003.63 14Feb-141.00 2,384.70 15Mar-14768.00 3,261.27 16Apr-146.00 2,065.14 17May-14884.00 2,525.17 18Jun-1418.00 1,773.36 19Jul-14301.00 2,651.95 20Aug-14571.00 2,011.77 21Sep-14962.00 3,637.59 22Oct-14895.00 3,197.05 23Nov-14768.00 2,996.47 24Dec-14438.00 2,833.61 25Jan-15666.00 3,425.98 26Feb-15383.00 2,905.22 27Mar-15277.00 2,055.41 28Apr-15634.00 2,547.98 29May-1512.00 1,877.82 30Jun-15858.00 2,468.24

PREDVIDETI NIVO PRODAJE AKO TROKOVI REKLAME U JANUARU 2002 BUDU 860

CTROKOVI REKLAME TPRIHOD R1Jan-13970.00 3,021.88 2Feb-13441.00 2,118.88 3Mar-13719.00 1,500.00 4Apr-13614.00 2,484.37 5May-13714.00 3,182.28 6Jun-13862.00 2,774.45 7Jul-13249.00 2,265.48 8Aug-13957.00 2,961.34 9Sep-13728.00 2,852.38 10Oct-13793.00 3,001.05 11Nov-13774.00 2,821.30 12Dec-13926.00 3,106.89 13Jan-14386.00 2,368.26 14Feb-14792.00 2,479.31 15Mar-14791.00 2,916.95 16Apr-14942.00 2,855.77 17May-1484.00 2,035.56

DTROKOVI REKLAME TPRIHOD R1Jan-13594.00 3,145.45 2Feb-13347.00 2,495.72 3Mar-138.00 1,934.13 4Apr-1364.00 2,411.24 5May-13479.00 2,477.81 6Jun-13739.00 3,827.84 7Jul-13910.00 3,019.48 8Aug-13348.00 2,440.33 9Sep-13699.00 2,880.62 10Oct-13515.00 3,012.12 11Nov-13765.00 3,234.77 12Dec-13944.00 3,639.09 13Jan-14934.00 3,301.85 14Feb-14843.00 3,097.20 15Mar-14977.00 3,271.12 16Apr-14236.00 2,655.57 17May-14689.00 3,140.67 18Jun-14575.00 2,821.27 19Jul-14925.00 3,362.07 20Aug-14682.00 3,058.55 21Sep-1426.00 1,996.21 22Oct-14197.00 2,435.92 23Nov-14869.00 3,069.57 24Dec-14760.00 3,295.90 25Jan-1570.00 2,450.46 26Feb-1545.00 1,703.56 27Mar-1516.00 2,003.37 28Apr-15835.00 3,558.88

PREDVIDETI NIVO PRODAJE AKO TROKOVI REKLAME U JUNU 2002 BUDU 30

ETROKOVI REKLAME TPRIHOD R1Jan-13117.00 2,309.28 2Feb-13654.00 3,614.83 3Mar-13433.00 2,892.31 4Apr-13149.00 2,292.34 5May-13843.00 4,003.86 6Jun-13871.00 3,918.78 7Jul-13320.00 2,980.98 8Aug-13175.00 2,381.50 9Sep-13957.00 3,747.77 10Oct-13996.00 4,194.27 11Nov-13476.00 3,450.18 12Dec-13838.00 4,092.73 13Jan-14580.00 3,504.60 14Feb-14421.00 2,914.68 15Mar-14209.00 2,888.80 16Apr-14779.00 3,855.28 17May-14962.00 4,295.91 18Jun-14448.00 3,180.19

PREDVIDETI NIVO PRODAJE AKO TROKOVI REKLAME U AVGUSTU 2002 BUDU 90

FTROKOVI REKLAME TPRIHOD R1Jan-13651.00 1,953.85 2Feb-13297.00 1,279.24 3Mar-13787.00 1,032.71 4Apr-13942.00 860.24 5May-13952.00 1,036.84 6Jun-13956.00 189.47 7Jul-13800.00 556.01 8Aug-13626.00 1,607.28 9Sep-13719.00 1,150.36 10Oct-13896.00 998.63 11Nov-13739.00 1,817.64 12Dec-13877.00 207.24 13Jan-1456.00 2,077.88 14Feb-14596.00 1,761.57 15Mar-146.00 2,879.54 16Apr-14420.00 1,915.12 17May-14855.00 1,271.32 18Jun-14378.00 1,767.48 19Jul-1413.00 1,694.77 20Aug-14690.00 1,149.66 21Sep-14154.00 1,904.87 22Oct-14348.00 1,046.28 23Nov-1483.00 2,009.55 24Dec-14711.00 1,552.81 25Jan-15549.00 1,534.44 26Feb-15376.00 3,230.18 27Mar-15746.00 2,188.85 28Apr-15807.00 1,028.80 29May-15359.00 1,095.28 30Jun-1522.00 1,530.21

GTROKOVI REKLAME TPRIHOD R1Jan-13251.00 2,327.56 2Feb-13798.00 3,036.83 3Mar-13361.00 2,469.74 4Apr-13472.00 2,613.44 5May-1338.00 2,050.54 6Jun-1338.00 2,049.39 7Jul-13928.00 3,205.76 8Aug-13722.00 2,937.15 9Sep-13389.00 2,505.53 10Oct-13748.00 2,972.80 11Nov-13808.00 3,048.81 12Dec-13956.00 3,241.34 13Jan-14717.00 2,932.81 14Feb-14266.00 2,345.43 15Mar-14399.00 2,517.14 16Apr-14988.00 3,284.77 17May-14228.00 2,295.69 18Jun-14825.00 3,072.72 19Jul-14239.00 2,310.26 20Aug-14565.00 2,734.64 21Sep-14423.00 2,550.17 22Oct-14741.00 2,962.63 23Nov-14927.00 3,204.44 24Dec-14154.00 2,199.90 25Jan-15411.00 2,534.58 26Feb-15369.00 2,479.32 27Mar-15283.00 2,367.37 28Apr-15706.00 2,918.15 29May-15890.00 3,156.31 30Jun-15511.00 2,663.39

Viestruka regresijaPovrina (x1)Broj kancelarija (x2)Broj ulaza (x3)Starost zgrade (x4)Cena (y)23102220142,000 23332212144,000 235631.533151,000 23793243150,000 24022353139,000 24254223169,000 244821.599126,000 24712234142,900 24943323163,000 25174455169,000 25402322149,000