![excel trendline equation precision excel trendline equation precision](http://www.tushar-mehta.com/publish_train/data_analysis/16_files/image052.jpg)
But of course, that is not a strong rule here, so we can see that there are a lot of outliers. Generally speaking, the F p G measurement is trending upwards. So we want to first make some observations so we can see that most of the subjects are sort of gathered around this area here We can also see that there is roughly a linear relationship and, you know, it's very rough, but we can see that as we go from left to right, we can see that.
![excel trendline equation precision excel trendline equation precision](https://mathstat.slu.edu/~may/ExcelCalculus/images/sec1-5-sol5a.png)
So we have an idea of what's going on here. If we're being proper about this, we'd want to title this something along the lines of F B G versus H B A. So working in excel here, all we need to do is click on H B A drag it out, then go to insert Ah, this little thing in the charts section, uh, and click scatter.
![excel trendline equation precision excel trendline equation precision](https://peltiertech.com/images/img200808/add_trendline_options.png)
For the first part of the problem, we want to make a scatter plot with h b A as the explanatory variable. Then we have our f p G for each individual or each subject. Uh So here in our plot, we have the H B a, um Yepes. Um, and another measurement called the H B A. They've measured their fasting plasma glucose, the F p G. So these are the measurements for people with diabetes. What effect do you think this subject has on the correlation? What effect do you think this subject has on the equation of the least-squares regression line? Calculate the correlation and equation of the least-squares regression line with and without this subject to confirm your answer.Īll right for this problem, we are going to be looking at a bit of data. (c) Subject 15 is an outlier in the $y$ direction. What effect do you think this subject has on the correlation? What effect do you think this subject has on the equation of the least-squares regression line? Calculate the correlation and equation of the least-squares regression line with and without this subject to confirm your answer. (b) Subject 18 is an outlier in the $x$ direction. (a) Make a scatterplot with HbA as the explanatory variable. It measures average exposure to glucose over a period of several months. This is roughly the percent of red blood cells that have a glucose molecule attached. Another measurement, made at regular medical checkups, is called HbA. People with diabetes measure their fasting plasma glucose (FPG measured in units of milligrams per milliliter) after fasting for at least 8 hours.