attachedassignment827538893-fl1jjnyb.pdf ASSIGNMENT 8 DEADLINE OCTOBER 26, 5 PM 1. In the file...

Question

attachedassignment827538893-fl1jjnyb.pdf ASSIGNMENT 8 DEADLINE OCTOBER 26, 5 PM 1. In the file (input STUDENTID A8 A8Q1.csv) you will find a dataset relating discharge (Q, also called streamflow) to rainfall (P) and potential evapotranspiration (PET) from a river basin. PET is a meteorological variable, indicating the amount of evapotranspiration in case soil water is not a limiting factor. These are daily data. The units for PET and P are mm/day, the units for discharge m3s−1. There are two questions related to this data set: 1. We first want to check how strongly related the discharge is to the rainfall. For this, we will apply a linear regression, and calculate the correlation coefficient. The variable in X-axis is the rainfall, and the variable in Y-axis is the discharge. Calculate all the intermediary statistics you need for this. This means: – Calculate the variance of the precipitation and the discharge, and the covariance between the precipitation and the discharge. – Calculate the SSE, SSR and SST. – Calculate the MSE, MSR, SSX and SY X . – Calculate the correlation between P and Q, and the regression slope and intercept – Perform a Durbin-Watson test for autocorrelation in the residuals. If the number of observations in your data set is larger than the highest number of observations in the Durbin-Watson table, then use the values associated with this highest number of observations. – Calculate the stardard error of the regression slope. – Perform a slope-t test at the 95% confidence level to check whether or not the slope of the is a linear relationship between the rainfall and the discharge is significant. In the Graphical User Interface, CV stands for Critical Value – Calculate the 95% confidence interval for the slope. In the Graphical User Inter- face, CL stands for Confidence Limit. – Calculate the p-value for the slope-t test. – Perform an F -test for significance of the slope at the 1% significance level. 1 – Check whether or not there is a significant correlation between rainfall and dis- charge with 90% confidence. – Find the 99% confidence interval for the mean discharge resulting from 13 mm/day of rain. Also find the 99% confidence interval resulting from and individual rain event of 13 mm/day. 2. We want to perform a bivariate linear regression of the form: Q̂i = b0 + b1Pi + b2PETi (8.1) – Calculate the coefficients b0, b1 and b2, and list all the intermediary parameters (covariances, variances, ...) you have needed for this. – Calculate the SSR, SST , and the coefficient of multiple determination. – Calculate the adjusted R2. – Check whether or not the multiple regression is significant, at the 95% confidence level. – Check whether or not the individual slopes (b1 and b2) are different from zero, at the 95% confidence level. – Calculate the confidence interval for the slopes at the 95% confidence level. 2 flux-week-10-qqvkov12.zip flux week 10/week_10_Au_nc_Ag.xlsx week_10_Au_nc_Ag 			2006/6/13			597.47			288981			10.84 			2006/6/20			567.25			288148			9.97 			2006/6/27			589.58			292789			10.37 			2006/7/3			619.76			292500			11.17 			2006/7/11			627.75			312684			11.15 			2006/7/18			649.91			324276			11.06 			2006/7/25			620.43			315635			10.96 			2006/8/1			636.57			304907			11.4 			2006/8/8			647.52			309097			12.29 			2006/8/15			627.11			313327			12.04 			2006/8/22			628.3			306171			12.38 			2006/8/29			617.3			307583			12.12 			2006/9/5			629.25			319998			13.04 			2006/9/12			595.96			310510			11.32 			2006/9/19			587			325852			11.14 			2006/9/26			593.07			322937			11.29 			2006/10/3			595.43			330065			11.44 			2006/10/10			579.49			334329			11.38 			2006/10/17			597.18			329875			11.84 			2006/10/24			580.33			331598			11.62 			2006/10/31			602.32			323481			12.07 			2006/11/7			624.99			335036			12.62 			2006/11/14			625.62			356575			12.87 			2006/11/21			624.53			355430			12.83 			2006/11/28			640.05			349517			13.53 			2006/12/5			645.9			330530			14.08 			2006/12/12			630.69			333101			13.85 			2006/12/19			617.32			337096			12.57 			2007/1/3			640.97			353494			13.18 			2007/1/9			613.44			347491			12.38 			2007/1/16			626.68			344685			12.87 			2007/1/23			635.45			361114			12.96 			2007/1/30			643.69			348035			13.19 			2007/2/6			650.65			360936			13.5 			2007/2/13			662.16			383169			13.72 			2007/2/20			671.46			396115			14.02 			2007/2/27			686.71			415155			14.7 			2007/3/6			641.38			382550			12.8 			2007/3/13			651.46			394090			13.01 			2007/3/20			655.9			359726			13.2 			2007/3/27			664.7			359434			13.38 			2007/4/3			664.77			347817			13.3 			2007/4/10			675.55			369536			13.82 			2007/4/17			689.32			380800			14.05 			2007/4/24			689.16			403388			14 			2007/5/1			679.17			396276			13.45 			2007/5/8			688.63			411273			13.53 			2007/5/15			669.83			408936			13.12 			2007/5/22			664			416813			13.07 			2007/5/29			656.46			425688			12.96 			2007/6/5			672.5			385046			13.72 			2007/6/12			654.2			412150			13.21 			2007/6/19			657.33			410324			13.23 			2007/6/26			651.54			407640			12.87 			2007/7/3			657.82			375642			12.64 			2007/7/10			660.87			387916			12.76 			2007/7/17			666.01			385595			12.96 			2007/7/24			683.08			401603			13.3 			2007/7/31			666.99			351185			12.91 			2007/8/7			671.47			352908			13 			2007/8/14			669.67			347973			12.79 			2007/8/21			659.08			330204			11.79 			2007/8/28			667.81			325767			11.8 			2007/9/4			673.62			339439			12.13 			2007/9/11			704.39			373686			12.56 			2007/9/18			717.55			392748			12.8 			2007/9/25			730.07			440945			13.45 			2007/10/2			742.59			439865			13.58 			2007/10/9			732.6			458936			13.25 			2007/10/16			763.12			483872			13.89 			2007/10/23			758			489471			13.53 			2007/10/30			788.14			516163			14.44 			2007/11/6			811.96			556856			14.79 			2007/11/13			801.7			552546			14.61 			2007/11/20			781.18			512430			14.25 			2007/11/27			826.08			520782			14.75 			2007/12/4			793.08			486709			14.15 			2007/12/11			809.74			486198			14.71 			2007/12/18			795.86			495001			13.88 			2007/12/24			811.22			517020			14.38 			2007/12/31			843.3			541854			14.87 			2008/1/8			863.12			558309			15.25 			2008/1/15			909.11			593953			16.48 			2008/1/22			860.9			560173			15.5 			2008/1/29			929.12			522142			16.72 			2008/2/5			904.44			495139			16.71 			2008/2/12			924.34			475749			17.52 			2008/2/19			910.29			489789			17.2 			2008/2/26			935.38			495102			18.1 			2008/3/5			967.32			486992			19.69 			2008/3/12			975.3			482035			19.68 			2008/3/19			990.29			489055			19.69 			2008/3/26			941.48			452193			17.95 			2008/4/2			887.67			399393			16.91 			2008/4/9			915.21			407212			17.72 			2008/4/16			930.16			422699			17.9 			2008/4/23			921.71			424218			17.79 			2008/4/30			872.9			429670			16.56 			2008/5/7			878.13			433741			16.86 			2008/5/14			867.31			439636			16.71 			2008/5/21			922.99			453084			17.7 			2008/5/28			907.38			430961			17.46 			2008/6/4			881.23			398441			16.75 			2008/6/11			872.61			396392			16.66 			2008/6/18			886.22			390471			17.16 			2008/6/25			889.76			401226			16.71 			2008/7/2			941.62			434024			18.15 			2008/7/9			923.31			443202			17.86 			2008/7/16			974.33			483920			18.89 			2008/7/23			944.92			475606			17.89 			2008/7/30			918.65			446013			17.34 			2008/8/6			883.43			408430			16.63 			2008/8/13			816.4			365611			14.64 			2008/8/20			817.3			372968			13.36 			2008/8/27			829.63			380766			13.7 			2008/9/3			802.84			382329			12.98 			2008/9/10			775.08			392592			11.23 			2008/9/17			783.76			393814			10.68 			2008/9/24			886.75			368254			13.25 			2008/10/1			879.34			336598			12.21 			2008/10/8			895.3			329480			11.68 			2008/10/15			846.62			323496			11.04 			2008/10/22			770.82			319472			10.12 			2008/10/29			751.73			313709			9.27 			2008/11/5			761.84			303908			10.25 			2008/11/12			737.75			293831			9.84 			2008/11/19			740.42			289700			9.66 			2008/11/26			816.34			276567			10.29 			2008/12/3			781.04			264796			9.52 			2008/12/10			780.56			261001			9.96 			2008/12/17			851.62			282915			11.21 			2008/12/23			847.58			291022			10.86 			2008/12/31			872.17			300448			10.98 			2009/1/6			854.37			320391			11.12 			2009/1/13			825.52			318185			10.7 			2009/1/20			832.5			331507			11.13 			2009/1/27			905.77			354191			12.11 			2009/2/3			903.91			346288			12.38 			2009/2/10			898.38			350858			12.89 			2009/2/17			953.49			361619			13.8 			2009/2/24			989.98			372697			14.46 			2009/3/9			939.46			371321			13.25 			2009/3/16			927.91			376237			13.07 			2009/3/23			954.31			387177			13.83 			2009/3/30			926.39			368618			13.34 			2009/4/6			881.71			344929			12.52 			2009/4/20			870.65			339226			11.96 			2009/5/4			893.69			341461			12.62 			2009/5/11			917.1			359517			14 			2009/5/18			933.08			367931			14.02 			2009/5/25			956.78			396965			14.7 			2009/6/8			957.59			387181			15.29 			2009/6/15			939.37			371997			14.72 			2009/6/22			935.16			370347			14.09 			2009/6/29			939.24			379199			14.02 			2009/7/6			931.06			372985			13.37 			2009/7/13			914.4			370509			12.68 			2009/7/20			943.47			390939			13.56 			2009/7/27			955.41			386340			13.96 			2009/8/3			956.09			392834			14.14 			2009/8/10			956.32			385002			14.64 			2009/8/17			945.27			373810			14.5 			2009/8/24			955.62			379629			14.38 			2009/8/31			957.13			384703			14.73 			2009/9/7			995.21			451713			16.29 			2009/9/14			1003.12			467892			16.56 			2009/9/21			1003.5			467145			16.68 			2009/10/5			1006.17			484307			16.27 			2009/10/12			1051.82			504187			17.82 			2009/10/19			1055.26			509678			17.46 			2009/10/26			1057.12			497479			17.7 			2009/11/2			1048.11			493991			16.46 			2009/11/16			1129.58			533119			17.7 			2009/11/23			1165.6			521253			18.77 			2009/11/30			1175.64			521433			18.32 			2009/12/7			1154.31			505652			18.26 			2009/12/14			1123.35			504368			17.29 			2009/12/21			1115.68			499233			17.39 			2010/1/5			1125.26			507643			17.64 			2010/1/12			1155.78			523266			18.69 			2010/1/19			1139.58			528924			18.78 			2010/2/2			1105.89			480860			16.66 			2010/2/9			1068.93			466905			15.16 			2010/2/16			1111.05			466509			15.78 			2010/2/23			1116.95			466572			16.3 			2010/3/2			1119.14			482786			16.46 			2010/3/9			1123.65			493909			17.21 			2010/3/16			1112.99			496481			17.24 			2010/3/23			1105.85			495143			16.96 			2010/3/30			1112.37			466678			17.4 			2010/4/6			1130.45			497388			18.01 			2010/4/13			1154.9			528856			18.16 			2010/4/20			1139.58			521338			17.85 			2010/4/27			1156.38			538591			18.34 			2010/5/4			1182.45			551616			18.77 			2010/5/11			1206.05			583504			18.48 			2010/5/18			1225.26			579758			18.91 			2010/5/25			1193.13			591360			17.79 			2010/6/1			1220.96			553950			18.56 			2010/6/8			1241.62			564792			18.21 			2010/6/15			1223.17			569204			18.32 			2010/6/22			1239.59			602411			18.81 			2010/6/29			1241.08			601138			18.69 			2010/7/6			1209.97			577732			17.82 			2010/7/13			1201.58			568078			17.95 			2010/7/20			1184.63			559473			17.67 			2010/7/27			1187.15			560066			18.2 			2010/8/3			1184.74			518643			18.4 			2010/8/10			1201.9			523078			18.34 			2010/8/17			1226.11			543674			18.45 			2010/8/24			1223.3			556464			17.95 			2010/8/31			1237.87			577352			19.02 			2010/9/7			1251.1			585564			19.87 			2010/9/14			1251.74			594058			20.2 			2010/9/21			1280.22			597592			20.74 			2010/9/28			1294.34			619408			21.31 			2010/10/5			1319.3			617204			21.98 			2010/10/12			1350.42			616382			23.16 			2010/10/19			1369.99			630626			24.36 			2010/10/26			1340.43			607582			23.6 			2010/11/2			1357.61			618381			24.77 			2010/11/9			1412.54			650764			27.99 			2010/11/16			1362.49			637435			25.71 			2010/11/23			1365.18			622712			27.69 			2010/11/30			1368.39			600158			27.2 			2010/12/7			1423.56			603632			30.12 			2010/12/14			1404.05			594652			29.79 			2010/12/21			1388.19			582133			29.37 			2011/1/4			1416.91			592613			30.74 			2011/1/11			1378.07			588179			29.15 			2011/1/18			1365.38			587832			28.37 			2011/1/25			1335.3			506047			26.87 			2011/2/1			1338.28			462907			28.21 			2011/2/8			1353.49			469779			29.48 			2011/2/15			1366.02			473345			30.61 			2011/2/22			1406.33			502119			33.77 			2011/3/1			1414.06			515784			33.97 			2011/3/8			1432.53			515214			35.84 			2011/3/15			1419.25			507760			35.4 			2011/3/22			1430.85			509131			36.16 			2011/3/29			1421.22			492087			37.04 			2011/4/5			1445.05			508956			38.72 			2011/4/12			1459.41			514871			40.18 			2011/4/19			1493.6			537946			43.09 			2011/5/3			1546.69			522323			45.01 			2011/5/10			1514.03			510151			37.96 			2011/5/17			1495.27			509164			33.9 			2011/5/24			1519.08			531180			35.22 			2011/5/31			1539.37			501400			38.27 			2011/6/7			1546.56			502251			36.77 			2011/6/14			1521.5			497780			35.05 			2011/6/21			1543.29			515016			35.94 			2011/6/28			1501.62			495761			33.8 			2011/7/5			1497.85			489782			34.12 			2011/7/12			1552.13			520202			35.69 			2011/7/19			1605.68			542342			40.48 			2011/7/26			1615.61			536454			40.4 			2011/8/2			1624.48			529403			39.61 			2011/8/9			1746.24			510223			38.8 			2011/8/16			1768.99			514107			39.7 			2011/8/23			1901.02			528520			43.58 			2011/8/30			1796.8			509326			40.78 			2011/9/6			1906.84			523294			43.02 			2011/9/13			1828.11			512068			40.77 			2011/9/20			1782.87			499356			39.5 			2011/9/27			1640.28			465414			31.18 			2011/10/4			1667.49			436920			30.89 			2011/10/11			1678.34			438090			32.16 			2011/10/18			1672.17			437739			31.73 			2011/10/25			1656.3			443723			31.75 			2011/11/1			1718.95			442435			34.34 			2011/11/8			1793.07			464982			34.87 			2011/11/15			1776.34			470490			34.17 			2011/11/22			1685.56			457070			31.47 			2011/11/29			1712.2			423176			32 			2011/12/6			1719.97			422956			32.07 			2011/12/13			1659.53			427699			31.14 			2011/12/20			1599.53			423465			28.9 			2012/1/3			1582.76			423275			28.34 			2012/1/10			1618.96			417923			29.18 			2012/1/17			1656.04			432838			30.25 			2012/1/24			1678.43			427032			32.44 			2012/1/31			1736.53			425133			33.66 			2012/2/7			1724.72			436061			33.7 			2012/2/14			1719.94			431164			33.59 			2012/2/21			1738.11			456676			33.66 			2012/2/28			1771.5			479044			35.48 			2012/3/7			1676.9			443249			32.92 			2012/3/14			1677.45			442319			33.3 			2012/3/21			1654.29			431039			32.19 			2012/3/28			1681.2			417304			32.58 			2012/4/4			1644.78			407761			32.44 			2012/4/11			1658.6			403989			31.63 			2012/4/18			1653.03			398526			31.79 			2012/5/2			1660.85			411972			30.95 			2012/5/9			1597.19			417798			29.19 			2012/5/16			1539.01			422091			27.53 			2012/5/23			1562.68			435706			27.93 			2012/5/30			1552.7			419991			27.79 			2012/6/6			1625.88			423941			28.77 			2012/6/13			1611.81			412244			28.91 			2012/6/20			1622.1			418492			28.5 			2012/6/27			1573.55			413618			27.1 			2012/7/4			1619.32			425068			28.2 			2012/7/11			1576.47			429854			27.02 			2012/7/18			1584.2			431317			27.3 			2012/7/25			1584.86			420296			27.01 			2012/8/1			1615.9			403403			27.98 			2012/8/8			1611.69			388254			28.03 			2012/8/15			1602.76			388187			27.87 			2012/8/22			1640.81			398747			29.38 			2012/8/29			1669.02			426559			30.88 			2012/9/5			1694.37			444489			32.2 			2012/9/12			1737.47			460531			33.66 			2012/9/19			1772.82			478609			34.73 			2012/9/26			1761.48			489516			33.84 			2012/10/3			1775.09			480908			34.62 			2012/10/10			1765.27			484359			33.86 			2012/10/17			1753.09			462826			33.11 			2012/10/24			1712.59			455836			31.91 			2012/10/31			1714.47			454742			31.96 			2012/11/7			1722.26			447154			32.12 			2012/11/14			1729.42			459761			32.61 			2012/11/21			1727.03			474129			33.06 			2012/11/28			1742.3			479373			33.98 			2012/12/5			1702.4			434416			33.06 			2012/12/12			1713.14			433586			33.08 			2012/12/19			1676.55			435742			31.74 			2013/1/8			1651.52			441304			30.23 			2013/1/15			1675			447773			31.17 			2013/1/22			1693.78			461369			32.05 			2013/1/29			1661.59			430718			31.03 			2013/2/5			1676.26			423982			31.76 			2013/2/12			1647.05			435088			30.83 			2013/2/19			1615.8			447290			30.09 			2013/2/26			1595.59			433858			28.98 			2013/3/11			1581.6			445651			29.04 			2013/3/18			1602.64			440712			28.88 			2013/3/25			1609.92			419727			28.8 			2013/4/8			1580.39			416513			27.32 			2013/4/15			1460.97			413083			25.16 			2013/4/22			1420.94			415074			23.47 			2013/4/29			1471.6			421087			24.26 			2013/5/6			1476.4			437931			24.23 			2013/5/13			1436.12			443806			23.7 			2013/5/20			1348.61			446087			21.5 			2013/5/27			1392.72			411001			22.59 			2013/6/10			1385.95			373844			21.77 			2013/6/17			1391.65			377106			22.05 			2013/6/24			1291.8			390647			19.87 			2013/7/1			1243.41			410399			19.8 			2013/7/8			1223.41			431574			18.89 			2013/7/15			1290.73			440283			20.05 			2013/7/22			1318.24			434750			19.93 			2013/7/29			1329.12			397035			19.87 			2013/8/5			1316.55			396062			19.95 			2013/8/12			1331.67			390547			21.05 			2013/8/19			1379.76			385410			23.42 			2013/8/26			1398			384102			24.13 			2013/9/2			1393.32			388584			23.98 			2013/9/9			1390.17			384164			23.83 			2013/9/16			1329.41			384592			22.11 			2013/9/23			1326.86			378216			21.69 			2013/9/30			1342.78			374151			21.86 			2013/10/7			1314.99			370406			21.79 			2013/10/14			1275.02			381727			21.31 			2013/10/21			1320.45			390369			22.13 			2013/10/28			1352.47			387166			22.59 			2013/11/4			1316.2			386796			21.82 			2013/11/11			1288.22			403840			21.42 			2013/11/18			1288.95			397590			20.76 			2013/11/25			1239.85			394432			19.77 			2013/12/2			1248.43			386436			19.88 			2013/12/9			1231.68			377313			19.59 			2013/12/16			1235.75			385432			19.61 			2013/12/23			1205.28			384974			19.46 			2013/12/30			1211.26			379550			19.89 			2014/1/7			1242.9			383021			20.21 			2014/1/14			1254			415426			20.38 			2014/1/21			1254.63			410959			20.23 			2014/1/28			1259.2			382739			19.8 			2014/2/4			1259.83			368279			19.39 			2014/2/11			1284.78			376973			20.16 			2014/2/18			1324.43			390535			21.66 			2014/2/25			1336.99			387503			21.89 			2014/3/4			1347.3			393266			21.38 			2014/3/11			1344.44			415340			20.92 			2014/3/18			1363.84			420626			21.1 			2014/3/25			1316.09			398264			20.05 			2014/4/1			1286.88			363451			19.76 			2014/4/8			1306.97			365400			20.02 			2014/4/15			1319.55			369577			19.87 			2014/4/22			1291.62			372593			19.41 			2014/4/29			1295.81			378092			19.51 			2014/5/6			1312.6			404700			19.59 			2014/5/13			1296.09			397029			19.51 			2014/5/20			1294.26			399371			19.37 			2014/5/27			1292.12			397695			19.41 			2014/6/3			1246.86			382141			18.88 			2014/6/10			1255.99			378689			19.11 			2014/6/17			1270.24			379843			19.63 			2014/6/24			1317.92			392388			20.9 			2014/7/1			1328.72			401813			21.09 			2014/7/8			1320.46			410992			21.05 			2014/7/15			1310.47			408368			20.95 			2014/7/22			1311.37			405617			20.92 			2014/7/29			1308.43			374467			20.66 			2014/8/5			1291.94			360342			20.23 			2014/8/12			1310.67			368114			20.05 			2014/8/19			1301.12			366401			19.68 			2014/8/26			1284.88			363608			19.48 			2014/9/2			1283.35			371515			19.48 			2014/9/9			1257.53			384341			19.04 			2014/9/16			1238.41			386080			18.74 			2014/9/23			1221.3			385788			17.8 			2014/9/30			1218.89			379874			17.55 			2014/10/7			1207.66			380087			17.38 			2014/10/14			1236.24			397855			17.52 			2014/10/21			1249.91			411057			17.46 			2014/10/28			1230.92			414410			17.24 			2014/11/4			1167.78			417377			16.08 			2014/11/11			1154.18			443422			15.63 			2014/11/18			1190.44			459657			16.21 			2014/11/25			1200.14			388145			16.56 			2014/12/2			1207.12			368121			16.36 			2014/12/9			1203.98			375323			16.38 			2014/12/16			1198.62			371743			16.21 			2014/12/23			1180.47			375212			15.72 			2014/12/30			1188.07			373982			15.89 			2015/1/6			1207.62			394021			16.23 			2015/1/13			1237.54			402108			16.77 			2015/1/20			1280.53			430128			17.73 			2015/1/27			1280.87			438279			17.89 			2015/2/3			1277.83			419524			17.28 			2015/2/10			1244.46			393232			17.06 			2015/2/17			1231.56			389530			17.25 			2015/2/24			1203.62			399307			16.37 			2015/3/3			1207.76			405124			16.41 			2015/3/10			1165.41			410918			15.75 			2015/3/17			1157.09			429738			15.63 			2015/3/24			1190.28			433767			16.95 			2015/3/31			1186.08			387585			16.66 			2015/4/7			1215.12			390571			16.92 			2015/4/14			1199.63			395089			16.29 			2015/4/21			1197.3			397379			15.99 			2015/4/28			1202.8			403575			16.38 			2015/5/5			1189.82			399988			16.45 			2015/5/12			1185.76			405612			16.29 			2015/5/19			1223.91			428597			17.55 			2015/5/26			1203.82			411961			16.99 			2015/6/2			1189.79			398724			16.73 			2015/6/9			1178.12			406069			16.07 			2015/6/16			1187.01			415718			16.09 			2015/6/23			1188.16			430978			16.16 			2015/6/30			1179.26			442301			15.72 			2015/7/7			1170.33			452145			15.71 			2015/7/14			1157.26			462664			15.43 			2015/7/21			1105.3			459760			14.79 			2015/7/28			1097.26			438282			14.64 			2015/8/4			1087.22			434273			14.5 			2015/8/11			1105.77			435489			15.27 			2015/8/18			1120.32			432728			15.31 			2015/8/25			1154.65			432154			14.85 			2015/9/1			1141.17			410274			14.66 			2015/9/8			1122.68			421732			14.59 			2015/9/15			1109.06			413333			14.41 			2015/9/22			1135.89			419304			15.19 			2015/9/29			1131.61			415700			14.59 			2015/10/6			1138.59			430228			15.64 			2015/10/13			1159.09			435928			15.75 			2015/10/20			1173.02			467792			15.88 			2015/10/27			1166.39			466780			15.89 			2015/11/3			1137.39			443900			15.45 			2015/11/10			1094.35			436426			14.57 			2015/11/17			1084.12			435376			14.28 			2015/11/24			1073.7			397705			14.16 			2015/12/1			1071.61			390940			14.19 			2015/12/8			1074.3			394128			14.3 			2015/12/15			1065.09			390944			13.74 			2015/12/22			1080.07			405294			14.28 			2015/12/29			1073.32			401880			14.02 			2016/1/5			1078.35			413688			13.97 			2016/1/12			1097.97			397565			13.89 			2016/1/19			1090.89			408835			13.98 			2016/2/2			1128.51			379185			14.32 			2016/2/9			1193.42			410833			15.38 			2016/2/16			1201.03			428912			15.27 			2016/2/23			1218.9			445290			15

