UNIVERSITY GPA

When you're enrolled in aBachelor'sorMaster's programmer, your GPA is easily one of the most important numbers to keep an eye on.

Your GPA, or Grade Point Average, isa number that indicates how well or how high you scored in your courseson average. It's meant to score you (usually on a GPA scale between 1.0 and 4.0) during your studies and shows whether your overall grades have been high or low. This number is then used to assess whether you meet the standards and expectations set by the degree programmer or university.

In the same way that your professors and instructors give you a grade to evaluate your progress or success in their course, your Grade Point Average is a score used to evaluate your success during the entirety of your degree programmer.

Your average GPA is a number that shows what youtypicallyscored in your classes throughout the semester, term, and year. Your GPA scores can go up and down throughout your time at the university and will change according to how much you improve your overall grades (or, in some cases, how much you fell behind)

Each grade you receive, whether it's in the numerical system, letter-grade system, or percentage system, corresponds to aquality point.A quality point is almost always on a 4.0 scale between 0 and 4 (or amultiple of4). The highest grade you can get (A, 10, 5, 100%, and so on) will equal the highest number on that scale.

For example, in the US, anAis the highest grade you can receive in your classes. Depending on which school you attend, A is either equal to 4, or is equal to amultiple of 4(e.g. 8 or 16). After you take a few classes, these points are added up and divided by thetotal amount of credits of all the courses you took.The number you get is your Grade Point Average.

There are other common methods used by universities to evaluate and rank students. Yet, in order to make these grades translatable - that is, readable to other countries and universities - they will often use an average score system.

In Europe, for example, universities can usethe European Credit Transfer and Accumulation System (ECTS)to help convert grades easily. This system makes education more transparent and allows students to have their academic grades recognised in different European countries.

https://www.mastersportal.com/articles/2126/what-is-a-gpa-and-why-is-it-so-important.html

Carefully read all instructions.

PART A

Use the given data to make a frequency distribution table for University GPA.Include columns for the classes, frequencies, and relative frequencies (to the nearest percent).Use 5 or 6 classes.

In Excel, make a labeled histogram from your frequency distribution table and a labeled pie chart using the relative frequencies.Give your histogram and pie chart suitable titles.

PART B

Use Excel to determine the mean, median, mode, range and standard deviation of "University GPA" and "High school GPA".Which event has the higher mean?Which event has a lesser distribution?

PART C

Use results obtained in part B. Assume these figures are true for the POPULATION of University GPA.Suppose a random sample of 48 is taken from items of University GPA.What is the probability that the sample mean of University GPA is less than 6.8?What is the probability that the sample mean of US imports to Canada is between 6.8 and 7.5?What is the probability that the sample mean is greater than 7.5?Include labeled sketches of the normal curve in addition to your formulas, work, and answers.

For part D and part E use figures found in part B as means and standard deviations of the SAMPLES.

PART D

Construct a 90% confidence interval estimator to estimate the mean population of University GPAChange the level of confidence to 99%.What happens to the interval?

PART E

A report claims that the average University GPA is greater than 7.1. Test this claim at the significance level of 0.05.

PART F

Use the given data and Excel to determine the coefficient of correlation between University GPA and High school GPA. Find the equation of the regression line. Use Excel to draw a scatterplot of the data and the regression line.

Place the results from part F on the 2^nd sheet of your spreadsheet.