Midterm Hands-on

Question 1

What are the 7 steps of Sorting data

Answer 1

Step 1: Select cells A1:F21.

Step 2: Click the Data tab in the Ribbon.

Step 3: Click Sort in the Sort & Filter group.

Step 4: Select the check box for My data has headers.

Step 5: In the first Sort by dropdown menu, select Sales (March 2010).

Step 6: In the Order dropdown menu, select Largest to Smallest.

Step 7: Click OK.

Question 2

What are the 6 steps of filtering data

Answer 2

Step 1: Select cells A1:F21.

Step 2: Click the Data tab in the Ribbon.

Step 3: Click Filter in the Sort & Filter group.

Step 4: Click on the Filter Arrow in column B, next to Manufacturer.

Step 5: If all choices are checked, you can easily deselect all choices by unchecking (Select All). Then select only the check box for Toyota.

Step 6. Click OK.

Question 3

What are the steps of conditional formatting

Answer 3

Step 1: Starting with the original data shown in Figure 2.3, select cells F1:F21.

Step 2: Click on the Home tab in the Ribbon.

Step 3: Click Conditional Formatting in the Styles group.

Step 4: Select Highlight Cells Rules, and click Less Than from the dropdown menu.

Step 5: Enter 0% in the Format cells that are LESS THAN: box.

Step 6: Click OK.

Question 4

Formula of mean

Answer 4

=Average(desired cells)

Question 5

Formula of Median

Answer 5

=Median(desired cells)

Question 6

Formula of Mode

Answer 6

=Mode(desired cells)

Question 7

Formula of getting Frequency

Answer 7

=Frequency(givendata,bins)

Question 8

Formula of getting Relative Frequency

Answer 8

=First Cell/Lastcell

Question 9

Formula of getting percent relative frequency

Answer 9

=First cell/ last cell

Question 10

Formula of getting cumulative frequency

Answer 10

just add lang

Question 11

Formula of getting frequency of context

Answer 11

=Countif(data given,bins)

Question 12

Do you put histogram when context?

Answer 12

No. Just charts

Question 13

How to put a histogram

Answer 13

1Step 1. Click the Data tab in the Ribbon

Step 2. Click Data Analysis in the Analyze group

Step 3. When the Data Analysis dialog box opens, choose Histogram from the list of Analysis Tools, and click OK
In the Input Range: box, enter A2:D6
In the Bin Range: box, enter A10:A14
Under Output Options:, select New WorksheetPly:
Select the check box for Chart Output
Click OK

Question 14

Find range

Answer 14

=Max(Cells)-Min(Cells)

Question 15

Find Variance

Answer 15

=Var.S(cells)

Question 16

Find Standard Deviation

Answer 16

=STdev.s(Cell)

Question 17

Coefficient of Variance

Answer 17

=Standard deviation/Mean

Question 18

85th percentile

Answer 18

=Percentile.Exc(Cells,85)

Question 19

1st Quartile

Answer 19

=Quartile(Cells,1)

Question 20

Find z-score

Answer 20

=standardize(desired cell,$mean,$standarddeviation)

Question 21

How to get Covariance

Answer 21

=Covariance.s(cell, cell)

Question 22

How to get coefficient corellation

Answer 22

=Correl(cell, cell)