Rajeswari · Accepted Answer

Sheet1
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.5290981821
	R Square	0.2799448863
	Adjusted R Square	0.2778757624
	Standard Error	75491.0887307667
	Observations	699
	ANOVA
		df	SS	MS	F	Significance F
	Regression	2	1542081819324.1	771040909662.051	135.2963385632	2.30821984455374E-50
	Residual	696	3966437516518.52	5698904477.75649
	Total	698	5508519335842.62
		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
	Intercept	272771.480073624	12219.3566405711	22.3229003046	1.14937246173974E-83	248780.2614564	296762.698690847	248780.2614564	296762.698690847
	Silver price	-4563.2636447635	647.2170744093	-7.0505921818	0	-5833.9955483892	-3292.5317411378	-5833.9955483892	-3292.5317411378
	gold price	225.2810821198	15.0338744202	14.9848984915	3.34911344540424E-44	195.7639006112	254.7982636284	195.7639006112	254.7982636284
Sheet2
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.7811730499
	R Square	0.6102313339
	Adjusted R Square	0.609111309
	Standard Error	4.2713040917
	Observations	699
	ANOVA
		df	SS	MS	F	Significance F
	Regression	2	19880.0651865269	9940.0325932635	544.8372910885	3.9884958190246E-143
	Residual	696	12697.8508961626	18.2440386439
	Total	698	32577.9160826895
		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
	Intercept	1.7941503681	0.9031076506	1.9866406479	0.047353931	0.0210084821	3.5672922541	0.0210084821	3.5672922541
	gold price	0.0198360494	0.0006258299	31.6955919933	3.73141742646298E-137	0.0186073086	0.0210647902	0.0186073086	0.0210647902
	Contract	-0.0000146085	0.000002072	-7.0505921818	0	-0.0000186765	-0.0000105405	-0.0000186765	-0.0000105405
