### Excel 2010 Statistics 87: Linear Regression #1: Scatter Diagram: Relationship Between 2 Variables?

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmTopics:1. Plotting Two variables: Don't use Line Chart, Use Scatter Chart2. Plotting the point on the chart that graphs the relationship between two variables: Move along x axis a given amount and then along the y axis a certain amount.3. Independent, Predictor Variable = x4. Dependent, Predicted Variable = y5. Scatter Diagram with proper x and y axis labels to see if there is a relationship between two variables.6. Direct, Positive Relationship: As x increases, y increases7. Indirect, Negative Relationship: As x increases, y decreases8. No relationship: no pattern can be seen9. Add Trendline with linear equation and coefficient of determination (goodness of fit: of the total variation, how much can model explain?)This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin

Length:
17:00