Creating a Random Process Fitted Line Plot in Excel 2007
I use data representing the amount of natural gas used in my home on a daily basis for 30 consecutive days to demonstrate the creation of a random process fitted line plot. I also show calculation of the statistic RMSE (Root Mean Square Error) and use it to represent the quality of fit.
The random process model assumes the data fluctuates randomly around a constant level - which we estimate with the mean of the data we've collected.
Видео Creating a Random Process Fitted Line Plot in Excel 2007 канала ProfTDub
The random process model assumes the data fluctuates randomly around a constant level - which we estimate with the mean of the data we've collected.
Видео Creating a Random Process Fitted Line Plot in Excel 2007 канала ProfTDub
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Act Sci 654 - Stepwise in R CommanderGB-304 Lab Video 7Nonparallel Lines Regression Analysis Using Excel 2007GB-304 Lab Video 6Parallel Lines Fitted Lines PlotGB-304 Lab Video 8Act Sci 654 - Parallel Lines Regression Using R CommanderHow to Make an Exponentially-Weighted Moving Average Plot in Excel 2007Assessing Whether a Time-Series Follows a Random WalkHow to Do a Runs Test in MS Excel 2007How to Run a Multiple Regression in Excel 2007How to Make an Individuals Control in MS Excel 2007Checking the Normality Assumption in Multiple Regression with Excel 2007Doing a T-Test on the Slope Coefficient in Simple RegressionHow to Make Predictions from a Multiple Regression AnalysisSimple Regression BasicsHow to Run a Quadratic Regression in MS Excel 2007Prediction in Simple RegressionCreating and Interpreting a Confidence Interval for the Slope of a Simple RegressionHow to Make a Moving Average Plot