So I'm trying out Excel's Trendline feature for charts and I'm wondering how to interpret it. I plotted out Sales Conversion Rates for 2 years and added a Linear Trendline in Excel. I read that the closer the r squared value is to 1 the more accurate the trend is. The r squared values I'm getting are all close to 0. Does that mean the trend of the line is not accurate? How do I interpret r squared value? Thanks.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.