Question

How to write this in excel?

Analysis of Variance DF MS F Source Regression Error Total 228565 228565 6.60 0.013 46 1592112 34611 47 1820677

Regression sum of squares 2 Total sum of squares SSR SST 228565 1820677 = 0.125538467

0 0
Add a comment Improve this question Transcribed image text
Answer #1

If you already have analysis of variance

then You can calculate R^2 using SSR and SST

= cell number where SSR is present / cell number where SST is present

If you don;t have table , you can generate the same using

data -> data analysis -> regression

Add a comment
Know the answer?
Add Answer to:
How to write this in excel? Analysis of Variance DF MS F Source Regression Error Total...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT