Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please explain how to calculate this on Excel? For each column count, n = 10 10 10 mean , x i = 5.1
Can you please explain how to calculate this on Excel? For each column
count, n = | 10 | 10 | 10 | ||
mean , x i = | 5.1 | 2.4 | 2.9 | ||
std. dev., si = | 1.4 | 1.5 | 1.5 | ||
sample variances, si^2 = | 2.1 | 2.267 | 2.322 | ||
total sum | 51 | 24 | 29 | 104 | |
grand mean , x = | ni*xi/ni = | 3.47 | |||
( x - x ) | 2.668 | 1.138 | 0.321 | ||
SS(between)= SSB = n( x - x) = | 26.678 | 11.378 | 3.211 | TOTAL | 41.267 |
SS(within ) = SSW = (n-1)s = | 18.9 | 20.4 | 20.9 | 60.2 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started