Reference no: EM131360928

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