1 enter missing data 2 merge and center cells above the


Use what you know about Excel 2013 to replicate the table below in the linked Excel Worksheet. You will have to:

1. Enter missing data

2. Merge and center cells above the table and then enter the table title.

3. Use the cell borders tools to put gridlines around each cell.

4. Use the summation tools to total the Frequency and Relative Frequency columns.

5. Save the modified file.

6. Submit the modified file

Tornados per Year                                   Frequency            Relative Frequency      Midpoint

0<-20                                                       12                           0.300                   10

 20<-40                                                     22                          0.550                   30

40<-60                                                      3                            0.075                   50

60<-  80                                                    2                            0.050                   70

80<-100                                                    1                            0.025                   90

Solution Preview :

Prepared by a verified Expert
Basic Statistics: 1 enter missing data 2 merge and center cells above the
Reference No:- TGS02160601

Now Priced at $15 (50% Discount)

Recommended (99%)

Rated (4.3/5)