(Answered) Calculate and display using excel the following1 draw the

Statistics

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.

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

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M91621915
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Assume the random variable x is normally distributed with

Assume the random variable x is normally distributed with mean mu = 86 and standard deviation sigma =4. Find the indicated probability. P(x

On average there are 30 of defects per square foot of

On average, there are 30% of defects per square foot of photographic paper. Assume independence. We examine 100 sheets of photographic paper. Find the probability of 0 defects in one sheet.

Suppose that systolic blood pressure for 35- to

Suppose that systolic blood pressure for 35- to 44-year-olds is normally distributed with mean 125 in mm Hg and standard deviation 10 in mm Hg. What proportion of individuals will have a blood pressure reading between 12 ...

Explain how the company newmans own brand fulfills the

Explain how the company Newman's Own brand fulfills the definition of a business for profit and a non-profit business at the same time. Consider in the response the functions of business, entrepreneurship and production ...

New york graduates tend to leave the state after graduating

New York graduates tend to leave the state after graduating. A study asked the students of NYU "Are you planning to stay in NY after graduation?" In the sample, only 37% answered yes. The study explained that with a 95% ...

A researcher is working on a study that examines the

A researcher is working on a study that examines the wellbeing of older adults. She has an interest in finding if there is a difference in life satisfaction scores (measured on a multi-item Likert scale) by ethnicity (Af ...

In 2015 caterpillar inc had about 653 million shares

In 2015, Caterpillar Inc. had about 653 million shares outstanding. Their book value was $32.3 per share, and the market price was $74.00 per share. The company's balance sheet shows that the company had $20.20 billion o ...

15-18 years 419-22 years 523-26 years 627-30 years 931-34

15-18 years 4 19-22 years 5 23-26 years 6 27-30 years 9 31-34 years 2 35-38 years 7 Based on the frequency distribution above, find the relative frequency for the class 15-18 . Relative Frequency = % Give your answer ...

Iq test scores of students are normally distributed with

IQ test scores of students are normally distributed with mean μ=100 and standard deviation σ=10. What is the 33th percentile of the IQ scores? For a randomly chosen student, what is the probability that his or her IQ sco ...

You have a bag with three fair dice one is 4-sided one is

You have a bag with three fair dice. One is 4-sided, one is 6-sided, and one is 12-sided. You reach into the bag, pick one die at random, and roll it. The outcome of the roll is 4. What is the probability that you rolled ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert