Climate Change And Snow Depth Xi May Affect Permafrost And Soil Composition Especially In Canada Researchers Conduct 1 (36.9 KiB) Viewed 22 times
Climate Change And Snow Depth Xi May Affect Permafrost And Soil Composition Especially In Canada Researchers Conduct 2 (60.77 KiB) Viewed 22 times
Climate Change And Snow Depth Xi May Affect Permafrost And Soil Composition Especially In Canada Researchers Conduct 3 (57.03 KiB) Viewed 22 times
Climate change and snow depth (xi) may affect permafrost and soil composition, especially in Canada. Researchers conducted a study to examine how snow cover affects soil temperature across northern latitudes. A random sample of locations was obtained, and the snow depth (in centimeters) and the difference between the soil temperatures and the air temperatures (called surface offset, yi) (in Celcius) was measured for each Below is the sample regression function to be estimated: Surface offset; = bo + by(snow depth) Using excel to complete this problem, what is the numerical value of b, and its associated p value...choose the best output in excel below. You can calculate this manually, but we also did this in excel. (hint: we covered this in the bedroom regression lectures and in the bonus football video lecture) the data is below
Depth Surface XY x2 X offset Y 6.7 7 46.9 44.89 41.1 22.8 937.08 1689.21 20.9 8.5 177.65 436.81 58.9 20.9 1231.01 3469.21 18.2 15.1 274.82 331.24 44.6 14.7 655.62 1989.16 53.8 21.8 1172.84 2894.44 23.1 11.5 265.65 533.61 47.2 17.8 840.16 2227.84 48.2 21.3 1026.66 2323.24
a. a) Intercept years Xi Coefficients Standard Error t Stat P-value -0.204545455 4.552031227 2.027067098 0.112587928 9.227272727 0.691503184 -0.295798283 0.782104495 Ob) b. Standard Coefficients Error 1 Stat P-value Intercept 6052,83.00 2.387324908 2.535404717 0.034959995 Depth Xi 27.81131836 0.059796001 4.651033179 0.001642472 c) Standard Coefficients Error t Stat P-value Intercept 0.278113184 2.387324908 2.535404717 0.034959995 Depth Xi 6.052834832 0.059796001 4.651033179 0.001642472 d. d) Standard Coefficients Error t Stat P-value Intercept 6.052834832 2.387324908 2.535404717 0.034959995 Depth Xi 0.278113184 0.059796001 4.651033179 0.001642472
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!