• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help with Statistics

J

Jorge SM

New Member
What are the preset formulas fro determining Total Variation, Explained Variation, and Unexplained variation? If there are none in Excel 2013, does anyone have any formulas/macros that they themselves have made?
 

Attachments

  • Stats formulas.jpg
    Stats formulas.jpg
    20 KB · Views: 11
HI Jorge, and welcome to the forum! :awesome:

NOt exactly sure what you mean by explained/unexplained variation, are those aren't strict mathematical terms. I'm guessing they're subsets of the original data?

Either way, you'll want to use the VAR.S function or VAR.P function.
 
Hi:

I guess you will have to run a regression model for this. In the output summary,
the ANOVA table will give you SS Regression(explained variation), SS Residual (unexplained variation) and total (Total variation).

Thanks
 
Nebu said:
Hi:

I guess you will have to run a regression model for this. In the output summary,
the ANOVA table will give you SS Regression(explained variation), SS Residual (unexplained variation) and total (Total variation).

Thanks
Click to expand...

I'm fairly new to excel, what do you mean the ANOVA table? If you could provide some screenshots that would be great. Thanks for the quick reply though, you truly are an Excel Ninja.
 
You must log in or register to reply here.
Back
Top