Semi Average Regression Line
I have to create a semi average regression line my school project . I have no idea how to create one on my own. Could you please put this line as one of the trendlines on excel?
Thanks for the feedback. We’ll consider this in a our planning for a future release.
While a semi-average trendline might be helpful to some people, MSFT is not likely to add the feature in time for you to use for your school project, unless your project will span several years. :-) Also, you might misunderstand the assignment. Semi-average and (linear) regression are two different methods for constructing a trendline. The assignment might want you to compare the two. In any case, I suggest that you post your inquiry to answers.microsoft.com in order to get some help with the mechanics of a semi-average trendline. I could do that here; but I don't believe this is the right forum for that.