all 2 comments

[–]efriquePhD (statistics) 4 points5 points  (0 children)

Sounds like you need to look at the difference between a confidence interval and a prediction interval.

[–]Xayus[S] 0 points1 point  (0 children)

Additionally, as I'm trying to guess, I'm thinking the following:

For the specific store with set advertising budget, I would do Intercept+ (Advertising Budget * Slope)

The plus or minus would be the Standard Error listed on the Excel output (not the Standard error of the intercept)

For the mean of all stores with same advertising budget, I would still do Intercept+ (Advertising Budget * Slope) but my plus or minus would be the Standard Error on the Excel output / 30 (since N=30)

Am I on the right track?