We can then drag the formula down the column to get predicted values of math for each set of predictor values. [CDATA[ */
In Cell B1 and C1 type "X" and "Y". Hi, I have conducted a moderated mediation in Mplus and wish to use Excels to plot the slope of the effects. In the Format Axis box that opens, look for the area with the heading Axis position.
But, where it says (female=1) we will click on cell A2, where it says read we will click on cell B2, and where it says write we will click on cell C2. 146 0 obj
<>stream
Method#2 Calculating Slope Through the SLOPE Formula In any cell type the following formula =SLOPE (F7:F27,G7:G27) You will get a slope of -0.50828. 4. However, plotting regions of significance in SPSS is difficult. already represents the simple slope for . When we click on a chart, excel opens two more ribbons. Within the Select Data Source dialog box, there are two main boxes (The left box contains years; the right box contains the products). The correlation betweentwo variables issaid to bestrongifthe data pointsare concentrated around a lineon the plot. So here, we can apply the SLOPE formula in Excel as we used in the first example =SLOPE (E3:E22,F3:F22). Error: Data Points Represent a Vertical Line. Step 1: Select the cell containing product data.
