t. Parsing the data from the provided PDF is quite complex, as the text formatting is inconsistent. I've extracted all the test items, their subjects, grades, and L-N scores to build the analysis you requested.
The request for a "scatter plot based on the variance of the test items from the average L-N score" is a great statistical question. To answer it, I first had to group all items by grade and subject (e.g., "Grade 5 - Language") and find the average L-N score for that specific group. Then, I calculated the variance for each individual item against its group's average.
The file I've generated creates a scatter plot where:
X-Axis: The item's original L-N score (its variance from the national average).
Y-Axis: The item's newly calculated variance from its own subject/grade average.
This plot helps you see not just how an item performed nationally (x-axis), but also how it performed relative to other items in its own subject (y-axis). Dots are colored by grade, and you can hover over any dot to see its details.
Create a scatter plot based on the variance of the test items from the average L-N score. Group by subject and grade level. Sort by L-N descending.
*Use Canvas
