Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We are given a 186 x 7 matrix that contains the points each student received on a seven question final exam. There are seven questions

We are given a 186 x 7 matrix that contains the points each student received on a seven question final exam. There are seven questions per student, where each question can give the grade 0 to 12. All seven questions give the final grade for each student. Each row is equal to one student.

a) Find the mean and standard deviation of the grades (two numbers). Find the mean and standard deviation of the grades for unique questions on the exam (10+10 = 20 numbers).

b) A simple way to predict the final grade on unique exams is to add together the points in the first five questions, and then double it. What is the RMS estimation error if we use the method?

c) Using regression analysis, create a model that predicts the final grade for unique exams, that only uses points received on question 1-5 as inputs. Specify the coefficients, and interpret them. What is the RMS estimation error for the model?

If the following information is put into Excel, it is possible to retrieve the data, while coding, by using scores = np.loadtxt('FILENAME.csv', delimiter=','):

12 12 11 0 12 12 8
6 4 0 0 0 3 12
12 12 9 0 12 12 12
12 12 9 12 10 12 12
12 12 12 12 12 12 12
12 12 11 12 12 12 8
12 12 12 12 2 12 8
12 12 6 12 0 8 12
12 12 6 0 0 0 8
12 4 0 12 0 12 12
12 8 12 12 12 12 8
12 12 9 12 12 12 12
6 12 12 0 10 12 6
12 12 9 12 0 12 8
12 12 7 0 9 12 10
6 12 0 0 0 3 10
12 4 2 12 12 12 12
12 12 0 12 12 10 10
12 12 0 0 0 3 0
12 12 12 12 3 3 12
12 12 9 0 12 0 12
8 12 9 12 0 3 12
12 10 12 12 0 10 4
12 12 12 0 0 12 12
12 12 9 12 12 3 8
0 6 0 12 0 3 6
6 12 0 12 12 8 12
12 12 0 12 0 2 7
6 12 4 0 0 12 6
12 12 12 12 0 10 12
12 12 9 12 2 2 12
6 4 0 0 0 2 6
12 12 9 12 12 3 12
6 12 11 0 0 12 12
12 12 0 12 0 10 4
12 12 6 0 3 3 8
12 8 12 12 4 12 10
12 12 6 12 12 3 8
12 12 6 12 3 12 8
6 8 3 12 12 0 12
6 2 8 0 0 0 0
12 12 0 12 9 0 12
0 12 4 0 0 12 8
12 12 6 12 3 12 12
12 12 6 0 3 12 6
12 12 0 12 0 3 10
12 12 9 0 12 12 12
12 4 0 12 12 6 10
12 2 11 12 3 2 12
12 12 11 12 0 0 12
12 12 12 12 0 0 12
6 12 3 12 3 10 12
12 12 8 12 12 12 12
6 12 12 12 12 12 12
12 12 6 0 12 12 4
12 12 9 0 12 12 8
12 12 12 0 12 12 12
12 12 6 12 3 10 8
12 8 12 12 0 7 12
12 12 0 12 12 7 12
12 12 12 12 10 3 10
12 12 12 12 12 12 12
6 12 6 12 0 3 10
7 12 6 4 3 12 10
12 12 6 12 12 12 10
12 12 12 0 12 12 8
6 8 12 12 3 12 8
6 12 0 0 0 12 6
12 12 12 12 0 10 8
12 12 12 12 12 12 12
12 12 12 12 12 12 12
12 12 3 12 0 3 12
12 12 0 12 0 12 12
6 12 12 12 12 3 4
6 12 3 12 0 12 6
12 12 6 0 12 10 8
6 12 12 12 12 0 8
12 12 9 12 0 3 8
12 12 0 12 0 3 10
12 12 9 12 0 11 10
12 12 12 12 12 12 8
12 6 0 0 0 0 6
12 12 3 12 0 12 8
12 12 0 12 0 12 6
0 12 9 0 10 3 8
12 4 9 12 0 10 12
2 12 6 12 12 2 12
0 12 2 12 12 3 12
6 12 6 12 0 12 8
12 12 0 12 0 12 6
12 12 9 12 12 12 8
12 12 0 12 3 12 12
0 4 0 0 0 3 8
12 12 0 0 12 10 8
12 12 12 12 0 12 12
12 12 12 0 0 12 8
0 6 6 0 6 3 4
12 12 3 12 10 12 12
12 12 12 12 12 12 6
6 4 6 0 12 3 0
12 12 9 0 0 12 12
6 12 12 12 12 12 12
6 12 8 12 12 0 12
12 12 6 0 0 6 12
12 12 12 12 12 11 12
12 12 12 12 10 12 12
12 12 9 12 3 10 12
12 12 12 12 12 10 8
12 12 0 12 6 3 12
12 12 0 12 0 3 12
12 12 12 12 12 12 12
12 12 12 12 0 12 12
12 12 12 12 12 12 8
12 12 12 12 10 12 12
12 12 12 12 0 12 12
12 12 0 12 0 12 8
12 12 5 12 0 12 8
12 12 9 0 0 10 8
12 12 0 12 0 3 12
12 12 12 12 6 12 8
12 12 0 0 12 3 10
12 0 0 0 12 0 12
12 4 12 12 3 0 12
12 12 12 12 10 12 12
12 12 12 0 12 3 12
12 4 12 12 0 3 10
6 12 12 12 0 2 8
6 12 0 12 0 11 5
12 8 0 12 5 3 8
12 12 12 12 12 12 8
12 12 1 12 2 12 12
12 12 6 12 12 3 10
6 12 9 12 5 12 12
12 12 12 12 12 10 8
12 2 12 12 3 10 12
12 12 1 12 12 3 12
12 4 10 12 12 12 12
6 12 0 0 0 12 12
6 12 11 0 0 3 8
0 0 6 12 0 3 12
12 12 10 12 12 3 12
12 4 10 0 0 0 6
12 12 12 12 0 3 12
12 12 12 12 0 10 8
6 4 6 0 0 2 12
6 12 6 12 12 12 12
12 12 11 12 5 12 10
12 12 6 12 0 12 8
12 8 11 12 3 3 6
12 12 9 12 0 3 12
6 12 0 0 0 12 12
12 12 11 12 0 10 12
12 12 12 0 0 12 12
12 12 12 12 0 0 12
12 12 7 12 0 3 8
12 12 0 12 12 10 12
12 12 6 12 12 11 12
12 12 10 0 0 3 8
12 12 12 12 0 10 12
12 4 7 12 12 0 10
6 12 1 12 0 11 8
6 12 9 12 2 12 12
12 12 12 12 12 12 8
12 0 6 12 3 2 4
12 12 12 12 12 12 12
12 12 6 12 0 2 6
12 12 12 12 12 0 12
12 12 12 12 12 12 12
12 12 0 0 0 2 8
12 12 6 12 0 12 8
12 12 9 12 12 12 12
12 12 12 12 0 12 12
12 12 0 12 0 3 4
12 12 0 12 0 12 6
12 12 9 12 12 12 8
6 12 0 12 0 2 12
6 12 10 12 10 12 12
6 4 0 12 0 10 12
12 12 7 12 12 12 12
6 12 12 12 5 0 8
12 12 12 12 12 12 12
12 12 12 0 0 6 12
12 8 9 12 12 12 12
12 12 12 12 12 12 12
12 12 12 12 12 12 12
12 12 12 12 12 10 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Data Management Databases And Organizations

Authors: Richard T. Watson

6th Edition

1943153035, 978-1943153039

More Books

Students also viewed these Databases questions

Question

2. Explain who uses single-subject research and why.

Answered: 1 week ago

Question

Does it highlight your accomplishments rather than your duties?

Answered: 1 week ago

Question

Does it clearly identify what you have done and accomplished?

Answered: 1 week ago

Question

Does it avoid using personal pronouns (such as I and me)?

Answered: 1 week ago