Connected Recordsdata:
TimeSpenton Homework.xls (24 KB)
1) Open the connected excel sheet and put it aside in Excel 2013 as an *.xlsx file giving your identify initials. For instance, If I put it aside I’ll name it ADTimeSpentonHW.xlsx
2) Create a frequency distribution of the Time Spent in minutes utilizing 15 minute intervals and Copy it in one other WorkSheet correctly labelled.
three) Generate a Frequency Bar Diagram, Pie Chart, and a Frequency Polygon utilizing the Frequency Data. Label the Chart and place it on the Frequency Worksheet.
four) Generate a Paretto Chart utilizing the Frequency Data and label and place it it within the Frequency Worksheet.
5) Discover the Imply, Median and Mode of the Data utilizing Excel Capabilities and clearly mark them in a cell within the First Worksheet.
https://youtu.be/2UdajrDMjRE
—
https://youtu.be/x8ePdM9LquM
After Watching the movies for this week, please record two clear issues that you simply realized about utilizing Excel as follows:
1) Studying Level 1:
2) Studying Level 2:
Additionally reply to not less than two Studying Factors of different class mates.
