15 Free YouTube subscribers for your channel
Get Free YouTube Subscribers, Views and Likes

(Very) Simple Linear Regression Using Excel

Follow
DEEGSNCCU

In this video, we explore the concept of simple linear regression using an example of 2 mapped variables to see if there is a relationship between them. Using Microsoft Excel, we look at the line of best fit and results from the regression analysis that would be useful in supporting our Null hypothesis. In the example highlighted, we model school data to see if there is a relationship between attendance (independent variable) and end of grade test scores (dependent variable). We can explore a number of outputs from the model, but focus on the pvalue that shows significance between the independent variable and dependent variable. In addition, we also highlight an example that has no relationship between the two variables. You may want to explore relationships between multiple independent variables and a dependent variable. This is called multiple regression. More robust software focused explicitly on statistical analysis such as R, SPSS and SAS are able to run multiple regression and variations of multiple regression such as stepwise regression. We do present a video on OLS (Ordinary Least Squares) regression, a form of multiple regression, which can be run in ArcGIS Pro if the variables are stored within spatial data.

These videos have been created in support of teaching and research in the field of GIS (Geographic Information Systems) for the Department of Environmental, Earth and Geospatial Sciences at North Carolina Central University (NCCU). Established in 1910, NCCU is located in Durham, North Carolina, and serves about 8,500 students. The mission of our department is to promote intellectual, professional, and personal excellence through the highest quality instruction, research, and service in the environmental, earth and geospatial sciences. Its vision is to be recognized as a regional, statewide, and national resource for students and society as well as professionals who work in the many fields that are encompassed by the environmental, earth, and geospatial sciences. Students in our programs currently focus their studies in the fields of seismology, natural hazards, GIS (Geographic Information Systems) and Remote Sensing applications, environmental health & impacts and remediation technology among others. Our courses are designed to provide students with the analytical and methodological skills necessary to understand or derive explanations for individual occurrences, for recurring processes, and for invariable as well as statistical regularities in the earth’s lithosphere, hydrosphere, atmosphere, and biosphere. The department prides itself in former students who fostered these skills and have gone onto successful careers in the field at places such as the North Carolina Department of Transportation, City of Durham, Environmental Protection Agency, Lowe’s Corporation, Environmental Protection Agency, National Forest Service, Army Corps of Engineers, real estate firms and private contractors or students who have gone onto Ph.D. programs at places such as North Carolina State University, North Carolina A&T State University and the University of North Carolina, Greensboro.

posted by cydwybodrf