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

Microeconomic Theory
12th Edition
ISBN:9781337517942
Author:NICHOLSON
Publisher:NICHOLSON
Chapter2: Mathematics For Microeconomics
Section: Chapter Questions
Problem 2.15P
icon
Related questions
Question

Please solve and demonstate how to apply this on excel using pivot table.

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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Microeconomic Theory
Microeconomic Theory
Economics
ISBN:
9781337517942
Author:
NICHOLSON
Publisher:
Cengage
Managerial Economics: A Problem Solving Approach
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…
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
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax
Economics (MindTap Course List)
Economics (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning
Microeconomics
Microeconomics
Economics
ISBN:
9781337617406
Author:
Roger A. Arnold
Publisher:
Cengage Learning