Using excel or statcato, stack all ten columns together into a single column. Once you have...

Using excel or statcato, stack all ten columns together into a single column. Once you have all 300 grades in a single column, calculate:

• The average numeric grade for all 300 students

• The standard deviation for numeric grade for all 300 students

• If we were to assume the population of grades was normally distributed (which it certainly isn’t) calculated the probability that an individual would have a final grade higher than a 90.

• Again, assuming normality, calculate the probability that an individual was have a final grade higher than 80.

A
A
F
F
B-
B
B-
B
A
F
F
A
B
A
B
C
B
B
A
B+
B-
B+
F
C
A-
C
A
B
B+
B
A-
F
B
C-
A
B+
A
C
A-
A-
A
F
F
D
B+
B
C
A
A
B+
B+
B+
B+
B-
C-
F
A
A
A
A
C
A
B-
B-
D-
C
B
A
D-
F
A
B
B
F
B
A-
F
A
B
F
A
C
A
A-
C
B+
A
A-
B
B-
B
C
A-
C-
F
A-
B
B
B+
A-
A
A
C
B
A-
B-
A
A
A-
F
B
A
A-
C+
F
F
A-
A
B
A
F
A
C+
B+
C
B
A
B+
A-
A
B
B-
B
F
A
B
B+
A
A
C+
A-
B+
A
F
A
B
C
A
B+
F
B
B
A
B+
B+
B
B
C+
B
B+
D+
C+
B
F
B
A-
A
A
A
C+
F
B-
C+
D
A
F
A-
B
F
A-
A-
A
B+
A
B
C+
B
A
B
A
B-
B+
B-
A
C-
C
C
B
A
B
A-
C
A-
B
F
B-
C+
A
C+
C-
B
A
A
C
A-
A
B
A
C
A-
B
B
F
A-
A
A
A-
B
A-
A-
F
B
A
F
C
B
A-
A
B
A
B+
B
B
A
A
B
A
B+
A
B-
A-
C
F
F
B+
A
F
A
A
A
B-
B
B-
C
A
A
A-
F
A
C
B
B
A
C-
D+
F
B
F
F
C+
A
A
B+
B
A-
A
F
B-
F
F
A
A-
F
F
A-
B
B
A
D+
A-

95
96
94
58
67
94
89
88
97
76
50
94
61
63
78
90
79
81
98
64
86
91
92
95
85
79
89
88
95
92
94
65
40
80
93
81
95
89
91
88
96
58
88
77
98
91
97
79
93
94
92
91
61
74
90
89
80
95
96
91
80
95
90
85
77
58
98
99
100
97
95
89
85
86
71
78
88
94
72
68
97
83
88
62
89
93
42
98
89
59
88
79
95
93
80
92
96
93
89
86
96
99
93
77
59
93
89
88
92
93
88
97
80
89
93
86
95
97
93
35
68
99
94
84
58
67
93
98
88
98
88
85
84
92
80
87
95
90
93
98
93
91
89
64
96
87
91
95
96
84
89
88
97
65
97
88
79
95
92
58
75
83
95
91
92
87
89
84
89
92
60
86
87
46
91
93
95
96
98
83
93
98
83
75
97
59
93
89
47
94
86
91
92
95
88
83
87
95
88
96
93
79
85
95
78
80
81
89
97
89
89
95
94
88
68
85
83
95
84
78
89
87
98
80
93
96
88
97
82
93
43
87
54
93
95
97
93
87
94
94
92
90
95
68
83
88
93
95
89
97
93
79
87
95
97
89
96
91
98
86
86
89
56
68
91
98
64
97
96
95
89
88
85
79
95
96
94
57
99
79
95
97
96
77
75
60
87
67
63
84
95
96
91
89
93
95
69
86
61
53

Expert Solution

Note : The following calculations are based on the assumption that it is a sample of 300 grades. If it is a population and not a sample then use the Excel function stdev.p for standard deviation and the calculations will change for parts 2,3,4

1) Average Numeric Grade = 85.6267    (Using Excel function average)

2) Assuming this is a sample and not a population we use Excel function stdev.s fro standard deviation calculation
Standard Deviation for numeric grade = 12.524

