Use the EXCEL program to answer each component of this assignment. You will need to be...

Transcribed Image Text:

Use the EXCEL program to answer each component of this assignment. You will need to be sure to attach printed copies of any graphs or charts that you create for this activity. These can be printed directly from EXCEL or you may cut and paste these into a word processing program. EDUC P475 Final Data Analysis Assessment (5b) 1. Enter in the following data into an EXCEL worksheet and have the program compute the mean and standard deviation for each of the three classes. Be sure to run a copy of this output for me to see. Reading 45 12 5 66 37 10 11 56 33 77 Math 66 100 135 89 66 33 55 70 13 130 Science 14 13 23 89 68 40 99 60 25 100 2. Using the data above, use EXCEL to compute the mean and standard deviation for each content area score. Then, create three scatter plots for the following correlation comparisons Reading: Math, Math: Science, and Reading:Science. Now have EXCEL compute the actual correlations for each comparison. Run a copy of this output for me to see. 3. Give me a brief analysis of this information in narrative form (perhaps 2-3 paragraphs). Use the EXCEL program to answer each component of this assignment. You will need to be sure to attach printed copies of any graphs or charts that you create for this activity. These can be printed directly from EXCEL or you may cut and paste these into a word processing program. EDUC P475 Final Data Analysis Assessment (5b) 1. Enter in the following data into an EXCEL worksheet and have the program compute the mean and standard deviation for each of the three classes. Be sure to run a copy of this output for me to see. Reading 45 12 5 66 37 10 11 56 33 77 Math 66 100 135 89 66 33 55 70 13 130 Science 14 13 23 89 68 40 99 60 25 100 2. Using the data above, use EXCEL to compute the mean and standard deviation for each content area score. Then, create three scatter plots for the following correlation comparisons Reading: Math, Math: Science, and Reading:Science. Now have EXCEL compute the actual correlations for each comparison. Run a copy of this output for me to see. 3. Give me a brief analysis of this information in narrative form (perhaps 2-3 paragraphs).

Answer rating: 100% (QA)

1 2 3 4 LO A 5 6 7 8 9 10 11 12 Mean 13 Standard deviation 14 15 B C Reading Math 45 12 5 66 37 10 11 56 33 77 3520 2561 66 100 135 89 66 33 55 70 13 130 7570 3892 D Science 14 13 23 89 68 40 99 60 25 ... View the full answer