0.075km, 7.6m, 77cm, 780mm from smallest to largest

The data on the scores obtained by students in five different entrance exams have been collected from 50 colleges and they are p

Westkost [7]

Answer:

Step-by-step explanation:

1. Add data into excel and name both the columns

2. Select top cell and press Ctrl+T to convert data into table

3. Click on any cell on the table and click pivot table in the 'Insert' tab. You will get a pivot table frame.

a. Which exam did most students attempt?

i. Move 'Test name' field to row in the pivot table. Also move test scores field to the value table.

ii. This by default will give you the sum of scores. Click on the field under 'value' table and change it from 'sum of values' to 'count of values'

The answer is GMAT taken by 13 students

b. Which exam has the highest average score?

i. From the pivot table created in part a, change the field setting to 'Average' instead of count.

The answer is GMAT with 499.07 average

c. Use the pivot table to determine the exam attempted by the student with highest score

i. In the pivot created above, change field setting to 'Max'

The answer is MCAT with 589

What is the exam attempted by the student with lowest score.

i. Change the field setting in the pivot to 'Min'

The answer is GRE with 267

3 0

1 year ago

Alissa is analyzing an exponential growth function that has been reflected across the y-axis. She states that the domain of the

storchak [24]

i feel like u are going to delete this but if this helped please don't delete it the answer is, Simon is correct because even though the input values are opposite in the reflected function, any real number can be an input.

6 0

1 year ago

Read 2 more answers

. Donny had a 10-foot board. He used the board to make two shelves. One shelf measured 4 feet 7 inches wide and the other shelf

liberstina [14]

Answer:

The length of the missing piece is 2 ft 3 inches

Step-by-step explanation:

Here in this question, we are interested in calculating the length of the remaining piece of the board given that we have the total length of the board and two other pieces.

Mathematically, the remaining piece length can be calculated by subtracting the lengths of the known pieces

That would be;

10 ft - 4 ft 7 inches - 3 ft 2 inches

In a foot there are 12 inches

Thus

10 ft = 10 * 12 = 120 inches

4 ft 7 inches = 4(12) + 7 = 55 inches

3 ft 2 inches = 3(12) + 2 = 36 + 2 = 38 inches

Thus the length of the remaining piece would now be;

120 -55 -38 = 27 inches

That is same as 24 + 3 inches

24 inches = 2 ft

So 27 inches = 2 ft 3 inches

3 0

1 year ago

George is comparing the sizes of two different phones. The screen of phone A has a width of 5.3 cm. The width of the screen on p

Leokris [45]

To answer this question, you need to makes the unit of the smartphone screen same. In this case, phone A is using decimal and phone B is using a fraction. You can use which was easier.
Let's try to use decimal. Then you need to convert phone B fraction width into decimal width. The calculation would be: 5cm + 1/3cm= 5 cm + 0.333cm= 5.333cm
From here it clear that phone B has a wider screen than phone A.

8 0

1 year ago

Read 2 more answers

Consider the system of linear equations. 5x+10y=15 10x+3y=13 To use the linear combination method and addition to eliminate the

antiseptic1488 [7]

Answer:

A: -2

Step-by-step explanation:

You want some factor k such that k(5x) +(10x) = 0. That is, 5k+10 = 0. The solution to this is k=-2, corresponding to selection A.

6 0

1 year ago

Read 2 more answers