3) Since population is assumed normal, we find the probability using Excel function NORM.DIV
Let X be the grade
To find P(X > 90)
P(X > 90) = 1 - P(X ≤ 90)
P(X > 90) = 1- NORM.DIST(90, 85.6267, 12.524, TRUE)
                    = 0.3635
Probability that an individual would have a final grade higher than a 90 = 0.3635

4) To find P(X > 80)
P(X > 80) = 1 - P(X ≤ 80)
P(X > 80) = 1- NORM.DIST(80, 85.6267, 12.524, TRUE)
                    = 0.6734
Probability that an individual would have a final grade higher than 80 = 0.6734

orchestra answered 2 years ago

Implement a stack using a single queue. In particular, you are given a queue Q that...

Implement a stack using a single queue. In particular, you are given a queue Q that provides the method Q.size() to return its size at any point and the standard methods of queues (i.e, Q.enqueue(x) and Q.dequeue()). The requirement is to use such methods of Q to implement two methods S.push(x) and S.pop() for a stack S. What are the running times of your methods? Kindly answer using python programming

Use EXCEL to format this and solve using solve and explain. Biggest problem is once have...

Use EXCEL to format this and solve using solve and explain. Biggest problem is once have variables (which i have half done) is setting up in Excel. A farmer in the Midwst haas 1,000 acres of land on which she intends to plant corn, wheat, and soybeans. Each acre of corn costs $100 for preparation, requires 7 worker-days of labor, and yields a profit of $30. An acre of wheat costs $120 to prepare, requires 10 worker-days, and yields $40...

I have to figure this out in Excel. I have 4 columns with names in a...

I have to figure this out in Excel. I have 4 columns with names in a spreadsheet. I am trying to find the duplicates between columns and count them. Example A B C D Steve John Chris John Sarah Steve John Sarah Carl Chris Paul Paul Jenna Logan Sarah Jenna Moe Norman Joe Logan I am trying to identify the names that show up in multiple columns and count the times they show up, all in Excel. Which excel functions...

a-Assume you have a stack of integers. You want to organize it such that all numbers...

a-Assume you have a stack of integers. You want to organize it such that all numbers that are smaller than -100 go to the bottom, numbers between -100 and +100 in the middle and numbers larger than 100 in the top. Write a Java code that uses no more than three additional Stacks to solve the problem. NB: You do not need to write the code for Stacks, you are using a Stack from the library with a name SStack...

One of the olf columns in your plant failed. You have been putting together jury-rigged system...

One of the olf columns in your plant failed. You have been putting together jury-rigged system to separate propane fron n-butane. The column you have found is empty, so within reason you can put in as many stages as needed. It is equipped with a partial condenser and a total reboiler. The column is restricted to a maximum pressure of 800,0 kPa, which means that refrigerator is needed. You have a source of refrigerator, but output is limited to 6000.0...

Excel sorting In excel how do you sort a column of months in ascending order and...

Excel sorting In excel how do you sort a column of months in ascending order and not alphabetical when the month is in word format?

Show all working and formulas used whether with excel or on paper A distillation column is...

Show all working and formulas used whether with excel or on paper A distillation column is designed, purchased and installed for a cost of $1.2 million. The equipment has a depreciable life of ten (10) years with a final salvage value of $50,000 in year 10. For this equipment determine … a. The book value and depreciation allowance for each year using straight-line (SLN) depreciation. b. Book values and depreciation allowances for each year using double-declining (DDB) depreciation.

Why is it important to avoid air bubbles when you pack columns for column chromatography? If...

Why is it important to avoid air bubbles when you pack columns for column chromatography? If you accidently introduce air bubbles into the columns, what are the strategies you could take to remove the air bubbles? When running the column, is it okay to run the liquid below the column level? Why?

Assume you have a stack and a queue implemented using an array of size 4. show...

Assume you have a stack and a queue implemented using an array of size 4. show the content of the array for the stack (then the queue) for the following operations: (for the queue replace push by add and pop by remove; keep in mind that the queue uses a circular array): push(-3), push(-5), push(-9), push(-10), pop(), pop(), push(-13), pop(), push( -15), push(-17). java code

Stack ADT What would you say is the most important drawback of using the stack that...

Stack ADT What would you say is the most important drawback of using the stack that should be considered before choosing it for use in a real application? Typed out please.

Question