For that, select the range of cells G5:G9.Now, we will plot the histogram chart for the value of relative frequency.Double-click on the Fill Handle icon to copy the formula up to cell G9.We are using the AVERAGE function to estimate the mid valve. Now, select cell E5 and write down the following formula to get the average of these two limits.After that, manually input the upper limit ‘51’ and lower limit ‘100’ in cells C5 and D5 respectively.Then, input the following entities into the range of cells C4:E4 and G4 as shown in the image.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |