In regression analysis, the scatter diagram is used to plot the independent variable on the X or horizontal axis, and the dependent variable on the Y or vertical axis. To produce a scatter diagram, highlight the X and Y data columns including the column titles. Then select the Chart Wizard on the Standard Toolbar, then from the Chat menu select , then XY Scatter, (in Excel 2007, select Input from the menu tab, then Scatter from the Chart option), then respond to the dialog screen questions. It will take a couple of tries to get the hang of making scatter diagrams; but after some practice you should be able to replicate the scatter diagram shown in Worksheet 2.step 1.2. Continuer la lecture de « So it spread diagram reveals an optimistic types of relationships anywhere between X and Y, for example whenever X develops, Y expands »