Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the EXCEL program to answer each component of this assignment. You will need to be sure to attach printed copies of any graphs









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).

Step by Step Solution

3.30 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions