Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Finish the calculation of variance and standard deviation. In Column S, enter the formulae for calculating (Plant Height - mean). When entering the formula, F4
Finish the calculation of variance and standard deviation. In Column S, enter the formulae for calculating (Plant Height - mean). When entering the formula, F4 key lets you can toggle between relative and absolute referencing. Then in Column T, calculate the square of the value in column S. In T32, use the function SUM to total the values in T14:T30. Click on T33 to see the use of the function COUNT to calculate n-1. In T34, enter a formula that divides the sum of squares in T32 by (n-1) in T33. Finally, click on T35 to see the use the SQRT function to calculate the square root of the variance, calculated in T34. Verify that the answer matches the values calculated in the "Standard Deviation" worksheet
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