Question

1. Create a model that calculates the course grade for a student in in a class....

1. Create a model that calculates the course grade for a student in in a class. Suppose the course grade is calculated as 30% Midterm, 30% Final and 40% Homework. As inputs for the model suppose a student had a 79 on the Midterm, a 85 on the Final, and a 90 on their Homework. In a blank cell, label and write the answer to question 1.

2. Answer the following question using Goal Seek, "What grade does a student need on the final exam to get a 80% overall in the course?". Assume 79 on Midterm and 90 on Homework. In a blank cell, label and write the answer to question 2.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A statistics class has the following activities and weights for determining a grade in the course:...
A statistics class has the following activities and weights for determining a grade in the course: test 1 worth 15% of the grade, test 2 worth 15% of the grade, test 3 worth 15% of the grade, homework worth 10% of the grade, semester project worth 20% of the grade, and the final exam worth 25% of the grade. If a student receives an 85 on test 1, a 76 on test 2, an 83 on test 3, a 74...
Suppose that you are taking a course. There are two midterms and a final exam. Each...
Suppose that you are taking a course. There are two midterms and a final exam. Each midterm impacts 25% of the course grade while final exam impacts 50% of the grade. The first and second midterm scores follow a normal distribution with mean 84 points and the standard deviation of 9 points and mean 85 points and the standard deviation of 6. Assume that the final exam is also normally distributed with mean 87 and standard deviation of 6 points....
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades...
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the​ model? If a student scores 7878 on the​ midterm, what would you predict her grade on the final exam to​ be? Student Midterm Final Exam 1 75 64 2 85 91 3 80 68 4 88 83 5 76 60 6 67 80 7 78 74 8 95 94 9 67 61 10 93 87 11...
Suppose a course has the following grading scheme: Homework: 25% Tests: 40% Final Exam: 35% If...
Suppose a course has the following grading scheme: Homework: 25% Tests: 40% Final Exam: 35% If a student had a 68% homework average, 72% test average and got 89% on the final exam, determine their course grade. Answer: %
1. An instructor has set a grading policy as follows in their class: Homework is worth...
1. An instructor has set a grading policy as follows in their class: Homework is worth 10% Quizzes are worth 20% The midterm exam is worth 30% The final exam is worth 40% Chris' score is 80.86 for the homework, 67.87 on the quizzes, 80.14 on the midterm exam, and 63.24 on the final exam. What was Chris' final grade in the class? Report your answer to two decimal places, and include the score only. An example answer is: 87.65
The following model can be used to predict what grade G a student will earn on...
The following model can be used to predict what grade G a student will earn on the next Math exam, given their current GPA x and average time they study each week t in hours: G = x + 0.24xt^2 + 5. Assuming the desired grade G is constant among a group of students. Compute dx/dt for a 3.0 student wanting to earn a B (80%) on the next exam. Label and interpret your answer. Then use the result to...
Question 1 1. A set of final examination grades in an introductory statistics course is normally...
Question 1 1. A set of final examination grades in an introductory statistics course is normally distributed with a mean of 85 and a standard deviation of 12. a) What is the probability of getting a grade of 95 on this exam? b) What is the probability that a student scored less than 55 and more than79? c) The probability is 8% that a student taking the test scores higher than than what grade? d) If the professor grades on...
In your biology class, your final grade is based on several things: a lab score, score...
In your biology class, your final grade is based on several things: a lab score, score on two major tests, and your score on the final exam. There are 100 points available for each score. However, the lab score is worth 30% of your total grade, each major test is worth 22.5%, and the final exam is worth 25%. Compute the weighted average for the following scores: 92 on the lab, 85 on the first major test, 90 on the...
A study was conducted to determine whether the final grade of a student in an introductory...
A study was conducted to determine whether the final grade of a student in an introductory psychology course is linearly related to his or her performance on the verbal ability test administered before college entrance. The verbal scores and final grades for 10 students are shown in the table below. Student, Verbal Score x, Final Grade y 1 80 77 2 65 98 3 45 96 4 30 60 5 56 64 6 56 73 7 49 84 8 52...
1.) You are interested in predicting the final grade of students in a business course. You...
1.) You are interested in predicting the final grade of students in a business course. You collect data on the number of hours studied and final grade for 8 students. Using the data provided below, find the predicted linear regression equation. Do this long hand on notebook paper.  You must show all of your calculations. Take calculations out to the 4th decimal place. Do not round up or round down. Your answers must clearly show your answers for bo, b1, and...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT