Describing, Exploring, and Comparing Data Using Excel

Attached Files:

•  TimeSpenton Homework.xls (24 KB) 

1) Open the attached excel sheet and save it in Excel 2013 as an *.xlsx file giving your name initials. For example, If I save it I will call it ADTimeSpentonHW.xlsx

2) Create a frequency distribution of the Time Spent in minutes using 15 minute intervals and Copy it in another WorkSheet properly labelled.

3) Generate a Frequency Bar Diagram, Pie Chart, and a Frequency Polygon using the Frequency Data. Label the Chart and place it on the Frequency Worksheet.

4) Generate a Paretto Chart using the Frequency Data and label and place it  it in the Frequency Worksheet.

5) Find the Mean, Median and Mode of the Data using Excel Functions and clearly mark them in a cell in the First Worksheet.

https://youtu.be/2UdajrDMjRE

---

https://youtu.be/x8ePdM9LquM

After Watching the videos for this week, please list two clear things that you learned about using Excel as follows:

 1) Learning Point 1:

 2) Learning Point 2:

 Also respond to at least two Learning Points of other class mates.