Scale of the final grades in a post graduate program

Assignment Help Engineering Mathematics

Reference no: EM13822664

The following table of grades definition is taken from a Students' handbook and it defines the scale of the final grades in a Post Graduate program.

The last two columns the number of students that got that grade in classes of the same subject that was run in two different terms.

Calculate and Display, using Excel, the following:

1. Draw the statistics as a histogram. Do they resemble the Normal Distribution?

2. Find the median, the average grade and the standard deviation of the two terms.

3. Calculate using the t-student distribution to find out if there is a significant difference among these two terms.

(Submit the answer as a file)

Grade	Range	Numeric Grade	Number of Students in term 1	Number of Students in term 2
Outstanding (A*)	80 +	85	1	1
Excellent (A)	70-79	75	3	4
Very Good (B)	60-69	65	8	7
Good (C)	50-59	55	5	7
Marginal Fail (D)	40-49	45	2	4
Fail (F)	Below 40	0	1	2
Total			20	25

Reference no: EM13822664

Questions Cloud

Compute b1 and b0 : Compute B1 and B0 (for this I am having trouble finding the covariance and Sx if you could please write that out in detail)

Determine the primary ways in which statistics are used : Determine the primary ways in which statistics or authority are used in your current position in developing persuasive arguments, and provide examples of such use.

Compare and contrast two models of conceptualizing addiction : Compare and contrast two models of conceptualizing addiction. Write a 1,050-to 1,400-word paper briefly describing the models, how they are synergistic, or how they take competing views

Role of governance in health care organizations : Write (1,150 words) on the concept of governance within a health care organization. address the following: Role of Governance in Health Care Organizations

Scale of the final grades in a post graduate program : The following table of grades definition is taken from a Students' handbook and it defines the scale of the final grades in a Post Graduate program.

Discuss scientific concepts related to materials science : Discuss scientific and technical concepts related to materials science. Use the manufacturing of one of the following materials as the basis for your response

Description of the types of subjects photographed : At least two examples of photography from each photographer. A description of the types of subjects photographed. Your opinion on whether or not photography is a fine art form with an explanation

Provide a brief history of the organization : Provide a brief history of the organization. Offer an analysis of the current communication climate. Provide a list of potential strengths and weaknesses.

Describe the 4 ps of marketing in your organization : What is your target market? What is the size of your potential target market? Describe the 4 Ps of marketing in your organization (product/positioning, pricing, promotion, and placement).

User Account

All Pages