QUESTION 4 The grades of 49 students on their first management test are shown below. Using pivote table, Construct frequency distribution, relative frequency distribution and commulative relative frequency distribution. Let the first class be 30-39. a. How many students failed in this test (score less than 59)? b. What percentage of the class has grade B or A (score more than 80)? HW2.6.csv a. 4 b. 44.90 a. 9 b. 22 a. 9.6 b. 44.90 a.4 b. 22
QUESTION 4 The grades of 49 students on their first management test are shown below. Using pivote table, Construct frequency distribution, relative frequency distribution and commulative relative frequency distribution. Let the first class be 30-39. a. How many students failed in this test (score less than 59)? b. What percentage of the class has grade B or A (score more than 80)? HW2.6.csv a. 4 b. 44.90 a. 9 b. 22 a. 9.6 b. 44.90 a.4 b. 22
Chapter2: Mathematics For Microeconomics
Section: Chapter Questions
Problem 2.15P
Related questions
Question
Please solve and demonstate how to apply this on excel using pivot table.

Transcribed Image Text:QUESTION 4
The grades of 49 students on their first management test are shown below. Using pivote table, Construct frequency distribution, relative
frequency distribution and commulative relative frequency distribution. Let the first class be 30-39.
a. How many students failed in this test (score less than 59)?
b. What percentage of the class has grade B or A (score more than 80)?
HW2.6.csv
a. 4
b. 44.90
a. 9
b. 22
a. 9.6
b. 44.90
a.4
b. 22
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning

Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning

Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning

Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning

Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax

Economics (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning
