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

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/210Excel2010/Content/Ch14/Busn210ch14.xlsx Topics: 1. Plotting Two variables: Don't use Line Chart, Use Scatter Chart 2. 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 = x 4. Dependent, Predicted Variable = y 5. 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 increases 7. Indirect, Negative Relationship: As x increases, y decreases 8. No relationship: no pattern can be seen 9. 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

الفئة