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