PHYL4518 Week 3 Variance Calculations - PDF

Document Details

BriskSparrow1014

Uploaded by BriskSparrow1014

Mount Royal University

Tags

variance calculations statistics data analysis excel

Summary

This document details calculations of variances for multiple data sets relating to scores and the reference point "CE." It shows absolute scores, the difference between scores and CE, and the squared differences. The summary of calculations provides a breakdown of the steps involved in these calculations.

Full Transcript

### A | Scores | CE | Absolute score | Difference between score and CE | Squared | |---|---|---|---|---| | -2 | -2.75 | 2 | 0.75 | 0.5625 | | -3 | | 3 | -0.25 | 0.0625 | | -3 | | 3 | -0.25 | 0.0625 | | -3 | | 3 | -0.25 | 0.0625 | | | AE | 2.75 | | 0.75 | | | | | | 4 | | | | | | 0.1...

### A | Scores | CE | Absolute score | Difference between score and CE | Squared | |---|---|---|---|---| | -2 | -2.75 | 2 | 0.75 | 0.5625 | | -3 | | 3 | -0.25 | 0.0625 | | -3 | | 3 | -0.25 | 0.0625 | | -3 | | 3 | -0.25 | 0.0625 | | | AE | 2.75 | | 0.75 | | | | | | 4 | | | | | | 0.1875 | | | | | | 0.4330127 | ### B | Scores | CE | Absolute score | Difference between score and CE | Squared | |---|---|---|---|---| | -3 | 0.25 | 3 | -3.25 | 10.5625 | | -5 | | 5 | -5.25 | 27.5625 | | 3 | | 3 | 2.75 | 7.5625 | | 6 | | 6 | 5.75 | 33.0625 | | | AE | 4.25 | | 78.75 | | | | | | 4 | | | | | | 19.6875 | | | | | | 4.4370598 | ### C | Scores | CE | Absolute score | Difference between score and CE | Squared | |---|---|---|---|---| | -6 | -5 | 6 | -1 | 1 | | -5 | | 5 | 0 | 0 | | -5 | | 5 | 0 | 0 | | -4 | | 4 | 1 | 1 | | | AE | 5 | | 2 | | | | | | 4 | | | | | | 0.5 | | | | | | 0.7071068 | ### Summary of calculations - For each section, the "Sum of column E" is the sum of the values in the "Squared" column for that section. - The "Divide by" is the number of rows in the section, which is 4. - The "Take square root of" is the square root of the result after dividing the sum of column E by 4. This document appears to be about calculating the average variance of a set of scores from a reference point (CE).

Use Quizgecko on...
Browser
Browser