week_10_Au_nc_Ag
		gold price	Contract	Silver price	gold price
	2006/6/13	597.47	288981	10.84	597.47	I	slope of simple linear regression between no of 
	2006/6/20	567.25	288148	9.97	567.25		contracts and the fold price.
	2006/6/27	589.58	292789	10.37	589.58
	2006/7/3	619.76	292500	11.17	619.76		X	gold price
	2006/7/11	627.75	312684	11.15	627.75		Y	no of contracts
	2006/7/18	649.91	324276	11.06	649.91
	2006/7/25	620.43	315635	10.96	620.43		Slope	144.3892909849
	2006/8/1	636.57	304907	11.4	636.57
	2006/8/8	647.52	309097	12.29	647.52
	2006/8/15	627.11	313327	12.04	627.11	II	Slope of gold price and silver price
	2006/8/22	628.3	306171	12.38	628.3
	2006/8/29	617.3	307583	12.12	617.3		x	gold price
	2006/9/5	629.25	319998	13.04	629.25		y	silver price
	2006/9/12	595.96	310510	11.32	595.96
	2006/9/19	587	325852	11.14	587		slope	0.0177267406
	2006/9/26	593.07	322937	11.29	593.07
	2006/10/3	595.43	330065	11.44	595.43	III	To find R^2 between silver price and no of contracts
	2006/10/10	579.49	334329	11.38	579.49		r	0.2182588284
	2006/10/17	597.18	329875	11.84	597.18		R^2	0.0476369162
	2006/10/24	580.33	331598	11.62	580.33
	2006/10/31	602.32	323481	12.07	602.32
	2006/11/7	624.99	335036	12.62	624.99	IV	Slope of gold price for multilinear regression
	2006/11/14	625.62	356575	12.87	625.62
	2006/11/21	624.53	355430	12.83	624.53		y	contracts
	2006/11/28	640.05	349517	13.53	640.05		x2	gold price
	2006/12/5	645.9	330530	14.08	645.9		x1	silver price
	2006/12/12	630.69	333101	13.85	630.69
	2006/12/19	617.32	337096	12.57	617.32		b2	225.2811
	2007/1/3	640.97	353494	13.18	640.97
	2007/1/9	613.44	347491	12.38	613.44
	2007/1/16	626.68	344685	12.87	626.68	V	slope of gold price as a function of silver price
	2007/1/23	635.45	361114	12.96	635.45
	2007/1/30	643.69	348035	13.19	643.69		y	silver price
	2007/2/6	650.65	360936	13.5	650.65		x1	gold price
	2007/2/13	662.16	383169	13.72	662.16		x2	no of contracts
	2007/2/20	671.46	396115	14.02	671.46
	2007/2/27	686.71	415155	14.7	686.71		b1	0.0198
	2007/3/6	641.38	382550	12.8	641.38
	2007/3/13	651.46	394090	13.01	651.46
	2007/3/20	655.9	359726	13.2	655.9
	2007/3/27	664.7	359434	13.38	664.7
	2007/4/3	664.77	347817	13.3	664.77
	2007/4/10	675.55	369536	13.82	675.55
	2007/4/17	689.32	380800	14.05	689.32
	2007/4/24	689.16	403388	14	689.16
	2007/5/1	679.17	396276	13.45	679.17
	2007/5/8	688.63	411273	13.53	688.63
	2007/5/15	669.83	408936	13.12	669.83
	2007/5/22	664	416813	13.07	664
	2007/5/29	656.46	425688	12.96	656.46
	2007/6/5	672.5	385046	13.72	672.5
	2007/6/12	654.2	412150	13.21	654.2
	2007/6/19	657.33	410324	13.23	657.33
	2007/6/26	651.54	407640	12.87	651.54
	2007/7/3	657.82	375642	12.64	657.82
	2007/7/10	660.87	387916	12.76	660.87
	2007/7/17	666.01	385595	12.96	666.01
	2007/7/24	683.08	401603	13.3	683.08
	2007/7/31	666.99	351185	12.91	666.99
	2007/8/7	671.47	352908	13	671.47
	2007/8/14	669.67	347973	12.79	669.67
	2007/8/21	659.08	330204	11.79	659.08
	2007/8/28	667.81	325767	11.8	667.81
	2007/9/4	673.62	339439	12.13	673.62
	2007/9/11	704.39	373686	12.56	704.39
	2007/9/18	717.55	392748	12.8	717.55
	2007/9/25	730.07	440945	13.45	730.07
	2007/10/2	742.59	439865	13.58	742.59
	2007/10/9	732.6	458936	13.25	732.6
	2007/10/16	763.12	483872	13.89	763.12
	2007/10/23	758	489471	13.53	758
	2007/10/30	788.14	516163	14.44	788.14
	2007/11/6	811.96	556856	14.79	811.96
	2007/11/13	801.7	552546	14.61	801.7
	2007/11/20	781.18	512430	14.25	781.18
	2007/11/27	826.08	520782	14.75	826.08
	2007/12/4	793.08	486709	14.15	793.08
	2007/12/11	809.74	486198	14.71	809.74
	2007/12/18	795.86	495001	13.88	795.86
	2007/12/24	811.22	517020	14.38	811.22
	2007/12/31	843.3	541854	14.87	843.3
	2008/1/8	863.12	558309	15.25	863.12
	2008/1/15	909.11	593953	16.48	909.11
	2008/1/22	860.9	560173	15.5	860.9
	2008/1/29	929.12	522142	16.72	929.12
	2008/2/5	904.44	495139	16.71	904.44
	2008/2/12	924.34	475749	17.52	924.34
	2008/2/19	910.29	489789	17.2	910.29
	2008/2/26	935.38	495102	18.1	935.38
	2008/3/5	967.32	486992	19.69	967.32
	2008/3/12	975.3	482035	19.68	975.3
	2008/3/19	990.29	489055	19.69	990.29
	2008/3/26	941.48	452193	17.95	941.48
	2008/4/2	887.67	399393	16.91	887.67
	2008/4/9	915.21	407212	17.72	915.21
	2008/4/16	930.16	422699	17.9	930.16
	2008/4/23	921.71	424218	17.79	921.71
	2008/4/30	872.9	429670	16.56	872.9
	2008/5/7	878.13	433741	16.86	878.13
	2008/5/14	867.31	439636	16.71	867.31
	2008/5/21	922.99	453084	17.7	922.99
	2008/5/28	907.38	430961	17.46	907.38
	2008/6/4	881.23	398441	16.75	881.23
	2008/6/11	872.61	396392	16.66	872.61
	2008/6/18	886.22	390471	17.16	886.22
	2008/6/25	889.76	401226	16.71	889.76
	2008/7/2	941.62	434024	18.15	941.62
	2008/7/9	923.31	443202	17.86	923.31
	2008/7/16	974.33	483920	18.89	974.33
	2008/7/23	944.92	475606	17.89	944.92
	2008/7/30	918.65	446013	17.34	918.65
	2008/8/6	883.43	408430	16.63	883.43
	2008/8/13	816.4	365611	14.64	816.4
	2008/8/20	817.3	372968	13.36	817.3
	2008/8/27	829.63	380766	13.7	829.63
	2008/9/3	802.84	382329	12.98	802.84
	2008/9/10	775.08	392592	11.23	775.08
	2008/9/17	783.76	393814	10.68	783.76
	2008/9/24	886.75	368254	13.25	886.75
	2008/10/1	879.34	336598	12.21	879.34
	2008/10/8	895.3	329480	11.68	895.3
	2008/10/15	846.62	323496	11.04	846.62
	2008/10/22	770.82	319472	10.12	770.82
	2008/10/29	751.73	313709	9.27	751.73
	2008/11/5	761.84	303908	10.25	761.84
	2008/11/12	737.75	293831	9.84	737.75
	2008/11/19	740.42	289700	9.66	740.42
	2008/11/26	816.34	276567	10.29	816.34
	2008/12/3	781.04	264796	9.52	781.04
	2008/12/10	780.56	261001	9.96	780.56
	2008/12/17	851.62	282915	11.21	851.62
	2008/12/23	847.58	291022	10.86	847.58
	2008/12/31	872.17	300448	10.98	872.17
	2009/1/6	854.37	320391	11.12	854.37
	2009/1/13	825.52	318185	10.7	825.52
	2009/1/20	832.5	331507	11.13	832.5
	2009/1/27	905.77	354191	12.11	905.77
	2009/2/3	903.91	346288	12.38	903.91
	2009/2/10	898.38	350858	12.89	898.38
	2009/2/17	953.49	361619	13.8	953.49
	2009/2/24	989.98	372697	14.46	989.98
	2009/3/9	939.46	371321	13.25	939.46
	2009/3/16	927.91	376237	13.07	927.91
	2009/3/23	954.31	387177	13.83	954.31
	2009/3/30	926.39	368618	13.34	926.39
	2009/4/6	881.71	344929	12.52	881.71
	2009/4/20	870.65	339226	11.96	870.65
	2009/5/4	893.69	341461	12.62	893.69
	2009/5/11	917.1	359517	14	917.1
	2009/5/18	933.08	367931	14.02	933.08
	2009/5/25	956.78	396965	14.7	956.78
	2009/6/8	957.59	387181	15.29	957.59
	2009/6/15	939.37	371997	14.72	939.37
	2009/6/22	935.16	370347	14.09	935.16
	2009/6/29	939.24	379199	14.02	939.24
	2009/7/6	931.06	372985	13.37	931.06
	2009/7/13	914.4	370509	12.68	914.4
	2009/7/20	943.47	390939	13.56	943.47
	2009/7/27	955.41	386340	13.96	955.41
	2009/8/3	956.09	392834	14.14	956.09
	2009/8/10	956.32	385002	14.64	956.32
	2009/8/17	945.27	373810	14.5	945.27
	2009/8/24	955.62	379629	14.38	955.62
	2009/8/31	957.13	384703	14.73	957.13
	2009/9/7	995.21	451713	16.29	995.21
	2009/9/14	1003.12	467892	16.56	1003.12
	2009/9/21	1003.5	467145	16.68	1003.5
	2009/10/5	1006.17	484307	16.27	1006.17
	2009/10/12	1051.82	504187	17.82	1051.82
	2009/10/19	1055.26	509678	17.46	1055.26
	2009/10/26	1057.12	497479	17.7	1057.12
	2009/11/2	1048.11	493991	16.46	1048.11
	2009/11/16	1129.58	533119	17.7	1129.58
	2009/11/23	1165.6	521253	18.77	1165.6
	2009/11/30	1175.64	521433	18.32	1175.64
	2009/12/7	1154.31	505652	18.26	1154.31
	2009/12/14	1123.

assignment XXXXXXXXXXfl1jjnyb.pdf ASSIGNMENT 8 DEADLINE OCTOBER 26, 5 PM 1. In the file (input STUDENTID A8 A8Q1.csv) you will find a dataset relating discharge (Q, also called streamflow) to rainfall...

Answer To: assignment XXXXXXXXXXfl1jjnyb.pdf ASSIGNMENT 8 DEADLINE OCTOBER 26, 5 PM 1. In the file (input...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment