Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #48: Data Analysis Regression feature
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm
Learn about how to automatically creates statistics for Linear Regression using the Data Analysis Regression feature. See how to automatically create statistics such as: Correlation, R Squared, Standard Error, Slope, Intercept, SST, SSR, SSE, F Test, Test Statistic, t Test Statistics, p-values, predicted vales, residuals, Residual plots and more.
Install: File, Options, Add-ins, Data Analysis Toolpak.
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.