Although Excel is capable of calculating a number of descriptive and inferential statistics for you, it is often better to show a visual representation of data when presenting information to a group. Using Excel’s built in trendline function, you can add a linear regression trendline to any Excel scatter plot. Inserting a Scatter Diagram into Excel Suppose you have two columns of data in Excel and you want to insert a scatter plot to examine the relationship between the two variables

View post:
Add a Linear Regression Trendline to an Excel Scatter Plot

Microsoft’s popular Office suite of productivity software ships with a variety of applications that are designed to work seamlessly with one another. However, few users of the software are aware just how seamless applications in the suite can be when it comes to incorporating elements of one software title into another. Powerful enough for commercial use and yet practical enough for the home, Word and Excel are the two most popular applications in the MS Office suite

The rest is here:
Quickly Add a Chart to a Word Document